BEWO6kfyj+sFuoCcPZzu0N09fCgUJhJNCnJvdrE2b2wrwEeg9zawyDSeEL+UK6J13ERX/vigTvGlQWLsGnEdD9pZjQJ4hMdnvq0DJq/hfKKl9VzlYhgV1R8TDWUl3DSTRWNBl7nEKEB47vsl5PLVRRulp/wDZ08beYjTs0zekx99XrmrJBPmRYje2ZIUnKEBe+rSgPXU984oscS9SMeYOE1oKCLax0PQ1pGiN9yAWLBMaXKrSqxPg9+Odi46M5jr3uisnjJ72Z48VLbqF6DWHGnYy/MlvDkT4Df1AXd9z8RPR4AXOAh/WuBtRGGzdxjo7iRn/hklwygLpxbfJTkCutiSAWdpzVxwRWHpKTs1AtxjLjvrD3eC8paEEwjI/kco91GKQHE2visTsJd2F9kgYKOo93VrEVN0GrqNWh6szDtuAGariWAktV05b/ffu7GEXsruehV7pXG1RyasJDwZ0kYlkoAMd//GhgdMsCeS4/quXo8wIbESBoVBVx8Yznc0xGFnHzFKKxYr1VlAD8lWJSGaVgAK30SEY6hGmQvWqU3kwy5S2Trx76GOwanw89EsJTlXCqW6D5ts3ewZBTqYwkee3vEpWQig6jhwN80gSYgiWdNqMIswwqyL9wCHmNWC3422JTToT3BpZ3qftYxwlCyXuxneDJMZf0OtGbferiqyf++GSnWABmc7FTqHjkum0dIQlPgnT5AE6TWKXfq7FG0i948hfglTQwg/TjUmIBy7Fbsy3tUehdH3j4h1Ex1LcYAtP/jQRWCK4GuxYVqY7Iu0Ob0wwDZbnFZAeZ5YH+LOJMnUdMvsw1JnMPNw9ZWTCrkb5fO1yuB8Zks0NvZbTuwoTVrGu7H1fCOrxjlNqxMUJ4PORkQqQKY+Y2ajUZPeagU0Rjl+wI0Yy+hRTFnc+7zLRdUIqgy2HXIXfly5o1fVsgJ50BzFUqzHqAoSiGxsqj0NTaWEwXRi2ViWDlPZiH0Y0yB5nNWgkWUwGQSaWil2/mZFxNPoKxLZj9p1sb3XYsWY5orG+2oPJtdrnCTYUpKw39j5w21S3MLtIWoVHMjxnSkKQ6M/uZKdzVEu9LX+QxCFy7c0hOa+P7yODAcZZ85yrLF+34Uj7IVuft52asFXJgSL/HKNCO6CjY6e9Bs8Nm+e52/e0bGJHEqUeZSLiaGwZ0S/vrV4L2QpqPZTuspi0Yid+pdlCb4UW/yj19lmfS2AFh9/TRoxHKwfP7RhYAR+OoWIPrXfpkm3lmoeIUqOqWR/eT4EjTl9Klt1lwaBF9SdRXQE9bYp/6lXqnd+Iz6/A6DVJxFm2WdYad6FGO9hmNfidmP40qKMM1v95WFs5MNUf+JuYCueEGd7BTCHE64UrUrIZCR80rmdiho=
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