v0ncIQ8Y12gtq1zpCEaZpGUaySrQ3a+mZvF9TfBjAkQcA60iA3zImHx6Gr+UZu2gFmx1SUWVUH5uWQ4JJDNKbyPonOsyOhwxMsFlZdFHTgMsivSIpzbIAl7jyKI5YnE7kYJ0ytGBN1//xiU59EnZZ5RIxY6UWXFlRQL4zg7ZQquC7GbSombHRkVOzpvEQIrl2BVwvhmVadwNX/O5czs4qfwhmevWs646KN6/XANlGlFajpuwc0hyYt6Wg44dYN1vOfP7auyfLcfQDxizQg25kQVEaQez7bZ+AiJAGx0uNKiyk85TlRT1e6CMw4B7LDD8k4KUdWu/pQ9DcNKED9/bCuCaNbnUszG9sfOZDvHWjcjH7d2CMHgb8PgpOLzRpSe60NaFfJk1Ui2AH240i1IoLjzw/esszIlpGP0Fa6hAYMEzFTXoYS1puKCWHRBaFjZ4V/vO0ADbAJFjPT3yeddolwf9POwMiHXTv12NBFiX8ht6kBJQ3urXkDvVdJhrprkFLOBibp44snviFk3lG1ym+i1CE/LcxWoESRl+n47RQXQHQIn4vw/Ej7qiAq66UabUU0DZau45uVa/GI2hzJz1yQ5pIxo+LJRI+MVLsHoZr3Q226eCCfwCmGqO9bXc3bqoA7L2qozHAk+VY+LIyaC2UdUiVXuJRIOdR/GRgr/RorhWDujFtqhVs8S6FIih0eSaeByvPBf4RYQxuwcBqqzbiLQGVLnUIhwKpZkKI5wk2j9UhKfqKTW/WhY6c130CzqIoQmW8bE/mDaj5ANNfgMUvLpwpbcrQL3b0SxykBld0bWGhQXniyhFfoCeepLEomWo+WLhHnpQypwEBcgGqz7kRQm769QFWrfZSlFdV3TM1V9MqHNiDDdXZjquie88L0fIV4yISQm74Ad19TcTvQ+3NwXh9Z6ywtiqlhQJiE3riJfr/juXR2NQlutLw0cu+YhKUWG2h15MC51ZXyURxirpnqee9BCch2sBLzoPpcYq7yQEKfZsaUnSgiSzJ/5ZrCaK2r7OIeApbHLG3CgNbmRbMkv64+3s4t3IfmUrCoV39zKBnTOjVWOojDCK24/srSGk2FQ2i0gdOoHzH6wMLzWKp9N6nnzaPRHjw7/B7Rk/fnHOPXIxCMJFwVTyU61Ie/HGSP8IMhAc/br9PBvydwQqWjlW5DE2nbJQAw2zNpX9V1nusXSezY3NmWEYnWCFppdPmpsIT8MxgPLmY5WOEObWJgfhgszTYnvbCD7pJ+OoD0k2QujfDgiPBgYlW9Nn9od9R2UrVSDGWZhbMzNT7uakzJiHGMJPYW57XmQkOG0ssWcwaSvvBc0qgAbCIBtsKkYFR1YckbzdoB9O17PvjtIb1b/l6T0l0PYOQuw0noQ=
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