aTJUy+aucoa7G70ps/CsJ77EEOi74rhP6yUzRcJRTGJ/S2rcXw4Tn/i8BBegXYiV2m8sJmOwpwf+iVA1ZLTxuQkUpBj3JKqrnnDEaWDxHAzT7/lJXcXEWKL58KnDuXhuRJpcvbtl+rEldIuRb1Df2T5afyNEM0tATQhqZ0ViK0qP6BQyCo0eHndF2f/yqm1KeIfMtvfSsA++rkMQLeFHI6wVH7fxHYsKA/YssNyHRgg85b3gYS86i1r19eBEhlNgt0Ql5CWTVeFrFllwERrm8PgkO7nkwJM6KDbUdzteU+0IWlfNb66LCCEbQlU+zig+7wK2aPaQH08+o/lLCwAG1PJJ1SU+3CmF91+CvdSNuzvAQhFQcz09Bx+4/kuBPBtqyQHzUFqiBG9F3DiVzLvRr9I7+8r94251DiNtvfyXdEWmPgbFo1DYC79IOIjIGc5vOAP1fa2dmZDLqY3OFAC0hLfLkLKlU+GIGdkFYJ0EpdDrAblb7PBTRorhUSVGNTjUda88zykjh2y8FyRn4FKkjqFc3JkD/wuoCGv7HXicRhwLy/KAEoSrlwXk4/6bOSR5cCzemVbcCEa1LCy9ZJnVxQ6W6UjXvEeTyQAt/tVnX1BzoK7zMC5ZVTZQTf1ItXr4uDAQoDoyTmZLY1xLzc5P/drRhvs6HYCTI7L40TjOfhh0iByRu3ygNF4mTo+rSxMLl+BJnQ3QT3DjzifiJZcKsS/JXmBIHzRV5hdXeKMymhOjb3OBw+Vcj3Oj6nKsPIEhnvzEtkreVS6+F9FKJ22Ybt9DODzPBBwEwp5xYUzXzGCGuQQN+PC63DuG/i9Yj7eLPjL1NczftZg6Hjx8VLrzEFgapof0EGx0MfUTs6ivVHHvODp6hSV8J03rz/QVQyR5E2+mh/tp4xDk6ue07C/n+hyl77dKmldYF9qvf51UHi4lbE/40+eFfxvhnS2E0oSTE/KbYP87neoXcMwaadFN478wMfnRFU0H3IQV+UAJXbcmKi84QQqVkD43t4+4QQ+qSKBmzyUo8Q2hV2gC/gLxuaNHpBOInPfveFEUkfM7tUvg8IKgPLd3Igi7eYijhdqCCJDMWQmm0ttyXqifXH8eA3h2dSG6xH+NThF6ySoR09wbV6YfgfwsPmx0mtvPFgtAgjB6tp9vD5cTqsJZZRKZwlrx8SFT/WyYULpsLf2tAwehWkxfeLFEgifJNLd19KglW1LpaAbFQpjqNPOMqEzdzDCkb4cGP0Hr9DPz4YjqMttR/NMgbNP4dTc/ZB/d7/LH1+hnR9mHhcaygES6Pa8ULRBbe/3mMWuReIExX3Vlcc3WQhsWRYT99WWlaVDpqo7qWwLtRKY+oa4N135ciDBC1mwEzeAf28DFxfebCgA=
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