RfWEYbMRkXqyh37GMVoMD7nC3wtYTog0xS9buCAB365HMtSkpiojb0qB0luCcLMzyIi9jv+6S43oyWENvCucr7NZIQSPzIccNcOtiT5IaQFeCB/QhoHa8Jb0s3P7YvaQLWbPSzgBzYTO3bqcDZzFvTPDLW9Jl2fXGu+60hC8i1TyE72uvOGiOrwdPryVcTxbwxI31Gw5I6gmGPDwUcmV7M9NuKE8tVJkX0ksxJ5r8YWw9K2ojU/q3J717cZnPyGdbwdysVnfqmsXcg9PJjrTFUUSQn8OKVfJy9HjJdUSuWnHAiUWdMez8d904CaEo3farue8srzeVWM/62mICwsUHbN1eVIhThDmF9ws+PoIJHNu1ry7B/FtT58DWkaWnt5SkVUw74Sx799YQDd0XW6etUUGXMWsck9gE6owrJbjqxYP9mYk9b9prVOVJsqUxpFvB+yegUUv59tdVD3ZCs8ii1nckZTuFlv/CyO0G2bHsEXISUOf/MBlDr44Q9XiHd/9AtcK7QDMBev7Q1JMXn0SCz30FPnlWsVlf7eFcThARpVMWKMmsb2DHY8fxcIM5HIDNWGTbKO3ZRnMq/Vg6jp6tNSfi4O/16p8HwbTAA9pxjXdl2HoDrBNftDLUhG9/4Zo0ZLD/DXBdE4TnfVFkLKvf63ab3BFSv1hKDPYF2HrqJeYy6Q/3uAOZDY0GtVm4Z9amF2ZuPI+nYnym4GQik+Ri4PPFuGIiJCRolURDapjrFFvzpsg+dV2mWd0pfGDYuS0mec+/ygSQnap99hf/OU9vzstuLo+sCJ6o3YREyC234t/r9WLAZAOAJe7n5USSfUWd0QyB46n+Cy/gkIIV1kXzSv6ycAzUfs7QUyquzofG4r2kGKIREZ8s8xmYvXMu4r9j2KC/aEdx62poNfoiD6ZljkWMw4RPSl928vK+uslxrbVqnw5Cb6p9j+Mj/RGdvn4+k+QKCqK3pa5hjjD6UZqLi/mMXkuad9owBsU871FbbhBlLP9zwToesNV2RlCal5kDzppP0Tx+ZBNv5/4Q8p0CAm/fck9qUHTo11+m4dITk+t7+RNaThuo23e4HK4OGRPG/1JSLdZpq6e3LsXIaLVX7nBvUNI6Gd7kJIQDiO99qcB7qHsDUib9y2Acx+wxh5tY8kzkdIlKPxbV0s5IJq0LdMeBtO6pG5I3Q2fugnz2uenOS9eHUR22dgqUmoSEiOGdhOuOMFd4ziPUK4Lb6wSrwcVqY9XafCz2aW9RK7fp5ljWqKZDa926iFzcx7UZBV8CC1fV0+XxSRi6tORsPuZG2TDqcjXiEenhhVlvaeaKrKLurT8CM/RJqAgHgh9k8UE/WaxabfPiF7RHYxqDP++KYazRrfHrI1cI9Qb6tk=
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