7ifMdOSWVC+XsujvHMj445im2uwE8NQVQ/lhQQMN7ygI+o53vLk7VuuKpUvrz1FVnRWIfaNxMcLjPl3VK1AbXWL6vybtU0Hu/ddHBSW/t3fkUYcmJhy9jMEZt2S+jkXzLpEy7vyGPSMnn5AcWlpiwCQhkSGyR6zTs2nSWa3sJbuGx6YE/F2puDe8gJtc6H5AMkp8tcztaU14g4j8N/O0GyMXBuhUF13F4KNVO8j23IUmV4mvIietkTJxsDpA6skbsCeX/9kPFrhrFxGPpn+7Zwi/0LNaukOMRC+ctr90aiJtWATiwxuYgtT1xl+b6a6YG67FlzL58xg9Ym+pIbt+nMYpJNtIyx0PNyE+kyqjJgJM5FKAlmJUv2B2F8txw+JM68T1o6Hey1LXziJJywE2/zB9WGZFA5GerXACbgr5l5lPk1Xa6QuKQgpep08v/ItPEoVTq+z++DCn4V55Qu1ZM2VlrMnZ4eBtnKJmjxLiDguG6m5MdJ8uNOxqnJNgwiULkvUVuo8zgYkmlxSTsbtTB5aTpyLGLBe83d7zCvWtkSB2U+AjeS9rymwG/STKSVLdnYSWRF+85QUA23zmld5alq3HNVRP5wPQnUBJEj8nr8Tvx6BoE0igxqCRWyYhWknd1M9RxYTFx94xHZfF1ifF69jFu4/AaOkBGEHpH2hvPk0cXY2IWxknV2ZTNLpgHNvruphbwtMoXYYGm+QfF26QzXpoHH3UTYdKS+E2KfD+UFwJDroa44Ub5EedF/0Wqd1vRy6Zvl27cUQnLrLDdAUWupxp5OQs/ydfAyfwQ2GyaPnTUseW9q67T5IOJyESIEZaCDLoy1o4EdEOoFY5oKCbSts+66MO5iab2ZVekm1lJSVmzLe3rMGKgQEYSPU3Px+8q1seGlnkTJzzAFVAt8bUPsQxHeZz6HH9AtmsMtDYIjmY6GYtKkwOFaffnyPqavNdY+YccNyn8jK/qsIABSwC6X3ZSZ1ROpenNrbBIqwUgTKJvJMEHR3SYwBbKNcoV7ISkCCKxllOirMla46PAT//JKV+2tMGeGyDuoZwW1fegg0LK0h5pFpcTjq29cO3SjIX/MBM9JumMF9XzvFFSkLavDVI2lGB6n6OsvtkMZtR5brPy8Ym5rFMr9m29jvS48lu6bks+nIc9HTDG+Li5nDEUbmS8MuBRmM1pr8KcjP2PGBX1q7Qecn16A/jDmTY4ZzUSrh798edmlVjE3/S5L1a4rnslo4ZcPJDXnkEzJN1emqV2wm8J3dkku7JmaeTVEsi96qW72SjIWh9xPGgjq9yV0uZ8kjWPysXJLNa53KOH1bORyZ+4ya2k08bIHkJhXIqdhuOvDYuLeCJsAGFmeA1HrstNzafHti0cTnJi1A=
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