EPW8q6QjO3x8frsNAj9eibWlTDvKfSpWRrsqELHYvsOdd6++r0+J93faE0NzoYYe+Sx2jNFD1SSBbVLzS7i08c2/ZKfABLCVwPpaqYnO5DLeyj27lKD83XQ2Od6LIcARB4XcIQqefnQ8DkgqNJ89Wjnc4gxZII6Gbrjl2xRMlK3yldW8Mtx0l3G6mT+Tu+LJfaYvUugJ3oHCEhQhowhlWc1A+ASI7o8K6JJ/ZSzaBcWTAlr8+he8rJJ0Blh+8brIXwyhzR0w57Rt08eNRL3PmJN4q3l69nNvH2DKItyIRnYY7xUl/jxp+BW/w9QIIB5uhhey4TB6f0DlVWXgE2RFJSNHl67zwp2O1kdCeqKPF1AUqb3PhU9iFs9IMTup/RGdO6OEPvcut3CUUZe63Pk5MzhRDr7c4JF3lKidigHTOHS+24Dk5iFwQ1a6s7KEkcsbDOtiLf52P4sdqu9BkZE5RJsZXdULxQe2BoHhNDGcgLuo6+bWELDZ3vrGTX86fCOmoq9WecUspTyevHScjsorDWDODRSK81Kh0lrFkbOrhz9n5T24Jl9WvOWDC5cFW6ehJ6YoCmRxaLw3r/bApYFBOxitvOhRFhggCZsZvPTMMS6E1fozOm/qiGKsUt1AIvgw67KRKwbVtXzdUCc3CkcDJuyNJlMjbQ/OSPJK66cACz1QMiHGbmxD4qmk6yihihEwTxIzPAW39CAAsbccxg8/W28Ls67ELvbikWiOX8M5A++NvdLve6IwJxdp2dgvRwXfCV5WaZRkaDEGu3a9II6N5fOoBAeG51xXFT17NXERH1iKk51lgoRiccL8z02cER1MchYUNjHG8ctfWwJuBTAqk8BeS4YdtGMsB0dJ85l9RUSsra1XO1J757dlzYpgwN8k+2jVS9FCs6XUjS5qe1Bv6LzwCHhnXpGfC0ssWsTX26pS+XyBlhhaBIu8XuJwE76mQp6aeIDFRn+MScRjmG5uev8c95SU7lWDREstxSM/74Y2swdz/x4fHJrIkUUNkujEomU5VcF0DgLa4NUIPv8LIT6TJ1gT2q9LvQUhGNTCCLk8D947xn1Y0bLIF7PRJI58Zcruwj0SaqV9O2PrcnwAZPMzIXP8PQYbbSB/G4xRQ1l1HHAYyAf7XyoLuxECiD3GNzxaqFDrepq6hYtpcXPBy0RRKpsEYJZlteVib5jGx7PSNSPHQFNxV7UmkBAaLtMvJ2yXCkNfjGBmTGEvWhkBdG2JfkxuYkxZFIeOT9VqPAI4fTnfVSXLGr1GMxlR6Ldm0G5N74vNmmXdqgdkbTjoy2tdZV92v6YMKyFmTxAs+E7rvvh/WgSRp8qgpgtfuNd27uUOWwZZN4fCx9y96SCLzDEZBPFHKdSUmxzuyRU=
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