H8oTe/Ja3IJQQ2DOny+70s2fRazpRjefL1WW88COTfZ97XoT6UBXv22D+l1vlZLC9Hw+xE3NaQBsUyjbE0evUEg9hrXa9GDBsFkryCXF9c7iopfL1W2WEW40YytlBBeOiNAiuqwH4WYb2pFjjKYLh/cEyIdzkecD2DfocgLojtQ+avsghYbDX9e7E3O4lfeyh6BsYhsP9qb5Kk1t4hKDWojbhiBxKLvNWQwXkTHg/hyK240BiPpKH/lPaxP4BdP/Jei/iBv09e0+2hWxmD0IQooI2fqWopxSU0sA5UlVrIeJCr5dtWb2vaNjgu3rMKmWWoGKuq7phGXgtdzGj4wRmwsW6Aiq1TzwbVYM8I54DNeFXbsG9rca9vwiPZ+KGc2jMlNZMl34lw6suzavDQxPx/cHpl3rbw1WJjELxkYd9dy0DVGPx3iBzWQAHVvnsFjRxekpFZzYk+GwFh7a8kFO5L3YHDBgFrrbiOWO4w35JSn76kPnoiCjyVGGlDRzYEb2C5YIfBIAVWNnq6FJAxvMP+QqSoXfhDFInGlg0GNFOgg+NP4WH7cFPbHWAOZZH10nFRB30YduQ9VAYYY4mg9FqrduY2qI3e1LHScqLzfcW8Y7IMO+LbkY+N0tGBEYQ4VpkHn7W5gfbtTzVdSqhrYcN8sRc9yCCiAB3aBj8mIzEjdMYzGnFP4AgfPVSkcWYWHbrYl9tov6XIad9M+7HU7d2PoA0HOJuknp+Obi+iAcHHvKeyUdnYP0wZOfauhCcDJG33RoZnJutdXluQI+3N+IdP9VG5EsEPxDNm+8s4LVYxZsBwNhgCRi0K9KS4m6hZPWg9PDCGfzsDqkDX0mbdm5eS/pJRg2gw6mCqdcMP43T8Lpn2mrPxgbtE2ZMidLJSSfqWk5EBZN2mU+Bpmmhkw7l9jmeXdPrLUP8gSPFYwkauHX14ouiE+Ot6ffbf2YgN6JZpi15zCh+LwcroMRs0PLNt4gNHY0sVWhocNKr+W4+HvUjNMo/hhp0D9MAt+Yya5AYfoibZ+fPmauFq7PmttIFLfQ7HvNJL1a1KApB2OlCqDQ4tcXYNDKkEDvROE0PJdGF3ijUbFbd062hpQ3kLkO3Gdd7MUrYlv0twDRwX8ZWXCP1roEbUByZiQuCOsZEiuKbibpw5j2ldCnbwGi5la3B1QEPw61T4JGNjCXbrgnMZDtYJJk5vzyD97TDxKZ3PtaWqHcx5uwNI8iWN7ObWv9RQCy50tF/E1xldQFfFJUsowynQfmv+3ODzWY7IKmh4P/80xYmLtWxULLnS6WFi/MY6+uZMG7arQR/JObSY4bZc6F6fBJ6AvDWDDz1JurevZARxPf3btFkwJMF2TpTsniA2tGs1UcK8qUsfFlb9U=
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