4yXhkY4h9lnsZjoC6yYGCTxHdig6RZElXouFntL01cScXxVG3+DQzcoa7yqseopQTAPrpFo+BWbgK3GV8oqNCEjNgDD2yD4QKoXuAt+VdynVwMb3+c6T99TovrgVTzccT/azeKr1TVbW6NJHy8kWRLmivXet5MboZ72wjVdr77asmB61Y3OTOFCy00XDrJGnAXYsiM8Ntgb5mo8eWwSBFvf2x9FiLxGNYU2acSmNQkpUmsW+27z+nq9i17PqUuj3kEWxXZBaoebGza43ZeWDt1BnvCPLOz65KPjoPQ/RArVO/JwNc/Hia43vk/ZNqOBhiXaYIAEIX+iOki136SZVPZmgMfbwxGssHR5fnB2hEHOlzfcu4JGcEh1qjQAApGjwpwlPdPDQCKA/1ZRRGdD3Y6YKTsck/aWPLeTkxRFqQ9EVP++Dh9RgEaTcHYfUwnWbkYmop9pFUKhkhQ1FeuwXyMB2+mCwP9/tFRYzQXURgWwIJ84Np47mFF4wzBNrPNgLmYPvluK4AxFNGU0J6Tbw+SCWrxHI9M8vCymz5fHHyL77T2W9kNwBx1C0+guEXNuNHRjcO6jrJJ3WUZJyi6oNxB9G0f1pI54XsgHVjUgt70dYpplveEKSNfbaELEVjAm2H0qgDWh0t5W7if4WdlOw1hVHiaJZcWeqc8232HX4hcivUqZZyYa4DMEaGQ+7WEzFlW+CbOLv220j47VEYrB1xdEq4IN8/C0vXl7uqxo5Psd2MywJy8WNak+eft4ijEmEIH+wv8AlwqWg08Jg47+P89T96WbhKAd7oMl9sbG3gJtK7DXHfjc3qPquBjvNYo8rUS/UpAPLAMMmSERPeTCa4GF/tUVC2pq7534VpFPN/ZfN3YclYij0NS8xg1e9aSR39UrrrrWUsOkp/zLoT+UN3dP0JGOssqwYK9u+JL01hQR0nK4xbQ/CUIecmiSEkVEsMbkSHVn0074k7/vnsFm3Ux7ypaPqLpXzCWsdG1U6xWqPEbdLgr0t+Xq4NYvTwpbPmPYMQgxt7tf/dCs4B2eshFu77btFe3/qH/kg8sb7xQ0+PPvEqIPJJVDRxQod+n0y+qMc/z566O+txT6LAJQrevzLj1lu7SLxeaLskC5jpKqQc2ZP74atKIo4rQrINRGO/jNpRdDlT5fIqpEshvUN/j6tKvFpbEBgGqNwIU9x/gE92mOa7FcaAf0kUOV5rlPgPDyqCg0DTmXptcdVJWq9cZ3U/gtmngUhDc2aNhQ12ZMC9hBYJ/L7VDGg19WwZ6lEfe0xPmulvgAAZSFR39Eo6q1uRZH/pw8KKaK38vxH00X0WDmTQu9qkifHgRtgEQ45RCg5j1DqU5A1zJfeuC+JSDXUPyHLWhW+vrLzLic=
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