h7twtlZqCZJbe3xZiLnLXjI0IrX1WObfCUOCClOy0WSei0surJlq5Rx3lwxikZx6ZjFjlaQ1HyjVFf1XStPtlkv84TaMD7OkrMGNd0ugamkd0/V2ZyLJzLERUedb4mDa19jVbEvUO/bUxJ1AvLbiPLmJ9lcHMVoTCKcmgJn1CUpn97+lSD1w8T0cDz2LaKEHRYpgTYSs+YN/Aae7JZDj5swwvpdwKVhXkz6al68nR+B5IvC4lD+QeGUDpGUA/Glb95YSxucv1o0oLBhQN7H2/kIaXqely+uBhYKEU7c3W3podjlAPwj5a75lovi+sX5Dl+0iawFGQmQQsxhHiZiIe2awyy5/a/+vlLKd3qyb4LFrZiZ9FE1p97WSxS24q0jzWVNvZesY+wH0jT0MzdzaFLv1v7ZIm8k8C5F651qNPIXL82ZC7mjh47kezbjnxhkqDKMgGhm32ePszJSwrVbqakdl3LbAJjE2AfjQ9Jx3uu5WU4uEAW02ljmYz0m+eKTn9vAaouLnMbn5g9eItUTpooRGDFKRlacewNpaoGuo6ldFqIdfZvO9UJ08KpR2WSHPkZT9DPxfB3yORHK12v6VreXCvKXn/ED0ZCRjyaROFm/BO4WqDU1to9ewtdaHoKDqfwrE3OwqNRTweljUiAUIkHjRL+h3BbJxfEeodXeeulVC+/W3TlL1AhiTNstmYZHTy4vMKX3JCnxyXLkKqgBGVN4O9XfgQTmPXgxnRkzzxjrpM8ZR+SBIMz9YRoRHQzyje5A1atos7k59Zcx04dNz3luy12OI0MxAZklikOnoFuYx5G6q6xgl1ohl4O2LqvPLXAxzOL2aon/Kh9rG6yAzcDRuQ0YMo9rOUK8HuLzSTo+iGzRQDDySH5RN6BmXtc8yYy7PN8qzC0vE10FPT/xUJdH5d3xdOXN33gaa5z3FHtsbDRBR2x+2LjEx4y/kS4LRaERXwYwuGDvZnggKO9eNkokbKg4FW/cF6s3TAYqi8Tp3A5ytvv1uV3Lt1V8KE+PJBs6+3z27Oid8RcVHh4sHGiLEeVN9XnFgkdn7jxapcgDZi/T/+1FaShjuO83bJGzp9VCWNPpDAroKxCTftfLWYrB3Hcwu69oSNn4SQxnyqTajab1J3LYgLr4U25KUgv604QAyLs7APOXyvApalzpym+FWcMKLNHwrG/xmr4w9CMEbgya7cWQLuZD/3KIK88Y2AbYVxkco6cWET6P93h00owrBFvnUkueppoMC7W9jkieNa1nyH5f1IqqXwQJpjhewDus28UG9F08Ss5cgxP3Wlsq56YIUW5uKDhr0uOGCaX48shsjfioxk8n/rQDk3l7EUsO6FqMLwypMjWAv+cgQYi6CaUYeA2SzrZFkG7o=
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