Zgran28/190hj5XDS5D3QOZLjcNvo44RcACfAqWvp3cd/x+F1uWn6MKNqvMI984dy2swLR+HORMEtKWmSAieVQgxNMixhEd4fwbJ1uX/KmmxbitM24tmaFuU1oT0IF6HDKFQicQ7WDnL5SeZ7GdQLoW3qyifLhhac29kKGvGSfA+YC3DPB17RSUVZduVcbquQYrODZg3mvOKoOaIssBqeEFpDnbTaNr6bmNgbGyabloWkxVrIzY9Muki1d+kpG5heuAdfdjKlA4K3jnBT6dYeZJwkMOYyPAMNZ1LrVCTH/un+NqfZtl+EJNB0XKyDTJ2Ko3cS4jqBvzQOQLemS8JMSq7SlxknJH+k6tBKbTrjFH27j+Wus/UZ8VedVV3Z461q5rdExwABzApPgqq/7giy++2aQkP7ZJZJHiwOg0Jr9Sgrg2pApd1/rCNRLo1KSoJlCAQTTh04O1nYMZjiUeTDa2Se2MZTBT9IURHmmTp+rWN6niaJe3J1xTpn+WbDOjctEM6xaRNhFoWnmzplbEtCL3GgPnlC6brvNUXQFtgG858heSJVht6zsuqGOXkich+dX+VxnP9a/krdknwAI0+9no00PYNlGvOJ880mRzXa7p5rkKJ9cLwYAD96v/K3pJqdfsTQC3wRGgd0Y9c+YZ5ZRREFDJUS69qnugq+2ccmWIpMR1Bbf6xYPzNLJdru/EvUSD5kHWbJwur0BV+UWIBxMz3pxRJMzPvOd7+eckw6q6i+3vqkoQUzk3Acj9y01BFT7YAc1KdVGJBAJS35bXiC4FuC+xgSs1AGt9IGa2xgOIe2DAKWEDFcG5wnfgG/vQgxUFYuJJ+33Ed4yj6oB8D3a4ani68gmozJtQZOIx8zMcepQKNEhOHXO3TapmVj7pubSegCUrW5Fd2BzU/OfZI+YLBk/bBK2gwEe90irjIq6IagHUQjK6zKDRHgXtkhpuK+pE3xYdvBLSGUs2+YH70lrZmagr9hVOpi7+HU0dAOo/sIi/f5tMerUWmcGufb0fIs3+jGjTwXfGlwU/ihjuqEZmvceoFQqtsoJ8My6OAW9oboJmuW9u7aBSECfc/9zQjVuEUg77yl117so1QI7vkjqkrJT8ExmiqPDrwL5LZXEAIOxl9JovZvhWK+ZAXzmF9Ps74POj17V2t2SA5nscIukkQbz+o8SbLb+2HIkuYLf5HFmlpqVPXSFpxgNyqsjrcr6QS4zmH++GrnbzZiU97LjmHGB3AVpBdiJy7tvuduULyaIvXqFKuCnKYNxwRHvZ8oZ+f1QtGDCSxwYfm7vuxUd1PoAKqQLxOkNrPJeV7KWFxma3gvWhbap5o0nUzWty50DXegdg8ZabIPABJnEWwjg0kZgIlNdFeVjY5cDo=
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