hxgYrezqWdcP7GS+oOmKlGxezg2uISqJQX9gf/GERALiW9JFedeisX1grwss6Ey1dxajLtrKE6UDI/aLJRMQL/DyzVt4yxio3c7z+C2am0ie7P6GCPvbdzEFeaxGZgRzWtSEFePTLTj2COteyyuw2JRKT6bf46TTdrkJMajvyTiaM1qZncmPL0DprOHiW7EzJlnGgKAx6LnHnolkF64QanopzjSupoMyAx8Pnqo9vEnsSVjTth9kYZKeOT/9v/laNuPuK/B3JdjNabP1BpAPtPAraWHS1s2y45nlYNhRDBUcpvKv0HZz8e5x4BDpHxfisMSMIXhSaj4xpXi0h+EGmQpZf0QtfE8PU9QYfhtZ4sQP1PyO1aJp3Odpl3rCkjsVJVRpPzLVT7KghSp3cmrcU1BRCuro9+4oZ1T9Zsh1Sy4vJzTF1yQAATfMqYxLTB7LzdVDxawP1sE86Eb1cQcnYoLor0eS+xtYgqqD3BSVUZgT6THxg+ePhB3ddiZOxbxvXIPPwwSqv+oHtY0lDzsTZZkJZ0ZJKcVEeEY7Sjz9So9O1CpSNljnVRIS/fDaV7fGPTX7tvL/UhqzVZpwvlrZy5WJ248S1bjyyxaekzZ2Gjad14UYvCvDiKS5mhlQg0MuT5Qx2YELzjv7RECa5KyNqMj74HhYbkXPnq1qJB8VwQdJT21ubk9IQhh0PD4BnnkWo/yWokzSjRvap+byMGvIukWiSrUI9p6zztuXNeJfo01c3MM5sbihy2vktkxxE2hgDdQwMZeZyqQXRrl9QwHX/8Fy5VyssuPHFCYAnD3/WO7V3ovAUu0BU/1NLz0294kmW3o9AZeF6NvJKDmebds3NQ0sRj1GJEXX+0kA2/aScJbJuZBM77c7goUVYoqBScT/1CeZe6zUpqHvQL7g1QidQuJtZ5h5rPPhA7j7fCHrBN07mJv7/uFBpNbKwH9eFtF4QvT/wjg1odsIA9TG8JZD11jtEV+xe3G/XEo2ce3f2nHIsU+oDI9cK09Y4TKkbUSazkWPFl8GNe/KGzf1mL72fRPwIb89Me8TUbacL9nNJ70zF60cxheKMWKlBU2axru6gMW7PWlezpxnYnrNyYJD5N8bmzQJdv63ZfHA1sVvclihwDQXakAKhoy0n1/QTyDPGocbIGk1t3TidYgKo2Q/X+zgRfy0vJmxTkZcpy0Y7IntOrxSwJ51Rs8I5/kdwi3+oV7G17T/VSeuTjP4ejGX6NeDdsn+RqLSuwAGdgQZwOmE/5LgczLBmJcOeQ1KVoeWopuWmlS2Ol21fwvL2vaTQAqw/H+ZdAYG0Yn6CIu26757oDdmoZI+F+onIDWaPLtA9Tp14yv2knuvNT/AJbAkn7qtLHzkmUVSYFVs8WI=
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