cDHl6iGhSIxAnWHlHckJlwGUDKkrqFXdFk+sN5D34KHZm5tSrlBSCFaNYNWctLpluOzjbPZtjCdrYUMINqXWHzP4tMT6NgFK6Z08Sfjr7VzQRTeDb7PpfXcUQRBgsjEGGjEVl/H7hWTGj67SIc5wjTaSh7s/U+jlu0CFrOrFmkPUVYwihdkq6IJ7OUU3Owg4a2IkMa2u2jdN4mxND+70WHrm+hynRZ6RfHaRJ4EJ07Ug5XH7+joKMk+gbzBjHiVuEj9hu5rZmqcEJqPzg8YlMhSBG+UYJfI/cEF8TwcNy/IhC342tBlQabBMXCEq6xzh/WJA6uBs3LaIVQmEcNEy6aC+5jAGGZnz+CL8TwZ3Hfvlp7NaeNL3lASuY2DJd8Z2EQBjEttnhi6E+sZyS069uZk0lQN/AhsfpBiG8dwH2ohq+YPEIdy0bi5bhLwLZYeoIZB16hvqvLTR3Whh2gT47If9cJ67AmvDl5JTefV7L1AwQH7Ve4oXOGT/w91m2fHwI4KlSfYQ5VFSAzy4nFJBwk1e8wQ2z1y43IgBYum426hU7EhxHBMxKUQdpQ4oBmOeaEOVb7vuF58nUI27EjFlvDNPKELeO7AKi5kOT8Mc5eO3uB0miIRirZUe5GCNViZRLJUa9QmM7NF6KxJVyaEfLpb+yKYwmgvcqwgsItm+5KktnJ/mEIdzUkCFyrJNdMRmpiV+yRwECRUy6za+vKHob/qtEIcFT0d2cqau0iFHNYfAUBdrmy7jH4iPjSLT4uaNeXK4WiJ7j+fc7sjA4JmiOE69kptBBWbJXE9WcfJz98JHBA1eehej1KHvlWT9ku9Q3CvAv++7/7eVm4wRhp3+1jKWwEh30wz1ENkjGkpPKZgxoo0xSp+nL/JGtrgkzJK64A0GtHosmcj7KIvO9kptx0L2Mkhxm91YRS7FDVseAgxROz59UBIjrawx3zZsxKFMWsdRC9SyErJKUnD9YrWfW/spJ5RAGR8fDMr/nKB2q0FSO51dqrKzC9dWvVZ/nLKJxa+vCQvQdL94iaKydHercX0i5KNIHDhtoIjPYyVHMADK7Z7BQY5h0SBgVFondK3aKWrR8sG0BbmR7mWVwC7OELVUZDfyrCb6i51nX45lnNTvHlOBHBhdYNC9k4e+TIXEtAnwdHsj3x0iXkvD8uq2FChsbasqcWxpGekj5XQDLKSqeWdqdxat7c3fWj+SMweuMcgml0eUSviOUeXoO6zWr84KgoONwWQWKNdaOtf0pIG5D4/DKUm2YDh7RHxmEsnRetQbUy+CAw99jjc8pbJOFe9ydqkVvuheNk7AJlQfdLIdRpFJrzDnolVjlfF6nvCkPCZVXZQE87w6Jo4lYzkU0wCz0Hgvul9QLEebGUQ=
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