0pT4YS3yifpYZGqcD469+JiZSmIWR7Sf+rpH0aHaWQaxb+rN5d0C9OlWj3Xcei8H3FryvHu9BPjwJ2eoJ5ZsWSTRC7iHLtf0FmAGEpldMQNocR17zA4W47Huo4qDxqdMbhPYoFOnu8jah9tqf2ccBYhMvDTiX4mEmeTm0SnP5ehohVr9XaVA54ZnOK4QIF0EwE02A461QxFwuQN5TEFbKTc6+HcNopgx19DwNmliH+j/57yyeD8BYX7wHJm9SIKpWc6a6fpI6J7pT2WPICcbRoYFMm3ov7tmRrAGUSmXWlo5IDUkhYhnkKZfmMOfwDYnpk+pEQ9R2lUNDKBpf1F1gisL5w6uYHfaH0GbN9MQbVgvIecqQVN5xpN76/Rp90olKgYrUghmFEaNH0aXFEsrCDUxphRhs/bV7EhYnr3wRECo6HLkAv6tPgWvbTNQ66N/I7hY5owba4KW89MCGGcmpoXh95Qvx+0TQp/GJc77YTGASwlGEwev94KAB117+Bwq6p7iD9psduNLJYCOhAPtiqnP7GVbIN7sDxM0iZ4O8vXnAUBK/K64ZAc4K+u0d+e58sH5XNRmCke6l4EWsMbCHfuUXqDKo9ipOd2Oo7ZBoZNBp7tx0TVmHJ+K1FW7dAuKUrs/7I0jrSuZBm26sOZ/JD1ppwHCS3lP9uoRH6oK8z6ENvG6J3LLBoWi2F3ZpXjRdPxJPn8xjcmlEvL6nBN6ntJbLZ4GRkQahIV1VYVzaQFIv8EEx5U5vKXmtNok8kzs1Vwv+dACz3pBX38HEcCQD13rKslryRpYbLszsG3VKrL6c9hZ+ST6Hsdr9mjqSmDVgW0kKgG0cri2ty5ehaaSvCZAGsgnumiAJlBOn5EvYH+hsu5gBMHNm73FZ9OzEk95a/kC6lzMtwwZmcL1L0hvCpVeamjEIe4X83HqwmJyf3n19Kftr6A6DoAx9tRPFP0pJ4DvTTuKdw7TeON1JneQdrIKDQBe60F0DTZyK3NEjzC9uPfLH/SufTWC5TxnV7S/29iM7guVafgWt7dVZfgOaFBs7V8fneAAuofhgEtdup4x5uOI5sp0SBfPIIESzjdeDm1TBfJKjET1N+33llsydfOaPJ+Q3eS0xsPRUrRm9/u8/6hPNB9EFQUeTzHJG3DZ5HgwvN5Eu+uM4bgWphgpmTEJMMjnu+P6aVLt/AfKyJ8cBMngY0iKlOc+A+DYOpdXC1iCTSrT66Vt0Mgoj+5ZEeLPPRhmqnwpEot9tdpawI6f4cdT9zV0HU/jOIdgwVkqpqfLZqBkD91268X5MEl5I2Z3wV0UCsyOVsLgIVK86CMtlUCY2AsjXDS5sntL9IDSBVhuopdYzYnPXj8JjRChJCbrb4+VmK23xs8+VuU=
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