bVGrJtI+aaSj/hRorhwY2FEEfFOalqj/TqKHyf9ZmHILgFIayutbyexiLmBkODcNdO6Gcou4qx4x0xwUOafi5YK96T1cCz8igmo0AKV8pQNblRSabC2Ap2SbzsFDyKBDkbs67DX2sFC7mSdIiEO2Iili7gfY9R7pTNR78AeJOlGjrCDZEltRkjjYaitH/nywpd14es5Hupdi9Gus1aZkqBfDUAlHFmO0fnq7CUoJFTmOnY6TuMDVO7KSUfeIMwJYVDfTkcHbmksJtzkLUZgL+R/8hZMnfLDKFSF4sE7TCAXqwJys4Vxr2zuSjR/bUR6M5nIaXVWP3hIplInRezsStmLD03R3/A9mUNxhk6gomgEpD73xQXSz4g5I7XMzszo6a5H7rk5lQTWDx30PYnkuLQDkzPBKcvmqM+4fPPl8i451001W6/D0KgTokHWrRy2AH61HhFzyquFOCMk6oOJX6qBPLX2rm94lTm9MFbxqivhBNuwEx4tqeawOf8olI6/t8smLc6ZD3S1ExqUcLcTJTlp5vUaTFLVTGyDscuFAivmPiMMM3X1pPW9lEOyDcELmiRPsUe7XUefGb5Lk0YSQ9aWshB8JDayWStmwCKHfdk/rwkVjXbvTY41tp5D7vFzFMilwaNNqa30ysFSSpY1aRFCZLmfeYdbWleQJ8A3SvYAfKf0XzDvfAQLAG3YV7/bCT9VzNsekDU9OP3BrSUzdU1t6QcnK3Ko2smb0TveX7NycHWWr23PhBlKjips9PxP/zwYNWXTTF+K4WzI4jeQTryqXVdNuume9X2tvkDNXnhtBIpMxR2QXazAUVjUY7yUuIChFZuBe+jDZEcNVRw1ZsMB75SpAl77iYrmy2fK48GGnckjl+J1KTm1oJbqPhtrOj6qHw8QXf6ISOT5KR5e8ykEHQ280pcKtf6IOjZJ0QRF6J3Aep0+kzpv+/p/ImgYb9oCFHF4Jfh6yjj7j+adUew99d9kqyyMTRBQUATbEwFmD7PFCVFH90XODwM12KoBwOJl+fMOWsE7G0YwmV1KH4HsJ+AY7W1h00vlvRCKVJH3GVxukIgPN5ZRAk/SP9iLINGTVgufCoVOA0BLvgomcO2CRo3waoCN9jjqe28iE72sBYBds1lk90KQZGeQuOLk5xQWEnzQ+44rZeGz0RCAugtVT5gYnxrkwQUalqt+SvbDBceDNN13RkzPtvOnQCRtkeR750D6xFlRJjEodx6MfExXp2n+YnZbfjXLZ57FpzosaETYxFOaeKwPG+ASSREUjkTToxSsV8ZCohnziJuRftVgk5DwSYsbubc5gEbQzjFGxKPZYI7Pe82hoWHm0N9GgE/FucCAs4lB1NguUL95z+MKhjEgD4XuYh2Rq5wc=
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