12UH7zenwedl3uPBpxjPVn8dRbLsTDhpJpq27dm3X315bMCBRiL8iX35jhgimx6QFU9ppMePiVmlxAsdVpZJ3VQjzrw+60QbBuODZM0ajv65DgeCinl+ovtLJIVYCrPNOLg5UVpqRFZMdWTZkKYbwrRl74PtwJtV7k4fbi+Q038CXAHqxDWjuuLcckb8GTDFZnYr+JKS6cgMv65XOoHpVBjOgkxlteGCsbvoQr2K7DY1IZTPRZUPiDbzNRM9q+5A6V7pFp7KVPiRfBw6l8fd2qcVgCMinhwTLQWp+dbcNX7rZ+kQlrBYU3bZWM5Gj05stCd4dix/EdDAtz4X48XoGhmAiHOk0+XnKajY4jb6jb05z9jbbBD78RbNDKQmsUMSoFhbQpkTjcTb7TgU55k7P/+zX13+83OAEs9AgGdVhXDT9YBYhYxtzsNm80Lf8ho22zVwXvJnayhnfacno7V9+G1PNDOrybXjGnrF/ttXgtWwil46n/c+dqxxfZ1c1t3rcWj3R6P/GP9zpQdNj5WDISBn93phUbFD9+YPooGvGblOi5PPTG0TR+13h9wcBFOSQCTbcBZg0OGBtC5/7wCZemVVzQU8AtfnL9pNl7h/VRqfg9XHefL1cJFLo5DCAPDMnasxHghIJifv5qTcztam1wufSJSxDp1r7kWntXpC/JPor4DtuSsZL8irAvu8Mh0j1ath2KUEL4SDlNI4xpQ6duy2h/Uk0u3JyC5RoQ6/joJEl78JuGgbmy8/K/K2VzNB07gOwTpfccFJll2R78NyMAsrYIXMw/7HD2ZZs7RascI8CpbIISep7Omd8v5Fjjg1qzwP3woX3PCRIa4DNAqVrBKjTB/4MoUfIludIYAidC+ENTkLf6spbZn4MEF8xWcz8ujaEI6y/F+InnNx8ou/9XX9Lnk0QmeNDDnIb+AdBiqapMoHwjvQ1G7TLrFL7h0DD2G/pZUhuNetnZPT7vbDHn4eGf4h4VEdBSA0WSPS7Tr/RfIu6Ftwe2c/Hvfk1gEdJ1cnBieI+9AoGlf7YBi5cpUMWtaKWx82g8wOkt0HqiXIwWo1lhZ4fVdxNOKD/pf6/yOM7Usb5eP4b5m0r+nCwB+K4SQnsVZDiHmVH8LWIbT8Clh/1HkbVi+HsHwyt7/3MB/Mc1Wx37AxGoBkKULz/OVTPf20N79KqCE825qPSDRQHWSHv4gtxj/eHcFdznwoF8o6GJuCZqYYKGSj2P0ud3qfEQYZZez3BXrs6pZ4Gvk5g6YEWCTmoR2RcyaTrdEScSapeFpoWY3gBIGseoJWwYiQUaKEagidsETL7ff3Fej9B1yC1G11eooKyvPQ79QQai+63biBfI7JcrXxw1oD7NIOi4vqdOjWWZEpmVI=
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