o8P+DmGYG9Ad3XTSPshjnabpqlv3Ym1PqD+Jj6O/U0JgfC14m5YhJRMTkZj64aJ7Pl9aU4+3Lzeu+ZnYbIVdqldk/MIaeZEymQFl/vjmbnieK5XUhJIvXSVUhzzTcVxbOGwSv+ZhYX+yD43HTMsZm/rWIsaSvpQstnAjVvooppmqoKFR6RnBMmSsVLCpU+15vGdyMfw7xcI+3LCWRJgAk2LYnZ9Naef1m5FCrHVAzODLA/k61OOw/fynI1XksySLFocINApoY/OhvTk3lAybcASntI2UdrTJBigTlEe1anLnwC9KbLve4w395hUCnPC2+qvX0aWfKRGviMFLS/mwoLCdvoC7qQblCEzl0RYGMqTI2JzcboNkeysEl0OQptXBoqV/8dY9PY/JGi8hYoW7i27jYDrYG2JvnB5QjUJ5kgeZXBcvT7PsQUmF9LiA+Fr1I5gk0suAKPJSd7SG2A3ItirLHP8qpoRudBdn/4ykrMyENXXAReC+9ioo0GJTmDdRAAHJwr00dgARXWaaJHG1KSAUkGGVqrZQvJ2Bk7z+BCIY2M9PWOaFCqRXgMx76ZBvlmaOLhvMz+HQ9mNKm3ZBUUkMwIlAtbRdX4Ky5mHbA82bwSlrLsGqg1Mn83cWXSAAdcnhLaNLgJkK1Dfkuq6Jwug2gi/bQ6L5Mygsduxp/KP0VbFRxMxs95H6ZALCCCcVV8ayY5j391jIFzXhXOXMJzgKmI5z2hqKZoQMViHR0f9o2daEpmseAZ/eJpMoKgc0OQuaARXIAAcUXs1eFAtzCHjijBDxv8bMNvYeAoZDebBzRReoeSkm0VtNxbxxUR2JzMYjXhsGo77rFTEJ0PAyOMKq8hi/ZjKGLPTDsctmghlTo50h5pgC50zVot51g2IaA9nfJ1qEuH0RwMNUxjTiyvuPmWpFrnuKbMJYoPBFSmduKV7hCgvFMXjvEcJ7IWgMcftLeh5/aQqS9ptKfL0R1HTzZIhDmT0K4VPtE0FalMTXFDAPH66y8HZRd7WcVSJVKr7WM8Qf8051gVSMFUuRXYWB0pabLGb8IA6MF412KlrUKQY756qmS8rGa767ddr2td3axlfYwEXRRarRoDyorsmc/uicoBKQv/u5HKtuIxfxwoHvLpe9Pud3L3CTuVInU8gPQW9gLSwh+rHtgceMK8uJQO/w8P3J0VGSprZzrXibApvq4pKZ86fiUTHm4FcrWfzAn9Tv+vKvSWIsNZtmHHRCjW/Ha/Ca+aG1h7Sz+T3lbRd0wIZX+T292ALaPFo4NQ8ahs/iNEl4zWo78N84UgUlHqf8e1HILlUCY67wmzNSP/cOj8x4uCEC15wiaeMKElnw1SAzch73RU6MB59wXchSk8bSOF0C1MYeh2I=
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