xhdX8h7RTbBVqO5aA/bpiRuc3G1BP+IUuG1FSKHRgs/2u0ILnPlAZQethOti5uGEWDo6xoijCPB1EazaHnDJMoInvrtbCIjnZkfdxA8qRhKu7MZ3sNNsnuVeLhTANelOtlTIk6APk+d5d0e4ms/GAqv1aGR8Ty1rRIDJB4DERpaYMYprox+O61PhX4PYh/nmnco18UkCFDxrkX7wA0m930VvUUfX1wvzhPpsZP8/xyEDIfvbs9bGUZ9a7Hhs4Zcgo4P2EtH4e8tPrYkWsjpRcgA1yV7vAjGjXrZ/SFeX4PC4UOiWRObIMWjAAjwlCmJBnRz4dNMcMewPgXa4jOYHX5Z3GFhyy+bncewZsFnSqE9KkhXcpCBn09xmZFCeXk4Liz+yxC3FENkoJXnUddA75aMohjozuGFumfQfJ//fCx2TvgiaaD5bqgn9ogg2G4UcUzfvPdrVKa+wPMA1mitbVQvdSLVVIohLILRqGvIY4lu2Zd1mbo1GhXEjH65yhXNC50p3RfrnTzfnyiL5AVtlK1+P2kEj0hb3psB191fOJd+Qv6Xsct0SK+cc400WLKyCq/Or0p5W9MOWzfNRa6YwTd8lGvVthq59GNLQdrZlHY979QzQ0+T0plpYvjcjXxt/wfF8kqObCgR2RKd7/cw7uQkDodbLC/4topcntQR4tXlZ9YavjvVI3Zku+3Qs3FinEwwuO5PPVu7U0vF2rOOvTHCZXJWxbJTcssA7/blS2/hyKudAkHZiRja3qs66/MSWWcQt8Z1ZITT01JJBsPyRwlQHJ+8QExrOCNiQbP1AsUYxCXXg7/3YouBHAbtmSUi0qzaYYOAcRbIuq0JIVdP4aNqcuD1h0EC/KmNtC0lmnwK/YNRRkCS6w3PbIwQy07+4YzP1DrL+JPnBuvMcCsWxnDsCtI13vNsHcEtm4wwEihc6zb3UtZ6388DZ+fYqBpvWEwurHF35bt+TmlytX43pZB/xS5V6BehirPm1Tp10Mxuxa4HmddKagECBd4vk2WiKGy8OqBlex6J5067QTHQ1dEe0aW4uE+aONUR60qCotrD7ukI5SuLrZ324MuyqQECcO9bnMdPxlK+2DtqPSswnH5gKeO8hdv9pL+hP1B2Bv8Ep8pHS2V2jUTdMoYckzu3HS1DC68T5sAa8tsRbfHDmGSYb6z7N6PDCqy5kNoZbzySXdQAgaJeg9RwbAgI+Ak1CnZ6o07qHN6z/i4EDOVUCSyO9izCfp87kDHGqRnHc6HZsd5oShDO3sPi/BSHxKwFjvb/SCEdoXBYq7QAIpG+8QK0pvUGPx3Usfnmw0cj1bbG0IE0NDFqRv56L+XxB8kaWrY/kaQzDEgvNs/Yqpd66M1atErBtKdmCmbk9CiI=
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