YZNOUf1ZSxZ07GHdabypT2fvK/nOJ0/bUFl0QCdQArX7TEf/fNNHtLgRX2Wc3tEFZ46piXOh3VKmBRwOIv44MN8i9TI2H4/wEFrFR98GclwR5IGTb0JDt+2kg13KFn28JSh2p76j0eMW0XLmLkmDjeJqXrGrOqIHmASGFqd1oj72YIPZeAgrKEoUiZjSWsE5ypR/aFGSgZQHXGHz1MgEkbGrEcOCpEdAkPFQkFe2Aj1ieVIeD72/XlRtntym2hu9ENlyPgZPnhqO9NttQg4ueajfrUpM1yfuHtMxoLAARylGherducgu7VhaxcNXlt7+rgekr9t/WBXwq0r3Ph1lGlOys7LsZXjo6f+a0LcgJViYeKrAlGhv41tWA3KxvELiljgp6LXIsBjAtjdg4bR1aRQDMw2FxKFKG+/GV6XbbZXfFMWwNtLZPaBX6hdcL9hxsEHMuqWzgrBRi04TzH9k4W229vgvy6ANAsFC3Il9ZcvjezZzqL9CBaOjj+5YemTNefAlovrbE2Zdw9yrJ5ZOGfIF9a/uaV8IgfSKtiKiksm2+gqo6RsK3L07ODHltShUjNYXHt6wLgBTKIuhB0Ng6XlHUniDOYKbn1wtmxkMw5mN1H1MrSbCTU6+WleG5XRbpozMIXm/Ma2Iis/NGd5aYlr0y3KDCci8ejW2Rl+CMxP5TDzCz2lRcDs3FBEdtZw+cHddVigDBAVW38K26ijL23YSpJd3lzbjlmrPMugExMRtvypHW2NQikUG+IJ/qlzoSA7t5TZOFnnlrPs0nvkxN+yzMgmF3fG0D+x4zb8x/ULmxhoM7JizCRf0fFodVGWDF29+bK5vCHucZxwm+/bNc2ubkR+FTB2+6lGH03ljOzIykTrGe3mmqMYHu3d/hWgP9JulQX5UJmEf/1IRYxfy4uss3EGd4NeBEM+Lwdc6jgtN0MQcezvlxSridKEWV31K9JCVbL7fB3vTXOvYG+dXHR/MyANVQGmjxmPbW6GeccUat5uXHBJpl+CCrrcRVxMUMavu9fWvb7t9+1M5H+5ICg6tQcp9024SI26kVAJge/iz/dULyo2M8CNYykxCcpvH4bppGakH7nwAKMX0b0uj7Z+FKJH1sU0qB7c8XW08y5e/X9MnEZZs1lvpKSt+W9W00T/p7LJRObxSWMCshVl14v5vu/MN0x4o4Lu0wJMMoxebugLzdfRwfXYCgHam1CaRagmFfQE3Z+SMTroDzZbvqsToFOZWKRiMopy6/jq2MEQewA11dC1wEfiEB8kZQ4G4aPahTQIfpmWllNIsN5EqKgD3xGWfeIvImNlVM80AfCytEuQysqOn6KDdwxqKScBdnGaQ+iAzSdhpJl2lKJ3Q64nZVpNUbo1/rkY+klw=
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