8kfH6U/S9JtsxNTrudlx9QmjEc6BQ7HCiIxA1lKdz7Vj4ugl6R94wumovk0rbXLGKJqhssvesscmKTkdI3uF3iWGN/+UbXzGDktzb/Q1q24f8qBAvM8b6kUpkjQpMerPoDB09vfhiassyv51sW3/1a+bPb9U6pViVLtV1TDpdZ2mH2BLxSWujz1LrkXZ9yrsErqJmONKoMWifQXXLzE5VM4ZAG1M2vCKKosYkYgKzt7Drnc0FFEbYfh08hc6G75ZKyaxy8rjYSAwTSfBTcoVZqhA6FunxNPCU3UxPc7sU+H7+K7Uj48VpwhzG/5iB/uq7RIDd0HimHImlWYli3G3QOMj3ZC2KCUdFU6QXcs9o8+k0vtHbZo5l2OZiZFD3eT+l6tFVBtsoglUX3CuN0CE7NNvISksEgiaKFL/QSL47nRvE1Ba4WAdyc5fRALcZQkLht9BMYIACRoD5JFWp0jMt2ZvDyhYDWVnn73FIG+4gWWxLHbq6qe9xzzV4KjF3zxZAHEa39KSFi1VOInKKDk/ryY3cYp3uI+qpJNAugh046PTLICsULb1m2T0iKVQ05r8qfPw9MU8eIG+dilg9pu3pevTlH+lOHg3rvniKMntxxEZRRBbLBFnVs6/ARdgAWTjh12KXrptO2xg2Ka6gnTUopV7UYoQnbiu5aBFLPHnuzejmxsdK8rGEneCJq72MiBu/MuOMB8amWDTc26XUFNBewZImhfZNitvZh0/kIl0E0ooWws5Qa+gwY5DYXHt0Hohf4OeE4Gs0m8J/LkoR8c6aT7NVMS2Ue+PG41V4uAlSOnM23sDQklHYgwK0omf2B+7svYGdlfms2ymSIvJ4oIcmZ2WD8KLLTiUAEaTy/cmwQjx34knYhVi6SnewK6e6wmhL9UNF3yVsV9OUm8IjrFgpcm0JDmSJ45PDbf0F61QMcTsQg6q6fi8UjDAasPFT/wMEuiTPYYY/4HNvATSD8CHpm0dXwZ6DTAi+kQY9qAihtUPt8iADH5DxKAvEKJ7jX/+BPxe2Uj/ftWUm6d5uxG1m+UDs29AHtaqgaJyB/sB3cOR2in0YTTJRKW99LAoYO4LBvTAINb5nQCkPkfswGBbJfxsV3jr6/Wro68LYTltt1eO61sKFsbp3r37RBem2kbnyYL2T7qegw9Oz8tsEaHgpzgj419okYK4sHrciAglf3po86NaAD6zUgjZn7t9LdDbH9kNUixd9CKk3nksuTLzvy0PfBiO4FUT+p4Pc4qaGxTY/+GYUiPVeTFhyhAwJgV/SficP2fui+ZmUrNuDYFSsG0AggS4ZYqI6gR4QA8Oaz1TxnumoqzKfEKayGgq7qBpwfOgLeZOBB/5Ju5fJP761UOERMaESDUajT7fAno=
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