xTXnof6C5rZXtDtwaPSol9hvkIdsLVR23OlPh750RSHYcgDilkTuokDZhy7sntJtlLLlz3kJiBp2VvRLE7XrddTCdP/d9AjaTvvMmtlL2OrppjSp8TNh4ptEdi06VUjdGWI5dSe23hRdGVzdgYz/yWF4vdaVdEguLdnMyVEnCdCh5sVUeoCdkuQvE+6G/tnneM+uh6vnh/WxCBsc5qwkD2Pq5Y7COCXh5fsmNf7zlc7Swaopl5ZcMyiVkBY167pLCRuX+iWkuyltFNZffVZ3lqYf+EwdK9nOsT7jucPwfEca+zEIKMum2ogQaYNEpZv7GZ9fyIM2LpajIB6Oy531RLKkBVQZltUqY1vmmvyI01kxQl9DW89r99LqChvCr6FMVxjq6w80AHTIBsZtjysIECv0fQlax36QST3HjL8CV+W71ihHPo462e7C7fDfaFxNjACX8wbpvFHSGsZWB5wPMRlxgJy8GbKj82J/nbEmu0l/NRXgk7Ykwb4DJk6FrH0mvETAjkPCobipmmt8TV6ND+g3KAo8UqhQDZbGcPB4R9rCg5Z+wRwDaqCs85frQj2+OVHvPROc1Lb31vcoJ6O3zett08Qi1qE76M22yPg+ps6dq5RWz0/Cc9tY+IIFMAUCgVtr3JdodVppypckByYxLK8YD5ZrS2p1GLObMdR8t0KA6b+mtLUl+ySh9ZDll1Wixl8lPHjimlCfa8N+jJQjvqlu38J447jU7cQQkCeoknMrptoEQn9zAqLvHg+NFXZIrLTXR82CuNUDugk+MgJR4NxGpehdheOUN7CJ798uO7lZmqefwzTLxltNEX6ECCLgac20rjAAVhVtlC+OJcr8Bf1wI9QMbnowPDc7icZUhfLIikeVWLoYtsJOOYZ4JRk6sPDnhyYkaHla2SokNZv1aaHmRcLFgL+HM5isDRjAhEVinnT1tCxQpjkLsUz6G6hWw45k/p4jK3OzcdK3ghwpiEUKqxuu7hSUsP1UdK+gKlceaD/weK7lAOZerPgcgf+LqqhagIDmk6LA2A1wwz3mNEQpXGcqHUCdhgFaSa5OxPO1C775+LAsKFC+r6DeBdYZlky06aD8SJe8S+VDfwOBTadrCCGKr7FO7TFNqocJbGznn1IwLY8GEf9YyBoZE//5yPqW0j5S8LVoYdgoYarplZQVmUY7h0Vb7IA5FtwPcVV3dZuDbVzFiRPFow0r4BHOlOaa2R6YPl4yE3qAOArQDFjms9WRDNVN58wE7dPl+LOCpZ5sjK9ODRUuMYHkQ22aKVRbCrubQW2c1pNeUPRLj7zez8yoMk40EbBwTEItNsfbWR4xpjXoUMA5Cc/pkEshN26wZ9c9Ysdz8GGyrDoUWPP2nS3Vxdl9tqWpZxA=
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