Zre/Jm23Ik1kUH6DqLXRHD4zVbrZUQOVWggYUn18CtOUjXiN5seWZln2EhkB5xGj9FNHyAe+fg3JPWJOcfSecTBzV86F7bTFM3OP3CJUMDJ+GnsFKUQB6hzDsByQ6hEPwHlrzpWXH/hbsyTkgSOg4FtLFUPPo+2gIfAoYBxA4AlavbmcT8xFKqRH21YFi+uCnTRR2XsUQhh8IndF0Gb3OUc+LPjYRJBIcPN3BDDNy1Y1nAyXdsNLzCn+/I4X5dUJ7rBz9hxotpe4Q4qlGG2Q6VQdWEqOK+Ldt4xcg1Qz3SFmyMJW2DZxAoxnIVchVl0hRZfLYQZaQF6DJcUR03Bpu+yTCoLVP2V8one4C7ZI/WuPUk10FqzhEFUsGpJEcUx+CP/X8YRoyDNxSgj4x/SsecYZT1biGtW698LPggzC50cxFf+8MDAggZbX73nBJDJHqHfZpSUEYOPV7KCI/b0YDZYBXnyw1xoj6x7pro+gaVazt5J8ZIzwiF0I8xIiDQFAbKzl1dixaPfi7+NdzkwDIZrLqlYZ5LAazj9hPCrxaCun2c87mMXsA6T36w8OlBQgmnwrznBbKUyTx8W1MKFtJY2Q8lVB5F5BuaRu0Thn1k2/sjIxV/b4oftR+yfi5Bz309nR/CmtZ7V9RbPTkLA5q8mGUIByRj/a9w7PMhuWO1zD8//gtgF/Ar8xiOA34/2UVSO7DbR3u1yvHs8HUcRESpqoU1z2Rk8Xp/TDi9WPEr+/4DMzUBzReppA+6MM+3902ouOotF2Lwe7qypeOdBlwd8JrTfX2ILmuWrbblxmWS6h650oBN7q8Np7APX6vKNwFj8nz+dccL43RmwdYeNlnPUEivOkzQKq4zeiY91KcJU+8Gor12qjEq0lPNBCo1RUBA9jdY57lCf0oMfXVZEYNOSpM+xIqEywUR3OrSqslSC5ol7aRZ9eLd7Tj3hORD4X5y92FvQTJmxflpxkmgOmtAOXJlrgzfIbWqumEh5TtuODRF+FSo3ieBjaE89uz5fEeoi4cDmFONfukeS3lGT4F8vu/ps2BZKqr5vRpWUn8teCNNOaEAuEVkIPyu1y9gwJ4fttNoUM4brii5TqlwP8JA1AQH+0G3QOduDjglp/7pk53PWFA61xn4RZUf6FS6D5gpzxUwOsmJ0++dVdiRELVykWertFu0Nh43U7n5muXnp4y3R3NIsjT1iSEH1oKeFZJSNz/knSMbOPQeW5h4MZb/isMce0bB1fepTAGwYKLHtDrLMhnhEqCb/DEHjw4WYUggAyRkgzHyMstWT5e6uA1dGTEHP4goYnh1HVPrfbbp23VuKYNc0/aG2i7zP3OuSjrm5Eo2vdAB1PbkiLyIu6YuurwNvWA5iEiHw0X3s=
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