BTuLGdaKgzM4GP/tXku2+e04WEjrAnzXoSCZPQT60t6tS7kc+vpN7mQaYxexWwyueYTpkFvGosZPkHhx4vDd2nyyHtxZ99n+4/YUOIDaQ/1X2Wp6HnKpbqan628S3uPo25ORUjDRu+nJ1zUHb8cBIAS606LjOscno+OUpGjciwfx+/DxK9TFI4iiVEa8HQ6iREOWgmoUjkeRsvdwtEc0D5W38KYXt68Me8Pmu6mnYPhaKm6LbfEaPqZ7hqs67CUIo6hb/KsNj00dZUo7kWWaAXRcYHqOoAFWs5XUVtuaMCrIl2GVN246lYRGVMtxFwxKnyW2rVhf55ght0aEdqoDrqFn3bkjycB7QaN3AuNls4O/ctMQoxcW5hQNNdOdCtiOje3lASLPu+KW/1ShTBmwZaOw+R6TFa19phksZyadTdeDyGdDu72Heq0+rGmGuLXQFxINHWBAg6dXLMv5MvCpmwMNqP1XdInimutmyWydN0lXWlYeVPQhL5yg1j44f6p5Trv0/vX0EMk5rZQt8O8wQByLsLjNNzgfrPf0b2nvYqyTaMPuz/h9vzFeEnmAR6Omz7Q9SU+96FufZMz7+Ofu3oKQ89rN9M9oPDpD8YMocSRxJf5UzTLJWF3VVVJp1gke7ehJVj1ELf+zuVMmO2ZYotzMpVeaV0zyq6XuYvIjsCD5AjzK+StV/tKgOAB5SHqOmOAOOzu9yqeAEVxVfBX7TxtoS40SXcZuZ7ZzqBZLvao2sYi6OhzCYJ/8uY8tBxSnW7IeWO4jnly5cPGrj+jZH5E3Iig6IiG9qgYwbK48YB4hH46NaNpn/VlA3lU4/n0vfbnIfhtOwdaCgqZG56e+WT6t+tLLGT36hj4+oarB0uYy4vAW8USelvH6Lo+3I7He8dw1MXsKq1Jn7CNPB9NUb4MOr70XlhM9qamnWod+HfZnxqfzVxe1KCyGYHDrL3OVeAXi3QGPQhqnw2PB+s9qg4Akx022Zb70QZRQpHeeIS9IGdrkIxkf0bC4pJtymDSqQvu55Wrh0fykNnOxyhhuU1W37NSitpJXihm4zwdzOB01HT/xLJLltTUk2o1VFm5lR6ucEJAnMqvUXrlhOYOLkPLCbsbBWpkFRjXGFGVW4+S24/PBAiRghyaEVnAAd01ACRrqOEGqFFTMQPk1XF6euCVV4iZfugCy61OsjvVjnZYkZHcxM//iBkOa/i415zR/ai9rMDHY2VsGrcg2s9yMFS3HphGu5QribYjCciONzzMzCmUWHvR5vhrtngz0rhF11wtSh5Vsx/fFdgIrUwOp9oWI0UdLPIQJgFA/FHH8LYBL2HESeFnaz//WR5SCPLrcS2TeNBifTwokrKZ1FmuSKGei912sENaDmQU8764=
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