jFuhptJjsNcdcE/AXbL9Zvayd07dAzsupnZqWUl+qZsUk6cFqSCLNwk0OBy9kiMmZKb8+vHABBa6WO7r1xEIHtoQTD+2xeRCmSPeE7/mDLaBv5vb/8baZZ5fOVISCwwplTPmyhFePDZ6XdOw5icfqf1Llt/iig513IDkdCvAtoU2XxXBB5Kaamg6RwRYvzmeDMPLFeFUkwYAk2SYJ6V7pNUGEfEOL5uDlJWHOXprkxg7d4R8MSIRdhfBsyarSdVf7AbgCngVGM+LloUu6JeAT7+Ztgo1cmWOb2IU4hyn4s+jKo0D/4nH6WuTV/iGb++L9nkcl9MMC9ICcLX/cEvFi57cHyZciV5esXdEFYiv6X5TqhDPaq8SZQKc72nfbSUWL4uZ819hFQ8rE+jgQpvuUcgFWQtswaMVMhBU+4oML2zQ/EsPO0ftQEi5Bujbj1OrU17eYaqKvjf/Ny7zf+Kcl+N0P37xEgmVomh/g04UdWPjZPA7oLF4wUYT2Hi5Xt/ZDOiQXpruuOuEjggmhnj46VSYJsyh1xHIC9ybkRk8FixUzq0XE9lH0QRTcFwNpVCHodkqo4E6WF7qyW7qYbyOBxF/sS+BZymrn3Ca6u/+QidHN6XWicX3dfbZWWGq3hyzQAuPEmUmsfhE2FScyuezf26FjJk+vwUBMzDpxI0Yca26zsfxVTft3oCLz9ZgdvZ6E9u0VR+Sj0bDTcAySgdeBLJUJ6XaOqzziIQOCY2ExTMZ7HlzePmHZ5acIcItny+AZILBteg/kTGwQGLZOqCAH6FJ0hDz1wWVuTcnBvgEUpikgrNoE/aN6qNuX3FWxX+aisLqJyueeTIA5eAFT8gzXsLXTRg2+7lh7Vhz/8MC1Y9Nil4bIVvkY7/YfXXrPc+AGZMv7PjMc7OsmUg7n15uxluNRWzIYjJEY6N8URHpuabeVkFN9eQVNkzsogx1SvOJGqIlrkEdHdFOqAscxbHIoUghvR/rrOSy8OO97l/Lon9ABdzT/MulP/JajXjMCkajHLtTwys0U/5J9nFhvz4mpeZPHxZM8X2TH/nADJyBPvNgp3pIaXVnnMV+0IPSpHW5XQ/Nnk9Po3WD5S+LRP1KUYQY427gzHnbgd/KfU52PxVYKP9pMhPaX4WE3eamIHZwSh5ZrgAFYaIcbTHOWxoZCuWt3Tbe8lroHaer5FknPjsCxGIu7GAw05qJD9HcRAjeGoGdDh9CrgMpBTeET00Vb23LRhp5jNof8at9q3zxeYOGp1410phOYoLfrZhMho3lgU33/M+DV4npDZWJmmx0ajxC7mp9sBl2e8cQ40F8QI6NhN4rr0wggGw40MwnOvvBECwtBhDAMcRvaMC2MS3qq0+0sSz/WxGzY3HlU0g=
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