FQawBW4O4WthiuETL2ovXpPDD+GuuK9os8xgUE43aiBYfKE/icnsh6cX11XsCjgsjReZ4Ed5mOZJr8m/A0/yb6tPn/qgQcd7TTRYXE4CeCIVPOUJdhoz7lpDQeTBq1T34Ki5dyM91wtWaWf5K3yjeMUgnQGQB4ZO4+/cl7+JKL0U/WTGJiU6aBxQUsvyaQQpZN6zE7yKtnu59D/w9AxLR1m+svt9aLI9LUvnsxoNCp0kxgL/digh7r/JT8CRMNXc1451Bhz0SuMgac4eer9jtFPqrunGotYWzsImQJ2+2cdsQ++M/k1QDe7mrj8GqNW4u1OmDFz5CHXDVnoqg0w2EdLqUFMk8l8KG5ii79HOTrYTx2gUZ6CgBLJ15a0cHw87YJcPotlJE+IXT4uwm199YrFeohXvu8w3fqj0JG/3MJuw8KWQSQDsboWGii35U8fnpwnqPVobluUOA/pzCepeF6et1+VwuCyMhoWaWpYxcSh/aYluEQXnr1xz8F9Y39H3OpEWN40OLnKFY8nDnmde892haZVJojDBA6kQ52+8f9hqbxX5XjrJjm8BnAvTcOXOqeJoWCy1UG9ofgxLapUHAJ2qnmqjeg0By9KnuHHrPIDy7B2YIorAfGR6LOVXfKhLvytFs+3K30IHYTzANua2BtAJeCW8FrEYSO5TWFffblnZe49bGzBuYkjD0302qaOc38+W9QXOIt6Hb9eFqP96+QrnxXQQJrkx+mK2ol6T43kn9BJp4tpxfGw4UkMbTRJE0Rr+SzBmefrTVisNNWwkKjfjr/YI1kTWf9axj2qR2qTIQ2jlaRGFkdT7GE7DqwjTAnNLLOCgR5zQ+4bjeuDzKcJXHFMY7BUM7kOnVgKZLcLAnNolJo1suOi1Fw8oyxrvnks0JBSTnY6Ms8csnQ455AKJHn3k252j/9PmDcaXSo1dXkos6kdcuHzm8IO2yZumtGjTpSZDFXUvjr73UtM0R0TdxI1Tvp2SwmjCU5gA7KqHNry9eneOGL/R6UccyKSP22pYbAmcdC+QkSC+3S1rxb68MEMyF9vYQWp6zkvklcfqEiZGbFeIKmq98Vk9fsXzQJm6aJdgxknDx8PbF1hkjmoz3MD9yCVgiR7ulnB5v3cKveebKLeWtYsVG6qVDTuNikt2C3fqJhVzaPNmj57HMPGnP0PxNUkvfwXRnXRkA7LO3kePOjjf9OiMXzb39A+McDah4jz5LXjA7NB+K7+xHPqnj2JLl/AGNBVfiliKIyJaFIy6xr5JsgdEy0hGl/2awAjI9ndHtlRbdSta2GvOGIbVsLaYkximmZNK/zRHW4u0b44P1k8jAVEtR07tAW+tHfthjeFEz2Faf0sd4XR+PA+jXiNRsPNWcYhYW2Q=
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