HcC/nW3S6Ak+od+9K0OI9VAYCgVA2CL4MqvV6Mh6rUPIEkuVWTjlWbn64h12nfSRwLfzteZs7v7o+kPKSMyCnxQlfs0bctIhKhFVDckOMRzDI8k+ZhMI4U1i/Vf684DNkrr0uOH7tQwLuk9Ojj/iftsajpkjp7kF5gsJhjdC8Z+3Evsff3+wuNYlM9PJFUqmToHtYMqcN1Puff0oEbkvKTyyQGo/Mg7YA+QJY9RpaiYWhpHzIBoYYKn+F3URHDJl4GgYEz2lryDs79kW9uPPx3g/6ibh8+a7cP8BxGZQ1MAviLe+CFsbvkx49dB5b3z1dYt5+YPjhS8FRUtSNvnvIWZfZJ+hpQ9IwFs4rTGxvhYjhttSJghzomXyVY4VB83ted+SjRk9HG4fImJ9MqSF05z4sO5bvuQMANp0mV4BTg2rfKhC/KegAyFP0R9KB/r4ai55Bx6IcM9s0x3Ds7sDabALvEn8mbPkVm2ePvPrRlaCDWmnBye6jMH/5cPw6InZTpg2YVik7xILiPbqhbaD/qnQN4HcdSdhrOLt9FZHB/qv88oi8/XgqpaMlIiJzYZRXS7jE2UAwZ2hvRFpbFBJ7apMNMVtfnd16Wm0akE8UVNPw/AzeOhdVqc8ALxP6wMLv4fF87ttTUUW8Kku+1HZIf2esgzod1IMCz20slRYm9ik04x4XMqvfW4OzgUC2aB+pIkFeDdqcyT+VLrxymflkbhGFPP+Ovv5v5kind33A3ALs9VTSrbm6dpbIERvbzonRBM1mC8BCA+4OGtZyTzEL0lzrq2ofq3s0J6uph2hws/qWOQW0KbtDCihZFu7XTQqL3f1kpcZGGqNFjeNk9IY0VVIixU6uUSo5X1FblL8bkXBaa0zqiG0EyLKVU5BIawb1DvM5CkquASCqyqIFrUZ20TiAX3A3qA2AgcOUzlUKGtYGpl4gpPYJkzDaeOaCTfos6cbjEgf96VqwsKAtfIRYZOzPHqu9ScTYfENeb7+gdHKZAieDJHfeDUQ+50wQioTBLL726Qu0MgbuxZNivcL0s3uAmlm126yXVOKv2qrYRuVyDU/6A3MVM6ZTFj++eMZIjc5HjyGiO+peFs/asDW2IoAfXK+uBMI8Ei0u7kjUKrmznyFnEYjxXtTq8AXTHGeSSNF8peX7QDY+a1mZLw5S/m9QH9MuegVqQrJKk4HCoWlmls9WWZo87ebL7uu9NZwvbelmoW2YPAbhgzwtkVbWt+XO/jZGaTPMh8NEYWOLIrjj+hBk2jK4D2fa7BfHSIk9PXtvpk0n/t05+2SZagHqOkxSlmw0pw01/crn/0O6FgixtVSNCouogJ/UH1KqTA5DJLkbRROcbD4J+yKcwBPgOwrqizNWvN0UaXMayM=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100