gm1xRrz6JbzrX2N0fBXRUSDUWTOgRFrSOLYqf3QWrog+sHFiBPGlANNcXXUlkuFGFtpyFAxbBlnZ7mXICc6hjvahvN07UR39GtF74tVEs0ZpsUdMXgZE9gtFoQVeGSOJsckIaINhyWsajO8yDLE63R4d5lGfT8tzmJ/NtcILHSDkQTt2QlPTttbrTxgzoK1uBUC9B8/1chSYWYFdOiTJx+wRuck9qxmQr7kKdrih79Q1vfJqgDq3SU74Sd7K65YUo2Exk/8zoD0vgn2CGnyuEl75/wnDA+RstyFddMT3r5faRbCw4v0gSGskcmO0tNQCp6YJ32YqdyMk+PayVTrF4vajsTbCSYY6HcK+YI6/Y/Apc6cmkWSM9bZ8Jg7VYfwx4w4brp2/hYl+r4xXT+IJubm64D9LPO6vqB55sW+GxOGGqDIr/xcpRskozvbOLaNE9Efo1v99BaD9+mgQD1pxZpAXCS2HqxWk0NOYEGyEAHtjG0cQPrjireTB1b8qT0j1Zg4Ry2wqdU7Oz2ShzJNhdkw0xerlfUhztlZByypvpN8SzAzWqU+C5q7FdpsYVxjbBzpXMrpWrSpEpNh6dObKwIlsPyEroLfiG0DqQE9SPTm1qYW3JXcXFfoRzeUos1gmcxU23s2SiTuSTda6IA75MquINTeYCzojiTBF4fopYe+OV5T4TvBAnrYzgepy3YGEivifjELC2eXtg/wofHUxcoT4ZgPxBMQny3vl4CDhhzbcOf1JJB26XKQP2GMcMkeJdYulfwCpUdcO4W8dSAqOLUgHzIk0S5+ts3Lc1YMPEMYThth2AS7fu8vNwYjUgH1PWBNcpLzShV81rYBcc1D3JanP1mTFVDnWstmivtEsimk+7CqtzXce/1edVuJvN0UTEBvhIX6CR2MfVfftStIaE87WApn30Z1nspUVVRMKtVZ0PgD5DMQyMWlb33MJJ1bhGXlxN+4D4ZMieu22BMUXdkO+E7NvNxZEZEO7A93DV6QHY5ALcrfqaGlwO6ZJNGxoqMZ5KtPeMSobiHzfErM1NWVVWK8xnrJwF76hXy8lC7i8KjRY8deTVH0YSvJq8cKvF/96S0Um+tEMP0Zd+W2/gAewqiyNRefwsY55Q8UcxDy4+are//gK+K2oWhe9gqPmFTghyJo97Czgj3e1o2OwAON9h53M4IKULAZesXjXkecHkLKjvr8qsWxd458xwJwOeGVTa5vb14cVzyT41eknvWQXVVDlD5PfjJgep1IAtrRm7EKKmI027QdTu36g/8BRlwjx97iPL0Til8nDE7yqxRvThebfkryQlGZafx9yqYKZ2ubMay62wafp+FIwXLKRoeCNlQcaUSzQvrZiH7r9JlLxW1/7yGGgjtvIxIk=
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