7NpC9IL7dju6juDzzk2OIr9mQKl0v1Fsk+PQQ5oT9jFmPG11HkbMgNVHRnNCMaPjrwTZ4fW+UaWDl9opHITXoV+H+PqT3ps7eupJHV08SwpZKad7qg4fnAsHQvLOlmgJvJO2quCQ2UiD3fRFtYcYm5Uf9v12v1MWCIKTn+OfApLnc+gExxbNAYiBXXjdi7TaNxI7V/fe3M7BF/gwKrlwXUbQExZ7kvb2OVzTg0mavF97F9RMxX2FwnA9tbaV/clrcoJeC1mqFPZTy4Ms8eB0PY/cNM/wTNk9hDxC9FNGTvl+tCUWIx6l/qr1TpBB2S8wRhaiaaffDSXSa0Fw01x38/Ln+rDHJI4lDSJUeIaP36r83TNMxH98iSyJwPbvldECxVmzmBkeBOv0gTYr8hZpRVEbKK1LoPqx9n+ogghRyJBm6yjmxniyTCqVZqCoeYdNOEQeHdCIE0PVK5gR1eLrabBmtc00rNY75HbY0U+/6BzrlpHomenrtsfG3qvbicNohfD2bCOgzbXWEkCKaKeq+NILGAGMoSwOl7sHNQFA8zeXXoatK+tI02t9lAsm8XqsLc3oj9q/FvVSFsePKvYHfzhs3GCYUkuiDhKCyX6jaUKzqGT6fajnocq5EKysZl24l8MLdklepy+UqEjVMkkv5IuOzzu56KRXoo7YbX8Pe1BV3zlNBRF8wnIGMMkCI3CEUHKotG4iZj9lUccmjq/j5RIlftK4TCrp7Ruu7DNi9x1NFTS+Ry99mGBQONuh+zzD2Vh/9FBt4HVqKPFszP+yXk3OE6R8j/t+ouzRAoCh0iWnNtAm3EPGMVuLhla5I7LXaCDzFT3GztUL43lUq3sA2gPyQKSjHjg+F3TmBdF/L1lusvQKKIwJE1r0zLutMT5eWqGXbwWVku/ifzMgyrBdcDwS49RT3/8x4k3+Pgvx9AjmQ4F6T5gSIABoaQVdqvi4K9N7G94v39+dQWXoNktlfh0BHLjqTm4nkN7IIbOT9zNfAqtPPHCSnmYOZI+P178Patkf2hA95+Up1HE8exy6zonW0WM9yrXFeAjHJY+POfYktpzsmFFyj5jmlgwZ07R+XGh5gXf+E/waieEQQBQbSmc4iwQrN8JrNFb901uKEfO8iIKC7o+Q+V4kRTMPI0qvsrLb97ELGuBs03cyyI3D4c4phHtiPZvbYW+RQtPHnuoUx3cYM4iRNVakF6uQeALZn+TZ3rV2kUlP8S/bWj6154eOYuZU3sEwKCVm/HYbwshiS9QHiIiDwX/4JdzE1Fhea06jqe6/ozzbxIWDpqSNIA0lG2xt3PbsnvRlQNL0lYGCiCwbyaJoPbTuMBPwz/eGoxGmLhMfRbbYWKLdFPOtHcmQ2RD66pdN2QxGsBw=
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