NGbzo2n2u7w1D5qq9agXQcnbufBJ6SgDks8JsHojEXS9CivX1GOMhztKyhIXfCGM0k3QAwGVQdB0FyqpAEc3BonQ2p2rGPqU6/Me0vkLbzERHzqY7FHCzB1kfT9shdcjsJnIQB5Spw7/WoL1Tk4RPzJ1ksX2Mcw46FO39KXeEEhgQgp4OSh5sT+8Hzr31C8maJiWdko1fCSaKYWcU5W9xOg7hdxaGk//p/A+KEQjiMuNsCezv3Zohj/v7ed49uZESedq3zicqPPnDbX7gJtUj1J1KcQsozMKSVociwv4iVbnNFACaVGhZlC1LzLVPR/drkbZGYzF8Sd9P9k3BBv81xBy8SgauOAK+PMBGzpvWG/yomjQpTmSnqlblyZD/8+H+r+VbWUDMWFvp01FR/R4fBnbHNbGnHbv2g7tPfiMIAMSSbnZ/1dGwn6QZmJIrkikVxrLTJKU1A70WFr80AzXX6sxXqMPYhH2r1kLRr7bvY/nTareVxfH02wmbRR653/G7UoQWp0THFAt90pHiWco2CW/LqjPybahMsdB35557RMZIaPLRY0av02VGWcIJR0zI96mZpYPUA3Jx8qg3P2TDz7H7/V0lQ31kRKlk/yr0Egd6B1nNA4WXES1oQKdWok9DABPRYF9k1OmvflOKuz95AVr2NE6yPGYCJP5nmQemMtnknVhxGpQVtWBoM4xn6609TkLRVpvvnYXAYyTX80c8Pk7d6WOuRJi6jM59kP6PvoYXx5EDoRRJku2656iIaQUZB252pm5Pfmz6LGu9MyUhivfFKuOR0hmf5xMMAm8Nc0ovw/eLMUJaBBMLHyJSyzovX/uQD3HUON6LD7HN75fEZb0kEaIoXlMgjrAotHsS2nAEqhtURNYTlEeZXBCya45tVupOxpxwr+L9BMGrGrUmnh0Kvd2tlZr2tTSJEW+iB/CZ+g30U6YIhMnckzg58006HSNVe2anTsY2QVeCKT9d46aZFs2gjCHi90ZBKmmDncokYYBSo36OeZEvSyGFmvg9Nkuw/JnYqInLHq8dJSE/r8jqL1mLnX+reCIgn/PjLfVcaaPH5zgPuJnGvUQQeYzLfgo/HNR0+1SBjZdO9zpFsEMXUiz1tdmVsjS+B3cEU40Th6x5LkZ44oGT/sUzIOzst+nRt9/XD2SLX5tBc1Q1Ouut10z12DA5m+yWMKqBm6Uz5Z/+onXHHAxckv5LBZXYXEAqliLjNdvMAuv1IYCl+j2xnJE0oRXvYTgDYN4Tg0BpgBkOYjDRHmkfQauKVdIa8SRmDK4Jon0/HeMWS8UzUAC3YDJoXsVVkNeR8uz7nObpZWG7OssoKU+npwUpDBa+XJ2a/pbYE4Fbgvuxj6NAp12ArGOxVNof+t9tGw=
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