/gNKyBDFAdG6lugZnF2FT+khnWJOurxoa/RaGVROGRs/moHBRwoDU7w4Z/pBfgwydkph3FMJe/3QFklhZTLlfj+0iUmdIYIonkMQyOm0E51AmWTdcS0Ho4LUWOGO34wIeT2LoYDRonXEret8ePu4/om8zOwq1ufHh0k6fPtHQGBklVQER9Nqk5CTJVuysrPnUbFAkgIJtSj1k5HFby4mDiByafkm6GJYKuj5OV0Q0NASjanzjgy9qADQdj9pBcW5Lz1qQDG5cwsLox92ByYPn2/Ct/1cpZVbxvS4mQGT7NvbSQK4buZjUdAq14gLWHLMOcZEXMlh++XfCA33gCMmilDrDBSBQrfQEkLSEbA3RWufhdoU4p/FMI8ea0NeAt9e9J3o9WBDD0cBrMVD7TwVy/ZAz/A4+X6zAL2+r3dmew3sipdMoEOD+SBpSyiyPGjnLXv5i7S/rZrz7+6JDdrYCB3PoX4/tCIMiQiaM6rLuo7tD/vROl9a+hMMN+vtVqi+1CuuqFeXcy7manKEhL+v7G6eQgFmr5YWKIuo6mUf3oAIcFE5nHkHG+elB/UYZW5dJVGR0nF1HDu6AQusEs5gq/Qo58PhvKibuP4Er8yhyX5HFNBv1GYH2e5+EEfoblVSaAzGW43UnpX02UqXSe26OsCh7VUj7nz4b0X2LTT7Q15D1KU4tme7+5BKKnsoKYFMIaQmwJVIJEF3hznk/Nyyz+AsypMY/j8QxdzQ2MNKogZUrVozq26HcAsY6/0EklivlOS5WWY7osBd+q2R02W88oA5xkDXKnEJS+TBhwk5FY8i/ozP9W9ece7ZkJhEzYsDzds6Zyh5x5p0ldmBCjU3tIWto8SHPfimyFSF/rBo4FoaizEcADj2zYuKGgQ27n7C/S+IiuhZ5FgDc0vazpwwm3XSMaTS5k/ymwwmQTZuhqnqw11aRaFVV+uBNCNYP+0HEuFDo94fPbO4CejJ/0jrv9COlxey0Hm2/1Oveu4YpB8aP/kN7gAT+HUCQQJlpznIUW623h+7FHj7+E1r4/FSjezne8Z2M/CQY/Ma0tTZO41d0oGDXvDJO4Pl01iRB8X/SlIUKzUuxllDZHYYxokSWFYGM73p4kzTVps8IyIR5OF2CKz1T3DZ1Rr/5ttnXqAZTHk1pKsRmmb4SefGyOR/WQBElvR1VJ7p+FRHR7otuS2xjNYtlRjJs0dM1+aBWBclIGx/aFNz+NvPAVKRP6Nl4FNxfGrAlfbjWFmOU8uOX7jA+FRv97ZA+yLLgA8iIlP4L1sD8ylsZ/lRTcWR2m9Kc00V2n3y67ai8Wo/fd5XR26K9OE76cHLAra/k2pPz1PHYqyAL3Is7FZEj0iqzt9oE65wmwCfin+Qyc33RyY=
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