i/+00TKLqkAYCJ8zSauHKwhDxYI1hmO0HVnBeSzBtWd2QYNjY6UYXOqGmJwgoZhlmXCfYxOhiSwg6wIVWE1FeOI9Yg/2QcWrOisxT9LSq4b2ff+dz6vLkCrKuqPsLnHjQeeg0GUMV1+1JfNTZQAVials7FGloLVDeirha0Ja/WtOL9d5pcIosZ1f1sK4ngOtZRu3T2onNuzDSsttG2uvjgSJ9AtZUENteFhjXd93Zo9hpkYSSMS409TXaNqoFQqPJJPilcEdAL+kBzWktKxrNBlylOiXgBfD5BJM3oWgCX4GS22N5XrpvJ81IE949kRUeyN1E7mnc2De5bTnl9F3ARwbHJcqyHxsJ1ZRV3QwWbtiJQPfH/OfyVBR4p5d7C9SaQxqpPwKIcPN3apo/H5W1G0UEwY0IbXY/GG4ie/Uot+gmIkj2Qzse3/QekbtaSQKr0g3WpzFw2AmZX9KSbX89rQExzvgSa3YxaocWRuqMeRr5s7oIG8Fcc06mK0IcMfMdpVTPOJYOktPX+Ew4VTmShqkHkYHKbj+qTWlPp0BA7EOC+JCSXsgCzOCrZ0DsUIOzHlvytNqEo5HQ1hJM+bZLxfrjfmBSGMc9zVzKk/fkPx+NhDpqrXrSwB8ngazOfkhzPWWkSLj0NnDrwigijmcnIux6fNYIbsBCdkuEkiapgMEDYkv6wEzrO79jKEWfxeE3HLhMMlGEiFMd1KxHBUNpwK5o1DCfZqQpXjvn33/xzWR0za8Jy6NWdPV/T/c76adCcvc9iN28O41cXiJEsyEWVYK5iWveTLLdpTt4tUjNJP0v3NTQbetR2Fy46lDAQP/jlyKbebfaiiAWYe+eEKMgLSQGsaK+8p48J8qrAQvT0kpbjoY/tyoXY9KSdnkLlNUBky39f2qmBGuWsJKeCEoXDHts3ZVsp8poYXmBtPqHQWiJzhacZITvLme+f9wVegcBR5BkyM7Q1WDMnSUdo+Y6KpcjfFf5a3IHPFLWBrj2+hwkw8NX83bu+IR8Nwc7LPAYP1qJt0A4gJORhSKo8DljOfH4Sa4Pv7a6HRlSLP7qQsS4HYf1e5L+D/GYrQDzH19Wbo/t4/DRS6x0SfeqiPsQQkh7C6zbQAzpPH/e/L8xMTeaI7If3MjB0HrwI2KFg54n0uWblei6Z5rypCLA4q7pHWYKw4Kvk1FjDRi3/jdvFn7N6TDRIorA2IKSJvJlbt0t5J6G8Z8A2KDoaE95jyLdyXBFcJHgzxpZHoex7Ra9vXFgVt0OU+qzLzqyG2spjrqjfMBUM22SyZZAEtPdjVBnjqydW5PJexFiy9ZL6MpuMaOk4QgMjZrT6oRvVKvJnZzmJzqIUZWO5X3lBegxuG2zDbeoh1e6Guuap9n8eY=
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