9ozUoLkN6BqCfoKNj04O1ZBCtYpGnf+Z9WEfZJRAcYGpU7WdLMsjnu/S/8aWsoiBECYsWU6AUFNe8oQeLc1zD02Bx1EB2JV3eY1JK+OEEaIxnAOpYy3+MnafZf4AH0yWwr/oSUJu2SvCoXYMlfj9luIDDw1AH/eoCiL7xnCO3iEzKiqVRJWsaL0RZ+3u9nL2Yjc3cvYsFIp29Vb4C3gYOYcMeWJlSn2yRjGL959z9mjxBd7fLv78cml120fSUD2TpUJjRREpOkD7ltEP+oVWedB5r+K8g8icDOqs14JUaDdy40PaFyj6WTWHhjT1NLNvzrfRs0zDmxhKOFilXa6c4FYFppvAVNJEOBzyO3JrRnFHl62VicYL5oA7FzlwYry0qL38ho30hwmkI9ug5nODcjn/FyDkGyLuACIjUub0PUL1mHtnY4qIXdy+oL+whnRFW7TeK9QlqHxtXs6XX28w2f2GouqkD+dPS+LwbcK7jIEdZFG8s0ce9RKydFihD0YRA8qweYAUf6Ik5ppmelYOwQOxnxmw0eUmLmCoAwpiJGWShTVUKdsLXr4Q7rzPNwcNOQUofqG9kR+HGSMyrQrT8MjYfP+DErTuRVW+/jLqx0rwOFaEcUYCEYYs0tcwg8kqJvljpXKfCk1dpCWCjeQ/ANR4AkY50bXDZEHbS4bvcPXOxoj26xYumfX8RJXyut64CqIoz+bcgGxJNg9kHVqwQo6gK0vUvCO6q0vx5wZqYQKPe5JsOhryz2MwT1Knz66EzD192aAuxVyxHL+1DFr4f8ue+H/kS05C4WULXNrO0U3M5FyIgeM00Ib/7uxAzoYnNwMUpExj1jz3Lf+laSCx+KY5+xN4gjLIeGXzhgyz2NP6UEUkrOGXIaux8rnBIlOr7ycexE7Us9KtfP69VBZG24Yg7neVexZ1ql6JfRYO3+aNk1pHy2CMdzyXqZOPmeFb5KBVmxcrbJIqVcexUCEOQaB+rybVy592GzCLI+gf07bd83k5H75QL+DYbbBv61HewQbaIbb7Ge4GvTIeTjxHoHXGexN/NbPD4a04MA10h1UckQ1aCUAc1IkrHl9+T9YOu9Nrh3SJHZzaa3zf9cDeII5fsO5EZnjLNMLWuOd996bcxivE3d/U8fF3Xpyjy2YBkJ2/cbaRWPNuXkS8SqjD86JWOrf5IpZP1OEfoWPEs1xqVlbD/PHPgy1nhfbLEfZuM/5EXuxXDXpChA6MhamFf3/YMXlaQKf86XMIqn6hRAdu4sl/dR7KSa824+B6gH8M+QhLzCYCJRnoKj/Gk6eSLPU5izUGO4lku6u1d93jKDXoVWA/P869AZHa4FNbEyO7BD9+P7EGhunT+akf4PkWeSimjtqfPwefNMDFwPs=
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