3dwYN7hrRuNS7xrHsnhIIcGo0P4+DJIgt4oULgxNkjqA4Zjkhn8Js9hE1bzi4FmX57VPyUj+TJSxdA95vePxfbjV7PGT+xZjjwP39G/QmwAGPginSQiuvqvxK9J/pCkz1/hFNUzmOCoYXsq3ssqYGakUNtC4tmpnDNDFCKzsIxE9BZzrefN23WgPhPpoN8bok2X6Y77xn2bhYHS0DrjXSKRjUezdpiFtB3KAdY7NHxkxTwxGKYMxhTsZpt1EI/Qm1F/fVuL/EPEjSr2Ce0sSlKpCEyGdSaAx7kFrGYSvHGt391f4kclkOd/+ah728cr08mDt0iWMdM0rEZlrLd0xW/U7KD30XBNQLJSDqkX1eiffp3EsOrs0je1xUdZrlXJffVhZpyYHtTcTkov0VexDRewcHtSNh1J/TjOtyja0XyJk0h6k1qpyqu9lZnMTc9k0hsEFzSLaX3Al2fcCllvOlVSYq+FBGRYriEgotzC28NGwNYVgsvWMl5i1oiML3dGdE9MTvaPRpzakKn8GApH+NBvlQUBCXkudhWBnmy4lsimWrKd+wVRmzqJn6PAxKxesmwv4Pi7ZAzruaUByvu4AAx08ri9nTdV3h05O5q2MtVNwfEv0urtYnhD6+C9uXJvWz1Kmqc64FZ9UDJQgh/TV8WGGp2ldcvCl4AWRh3kzZVajhM3tzGZbOXxLvXNowNaaePW2+6DD9nSFdkH/UwqbOuS6dB+KMEoWEAxR/ch83SN/94zZuXTrNjhOaMal38R8oVWQGgufWTGE8KmK03TUNclpbBbUPbjDkPX8nf4c6U/MHkFeeTwYiTZEwthHZyKfEqOPPWRDX5lDIq6u4sdwt/89AvVPZX0FLUO5ylossghL6FO5wlH10yY/jGmPG3BbExwVzPNJ+JjPc2sOgNHnvYdaCG0kIgnK320E8Sy2OZ+7atCwEY8jrkX2fOaLLkFPVj4e6vqCsy5AtF5bqt67F5fKo2o3JumpWFhosYeQ0JiJBKsqz11NT1ibSrVIFWMD01QgTGQ/DW1v+LJptVy8Lq4/2pGL5XmJpKvG2/cLRPqTdcD6woc5wTsi8Lj8KKnJ2Vkc/8cURKtdstlz0bcoPj2QFxvxvTfQi/ANmvpWxro4dmnAJMR6vG0pl607lt1pBolwfHK5jMVB6bXdejG4ayyQsJKuf6jDc5nW5GkNIs9vEZMaV9SUZ+5PHsha1oPdSeVO7o8Jm6sGOoKqlg2JoKwiv2/NrgrUp5alBBG8ocLvqH36a83riRG3DUMP8fkTNSgd/QByX9hzTnPSGiyZXsXGlfugGDpnmCeldXb6anC9yUbwmezWKs71eGkp8l7oyXlE1H6pVLB0WYmw2b4iQwC0zQV3eCxWQ/nr8sU=
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