BzmMhq+y4Beib+inniCd/dwkiGoDHQK2KtchUe7puzpE8C3Yg05EfgoQcs1SHSABe5SHBtgGOZ46LFhpx1VfOIZWY0P+1OFKw1Ti5Mdh+sD0ZNX3mQjb3qKBeyYPEauZ3U1xW1Tcc/+xHU+l70GkqxFMMrVCbvYbcpKNAKG84eZwuB6qFMjnL7gZK3xJQuz1x0MhZU5otDjzEbXmt6knSFnL4oiZsJ1xbLA3ItL+F/+9th/5rtoaWXFf2Ucr5TbmRs1y2Kqo8+PyBHCAORbppTOS9SOk/tvgm2MSJcP6kLz8BgE48hqN1i0JG3TFZNSfVwoCRHJ+tCRzoouLKqYxuLC755CVP2A1CtaclJaFZW9SE4AVWrb1i5mo/iEgV3DrI+4+NPGWEItEmhtSfw3COT/gC+GYJTM2+BylZwezPzE0QbzECSqh5+z5HOP11hylXy9N4uCQnyokh/veoQf6gUWhIzoov5Q10icymI49ZzMG5KeL0+UDrwOLZxz/aexvcFa4Dg5gi5ZgFMXmWh4SBTDTDfCQKLXEYWJ12+Hzm6rgUtZVJG8Y9dmjreM+PqkaD+J2SWMq4gM12K9RdK24N+jfZINTNjesGy2F8uxKcLCzYn2MHWEK0oNx2XDl0fglIpMM1TKK+1K/fW2/bKAo9cN3utr8PiofiaMAs1iJo2ymERzjJoshiFKc8UGk4WTNtazszcMlACITk34zPbyLQv0zVWGcboywWPLWycEzSdMzI1zHnIJ5CmLSxqVBsLJeMTqmW01Lg0mGjusMOWNA71/s91ngA2DiXuGJtoBbyyuTbjLgL+Ec6Fio5tD4HzYYbpDP3LXdvRmnjZDV3GUoH2WWKOCK06BfQi5nmcC5GI6KzPGQ5h6mxUqohyiLBRWCu0Y5scMfiNJHtX7CRG+AvPxMBeRofTAzMI565yGs+FdchfgzmkAJihUlsdcKk/8FIpKBQFrZmj2sw7fzMBajosM8Z88dvdf3FMqeQhlWqgyosaTre4dKEzrHCk++SbSAQ5v6zNOOo/WmORFf5tLiZVKS5x3B9TRx2C0ti5hxJqUmUL6CLl4YsGSQixmSrF6n7yyUaER6pRPKkaVxp97OotPFWU8BiIWOLZiH2KpBbPIM67d411ywKm/Ivn1w1oLcQpdYD2Pd9B5+2QpCfNRxd/Dw/zt/iHCqX0WY5jjIudTtVMQcUT7XWmFwxU9NxQo39xkKleOWiMMoyJes1171OcZtvbmXUbvZoz+zW/NLxQjZfyvb9hsvj5PL45axwF5Z9lz196pXL+ctQhxbX1w6bRKcowSBSRO9SWtuFaxNEtCkRaq4x6ohD2t7nDVTPPc14RSJEZ0ebPTi9Cw2fxIM3n+TXf/7IrXz4up+9W0=
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