N4pF8kH0XcTWCUQMoHGuRQxrtWwX5XFf3KsVzj6OF1lf+V623RHWllPLnFS9yfqyEZgqQeolVQmsjUvhTeL7XDIkyppc4C8nF/KTdSa3rNA7b6vUHiS13ErZiD5YNovl3gITemxLcJTTdeGTOqsiG9msoF6TSRVXgxCbnIILg1sg7OEldpfuI+eG0YsBFYn2khx6fUkMGThKb0/mITjoXIW2Iol9zNqFzZ6+tI/GfwSOd1r/KCJniTGUE8Ig4/v+iyhKRB0l3LRkuKHV15LnLp5C9ih1k+0NAmKzdhIkYcm1crYgWpOdRO13/frM44n1Uncxra8ZhhErQelPwrNvTRdNlZQMIyKeEK4mRxGU8tiHm8ASO+yJVVAuTeUFPhaVzNiZIfOB1cO6KtDeWO8fdLp9t52y+k+G0hK1/7XmliaGTfUfcGXU6UBupMh7t4cAznNGc4jruJsTj1aJovLOFHb9pSBhKNYPiN066VnXL3iigqPaQDI5He01oPCwaNgTo9BI6+VlJ101H6q6PCscAaMN3iOKg1t/IY4hIju381DMM+k9sT4GRQxMZ1V8J141MFI9et+cKJpcEMyyAgjlScrksZ4ZklWYafvMwjaOeXD/Oyr0HBLayNgiv81JzRvxM3k5zc9GZNmt93l7xN6vwHof5Xr0hSrOgbi77X/xF7luyu2k6+atpWqWZ3o9agpPogxUmIt3ArBpZWQHQV4KW5TazITuF1P//rX22d6EtpS+gFVSgN+jKVT5MGzFYK0KxwyrpA9mFL/gzcHnhrV/T+RITqM/WDgpiXlaSTV8YjuuS7V5xAdbIgDHtbbt2dqXlf9dXD/Cmi0WpMWsraA1uYrxoimAvI3Z8sud5aAHB0FiwKonisWja1kAyFQxagrcUvNhwhOPUO/LVIJZS+ju+T6HQzrVen/0G5QsCmMjkvN5FbFA2Toob9wjWWPIQOc4KXcrIQkFcItVfaOa+WjpPICIHqeSn+TX7ZpfXpZmluEsvxIMV0VIhGZHzTWLUBy4X6myqcWFI3AG8bvOkelb/GyPEpqd2M5AzPbkfpIV4BW39BH5hmbdmAvkSMhxltJY4C8xf4sSmhVDlF/a4UrH4DWkPF2ktrlUA3xdsyJgtFLnMTijJF6phy12OK+j6A2LTz7FFidvJ9D0Vd8CoW6ICpAvNOPsOjN9cc6BUYnJ8v6067ugsZ937Z92AmLL0qUtnrrM2zXWXn8Yss45BmpMgdp3xfhIb2zlw1N9JWgF6CoeTKUjU1RKUDPg5vViW6nAyluk5bWZuaHJ/48d6F3m+J36Qun4IGsJSwk9eikASrU+EiGQh0nIiKloswegqXd18NRjXYgN5CQpws+bxjzuNV4TOPRCV8oA2yEgh+I=
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