HXp124tOhgMOXT3f1A5spk5rQACdnCHW4BeAbnSP8ISIaRSz7yiR4elyrP5eiFICEgQgXapZyVXJJhcicaAEyGJrHn21Y7eEWNxkaVHl5MDpTrd3a3GCG5Dj4efjzMvnh34zFltPN+NS0QectiAOfgmtlqDrQmG8JSnh8opYbeHJEzjLle/jXGf4MGQDrOQRALR9+lb3yR1c6QpPR0YFJ6UrimvV8G7G2uqYQM+bNCuPhD42+3k0F1XE3AcHoI7WvGYQfhGU1a3GTnpl0xo7ZR436AM3WN3CuJppSGvwRvS69wRVS7KR35spwKvG/LCylxe5z6wTE6mq1a5U3fmzahET5gM8ESG3a8m4/buNp2tJ2khs1TSHV3agGDC2RMfjiARU/eyvAG/2HxSEMDrS20fwvSo82JBLQ1V8FKK8H80v9+6stfz/e87AwAKohJ/id7pG97Up2jIaEVD91XFjKp70lkFkcI4g6NnHsKK+Ub56afTZJK3rbUwuyergk334in37/M/NjuM+f+1gf5KeAeaXXiPhki8SPdTFWsikxR+odT/yPawRnfoIY6FwYij37dcYS72QAt+iqPr0ssQQ1bsvV/uJj8Fm+bwKcl+2gXOMCf3iIlOUPxsBsj4lThdCw3uADTPB1E8McH9JixH5wtvIrZ3pQsil1TGPsPhlgC/YPx/dIPiBxLE4LkYDGNRXduK+UcXG2ygqknh5MVvD7/MW5PaSyqtVnAe44tIAZS+rJLaUlpiSeXLnSYk0PjBo4tosKPaOPrIutbjg3XmN5RXWluY4R6m5+9VMOyg+jdk12SXGQ8mrzRbJoih6sQ9nZxDGdk9C1GEG52LKDln26COecrJPD8f5w2mjqEskho+yB2A/9blpfDz3d7nQy8adC5stR0bCBMTuiNVSoN9W/UiNXfmTKJ1lGKULZpd7P4JRp41w1qje6SneLdAG5cEYkQWgxj/Jp9Jznk9wO72bD+DHBGxzULgLOzLO1mXRACkXZ8XswwiaZ3w6lbKu0CuyMtPXjyZUJSTsRhqk+AtWMpPyfF6yKkg5rAUMQlz29GULECNkIr4BMoFTOJ5PeEplM3X7o4p98aykvMH0PfF2RnROOtz+8lz1KE/EYV9dO3Q5VhpfPvXTioe3+jbttaLL24iz2hcN+kVx6LDIRgRC8jBgH9M/AHvZxTk/3zX18Dm0TiIpILcDgLlw6L8GiRRxxDRNtr/gOuICW/m/w3oLmPhzwPj9uwubCzihSjRtktfaISphcvJxyDOhwwxnfsG/oBPS9gx+lDNamxP7Hjss5z3pAtw4zt4iw22QUzTLkVr46ZNQGYcdQn3YBxUP7oDAOyC9xgLrKcN+ECsHhrAGlWELFCrUa+jHuU0ywiI=
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