tt4F24JyunErqZQDFgTtrX5p2KV9xBlw7se/jVm7wHInR7m8w9flvDDHMSeKECNri/WFRSbAa8EDPU1hsTS5PBiigGVZi0BFR/fiMLr9PTmbmiuhOhRterQLAxUbyG1i125WIacI/UhkuOAhd21e171+rsj8QpsZ3p+UuEg1J6cGNO84Fvkdr5wNgJrC5ZtDnHAuA3MrEK4END3AGcBYCt8pQ4nMj9B7hd9/j5pZAxBaLnkp3uIPwkLqkoI4fbR0Ksc3AJPwNYIDhFP6Echqde62nDVo05F5kwzE6iVOdTzAnhkj9ObYnuwQ19qBdN8QHOs+5iIOxeoTLw18Sd+V64isVAuCCOHiLob1L9Mky652FVcx3XSWPosD03+XywDXFEyR9tHfw/tLn3Lf6W7NOBNNRFQMJhK14F71DJmwWTmj9eo54p4UX7Tk5i4XZLBK0wGxDjuDlsytwacyRAgO0m/6FNPKjFzKKL6d75FjbU1YVSFVqFy6ULv1Ap3CQfWl/SWyieuOnPEyJUwDP39TnLGCMSTPSXWgmIcrrO31k6zTdeaUC4csqJcqUG2Du/kBlY88P/BjUdLLJFcPl1O31ubL88LRssRqQofnge7bqX/ux1R+AyGomd0u7EcdCiCkYWLP/Kb+50lo7Tb0lGw2Sykyi/Hhw3ntGBF70QAIfBz2ch8x09d//jILcJkcgAHqMAMEqdlmxkb5CK85MoavvlYRsCCR+JIP/dD9GvhUOO9+/nw0WWQVapRc6WnZwd/poxKn0iqUiMefsZabZV8suLQCk8eB89wWE/n9qtOGYp34LsEOLWprL+zs0kcoYzqpSDXc03DMBksjtI93bvBypQJcU3NZa2Hjrq16xQOPMqIgHU6RuZ780ZvnccWqYTS12JNtU+WL+CZmCQCA1uQbLBso/+1fNUVQ2x72ejkW3n2uFSTYKeCGxY7r4Mo3CXFAsj5EOoAkHVFPbjcukVjAh0NZcsj99ZIMM7Z3Y+bxfdlJnV2kw+dMNImVeXYQVlR0cZZ/tfEA1biOPVdusb7Iz4a+Cacj3YWHx/8RSgm2JZH5RB5USWcRJvAGFM4IzR8ph/wMGAXDd2XkYlwttgxQ3JRUCcoh6OtwVBhqJfYo9rPLKV8AU/QRvqzVwbyatNynsAmkc9B4/6h7q4I110ppurCdZLwFZd/4E4l00h/Im5moyqCp8mdgOd0NpUPxNiiAhJ0JZkctOD4C7GOm/dBD8ImM14befuow5aQF3SaeAd34tC1o8OPQbVfmL0zbUtcQJ1OecnaMWABiJ6XVmui7Wf4Gyf4P9O97FNKi6c3rPjSyEWGjSS7COvgIQPdOv+KR+iyrqfp6BrB0iME+ilquNakVr9Vtumzu5HYESRo=
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