PFPex03577mDUiTFDkRY3KJp55lQDwTbqA7PAIglBfrQxrPGCgJHjVx4lDoEU5jZAHAm8TaPDq8lDHt8IuhWEI1cPr8OYdBiQCKu/Yl/TO1awq5fxH5csERnovObNgSa/gBFeC6si1jMq+FYmJdBX0j7PsT4q6VjiR7k6Ko8+M3VHog/5kBF3eLXauvRXO9E4Z3ciaMIVr2ZyEYMYhAdPQZkKpLQtuGAJP9yxDmRl77CVpVOb6Fvl+NumR/lRIrVmxmxw+Hpdth5jiuIi5EISz0mg68Raww9Ca4X3YLiGwHOWgpB7oNuNDE3nUGM9nQejHOCf6zt51YnabBPZDJp4kqKAD8NCyzX5xg1Woz9RoggcTX4g7U9a5Z8a2mK1cjM32aoiLwTHQVqBHEfTnZhUXZftuKBXQqSw151/DASXYnUTWm/+fuGNNNhFfv4pslN8+00zVy/0O3R3MPYW6CEqPbYSgFh83G4t0keRAvgdtketh6XT6M+aDmfBusz07ptyyoN2RJm9E7k41bJVr8CJYUwP6A4oFJWnsLs6HGr0p5nP/i5chLXK8Mesq2iml4oFl5NBw/Z6d1l/J7YW9hBuIok0TqFJenVf/c9vepEldCAgkuDKG7BeaZgx6HFuj8tAeGg8JQtJcSaFm0whJ+G0yr/EpAD1w/KQ5YIk59axyr0QoG/mbSg3IdARwvU8AdTb5o+8nxYLmNtJavxXEZz1v+DJ6+KSqOfJcyTDr53VnWz91Pcqkmny74XIhk+D5LDUMzD66p66TAihWMgJccFYsJQcYhDktsxSceJlO7ztS8NNp4u9o+VcPa/TfKBnSCzsPhqx34MwYMhXT74EwRZjb7Yy3yyB+GeCdp9FMsXdC+hWBRm8JbKJzNw7q86oBTbirJ4vFLboZXoc0LuJBkvZT1KUsB4hcKncti/QjBksa4gGT/3l38c8WHR05Ah7VWVbUG3Q6CwLPbANCymdIWQmodyL7H/3c0BSVbCbsi+Fm0vQseBNSfjQyq2S/N000WqsiGJN3ciKilrWvgsCMgaevifR8Lqb5WFXCTmjPDP2oFwr1mdjtjySpf4Ct8qNBq0m7RcnEs0wbPyShPA/yLEmYgz5TlTA1cdD603IMl/pAF+ScMGFN+VkXNnMy0GW0l7BL935icNCiTxZ6gaIcq0ZbnzMI+05rS4ppkA2rT3MsZDMQaca8oJ+FAwY8mQOETAYxmVMk/pkOE8tr6PyacpA46CZ4DC4dDeiW8pzn1dzu46bhUkv2oGEHM+08zuP9n6IVEShcV3a5DTZ8aYzt83QNF7avMOETXroafzgKtoAezQemBzTsQC2bbLbJGdl7ryYyRZ0W8aaFvcHc11M1W4221OGlKZn0fQmb4U73o=
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