7GGnlPxNYQS04g2hY+MLVJ2cMuson6ajSVjTT+cAHnzqUMp2q8+LPnl6Fzc0fWBanSAoQKuz7y2oZ4k1CijNp9GpmM9ya9hOP/o5WC3Lm851L5Ct67ZiGW16ERARc4+cCoQPzBtjQtunnujZhYf3bGEYAguB1syt8VSxShA02qVsAZFbSUFJq1n4jvhZEXaOX5oMcgf6HwXVDdN2/kgYCfZKCbi8X7UEiYkl01Tv0ZHoWx5tCbjmF8EVCv4ZPPI647ZCixWiYdmjD1/WHlLLuGQmaE3Zu0MFigo7wxD9+ocdSMu//+kHtCPZfy7E70jQ+LELkRtr4fOoGD3POUA1ZOjUjQDbVgLniCqoc7xVoYnoQdYoxxYTL69u6Jz+XTUshY1a18Pz0pGfaVY9+72REOQT0xOg6+GoPF2cZ+zyfXYAcCpjkAgigSMOrVKh+BsgZS2Y1H5Y8jVnCOPG2TCnIZR4AUq3dz/bKWao+jQAFH3AbZlGjAPsgV2wzPZghbQ+LR53YophdvGTc6+i2/ei5drX1HGEgZ+UQKKzN9MfqifsGaNWNB01iBn64+Qj1gwEQs5l/aCDtLl/4VWJEkEqmerp1GNuJmNO72NbQ/9DRZZa45xcgYA/vvZ+Qq6om7BH62PyxJW4gnUcCjHf/FVe5NWS66Sig930B6Vk0mqiAePA40PpgiK/sa3byRZGhEd3xEXDLIDqHjWsZJxM2HLSnZUz3CYzLmgYX2jSd9YuDGkB29mINkyC3uSxbFS8nLU+SwSU5LrRAzJsG81elekz+d4CNdD4JhqrFk29sECTQLW/5CCz+Q30rkJkWODr2qyJKxDfN8Xs7QnQKLOP7W2QCSqWPI2MtulH1Kg5kWnCgv+gzXOUpzIH5qZ7JjoHOTcslEiBRdZXTJBoi4H2kf1rictqo+y1/X1hZIc40Dk4/bgLREGzJe11y+SOpiUUhaUz50f5l+zZnEHs1/lc3+NYN9bkbyljuYjVsohfctlh38NJn8g+nL3CE2kxj/pY9ez0DThxEO86OuJ+J2zTgq02dAdfR/Kb5cPOO8FFO07GqWU1y6AMGL5bOySxP436ydaB5V81i3Bavl/v8Kd05C/IfOioDpFpl8klOWu+DNmyYhNJcpqCJzQ4xod6gXOyqq65VPpezvfljHaODZcOsQ1g8EC2DLt0ZJvK8OVJsl31IIcRoZGlWLVFBAghWf9YeYBcnKeWhULzg/d2NFcYCGlynxMUxyrjbfHcGWIuyvrZb5zgL2ui3JPGZ2ai4SFHDpjmkQyTMpAekOgL7iz94/jYK6pXwmXe0bT5gBe4binnH3kxUfoBpn7RIGI+Q0mw3063aNTNwTy7o9UUSpksmADot1JyOi9PH+yZ5oYJ8dM=
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