+2yPfVAgmBhMp860aJhei3lraXxmebQhXAcToMaIWHZJpl0xhShcbGq6LjkNH0dIPBhfTl+cXUyQ0odgsClWPtjY4+r5Mk/WuQfINIgjxlMH2ZopmCmFrdk4k6hO3b6bPnhY/aHz5YeVswUqorgx5AmxHOR/aKasUrN9y/DB4ZDsZAfExhf77579tn0+dxt8PUoioRxxUal6pZlfupNs4GT7RZ9PchVaPXgiMo9ONlyA/2KJ5MCzqOap9va2k6sz1K+u8+drYcl7dG53m19KMxTzwwHOdZrAHsbBOwCLLzH2AUIt12w7RJysh6XKxvS6+akUgXvjtBcLEol3ORRqSUk2SqQ53DLf22k4bqMSls2tXgiSvx65UVdTzTdBVnfjs25JLrP/WqeGeF62r9g5CAY0JfiGblwPe9wf14WtcKMhBfgvrDeiJWmTAZzkj0KxApUrBbpd9ya05EwgZzihi6/rwXNbftWdO5PFX/lz6FhWAoVhz0w/7n7AiU9ROkWivIm32ooD/OoqaQYUDwMnMFEPrPgMi/cBqfDCnWNasjQgJTodUbfo+joXSxzTZAAmIBTOpH/zukaXi/gfrfRgpOgPhYM7XJ3ijyGbBmXWfhlRY7Qe7SYP2egtYVl+8DfDzYZ7F7u4s1w3EE3YwqwJYI4dpPj8KdVq2/E6EDdQGRf5QBGkw8Mhb7jHEcJima18iCP+z5Jfpn+3HGCc5aGrmFkUCmpuGD6GNkA/lvcNgsiI61wJRDD/Z1WYoNbip5UlJZLUvrHn94tsikIDRUqsDW3a9KWfNCXxluUDOZabC1kaztzxrizC+Zen9GMCoqr24IXntZYJY+iG7Ja/iuqwOlrFq1neJEcY1vuq9FXewVeCmjtIjCyjpGx6FLuzSbMw2v3MehHGAkGovzB0w6OTG4crSs7JNYLp4dDynm1AH3p5xzLHZYofxrlai7qrNVPGfwSliyd6y0p8msxIitGRkBdi+TD0evmB8+IfIveWvRYnYvPDsU84NbhG2OeYPnXLAZPQror+rhMpTsGk/KG2GqeO0cI7WkvAA99YORhTcyty/zyxIl5QjiFf/EuwxKcQVo7kINlnHzH6MzJfAm9H5J+KKkcxVXQo29jXHD1srTPbh9+MewhP4kGDTHXnVab9y+Cz0c9Zc0Q5nkKrktXanMRVQ+5a6TR3yQOeSxCrDC4i1NyUvP6V9KMzHNLUXPqp6a6UxzGmiE5wh2NqoVf5bVHTfDLmTR7aUo3ck61H1SQNsxxFMGXEI2Fum8lUud/ZUNRkknGd15ciaXjcjtknAR9UHFzYc2BP5VEWQJJ3zZQ9s9JvXk944iiEmrTRrPHGdpTU2avitg1n8LnoytgSv2QjFKur2RNyctZ2yxo=
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