jPhGklT6gPKm9jP5+XToYGKuw7HZlkaBSSJ8pedAHawJzkyD5+AYd1rudN7GjjcMJiRhAQd8oDBkweHIBMH3qYkPLU2dhi17I96tWOuQqIk3xgzfHsIo82zYqwhI3rbzDw6rPnxhLpcydAeShY0QRrJ8qnmedXLBENZIuSizcpAPJT8lj4S8cFhuWp4WZQIep2SZW+KbrZ8LW/Zc89b2CSN79xzCRMy+iARAS8yITml+5swHWe4P8cqNpycFNay8KEG7MF/I1gXwdHl9nmQ6P1AZPjdMckSu+mOOZUj6lI3yLTiKee8T5lpPB5KVV+REOlLp5w9U3tZmaxJpqfJsxgJgvC44VqLaNogbcRGq7BBzkuBxZnAnoCSDQG0oNxBZYTQjE99iT+sQXuUaHadkst5G+YyFt8aeFtxe/9SNBR8twsjc6pGsDS2Tl7PReTdaVSu6sbixUeGcc5opknKFd0ZcLJQ674Om2NXuKZkXDo94XP9p73aggohA4RXOUfy0IJIxGYToCFSiHFJUZfBiWKcPinaCUOReJVYU8LEXY0IBvzTuI+vKwMdN4v864BMR3Wqi/ol5HZDihYT4YpfTzB9wToHa+dFhGrzc/Qex15CpMKaJFUdXTQs4k6wd5OXcjaoAI5qvjPTAY6j1ZhlXjBlru5mOGk5EVeuceVsaHfNRuR1Kx0Cf4TVqfzJ+/TTu9uPZCwsce/SZ89AeKmDSChYfA//sBtqmqQesuO38PXfWxqWOjBG47nlsVtICQ44axtK5c+ljRWJqKKF4I05scQtRxbWUDv7CMEde6/tc7fm62PIw4wTc3okcKvaxzsD+PhjSut1brTstr1O7lOIB75SluxuFm32ov1FD6N92LS7EXXfwLs9I9F3naocOf3vCOZXFlAvG8Dqi1ZCAjyUZ6FgTbDuD2w683zbST8Ek/hkI+a+tVxmmtRTiK3khkIvZWjcivwTv72b8AW4IhdctriDNh8A28LkTkmAOUqgSIzN4zFHmLHNdU92JUqjI9wLRoM7fPy6Z+yRHsKps3xkV6rd7SIVLTrFPw+4OFDvw0nxdX/3ONhM2122msOg0sKtz+PxgKoPN7hNAz9/kqZPBvFNEBY7PP6fRNhPLP7y1sJFaWko6K6L2NAZQehPCgBzyF4WLfO9kUPrAV+XB9YJkF+oJHV9LYpX9yt861sdrfZ6EzJrU6nUpfjFbvl8/ExKoLklMKJQ1D1D8GE1A+ByxoOn88hbXc6crPnVqgr0IJzmshCGQae6+FOMyMCAttDx+0GLT9n2cB3dFI98Hxw/1Bes8NLRQnbxUOlA3TAGlhb61VYQZ32r5PDmqg1gszHJf3bNC2Dk/TD/BJbG/gv1MsVUz9NeswzpHRHeuKf8=
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