l/qbWkZ78m/LdSjqTN/xpBAAItodTYK/c/IPcSzgC+chG6AGEccnaHOPV53R1ci0aiFUMcaIKeQSNmatGAy6OW8to8/vkAXLjGxjttX9dnEqp2TXLq+CrYAZHdqlTMadmdiE7c5xxDwatAcCXR8TrMJi2Hb6zkWv2slKKUD0IpPG5vAUjkcon6kNBg+y8kBJpDdD7Yuw3i1KT4Fj6PfDe7yLoLmCHLUBH29EHyjyEYNMhdHdtHIipBBPMz4iB3HNPqNAf+uWYlpnaJwSAMyVOJSkhy/iRTjWviWrcSTK7LU7VtPeaUDWOOitYLBAZcb5UqCgH5aylvfBy7cghgmFRP4TO0RT185KsSYLcDNffIQAlguJ8uI7DgqWBNQdobcrL3sOXWOD6+fzZEirHwFSlOZD5hNAX4rEZ89y1J6+CW3rOJOOlDL1AKYUk9XqiaxR7Mhw8JtZOmDULFM7+5CXFKYI/jwgpOM5dAVeTdtDy9gRHNHaFWmUxJrbrpGw9Z2iAIu9itBrMmaUf1uDKwO9cgRhuWZ+Ww7ptBzY7XW60Q2Jjju5W448BQLd75EtgFTmyEKw2t3enYgboih/1igzS8dfoIY7URQ5UmLmndg9Fuh8PPxKHsk7VN59dxwuqU3ZtK30sOSvF4OrMQD5tTua9VWr+Nw2gzTU1BOZhtP26TNuUTQ+6RAS2kBrGCvtjfbmwUIr0G927HOWYVCjiBrKS+toGa8hBxZYFEsVeM42EY8H8x1o5dF4sV7SMzwojk03/qROR5F6kKH4GtH3RfIYX0QojFV/tPSIDawIBmbdxSGQARvmnRCEirM6RCvYf2QWtPuPxSM/TC1h0zEPoOWL/te4G/YUAy53PZtYI3RwodE4M3r+xoFly/WWYjUHVfRiNjov7hvsz/KATwM/Ci22QAY1AChzzykSU/fCUrFBhHcIpC/Q0DGoOytZncjps65p7LHIJNJIbvf+gzL/uzU5Tk3TFidpNsIRFJEzShGgRkfYlmKIqranQRQxqkCS8LSQfWCCXdSMhjEPa7ICZzncbUxk6auLHDyuCyr+2GPmDPZ2wb8CnhcFs0R45nVdcOqL7KY+NFueHF1smBm8jcWYaCkB4zXeH2lhtmMPOpQloBJ2YG0W+dIvyUurTj8zZy6b4L3H5HghZvQUHv8zQknCp+h88r/Uqs967f1VH1tgEIOnrBaV82Hg6klss3/dKPHuMex5AodD/AjoZiNw2K7XVE49CIbUGJQ+W4CitakrknQ2GLMcGu9YcCSuda6GK5I3qv0G908rnFGHau+uOiO5KfCO1zIex6D7r05i6+U3AD8HkP5DzsFFuL1kWpS49Q7GhK1Kyhhob6GF995gHrM0DHyIguz/9yXpGzJ90xE=
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