BkfGyxc4b7TM9aIY+IFZO5u3CqbhBT9Lunp7yPzUV/QPvoBDilupOlj0q5sqdkRu/bHur6+QniTLQveurscRkdGUVdGF43p4wzX6QoU+ysuIfl18+vxa0bII7XwUFPV1pSUSBAmL/EIE4QSQOGYITLkfDQ4L0vY7a5yHUIwZAiU4frTAITsxzXWlz1j69JyOosXMPuBarpue3t3N0U+lIvNYLz9i+w7Prd1UhbXEwEC0FSh+zMgw5AGw09Ou2mlFsIEu9EZaivSsG+DkQUuY4jw09BgBprxCBm6FWgGcKTHTY++VfwFfDSS0vHzM2Be5Y2qOgxAm7Nr7moTXqULYEouZ+SxFZd5DnAlG+fMJyRUoXrxyr/oGndcCoaynHs1L25RPJa0TCCQLPH+8OfShZSp3ovxfrfmUpFCuvgOFkcx23bc4XBPTcO3s9hNLU+oUGWlIglr28jriSnLgyWinFVILI+faZoPl1Y16ahQN5+VuAPxjJQg0+IbpxjN+f/k7hlE6jlHGXFkLRXl3A0kduewvpVTmrc8BO0rOerABznDAh0IX049fuH1Hn5QygIk9tztS228eBSXBvh0UwkrW7qc2j310knKSXwPlfECDd993AUewntWCirfzSs/PJrIUgG1oNaBRJdSqANxmtZSG5C9ZnoIbnDFBfjZPML0BdNoITChrIXcA7a5j2fCWiPhGhP7yUSBjynUpn+mUaFvml7QMKYaoZnu8FA9ei9fNgEAX7+pEhx71laFG0wzOcdY/kSEdvwyA/OrII2/oEfg8K0DA6X5XJHH1PfcrbFhQkM+UAV0lvPcQk1R8aN8n03xEYYd96j9+JvBqZwFl4/BIthjxVueuOFV6F/DHTTztg1InIPqSh3I50ra4RefJaU3IMRJ/UOcrNQdhiSVlHO2BdhdHDgbe7ivvz0pyMG7Kgm/GPcKilKclMlebtJ/ChPTG5dRJNmhCu/5umKMcXb02gRW2i9C4tKn04Lze5vUarceQPAuBxyWX/qFt2IyS3350GQwPJe7ODMJB3JUmRH05KW5QzUI9Z06bdWOkQFRb+uGLuFzmwLdnKeNO7RJdBU4gi+3zxSd6kEPF39fJRD12nd4MvsMGZVSMsMh6D8KkAM09YZLhhT2nU59ndVdHtHozX48N54F6Hv67ftmsj/m0W/ZrjeCFjyfUW4jDUgx5g059feHkQhZymblJsjhPW8H2QvJRiqhDKbH6grhDyqUeo6fKPiGAnAbKaP5LAP6isz5IlgiNrClJjn+kaOhcFItM52pfdebS1dripzusXaeLDmlKSby3wEJZHeTih1kyzOX9jloWWgo9SCR3C1Nz96fxtGRnABNLU+G8wcvmXoFx1Ti2ksKcVOLXiB8lxTA=
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