MeaCBTsxnNijFOOdoYT24lCwoM9EdsxH8kB4lfV45xqiJKfBC1CQvRSdQtzDS6rZxlphqSAr6nBEjdF6ldH62ou2bLqxsZkX3JhH2qKTZaf7h0Zag84DPqMASzqv1IaN7DTVbjny3E93vqU+TgB00O+nll3mzv0HftyTNsQWPLlY4Ha7d1btJ3KkK1I15eDPYc0zzJ2B34YOPxUXZ+YvhvcEk+g39jIrrPiWVrcGOSmfa+0wOUKOvpfssXIFYg675cgJmdHLihnqleeujIbWc5Iei4Kpn7rB9muOQqO4iuvaK86Z4lr1rUkcB0FPjiwhd2JxI3VLQdgekQ10BztjuIBucTdvToU0sejNCyaRhxMjrVCQK1TajNwePxYHFQtwdnKw9eIz9QeeIwxpZlyGoVlhWGgg6lFmhnn1GZmXFXnp62CEUtR08UfiTnIivl/YcIlBEXqMjG8NnO3pNjP5y0FarGmoKG4jf160oNIvAb1SAwaeJzFICt7odptj0v5M3xsY/Fk7xpz68ID+CC27/oW/HRzpPc4ZOz5KDRd1+Viqp7cHVzkCsxRpyi49Db3mXhzM1Kj2P9qBf6e3xsZjBWsPLUrGya58Tv26FT9sIAilNNeXyfzYoat7hqQb0n59h+buAFsU7sUY2CTYTQhs4avmvdOTAiQbCQHrzsC+h9nsW9M91tjTADbW7LyMHM0xpBM89CVXbwzHSYSNn3hGCxl03hIgPVZSK7CQ2c3yridDRwGh2UGtbjNwlvh0ARL+vhw9m0YhRjesCdNRR662M42pAcmJQkQEnqr+tSU+xo4wO5gF8yS4Xh/qxW+wTIYxbTuK2NW5joYA/84gQ1ZuHUYFSVJWIL6DgD8mNCU9HbxFArJCBWCXyQ91eXREx7VI1y5TkLlTs5cVdsIwgEGBJDm4Q4mnoWgICPUssrbUBrbEIeaHidxHYWXUBL4BnbFv22G8Td4NbL7IKCcvRujTEwlK7R+ogv/L8SJLAaLSEosS5MUh13XSSKl3ddIa/r8lec7YkK/iT0upAw7HPgXs/FFl7hOPx/8SDC4IRr386+p8Inj9AMgRj4wIiNf58hxuhWWZbphTjYJty0hRGI/LcRiGBeb21YRJ+7Cxua9pzpo/O8ajzh4IsM8zsw9IEzuTJd4BOZv5KFlrM1v2cmCqqjieVgv4sqyO/1GqQTNEVHiIvabUGAQ0eKwg0omAPEumKXhjcppa0z/1MCwSrRrD+iKTX3nKE7zT1+ljoeBBVFuMaFnpWKAkmK60zC2N8mvPytKuYKxwkdZyMpqnDT31QA6khHraQTUOIZs2nLX3xBV5EgJX6TCIhWq2I8YQdLwJckw2Zi56e6XERfO4pVHJlgBFBcqgdSLrM/QJrgI=
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