vZdoch2xs91PJAziS4VzL3IuKKfMYXpItN/nhj3mzPdL+nB6xFELOzRBSk4YVTh52gNT5S6jtrGdOpfoM60CNlm5jwhOIZeJisSBNKfPUcuYj4enNfjOVDpBF5smqb7LhNo5TruL/cRQ8198VNqjE3JB7m+9Jv3mVBxfyickul7b/sn512VAV1I7UNDBkhi9ejilzdABOfyDTr/EVVUBo/7i5u/VEWOxv2QSjw0NuaTZb/8lNMrfYnFPDb53EkJzfe6VQjUKof/ShGlfFHjZ99NgdZy2jT9Q0q2arlzeR6fLo1Uyc2jPshj/CKf2t/nhhZXAiWtZwByDjo8lSGZp0wAfdhwuRFBWGDEAkRw8I7RtEy0X1oERQBXhIy2ezrCg7WyZ1iqjNTag8Sa8geVTBQzVM1ZlGiZ9HVUCV2UrrIQ0dzxdNGxSxspfBXgm/4D0nVyC4ZJJyYzBv8IYjXNFDrQMM8X0tOmLL7b44lT6ruApRM+FVgmTYqznHxc6MA0UAfgnEROSHajQGHL2xQMeAUJDnXu1xjZWAR9oqk7Yo+QodbMjcRCCxw5B1RCH3sTuss2Ndxq4Ya6ncotfjvVDS9l+Kdd1J35cOJkd+mHA/h4KQog/HWou6SpKJXBDroxkX+UEKZvo/9D0oLj7T+qbL/Pds21tk80vmsagVolcE/LrEKQ67vuT1MlzVJjHKL8DAQ2K0lGOuvruRNRtHQOe1Til4whlEKK6lwpAiNxPnP+s0Jk2XRKBBQoNWLmqbLMstuOWVoOwCPJUOhOYbHM6n5IUZ0Oj/38KeaeLLG7+m6emr/+steLcwSJQpf/FdSQXshKrtKtckHFX+TO5pWwr4J2syCpz/TpYjsaHVBbeQQgO7ehN6AxcMBqh1Ke5oC8k1fPYlWpEqPe2w2srTiNrUmjTK0ZAxqN0vFSE0yF2vapBwA/R5NszfCrm1bLnaYEAk2CWtF45JSluAzVovVYLY6G5Ta/Yr1erKsZgsFDoK1OSFPbZprEW2RqT0l5UtuL8cC4ZlprIx0TQ5kDAeAMT3ha4y2t1Fk3hSjaOiwvB4PdP/zbKpD7AVYRORlE4TLdCGICFHLkYFR94WfdIoOvT7ZMfpNB2eaVmhgTNK18XixsDpESquGyJI66nUY43xghM9G5HEZKyf3KoO4eoqX3VpvyPGDVAu5pY0/7jshk9F5nbOFKnm1ovP+HfRSF/ft5Pw8qwxpUTI5wO6h1HdIcJRDnPeorpQ8U3jy26yuoJ9WsKPNrKEhrt+Xy6DspUwMymiAyoQCKtug+fZT/39+UvoIlMw2DWO4XZnjeI9ulURSHRpVRdMs8FHRnyHyrZFVpTFZEG/bBE9Ki4LcqQhj0ABR3n+gbf53BVKcx2LHs=
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