E/E1Xhc3wWHcC06XvcLNKl7ElCa//Pp/DuQk3AJlTKbFiRSyCY0bDBnWWzdKcqgBEuzrOq2pDVwOwp6vOF43lRdcbRahhI78QiebXHPib8XtkvWuCPAX0Q4saHzw0T44HWhz6hlC41PxPpqk14zvhidIRg5C+CZT7aE+NXekCC2ucDck6tQmdAaE7ahqHuhfAZNqM5Txzh+VoAzwWVqvEMlM5WKrUx0RXkI5SHUAX+dcsWmL0ucHjIc12EKj0yfmmw1JArhdNszikhDGovwEMZ711TaNzV9QPWCpwoz7iiGWf8Ehs92weyrguxhteZz4Zehh0U9vKNXPpMDUnRfQZImGEb6xjIqeuaLbVUZ1OgrIUttCGh8OiNQmUs8R0LZr8+X+0Dpow422RlE1elBH/vrA3tKq2Bm7q65iyWLvwXgGWUdG60FhzCo5U4qgeGUlUjsOBi24cIkdditE9MbjQ70ODkcU7jIe85ND5vzWgwAy8/GUQZRSlvw7WU7IFmhXUPvv3cMi1OW/jeqF62SUcy3/uC4WFRfXfrq1i9BChI8zF3/Z0pziPCZ+++YNjpLClPDqunVhj56bCLIisVpPNHdOTSn3oIMSPBaOTFOhAOtJ/RTt8OpHMeQRSonpeYpndmQ1+L6lEJjc6bJM4brvup411dFxHN1PUxeIUXfazJAWAJV0j02VmhhNRijywTvTb9+uAQ6e0UfhNSKTN+WdRvesiEKvcU5+L8F9NgLeVJWUi/D0q0AOyqkGvphC4keI+Q249cR3zjlICxLyLdg9Yzg76K+IFIAYXvrx9vQuhk8hm5wLIrLwqjyomD2Uq7CMwPzdkUXYbbEPIYPQVRfUBT8fZfDDNEMqg1OPL0S2teBrdgmznx4esnNl0Q7PD5p+uG34UIx8uz2aT10ge6DDXp8uZHXWow3VKDX/DdY+jzPi8O1gjRPXJiil8oEkY18gPlTCnNzDuy/wvwvajpDFaZZdduUhVQnp4l3vUZsii9bdXHPHw9tVsRSl18nK8TZG14+oEpfUh1R1p3kqlInlQiy57/AuX6+38R6fB05i7UyEl98gLoMj7BkPahhXWEfb8nY8Q4sKDHifUutoQch3tPcMVtu8q/x0FAj59hAfzHfwHlIWNKnYommWBwf7qJ0YuOEF4TeQc4FN3WWUGGwlnwYEo8wvQbLLPjbHFEbroJmqP6TcYDmVsOxJ5+5kkKekz8gMRBsePCCRe+QmtzcTSX39QQPy5HFf9qdh4myIDCs+qctcoUlXPrPZTIS40Mmu1GH0Xnho/atHJB0OYMbfTREg12f+3KKJTIMOsapqPqLUtd8xY72v7Eh7e/92QaD3mUhrvCGg4cU43V803uzU/VUHqju72wF4Qs/W7ek=
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