bmuVPTwlUHeg5ZCM+A/gpzmra9xF/4T8Yz81NSRPUlZwr0rrCLXRRo6NKhpJGuINeMnp+Mqu1OykQ3Mh1skeCN4qKoq9B+ZB9cns6WSatTSVf4J9denoXQWI3+HLUf91yuTHE3KI+8zjIsDcYURe/oiXfCxS+/m0sYwsWKIFafB4lnoI/nfWyv2i3ZMpEquPrpExMmfKcyGdSewWYsruQ5EGNAGYdywqceLHQUXTy6Ezdc/e0J0pB3FhaE59PJU4lug4znIxfcyNZheQ5InnZxEPHWVCZIGWhIfAk5xIju6T+zCUdRilUBCzJsj10PD+A7R1fxCG5wcs9zzQhw0obDjc3vSFzGDALtQMQMXQKYzJfXwichRDZBPs50vYF9IzQ2kIzuuPpowU/9de//kntRZyqtuL08PJFpuYdbVrP1KbCc0y2dgZ8b2FvMQn8dPcAYPC0hczFoHvwOZx0koGbZj0Y6DPcpDxspiBnmMxmNSHi8z52z+VkZM6xpZfPfyA+Ysgv5JRPMvCXnY9K+PVe3GYSqjgO2/sKzREL70aNA4qVkUf5u6neZPa4P/rM11PyzY/JYVTOaTnxBVWKO5FZUQVfDMGtS+DEEhkaU8XMC2JUWkIyzJ/V4QiAhBPd05Bc5aL278NJa68tIah6JzNNT5AaK81IfpZz7pMgAE/ARt01Fe1w/SKWF3Up6JGQ3gTr+sG8BHwJDhOqQRmWoadzsepz4yyUXLHi4An/PlFDOwn3NHLiayNtmm99wyRVDownkf3iEJEq3UF3BCiyB0VRiwZ5SozdFM/othbGzqeib54nJZYSZjkQk78nt7UsOFBwRybmxkN+BlrxN6+RR7Si+fJDuoJFla+UhXAQs078aS3cR710ypGL/QIfxeuWoq+UmDmNAA6bRjxrpdPuVp4NcMiI7siW26araK1hQLlngcJ+bZ8i5alOdpQZkvczjVK3cjFDGNkNalCZHaDfcaed9wEuCaTM+p/OAIrFYQJKsa3o8EeuezeIb5p/Nl5rjKOkObK/bl39Pa/dm/q9wRzKTFrBQ91hLBXjTmyfFHvT+z2N/AdE0AUte/UI08A2K1uaX/u1WL21jbgFE7eOWr+8xHmA8uuALgPc7bsVZzfGP56yYozv8x/4TJJ99e0/QCCSuhIeOeV4fnCLrgl0u3zkbW12jB8T6uC08heyJ1AF3xATayL88WWw9JLvW4eXPTz+0TsFAh+fsogntLrcYrnCVjzB7lmEEx0codmNPVd9GYGubR8x0wRY4sReWb9NHyxElbVm8sR6rKS8tkU999V5BM1zGY4d7b6nm9QwG+1dB3pmEDlmkj9Ud9ZgO4CLe9t1tahF704t9tpAHmsKpWZRyFIqlB9mMVewYxTreA=
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