MKfC1i0VUp2iBDJ4Q+6SGA55SXVUg4WSzZXZ5X6xqyGmWDBzLpcDDm+KNEvamA9tW0jY9Q/RoES0/D9ZtmAtBmhC7JO4GMguVs+3K3eqx4UX+gWdW91dPNdrRmzooc4dM/wTf7Ehleex2NJ0R5T/lpxi+l2z9HlZUipd4dBLHZsZiNTP7IjrAMLvnACzxIxhdCAD5z0Ed9cQpDgvakmMAT706zGhj7VfaUMkx6fvEFwKtjyqAZ6N6BbtDy2WP/8dDNFe8PGXrE4yJjaGAWpf8YfefDSS/LbOiB9jjiCavELkSe1VIT8UgNhz5jtR5Pt/ud2n3sna6qZMohogIbgEmSCm/j8pfiJ7vzundqbqXUKxh/wyOi4lV+A2rbjiGzJ/vrafKURd6Cq5eq2pE/Xse81WJmr0lxk5y+AWNVCq/x3y6XJDJAbhaeRbyhscu3bOrPnT47HDj3EtSuUX1MYp+bP9WHTnIevjRmGMMpfNLOfAqJaqQqoJspXN7ShxkmyYPYG7xDx7Dg4nrxu/k5R3gJeRMc/hZ73MnPrHFXMAQI2Vae8//TlrSalA9FD1aDPdGqkEqawxA29iTUpZbcz3FpL3rLHOFOz6iyBSsUZ4wSQWzdlITodMS63P8p80HoOuA1M6Kxy9AI0GsDOK7P/QkdkcujETk4eGo0q09iN+uIe7BdclLIEfDPP8rACzYfLO5W3nj+KFrFiRHMntdkht9Pqzlxe2idBtQl6RW8SWtySetPbRJuLlAZEGVQx4LJ9i/zht1LTduRY0AKTqQyVLeGWatB4CwXa7rri8v5GUIbZ6H4ujKhKAUwkwY9BKiKVZw8VUtVZIWfbnfiH7qz39LQohRTOa/lYgnvPqiYFdnrMFg+L8fFLOhMVl/lsIQTxWX7yAS0KxpsAh0oxMlrnV02X0FfIPSTelGpwqkXo61kFvmHnv2EQE8h+60ZscqzlTg5ruSjFObjjiD2jc2ShIoLM6PeI2wI9EJkUvMB9bGIZefsAZvelJAhLPeus1bztW8h90MKY2DD4QSLT2IJ6XZqRmDTDMwoJr6Bs5oFNNjo13G267+eHA8csn+73CdUQoAJLrMwpvcwxZFPfq19LW6wxBnO8LgkbvMlTi5aIPfhGr8vef01Ic8FisWLJGQjiiF6+iWwHRBgujWLSs7lzhF/EwR+TQmpGY7W/zIT7y2x2FSIX6amCdJc+D8uAnA+HEMQje2Xl9iafw5uBXCslMPTvvdtPk+Dq+3uZHSUCcDmqWI90Ii4Fjvi0LYv14sanzyYoC7YhLAXFH5ZWnXTeUZp+ZPKqE+3uq1RjexwItLWtXHV5Eqjf38cMnFVG+EEgGrxCXC/D1Yh4JBnUSRhZ5caWPS557P7kYmFWkfZs=
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