hd5HtRK/qTWW9DK+FQWD7Vss2yT0qwWcxJsayXzjcgEU5lGMu/7mhKkFWeuqtCZPt5lUuQ6dUPUtRz+gWuXvc4jIdVRGtlpTF+6lfySt8qbquouOcD4i+q8/Q3CwKtkYxVdvoF00PMoKeWZvBYjFGUeL07Te+y+ZZLhHUGOBa/yw/WLMBSoGYPY0M5Ic26Pxb9ZZu2N+lMr9lPmajmMuSiFyQMJvJqZ8oB8XK1cirazDWYOUwehLqQO3y1kNex2jNiaiLjEwBL+mMcX80BIb58U6AXSzX9johtavziBw2SEJg2F/tqYzAXqteistgK1S3VFe8LBQxYR4XvBan0DvWrw8nViWHIkSPLx6s9R0lp+I0DyEwNl7TBIjtO7csKuAlj0RAKYYo+LQe7zmlYV3CeORKHyjLkMLuzfwjEbZLEIZaA/9PVpJY/Z8xxdQLgFDGbrLzwRMMeP+2nNwCvr2L+RlW6tzXYchk4t8iDAa+8N3JwlUpf5aRLG7yFua7uUD3D7yes+l5RQeFh7jl4qUNP7fFkJL1mGdPfkerksuYjVRKoaF3naAOL9YVOPbnFv1Oo/a/Vj1/deVAzLW2wbMR/8NKnbnXtpEwf8g4/mjzDuJO9wsatnAJJVuY4I5+n5M7X7dIRSPxRZc2cz8qAONS/iClfJ58Rs8J2tugv8mlgOaYQb/BYXmmUEsrxUElkNGnPF0qXo+hCaBKfWdde8yQAkDGreCBGLyT30OjkySjrl/SDU2uAWou42LcX1XPl3tz6YzTL+TdTfW8j2H9OjaQVsTr8emUxzUxf4wx3BVsx67QvPc58XKiK02hHUhgQ56/5UHGQZ9dN6Taqkcz6gyO/qkl9wygigWiSFptue1tjQec1x+Be82v4EEEYk1PsgT1g+URgk1rOFZkGixaUniAlQyIFWBCstLxW825I0p9F5Yv6udIzXNnENjhNT9qqK5Om5szKoAznq9bC1En1iMv7z2yvBmlA6rtIkT3OTh9ybEtsJsu0jNZLYFVYHatdZgRCdzhu67WYCoE3nPgNzdReBhPQ1rgBmo1pxWtD0z4IXRxH7p8CIdWKdFwX/jRSwZxKmE34ajXvMGSgm9PlFMvyOGkwjSrugpJIMAiPChbGcUWx953kEcpNg3Uwlwc8NhmdZHtqIyZ4Voiy0+QENTD9eR18Surk2UkxOFJRpsvh3lBkmGGbDI4had+ojlpeB9mR6XmUOM5TfTpS+iLtlyUlPhab1ShKvXC5QJ+/zWqVgjPjwk9dhD7JHFP+0TlLZx3FqhIf3Wl9lrmprmHNBQ/D0L1D/iuoZfJczMdtHyWybfeIeH7V0chmW4xs/TO4f1hXXvyFQArnQGFrbTK59lgrakZGSkjvlSE7HOSfQ=
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