oglIlJKomk40+yG+WWtie0oeCltMafI2E5FdLzW/f7f3EQDlpLfiqUmcduT+rI1FWs4HfKMAg/HOYuTz9gwO5y1XXG8ji8wpVNqMMAQ+QqnYeeID1ZxIA2fokWIa4aw3/ZRm2ZI1ED1fjgJS8THd1EDqh9O8o3g0YK1qaL0slX6kbJmQa/n1U6Jqn2xYXpHxri8a4qb1tZ6McoZ71Axg92Yj6Ij9pxOGiig+edyUyIQQlFrQg36BHzfDjzbA5jv+azRjZsMlq9G3Q8MDUg9PkZXIjRZugpSbkwzGk3qQdleebQV/iwxhiUrbnHbMPJKDF8Dzpgh9sMTwrO2u+YRnOuW5SVaD9zGVq1be/KmrKysN3Jfg+kZLhCYt9p5EXBVamVUdQVXD21kxtV6F/gX/Os34XOApjQqJi6Qu7sNwm1awpU+Jr1jnedNxf0FXeEDvnQFWB5CjPEUk5U48fCWPnJX8QfWSrQExp4NyktSGP7pymR+/xsglwAv6eYHKeH0Zm+Uxp+TGI8Nh6wSLmx5ApoB+XbryP6f40k1CQha7sAYgWAQQ0Go588/o5C5QBuC03J8k6rULAygnbEbGOY26VzLTj52lHv5OT6t9D6xDr+tC1ibKBYZ5udcs+WMESfDoSzs8TPgHWi57FtvtxQL7170mJ+uOECtkBDc8yzzQeGo/13EFhNzZGVyHMFTJ8KghqN6bFe3fVAVApvkm1C7PvCot8eAhlM+6TS9jeIkn0MfGWCV5VwgwJTlOsYN3WF0jVpFlGUzZKdxFP8MqI6E2U/CvO+zuL5p4KG5oFgBAWg51yRcPjvzUWOlPKeeg12eUVmBINa+BriRK1XT5KIkEQPB0AUyk5VjapWg0l3HmrpPmM/8Em041OjiN6qoYog4DLlM4z71lq3xQElLBM0F3y9kG7oD3IgOxbbTTuggL4KdWmpmn7ABdLSJ6y4uqU6v1d6z0058nQNXI61xkeb0xYzxsj5RZgg4csdzfQ5v/WjASEN/EUdM/JIKh+7t6rAVnWLvBON0J5Z/ejyT+XfL6As2MVBm9fVZclcDTKJX/IXN5Al29+J5kLlogPW9KXFhkEgTMrMbFMvnVe4QYlfL+nZWYEetrGsGfpfRUkCn/AOw+n2VKWBmhA4w9KhexnTCU7xvBlRi+W5LYAPs0Kh1+lnOn8Ba+fgRefOWChuKfM6xHkEkB5dSrjPm7HiuVZgJmFseqfoOMQv38vm/KcxfpxJ7uxF8TK/hnlppsu5CWhOd4TeijP7toUDa3QXPOZfrY9M6r3ZxriEdAUn8laXCquUlkyoRGhFdpbiOYY5yn4+1WrupmrhRickogSdqpaoI3MvP2YHj/NRMaQe2vktX0u5mCZIqAHEI+mxJjTI4=
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