sBoNMr/Ut62OUDeLg94d5i5oYBqtgYV0WCiz5zqcaSkL9cGAHCaefe2ixbqQqkR+AbD0qpUMhLxwoPrERvaENhZUbjQEj5Bd3jR+F2j+xgDMRzTB2eEjnBMuN8jlMtUDJFpvu3beYN6QbrAraDIkmROYf0AH8owr6dZCmjTY8d5Tg0fzT2h0oN62PLfexm+IHt2vHxj2vIpOD5Y014aOvB8Qkgk/hqenMfKt8rpiWNUDlrOJ9H1Ye6knv5U6oECOYeIfqHiMK3y7HP+VJiRM/CA21HMXvxiHs75LHGt78BoSiL/nx9pUs9O1QxBmg57nPNApj0h1OIXKBJ+7iWj/IGfvcOlXosLR+k+8efncKaALBsBC9PgpBkDYIQQKlvXZZbPk1lHFx8dGlyXpDZq4ExPm3cCekW12l4Gdbly1ktUpbA8KLcMVf+F6/uyRXQPFWLtrpws62oqj7I2wGC7qETnw8bPcN/fFm3HPGUuPM4Jw6DqImox3SrtelRhLcwT2x3OOitThdc8L6+Jr7y6ppvebgDFdag44At6dFrlBXxlF+XH1X2G2BWXPRXWWQVhjSshsx0n5IaH+TQStlK4gbz0avl0B8TI8grsciyeL3YO6nhu6Ci6ZcbgA7WTXbDgb0P10CNWoxVZLaW15veY3+Y6M/GvO38Loa4ezXLp4CVOWYVhEfZeE4mhDelEjtuGPNIDsKACMRsb0jnRVWDVxhLWwL8rm3hMfQCm1LwhJ1POAFYRAnpGld6B/NNQ3IyYRhsl3ko9jXS5lHwrfWhtMWKaINasjnt7LDa4PkBncOVk35W0IDE163K73bCl5oNDvUnymWsIaM/2KiUSrAk0k2kr9v+gEJfvbT/bxxpVTGYivCPa2WeNYtLNaV3si5f/ydIbdeqEY5a+SwJ6TJFZk1BQGBrMsHS00ZW4xTkBuGTPDuZlOzCw5Dd8z/+Xl7SR7I1Jj5iZRvNuvcG/XSHpbg5u2Zog8MQWLt3bAhJHXDMUbbvN34DeAxaYD8LXIDjhbuF8cC9rZGm1gH8hgfKFwjja6CoiVxpxquRtoQO/x5N4jax5uFg0C0Qp076efp8Hu8LU95H058Sdi4tUKE6bq3Iz0FPOFhDFHMjZXHU6PcnA4Odhml/IIB0K5qYlZmZqQVN8aF+vCtMU036myn5HB2skFxxa6qRh/DozltWNODZcZk9fJNVsxqsJt0dSAEzom33mohRGGYmESIWzEBFmZaDkiy6o/leDCmESzxgnr8BieflA8Z1uUl8zWgjA44NTGN7N8NdYmnVznXNkJLdczs5sSG0/akAFIrpkpArIYiHdTYqwqRMn34xjupaK4ELcTTKD97WWXk3tC5fhDh+sBG+GW10kbFyJSdeOHkuY=
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