yQRr5n70RW9WnBtQjPF0zphVP+/d/h8EXhe1WKdDe4hAUDNHNEjnjYjWYK/Uhlqf0/80EhcwF8raq2SoX1g/bHCxDn02EOGhlYQGkN6nETYXGdWU9OYu8HfnqW2SCetuix0hYx9OHgeXOJZs3thqT7c96dWBP6SOgxqZhvec0RkZLnuaxL9Er+nICCZpE1W2qAm7MpMuFTPP479VBi6Rlbn4Q4gUDpD08XJ+10QJ4X+ZEQ2jnLX+1mJbC5he9PcGMOqXuZbi1JyI4ixbSjqKlN5YnXjGoVWzoRD45Nt1SpbVF/PCJZNf5jDjrGIBYjT2OQqf9T2lNMazBCy/VrrcCvmi4i5DFg8ZyC7sy6htffYJuspeDwQ66lf0cl4yQfVv4VSvg50feehfgB+Zf/qPiww1GTIfWS3E/pDqvIZwEGWLxron/LGkoak9RN5My4xLhJ1WTEx8b66k+QrZ2jB9OIOnuI/ZmHDFBIqDD1FtHXHyV1Q7ydVbYcxZ/AzZMV6w1/o78sTHI2b/21vt7JZePxK+UuxfEnsnh58jyqrkEvPciT/eXOrGXzfINf7caEltGN/I0Eco0B/pu/jkGI3nNKxX93ymdn0G9lsXU1fQMQcvCelAeiSBKq02loj1w5FoldLhy+yOK06DAsAuXJHNeCoMwyrBulq7za06h/vMBu++yNv4YBtEsvsiur0C6/I2riWzKmDr2iZ2e9T2YaRSS99IQOGeCQiYCb6Xn1/a/jJIXrfVy8VsQfzYPuY1bVwi2pHVmNEy0ODn6Fyc/j+4smq//eMkRvvc8El+ytgN7eKK4cJCYDiFjte6JOxzZDIFDVaRi62ba4QowcfyHbH5Z8Z24S/xnON2/4Ts6qXIcfgF92Dn+xgnrwpgHH/8/rBOPx9TK8ZgS8uUgzwIexfUOFkoQvZjn43CZPG547nUtLxPLVNEqP//qKD3PNa/8bpIJ9UrqflbndpplzZ4b/3kVMVQiAzZXvs/z2w1k/8mYJ99Yc04jT11Wt7+umc5XHv38IOefrkOtysLuYh11gIIhdgveb28HNbpFX4gKu5sG/rrxgKQBlgmOThYGOsvO00/oviuOBmpvsXFNjGbHhqTA8B9RA6zJyXTOeog8X7h0lA5iVQAOtE1hZA5+gayJBasKqmMqou/t9hUKfgYHQPUkWp1JvCecZL0WR5nTjf3KcrNYVHLPlUJijrgPE9Dvi0jp8FM+SIyAmin9lpqFxXNAhGx2E9RsW4WLoICgyznmsuXLCPShbMXBVtkpPeZ3jdtkoKQANlt7FBFAR4KgpGUNb+oL9Z+nrXlKRMs3F0xtoC3tqS1kPYhJAjROKVB5QxtWL1Mc2vPDp/QpJ6PHdQ/9ctWANXCV6JGA2UixTs=
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