wLhP0TrdJiMxFPi5LgYRfKcXCPE813rEtMbLPL300DCXAfRct6Uulqpczlh61WeCoJFst1WYEcLHIZFiGLxRCvFYlUg6ev8bsH23VbcSkmseAIojPBtgpY72BmRyppIzrYRTcQL2P0EodJU0pqL/tyXxEcWkDQ1xRdeGnQQf7cgo8ZXl+fdjc29veKZarYz18fF5ON225fJ67XyxJh1o5CPOIbqRGGcMyAESaBB1f/6rNIhHpT/PDUtDOU3fIGeOgeERgic9qCCFva+I25waRjSvD8k0WRvvvCWOW7Ht5AJDjJAh6TvB+sCTiKxS00nMilyXs6ndX6+hMZYGuQbkcfUV3YEyR1vKsgR64iIlnO7nBTvMsknuI09hDgmdKrrMF5l7gwBr8bJhb9U9c1EFtOwA1rAT3ebxmJmlCj6H4p88OoaukvCZWGSx51XcqeK8PC8USO7xfkROVSQ0yZcroYXt+4/ZFLrrYhBPWnY4xIZ1Xid4bd3kTdIvpJWzMyLTSw4DmfsRr57a/ahdW3ZW501tn3FH8e0a8a5z+CMQ5KeHGde/rN4wSyp4AdBajdO2+W9Ckn5XGYn2xlIFvgfqf0VoT4oliTYPc4dag6G4ZLe8IE51eXLB0ZV4tS1mEXPAOcvzIkQct7ILZvbpnJ9QxCRLWslvBWfSifpkQ3ZzCO7KiBQqG09TPw1jc0g1H/k4RFLL/pW5x/gYnMaLLNvd2syLDNKCPND7TbmqVNGFVpaHmOe2zD2c3LbBRXv/TomD+P0mDSkFwZ/cO+S7c/RL8sN2ofSKuTG5GKykYNfng6cD7Uu/gHLbOghg6OTE7ufeK1bJ1FI7EBZzOZRa1iLvXb3HwgCnmu/foZWl5d0kIX2MfJIeucuvynZOddhPQ9Zau0krJ9LjojvBkELx7iVnM5Wf6LGeASus/5hCqC+bVQ1UXg9FDPGLwyg01/Xco0gxsjH4S7tXl0moyVRj5g0pkmobR8aplhpOTkdj9WeeMMYKRa2emQDjqDI+zwMJElyUeDF31c0tgEo2Z/Jw593ORBrHKCg+dObXe02pV5R9m1UBVEXNQuq3y5ME/ncmOoLVC3BOvu0BYbkqksly4Ekg5d8FQRDssKnsbDuu8UfibhhKnJEsLKEwBLBcnhxPfdBuwGiVsW1i1XzP1TWWoes3S6sFtytfqKAZZnntUt+JngCnScSndVZL4Y826wvG+TIU8sc6duc8OgF4Vc5U1Xfnaiai7wqKFMvASlC6OL+hgw69uPxFZIINRyb42XHQwuggyRpoj+LkYcDjUsXcT7lQLLxf7VABIqURL6zC2goV2cEUn0fPB7m27mv5WYmFdR/H+uE/OfWMoJoHMs3oKVh8N7XnKt0TNE4g7TgyzTQ=
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