py990lfG/twoqOsI7FCjffTH1mXHrDcACxqQN8cSSHanYFOMbOUD/r+cGznCD/Q3wWs4Wc11WgYrRYEHi/XpaH+0Q7dl+G53y2dztxbYzZSWFI4HMjDtIwKDOj+9CB1croN6D9ksIcQePTATTLcWKLL/r/wpG6qtBvUUwWJIHayk/IP9zy/jPP6/sFTNaoJvufIpELo3rz1TdFBv9cMOPP96p6CbHdFPkkYHdPVoQI0xaRyYZA5Q2sruWHEQujW42Ma5lZ4kTnhmcd8bdVQnGEUwiMUDPHosqb3yIFqmSdiZd6t2jiIQJlxDBT1zT344yQH5mzhmCW9Wc97xSWqMJ8bpg2+UtXeMAlB/9PFnG6LaUM1cMOSunhxj9aax45eoL3R0VXWnasm7MBwNAjdbhCdeIs2h5VI07GIrQ7CbgdhVB+Papn7Rcayo/nDEtwL/xECicJS+2jI3PF7cl9nGX2LdOJ1A1gpMK9kFXi+ciS5XME3Pu1ddxGqFc8nVPAXZbps5166/Y96VhKCFZLTqWZSJt4eg/bkzz9kVfv/hrqcxyH8qRTfBbtGdV84y1MVah/ay6GjyGbMURPkK0XmYMMTR0BYb0Tf0dkrl0ii18o7iej2tVSnS9Ihwq8lsokzbKBNyYWGcPozQsZu6Kf6TIoRHU23k7cuNMn9q+Cc+nYMgQLcgm9DktvPm2+T4wetwOVs2jkS6BZCx/NC9XVCdX41QfP14B8hN66U5M30dP6pDLwiawOlxROJf8LKG6Kh/ftj1IxUut7HwVw1dvOsCnCnRziwYfYdugL7LvRkVz0t5iVdliiweY57J+PLDWnuPAJTeL3LvrglTrBc9KHoQn+KZaPbkjCotNj/r6jveRrWqbKwU28Loj1MI+8edgsWrmJX1MlC5dKlncerOuR1o+XaDxOReS+BSUdCyec94pcxXw81tayP0AJF64Iz1wb9ttEp75NGQUT8H57pgYDIgdT+HQ9z8ZrnbHrnl8/tQ3yh1ilTXtbSLdmY/L05OblAtxnsCLjKKaUyAGXlfwpf330CYIs9bGOrYkrpcN9eWcYKL+xc2bKG9JFnZfMZPsvnFofo9yu9V/L2elzsmA5KZGR6044RmQVFEAJUpYr315cpPVwLQ1ZXtrR2UzazIeRQWTHAM2Cl6upkfIEpukMGBdkjZvcanMu50r+ctbLMMpCfdUKmozIHmpWC3UolgosOI82gHpIeaJsf7NcWTvSsfz5vpw/ZdB0kg4KDiH90RDd9wuigjFDxL2ID/OTkN3YiK/O8XYzPW5FmCNUz4nHXSPMOsmny+nQmC2aZ2q+pWFpCJ75JTmTFjKMs/4gOcjryJXigQQs85TCldATA6+U4Hah1ylu4csb8+U31si/c=
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