ldqaU2oFE64R7XoRZISQ+0bB55eCqeGMjL/uOuAFKIeXu7bj5PBz+YsCnwc4tFVmQ+t/GGd6BXmkJHFDEJQpii6DgtVhPj1wECDZoo/LlPBmJRyYgNvvnMaaHBm2n0eSCqZ1TdCbGr8OKQnOB+3XInMVl+sCJN6uEF26QlQQ0QwYtI8iTEb2TTN98iA87jo8ixOU6KPFCzaGaTXJIVOPF6MPZU4M8T2mc6Depgo2MM06S1APffPxjfByNLtSoY/PPs8qHri1TP2WU57aXrkzOZ/FmgksbNleGKx/T35dl2wKEdsPV17QpW0do41CJBm10TMn2s8EKA9dqOpyFgH3yZN6zNdv68LK8neG2MgXATGZC/ZAVl+WleVNCox8zqkIEAZO5AgDvbEtbMnfPCBRSqgYWY+slKueEepOldFjnZNNere7kYBhtKyYf7mt66XVRSq9OEbcbDbSKX1I4FwRzDBWY/EDQrfAFaRby/xkqAM9SLIfMq+SzXrtLPxdP6xJKwpwAl+G5glZEBNVQ49AeA2OEzaRxI/U6xzWQqcrT+WWZP/5m7VWw6vmX6JZ9L2JIFaJEbsV5KyzCQDi57BMzmN3km/nwi0Bp0T+Gfkwo/l0u0NOW8Sr0Shw3jcQnYMfIRqGVvwhaUsZ5c9q/V78SvG7G2tbFwW8a5LfYf80BJha19/NRvxaFcsg1XFYzoorTcmoesotMRID4mbJyO4nzKS0agPmIYcXWb8McLqAoF0RAcMB9XoOiyciHBK5OrP4HEAlmBt8bgjuS8/Hkc1qY9ikLutKtCQcRuYMnJ2+YmQAZBWoZ8GrrVcqbHwkSjND/UFBqnnUmH9pNXwAtjZlQRwxyTSuOD4CSwXh7UNm60xFRWvMafqoR1S8fqxsijLTxmRf2dtN2vjtRhBSECWBsI4pom2roRtBCMdmnYp7PLAp7Gx1lOM/ao/SmMd/JEaE48NJ2Z3aFjcM7rpb7oLtvCRlNdI+WYR6aLmP60+PWxxMvGfT2Rgp8jUzNkNHY170nM2cDsnWqgPoAqB8/Q//E00zDh0svlGNNxxIdp0D5o/vdyxTm1DzFkdKrfdxAeduIt1o5vvuQVOT/44Rx2Ze2pMlDmoS6LFGbY8TQy9xtK3LW1gxzpNjhaaG3Q98+AkbB/0FXVdcUoTPTuWs7ff++URjagK5wi9nZxneUChax8TPh5G4drJKSiIC9QmEOhOSjx3Ohyklq03gBfRuJvT8r6imr3zg8iGdGJYmd1qm2yf9FWArrauQ5WuW5ptSjNUKCBCx7F1ewXw4mmv/3Y9ruRyetotAObmAh6I3hGi7whzLp74UlQx1D9Ehj8gJME0+09FS/kZo+v9f9QkhT3plc/i8EIsLS52ch7aYPgM=
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