OaorKR/yd9SC3OHH5Ajb56ks6X9nShEzplzEcF5vhs//s+DX5kJyffZjWGz9GiKE8hbwJ3KQ9nN4Xji+Qi9eHWDM0cSmq7UAEN0hVVSBZhu5/cVV1AK1BYtjQJf09czVk6M7vYliQ7CEAyYnSBOljVI4076EiAxBiT3YwOc/EQKARgM+gKZuoWfvL4ihjO1+eGelSRwkBCiTWRrCSrqoROmvvgVakiYCNoZafWxGaErkAu3h7DcvjR97nxHuHNRBCmOlAyQJAXYeisHrcTfOqMTMzYzr0yZbBjH31l0EfCYVcZlHk4aEtW+Y7WIVpZ5W/57DD3Y5JLUsQNZ1effaxKM44rp5hKra3cJv48Xneg2Rie1gUdEF7FoCI15sn26gG63PWTXmq96RgyEqBnX77+HHBB+RpiOtay6BQl0X4rwaXGdZNO1YqYD+s1ogpQdxqsKLX/LoRq+gX9jsXUWRKu4lq0EoZZNdwIVtgn6dfXhKJuLnDJYx2hYCR3bzyBDjQnRtsWQPYx0Qh/JkBDl5MXGWlA7OWMEApTVeAcnyWEoH3V2rizOK6ZC2n9quQY/NmRBMVRoaFPp6uQNddFGRpjihzX0HTq+loHcX2Y+Zp2CdFwzVVIIrBTVm/f9iWS7Hbs8Ryn9dJbpExBOHWFJs4oi20iwcCGkBcupPjDGY1dO6u6vXXJj64tVBd0YxZtJrvqWWu5P9YaSDWU1RMpopBSemabcgLI/vyWBH6yvTaaQ2W+xeC9dBDV0QhrG+R3xTUjeN1uWd2vUIXNTCgv2sRDDgRgaVvrBZikcWob6+Oo8R3LUzTSkDczGfB/FtpqIUnk7/Z/B99KpAb2bX6fkrqZoWcbndCTkg8Bc01G+vCYUFLhvVEfAxaLeHermINyhyb/grmCWCq8yKJc+El9pwVQUlrHslOP80bfwa4HITNXbHjFPtN+Xm0rWMUMRgJK+MG0D2Si131zGAlzdI1yq/kyTQZurn038sFNUiRmUFZ/kOA4dQnj+Tv6erWW9XH2G1p0BG93aBWfA4uipXxps/svUyy0+x0097fHxSjGN/vB1PVJGAERMAQbNN4gZI7LSu9ogv6CaP4CZr9ydNGOGemo2T3/qc3OhqTrY3Mo0Ec1LR2U9hsjjES2fI9FldYrtB4sJVVkzVKdo8ubLwzxXc/AFW683BqRLAMQt32Cd2xM0ztGwzJjjV2vCtz97i8qeYDHFteZ//gCGWpm3iIakj+lIHSxz6o3keoqc7f7Yy5/7XBCH2RvYo5BGSirc3oTGWzPcpIAxdy1z/tGrgsgaNZCcd0/WfwQz9KFdatE8v0OqaQslAPnCYpfc77hzsOfHj/J8wL2a9wKevQ8rzCWEy25kj8seKbSvbkGv4C40=
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