Y3guoJKwAVZWO9s08XY2J8z1Aym9KKQykUCpyJtW5gJicWF4na8jHu2BkT8vyio0w+J6AtEdC8dW1+3Li74p1t5Ybn8VDAxYe9UvPcBjgKbEPcYRn6TPz+Bn5W4zTJuCXd9nTst+Cedae8pHB8NOByyj2NPuD5vPl3FaAomRBsGhI/R/DOpldyVa4v5Hj0c6BgH3psq590R/l+NbRNZwgZ94NHrn2YGl00WWgMqKQUVYKijR7YkqXXAUHNbpuOA2oNDb/nZoheRH8z9obAgjVKc+wMsiT0DDLGTCyPFb2gORgpt28CkPaK1Y1Ytnq3o1rX6L4+m4AmyRo7+P6vtE8PVgUOrJgfhzGg15jrOx13Did9ZLkR6k48bUEuoEqeck9rb39KFU8JE1/Lru7WODWBKYM7WxetzdlEpdQz/5QJCFg5BrMCRoGVPrJDnBjTNDBYqXuzL/+xRU2qGcoHwcu+ZcIDjuBN7lrOkF3JAOcVKVYTuxzDg/hYYTW1kq/3dYJScPcQRmD2R7ITKyfzndbRkY3Srl6zdCkvch+Q+QYUOKlUAl64OP1sAbH07HtEazJ1xYNX+LusBUtIhz3j4RdOigCofGjQ9JooAG2Ld9sZsZhT1/P41e9BB+G3lym4ejll65LfleXoGElV9J+AWcLfxQQCsePjyXqO5G4SlWL5S33O31KFMU9H/12JeX/GT++aWxOtfGzghhpitkvG0B8iIB4iftb0gPHtTNPVl3bUb1t2iN4BfzbLfmobp53ecyPgi/X7C+07TuZuTsrlhb/AGiqdufWgj7wfHHUqDpoyz/znUUWX1f/uUUDdmTQs3qHTBsS0bkfvWq35NTk694VkzT+VjvQBayO61jBvMpu3w3XEe8tc11VZGUQ/cEfKcRK5i6S5keEQRQ3a91rBa007UAgs13zLcheSpk/kcVs7C/2tUQZ/S86xzVdJgwgSoHhWOUKzvLWYJIZo+6NKa2fftktdd2Ffot0JF5bIGY8UQC7IgHZyOYQLWnDgItGaAMmxRqWuyLyxScScWnc6Ar1goTWaPRmVMojOjFG4XrpRKJV9tYSiscBsuL9T/un3/PrrmxUG/QEDBXd5YwLAnlLpL9IFV/G5PVq3oTl+1PwrZVqaBAOyrq9wpTtEgzSl6y1hh/eBCxLRLmZU4C1iVUfcATAYumYyfEhMv22UgLk6OJws00KM132J3wMHZOxjxvrP1t5ULaWSCPwcNnKVP74brthGBMBEX6q1IjjLO3OZYwWKd7Pjr5pttJRCB/QUTKAKj00vAET8bB5XRlKAwaM6GY8TewABPawPlBIqTi7czt/Csw3P6Xx/mYXbHUrqqlOhFazzjHmbVZ18Jvo7tdciWe8DCFwzYKgjROpnM=
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