MQXiIfIGem+yn+XLEfvu4qWL+rqhRiQ1WQlupMC4BitksTNwuEYukYfEIv4Z+O91Vx413z4P4NAvRK1p5EFVRy8+OdrZpXrOMA58ZyHh4zxC75nUJjwla9Zadbmp9Kyz7l8GaUXlDTCW6GpM+nPOcDc/7+vndc5UQQ66UM2fmOfDH6qMapCGFvpNFCYfJKNYtFW5/m1B0btdpjyXb9kOBo1K+TMGRC9+xzsrl5gGqHSeAeNJQqY6X7CUEQvYCT46Ie6qkQnQPI6tgkv7r2w4j9eXmoSLZpX2G+FdbVXI4YmuGCNB8qdQV3ozzStPwvg/fhytPLctQ0p/aEM6EJMBIf65qhvw4Zrxmxh9YDj0DcbiiyQNgFh0Y6Ly7cbZg0IS0Ge4A3zk0xaPegUT5QKdq1tTbGtdr+lk0GOJffiLu3JGdSdIe5czb45SApO4OR4dPqLpGNqL6kngR9Rz4Hio81Xti5Bi1IBkSAOBR5TS3i0bsNlAtZb8rsuXKGjqQkPNmLGZQHxZEy5ULB9TYGjDLa0edXdulrl1iAAIEg5BYlJ8BY40mWG+3VuJQS7X9xLsJVOaUWfmWNPhy2bF+toc6gsU9DLyJQN5PqfOa//j+h1rbRpVLV7ipReK68PlAmNH8VDgIlcjWHJ8T++vBHWbVcT0BhQKJIBtyBBDCgDgO2Cimy6YlF6ssogoUViTAPl0iKGtLDQYYCpnRIQMnN244uvyxHnXv1tj0AtJvkAIqLccNVHNJAAk1VkXtp/2xwLsn1PGiSU5gBny3uob27NomBkm63KUXFEPccyS6f1NBv/ikxTBydQdwPqSkTbu81YNj1vCDQNOFrSVa4IDdyx2z0+yRSP1kD45j0atDfnli5lBVHB5J54mYx3ALROl5BTAiKPhHBri/TZHFxJKVPsvmZVvc7UkpbuabphaYWMaqtD7H8PAXND8KDZbePaRTIO9mjP+Uf6+erTmbsvwS2CWEKpi6DcIPHmKWR8Xn4eE1fvtzAv9qor3PgFNiwoMNMZOiB2dsxy0G88rogiQZ/eucwexW4KTAxR8PuXsO4CJ7ejlVLsotUwPPfWHmjONr5jpLHmalNhjWei3zyWfyjDjq7xwLIZxsjcMQvCSs4wdYSSx4UhMeQ8L7f0AQfOk7ovA/PFE7zHOcQm1wwfeObk1+979Gr0aq3n3+cQuu5QBWdFrRG2ofPzpbkgW7Y4luHZcVMLdV/8E/yvkCEZY0Md/kBKZKLfJWIHhz9Jf9hVv6fTS8iEF4c6UlEPElvgw3jTE+csf4QJXfi/T2N23Z4uZlTt2ZVu4UO+Gx3GfQwAcKTArNdeEivgTh7/S6yJsT7jJoWxTROh4tCr/rL2Sf4poYliPWnWBjPnKxvsaTBk=
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