Ph/hIAR/NgXD7VWoouJgUaBjx7tk6oB0QGd1czn6nKaLQl18rTCIe2ZJfNWoDcCA5la3yTLh7PK/wMyRJAlqybRpMf9roj9GdglOY0AR+FCpZksNt7i/iWzWJLpd1+NkVoqGeZYBPgd7qqzINEai4Mmg/w599B8oIkMNtrx0SP3wRH5E9ZX8h2e8OF7001rJ5NmkiQN5CDtrxq3uVMQOlXxRSCT9sasApw/nbtDrRIDtGXhD7K/h4vimPlPL0sikvWO55LIaBQQ3Ab9pbYPLV+5hpCMsePNL8wxHXiGL/iZ2YKpLW5WVL+pTcC6optEnEOspAwHfh/jGu3foZ6sO58kHBhYsu6DsIeGWWi+02bnQQTHklXdB7HsKyylxqwaiY6HXfoWsxZVihhIwHJttSREpM2Tj0uMLTOQbznLV/6lbGv5eb2nalEqUMDNjUUs8u3+ZcuQLC1n2igoNWI1Lr6hm7e1f15AhdyniRNkeFaomdeVxpRZwXKicMHkNY9AJybKwsh6sT672g57ovRc9O+4EkXKPLVyNaAo754HaLmmBWaQf28JED9KGOqz1h71YAsr8fl1nPOT+kEo5Q+hp9vgCEBJi9hBwaBvYw9wqv95NUyMSEpYTg2NrQeBrvZ5hd1PGTSJgm6LDMN2/scT0nf8ycvSBX6XbEkPFJn0qa1WEwJkRKzZ+HTtO98Ayn+zJTKF1iDhkHfFxlQrk9JajzS5VwjtdYpWfv719A0Mk/AK32PbZ2+S1juIqbmjMx2F8M5Q63WP/JYBbH6z24/pffF17LtUB+ZWzbljyflvCeigThg0+FWxbbN3MAMyfUuU6CgR0M9boTx4HKy89poiiDerRKIYpwNHvcDcy8ujrmnxsSDd7WsrSBBNdC+Y9xTgu04ZaAmYSm1hKI7HB9E1BQ6xLKZvz15AcjM83nU1/A8IGIK2ygvK4lH8H1bgVzgrz37Unyh2fey5icrAiiIw5N3tyue79RTbMIzPoqQ1c+FzdqUbmPgnEx8sqHbrqhOEUriYjYi9GMAWk7vJdqvz9ykSYK5YK5HakVQrQGp3fABEcEphpZsF9X7vDzOHPWiCmvVCNWzAodOwOzpAPBhfou1QX/8WrtNtVtp2KGLpzX5abUAnkfZOd+zSDeZYVDfbXu9HywcMzF0XbneQ2InkXoEn/Jw125A5YK4tcsK/2Ez64shEObPMB5c6nXFN+YcabhkrE5FXNVRvw94gZAFpBxzjDuRXGvmo3KkYJ7QiGDUzVL0DH9ueLa3E1BaeA17HBMikZkTwL0tNTm6mRbJ70Nh0TRiGuwJAR7xOJCQYywhoZMR1BSCIweUAUGrVeyQMGI31Xm3zgenR6tVyPR7h2juaN11gEiLn72TVQpBI=
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