YCkXtv3OzBbP8v6zSfKaeGL3sthu3dCmOpc2V9ndQHAT9CG5sEWFevfdirz403kNTzAVOWwGpkcQrX0trahfdESZivH5LMqY4MldZmXxLW9xGOUpwx4mb1oIvrLmxhlJ+k/kcQKH/94DBsFck175QqIAQ1rf90vnNKyU4CRXWO8flsnSwkVUItws0D5oyXvdLM0hf3+6aDXkiXxUdCjh+2f8/n6mY467n/5XPdmRaXJMfmtXo2Phg8oA18fVrqOOrE5A6hQtOM8yr+CmPqLoej5baaemjRVnKJLC8rbQFrD8jP95uolPQRbb6ircHgsPvVHfe0nv8OqZhu/N+oV/Q9OL2AaZ2Upom6bu6Tf9O1fHPyEuUmobm2GpVl5IeqDg502QJhFe8JRrm4zowXRDYQT4g7HJjPaiVF48nF+dv4mOWmLhHLbDUiLfZGZE3lsK9DaJ5H8sl6BwG1Kzi9MGogBaJ/KaMTwE4NimN7wv/ex1Y/TJtEBrQNqPPr/QZfFGzLtzK7CjIawCJAUZ5Ffvg9DaqgRdgIHip2i+UdCiuOCFhMHSRfKIWqJHJa3JhN1yWTGAVrCqnJBa3dmygUFq6dK2QQlabzEmLlUyhaNS0h0pZzYh6ruxirwUQms4bc1bwJvTwa2cs7n2J/R6xy+tCpMKg28UkBkNN6eGECZL+cpXTiY6mtAb9s38zHqSn+o4iRfHqy+Ip9DB51ZwwgXGQZykcXGuTLBQmtolkKCrNH28UTtbQFc3gFDtGxnYDRaN7HfW/HvDQEeuLUzvGGHyekB+GPBYy43aG5E1wYMJxdHHgqT4Z0Ufqmxt19gcWMbKyNuSIZV8MDclCpCOwEm1WZCbwFWd5SnUwELM55QUA/7LEfANwlSjfDO/ngrPKluWSS/E7JXUvmT/amLAeF45yfFVBRrWaVl1IZ+V9FelCn7SkWcSwIFG1q5SgXzM7bAJ2kV7jnnxEbTQbM0ZE/h+xHYuOAL5r4Y+WTOX8zwfuNHWdBIHf3Gc31cyS2/mxK8y7mcvdjo0JVVcFECEjtHxwbCDS868jkdCyBty4FzT+oe3qtQhmwzqtvSVctzG0T2Z3PytkrFKsbruJNkQfe1H7vceCdzhnBxi5e68HldVzNefqnQ5lC8Mn5DlEdvI9zJF5Lc+zCEkSvajtwXlcqL7irbD7+nX3MDHMDr0sOWsxjH8PdvjsuV7bWxTBQSdNGMbKe0TJPQ++HwDbcOUtU2WDxhg3wFw/rqoUwKs0UsOGYt6WfXY8DDWUknr0UAxUUUmlp6knBFTwEa/Aq3X7coNiOqMSZ6CNv+0n/zwqPCDr/KfWqMfNpLh447ViC6pmcnyIwhS2sDB4X2Rwr+T7xYSzMyC3ZyStkLMd13VWnA=
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