TLblnn9s9crhL0+ePd2rQUjGMjN0OAZtPOIaZLgnda9mY9738Z7i9ZgphpxkOJTr0OoikS3PEuq/Ero4XdZapnBK0FCjAizV9GqSEWJr40cHK+Y6qlQ+/bCJP2tQmDoxtGcrqxizLjvJlX2aKHkoUJkSgyIaHGCOl9TVI4E/HPFb1jbhFo/TPTDaooWHXI88oaZ1aSwLM+z4SzJPXrT/1O0ACnMl0bzqodAtCD99gWySByhhCm99Pasu6gXcjinmdwRr5pxFziWK8wb0+ntbTg410f0fRMn/FwH+GRt1iHw1Suksak3niBgaQFE1mUkxImYlykBVS2hMiQtiUSis5+VigGiQNbYTVmWKbkrmu5UfZsQiLhhB7R3L7ipCvHtVZUHYldvDs9k5d8YvKWfSKC84RgQnflJ6FJtXtOF32CRhxs6VdEwKcjeX3ZwEhSg3wbXYr09KQO6puylXh69XxaSwZ+MCjJWdCTXWrFzYXAQJdA55LPK98di3PrlS7Au52qeCtfosv0+EsG9Z3++Moxh+P3hcCpRxM93coCWFtd9Wz7OmvcfD5VQfTrQ4sAV0vDoebchTUT1ryCcv7C4dLIbGJQu6pT5A5A533COgxrm0IJQ6pAm434OPRr0ghHxeUDlSzUYMD4AbDwVzL7+XzDXh1ohAPwONkChbW4UturGxcRxsgdaDIWUlFnbtMJZUcT7MOMQtdYrEjT7+/tmAzKL+iGLUqrWRgsRt60aKvdNabxfEIezdqoMdAte74NzamQB6NYWXz0zbW9LsGVx1+zUMmtNfVaP7xhfYpnPX2gh/wHd8zJ3l4BZv7ZTi845+CU47rdgtsLuhKDB7ptH8KDsAc2xNoeFpc0LfPGrD4KhMk3DLus+WYI1AWSyF2HfcxftvsDqU3+QhujIEROejZtyTW4oowYALG45pNkC/ChO8CyFnQkMnAgmc9tZ7/lckMYyS5nNBC9hhf6YmiBNCWHfSHK4kku1MDIEe5WdbP1aeprmZYyph+HKnp4TEtcFrjOIdb3ytnprURxbcaWewMTZHDNUhUaTCmbOXLZCwh8UTf4MTsJ12tZvpD+FxMOVdgLDcRaqh0fRs0v863IEadULztbeVkm6xQOLaiTnx52otiStQ3QNXNJoKb098Pm6Rz9/ldjd7BhY1EbkA/Brz5lJPH+81HmFH7GVEpfWHs+Hg5xJs678OL2oPNAOzEv5CfcCOA4htTYE3OPyWH0tvObak9ShMFQTCrP7/K6xLx92mRkTZhrFVUDFPFUgRmw4N459JjdVaTEjOTOlvWUhdDTDOKU/SIpzZFGFzkP+tAzhWWMVlnxUADOEShlKljxE3uyvu1VhjgwhgqZmgEabeGzRz5/IKE2dUojogSzA=
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