Mx6X8PHpq3yqqWIK5L7zCOAsFN6Rnl3TpbspBue4tffyfiXCYVArm5Jjzd3RuIEGfsUKIjomXPrVrkKbZvlkz9F5i8fPuQhhqzsmiHvNYtEGZ06+nB7zeDLruAPlKmfsz7rfD3sokfsuN+3qdRAymT0jyA6G4VlXoOvDPgr9VgjyQp0Dvm5Xy+YIJqbfYC52dvKA4p53ZJynIiXoazmgzEiQQlfaiRkSEXpTESIoJ2Hw3gBUek/eYdpuFI50wbBWHkt4k8GI8LfaSlJzKSDwr+5s5gfH6TKXI8LNRN0JwaLEhfPOVc8Wdm5QXMJrDyPW9YXL5alXZGOTLl5bLYQFJs6BSZFAtpQSDg5fIg0PJVunOmjfuhCsMRzZZWjp4oFDTx0cG+4HoF0+jw67NdBS4vWNU8gONipBY2XpHmYXtuHh1cO8qE8JuthtAp9lT64IzaUqZiwHwoMp9TdDZK4GvNX3ry+rNYPpmxLRV9OLQJeMEfKLg4twhWnZ/Z+D0ffhi+v2gj/xpnhCFglA2iI3zkReK6G0cIc8tcySM5dFQ3FDsxv8Ekr1xO3oCw87mEv1HVPeFaEqNc7G98QCtWyAjtl2bPqgFh56UZfOuls4UBgOMvyHmIcJhm9J3bi+MgoYu+0nevbswh+ynorMgCM5oxFXt3hYvibdiJ/BDNrtPfwTo6O6GVTVHr4iemxECUjYiGfQM2hzbRTCWf38plY6zO5bIosVEZHHkPKnXIpQXAJOyqD/J/ejtye7loq6JWBfN+SBeqQUhh/htylcBe8gBqd/8H21lTb43dgvc0/cWvKxgXRL8g5Rp+sLeaXuMd+YKDlVlCEDjnPsjqFJ5NDxiHxPA7Iy1/AtOqMOi/tMHfZazh5bknU1cTFVlsn6QXqSO5+A9nIEuB6IhCl5F81xOkyLNlMHvCVHnqnDcwp+22dYFXXkTsyr9qBImJ3rvOc8AGiYCeubcFQP5GlFykATY4AEqx4MxObrc9vt+iXxhcvS2FanGiK4F5V/RqWS19XUQ6xDzREVRli7bWT32emxJIeNLLYHICD8Rxry4XlDkcXcLUlISB7QSkxsFv0LgZXggxjw+X+CuOypHG02GhtK4x54xvcAly4kYSs78Sl/R9mT+b9avYFSM0NFbn+/yRGIXRJHwnVLqFGpCQvokZFUvSCKUJvetnqc/odIUBmAp0aYP5hXDQMHu/e8ZZfg6RhTh1W+RE7OYIrlRm8X3GlD2gcfhbHl1hj8Yv2cQL5GMgp8LXwhqU8jEcfI2Df/IK6KLRJKE1awx3mM0XMSnRwuSE0aIYEvsl1emwno31+4ZMIpHh10RG1mumFh6GmgGEMi8bhLjPEJ1gsFJAEiZ6MVDBhf72trQwp0/1CiklY=
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