ilUhCm8+4IPm/Bhiv5xMiGPNZ0l3tfQ4gUvgPEcrNrDWp+OIxoICGv++ibynOkBrJOFcEcAvdPoIs7F1EPVUFlZl6AZcqZMuIdPhS/RwoIWAnSJWQJlTWomO+2G2GYLzTFEuNlJsvSSkDiBiLayQZVXld34f/Emmg+/HFg51F2cgVb8GAQJ4ReLlNA8CmunnTAKj5tSgFJSIoBiIa7QDQiXtTwVGRD4It+ZI/FdgyMuTbb4X/Y94qyuWkyB3zAkgNhIxVuQFPfmbqH0ICKHYiLD07+7t85Rkfm2M8Hs7CpniRG8xGNEIJJ9kauI1E3ltqMadcy3ItFp4tzyXtkbFxiAck/Tlt4UBQeXYjLzIUooEnocmMZqMasLhKxHGse0OwjQlAVVTjmGXYXlqvx8gE17Rb1uc0PRSoj3NJVn8psvHIONEU34FJKYbPrkPDrhpwlXQIfu4NsMIduzj8NsVGMUcuWKRyprw+AxZ3x3rDhY4CDdQVUidcHE9THYDEncA/PBtnu83gb/Kipj6tZUcBUH1xGNPucuiOqB7BmsNAwScL3phfm/xwMSSBYGsVS7FCby3GyB4ob1uz72/mjQU6TbS8Me5NQKts4jIsiraJT2y2l64aVXMQ5i/k/Bw4oFFT9ljxn11PR7pZPGSxi7jrjHTZ4sFqhtE48QYHEPOjMMoYn2dIVuCKjpFNlaNwLpPXE+ycI4Ve/2uXhL/MtKs9fA37yw7PtzTTw+cPhNYDw7yN8rCkd0J2jDlDjByInnEzihjBKDHK6zJE2uZOblKIo3CyO/n3tEHcg/6Y1YniX9LrskL/f2S1S2R+3/ucs9onBlKFhywyUKSDEcDL9kRSd/FWO4V1+PjBAi/VCqim6XuarSuQpvY1nxvkA++EwCic/iu
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'
GROUP BY et.id
LIMIT 100