gy+CE7S7E7br/4Oa2rwYeiHNX+BQ1PdUm+1Los/BjzPN98IkqbajJwNmHuQ8Ifod1DiNGTQWPKg94RlZM5jzCJzv4xxdtyqhbK2QBVJVWTCxLhbPOFNUlYkZ8ii0WQg/vG+9pkP8UeW1RopwR50KZWZuywPg0y6TUQjQmFj7qTubqEmxNFc0vvrFou909+eYTAlzjUhbEujAzfAv73SjbkBqMlrPlICfqfKnXxuqo4VuMfP5fomrT3MPcp1HyG29pwUR1NYCiYvaz6qF3dTCQrbq3gl6Nej5h7scUIK2h58u8GpoS2uqJ/2nBlkjsGUvEToSncbUGjub18Jo77OVM9BNPegfw/qViGrLS7rv60zPbrVuZL/qh0/2LkLW8qVGTAO4Mqg1g0k08wwfdN/vF6WDkL62g8sMNlDcaPyqysdJdIemce+vChd45IHejL6Tjzmvp2Nci+hFp1+5CdfBkSqVPQ4gzpW6eKjHo7KEZZOhcn9L0RqQ1FsnQKJxEnCGVSUGZhYhGWawtRrt0nkBn8WzTKOSbVCInjXu159Ir7L33tMZ5B0D114wNW+Wdy/OBDDmqhCz/QufP1cnYrchDlQnb3ToNq7s63myyrWp7CiG2dDGGMe0VeBYtSMMkLZ0mV+56TN10w/KOGVMiKXnKB4aN2VaKZXisya2YzRtvkSAjl7sfCIWjsPpUqvMAQzGiAK0kopxIyPRJp2DicvJfaZ+x1NKgF+9SpXiovVWyJlRuI2F+GYjDp0Y9MLk06yKrzkdvWKo20IKjw/Yo+qZXIzaYz8Ksp9NADf1wwgZTLEbbAcoIMZl0k+M9dyzL5Zti8Wzf7JCMFQ1ouFLzcXI5COmbsJVFMSO5DgCF8L3xxNKgPFKDVXbpiotqTdyi6G+7sE3LoPJItkc/NiJl5X6eThwTadhExwmPIG0jkgFSrpiCeOtLDcebFjA+JlE73lDGpss3Nm3NYyksYLKRoHMf1Rmq0UG/CAOnx181a52iSfXpIsbcio2hI/A/cAr+6UurIVZ8fzC0bmgxACnXuQXxL0G7hE7vLnkdw1LX7JEnHyT6mWg1RaRP1w4efH1FhGpyIofZdmxCM5p2Il8jTBNo9qX6oUY2BD4RKouCI+6aj9BL7LQYzS40Jdra9+Me3sXlfHMcq22LgvzCUcQHWKJDhRzDSFRQJYYOWcBSw2jFu2mrv0u74cDOXNAEglunFPqu527QJ3/6ERST7zTgDIeGuQBUidCVXtxBamR3M46hxfgLeesyuSNdlVmJaCxoqFCFBtsMVsHObfzFlU85scsB53iSvsk/lslD0i4+5X31pi46uvOeSrxGY4huF73wIDOJrKA1t9u6qCB1VBkFEMA/VWZQbuTw8lxUW60+f4=
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