0hLXWu4lF3Xz4g0ABaWl1d6dB8DM3Hk7Sn+LozRe/uN/wnyEvfyfvvIPJtYw0NoWyXJP2wmhjVKLVGTL2NMT/lk6Hll50sPdUSV3Ew3WPuDXUYsqq8yV2WIC2wKjps+CDn02TT8Uxx2llRGm9LlyqG5pbcPvEAzEIHjSjJbd+81DIgsAO0UZ1hdXWpEVqb/e5jkBVwUb59P+dR7Pn2nKW+rJH5iqqaN3+3U4O6yUlnUWtjcF8m7y2BtBvClXD4gI2FczTIA44HePLq1X37+GyIItSpCS4KmzeyUrBV+CKzoxVcC2sVzDzDhGqwB5pRZnb6ZmKtdAqrrwxta0aJQbgkaAoeXxgm04ZMBz+PoKhH+IWTQ+sMvZxOpl2C3CycMtgTQigKnUOUKIX2Il9MJa5isx3WildhrCR0KEo2R1SjyT2LecUF0rjdc7/VzLt5T4Q8rS9pWSvOdOZp+4PdEPDqpGhWcTwKkjP0tBRVon8/6VbxX5rWrQvaDDBZlidsGjpeo4HzfcXucE6J/Ih1G/YORW7FFOo8rzA3dAsqVVJ2YInl/b9TMD/gomqdGXGAtDpCAYmggUIT0cE/0cN1CYcBuCJa6llwf7Rw+E33PEUzLcjXtGJ9jWq5bVo6Dc6Lo64vFJUXLdw5OEMzqtU8k3ilVyLUH+PSSmrA4OdRK5z7YpWOMQ/7qXq66uTGPk6ZL1Y9O990rxBEA4TtuwPNfZ5KMLbc27HQyIGoQOHKmydKYflnKsKPAeZIgVXZ3+9neJLn6CFEgCri4PXWnU87dnUSW5ySCM0lgJThzF/rnl6DeHP8i9JmWYbRwo9ycGEtrEusQKyeyZQhiEzsiAFvcFQ+UqjJysPdXX1z69IHyTE93fTBZ/fzV6n+6JGOBzVcoA0F8w2wWYPVy/rHMzJ2EielZ+6FOVJAKSBzWW31KJwn9ZpC1j806e5GOF/mQNAbIr07GdLhFcV4hTVyxESQ4ihpV1AKpc/eE4XsVeyDQc85l19929gd3zrgiX80wG4f8RZ1s39faYRmb/FvlUwDO9COtrjJmCdb2o7/IJbWyBk+LxDAont2bVcU2FW96xMcb3SUQoWd5+xopwxOQP/5VrDAhtT5IPjJ6hfurZaUetrHmGuE7ZTpJIMBQemT8X87evxVelF84n5YcS9bDrbdd2PxPVDRn50F1sfg+uqbY6o5nu1qLAqyRiABtThi6txyzXhuxlzIcYNbxzRDKEbJUsUJI34FE2mfjcBRWDLqH9QzWEkp5P8JUmsp3dzZu+GARLdgn1r0aWvEIsJwwtOcK2vhqSmY4DqDgsUYa4XdtNd1XXCqeqiPzpXWvHfYvF9N2czyf3VH4BEHbrt5jNCx04Ry9jQgnLu1FwpG1kh4Q=
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