xlwixFeaodfnTmXMq8evuyLufwldx11sy+GJaBQTYq6B3Bjo8WZhFivqRXlSLtBIXytX4U1KwL5J6vSJp/GKsWrhnRA4gCznZVY5YrQFYCIIF/mJMzJjMMczf5MhezLmb+S7PUxQr4t5ixBYPIOktYoYLLb7vhti5UhB/Kwa870W+r92DjwCZDy6JzoyWL9yI+/uq8L6GA08ztMjT6hgQNmG6MteP2Z6+30Gu5yzcjB/V8uw4kY4on1uy6cvA71H0Q5ojNGG802niXGrtlD8FfVwFKhEtNeP9+0CVI6y8yCJrTwoU/8rrfQxS0NAVl3p9229Uo7vp67iu3GoCqxoGSxh2L4KlXFSmNowpH31nRnQw7avbc8mIkJz91/jhsSt8g6gtzLcTVtucbC1zqYtf8ovKB4JGTTHOcv5gykYbpvKg/ABO1Fy5LI+ZjpNP1E8iCnLm6+mPeZ7di/fWzhKMPfTg0GtkDZtTW3vRfBCWGYln+6nPy5F2OzyD8jKSZtI+K6kwa8IeTPMKyQROh4EriJChTTYo6YwTqN6i+c/zRSrGAUOZPkyBGVzM799ndzxVjIhcy5622sgaReIRUIvRowBDQ7BHKrPKRa0nW2um0esXSUU5SJqSdus7roz2g+VGARbx22577gHlP9dB3n/ZhR/kR8PubULL2LxUjQgyeOjM4ppqO6me1JRme50KZuTQa/sOJK2Ew8QqnTYKc8P6DgXWqUS5XYMhMi8xFkgeGiWmIMyGigeBFI9U2yXPFSN9g/AVxE+yAZwB3BzzyzJwkKCv0JL9mfOi67lLvjBfpjtAguw2h4YL43ecDQGSMmyYbcT5N14ryRaBRHcIMAgbrfLRkTmXW6GV9L1YOCSbOvxJrwp5W4SJAyaF1cgi99Ui8A4Kik+3VO2iRQrlQ4Ef8VsNU31T+uPRc2f9qtsQkqrRqce6Ilvi6QYFqChIkWjx6IMcdfDkMCKTtZ5BDE3ma3xptN68mtJtL17dcnzlEc+P1aWywC1roGHJnH487Ptp56YYBC0/2yBgS4KSRyhQQJFjIrZaaQA/RNxddSyrygYxhdR/Zmtd4SDFwgL/VrP8N4BKnFILbXS2VqX8ldYA3FQmfmasbTwtrgdPtr1qkblTj9kuqgzLNmoidvUUKQIgLcIHVxNCqmuqELH52a+McJiShO+LIdw8iWzRdO3g9EWVzMiWhrmTguymQWuo677A64bUlA6bGDpoUuu6M+TSCluskS+bRiktGc/YQAdER4ylEZVUONZ5GBorEW1XsBNI6ftP8JYNFF3hnuBi+UjiQk4dDigKs30rEjAOJQeEDMZcP6BswyC8VDEVUbYSoKUNiaS6QD7nnX5l6OTQB2kMZ6yCKDUBBQyTunNdKc=
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