VKtxpYZWXK9HVhnTqP7UGNXlKfLWcywD+/NpkBxP6BIFWb9ZpmBpJuuM0App+ZAXeKueaqDBxtuPkFUXU3swViCdI5tcAR8d6d5OMo64WkRrV4p3AAasA59Bwk9/0Uf7V3qVGK2l2JQbKLB/9WaD/BMRIFN59/f8VfepdQj7ATtMSgtgOixX6Eg1yBITei4RV02OsDTqfhRJtv9wOgkXZvwVcW5LyLlpVCDshWmNC7+njI9rdpkKcAnw9mev7pdckV3XBsSjHrsiEZCECxZ77XJuOjLaVEZ960IUuphtoLa3atdgQKDlQ1AZMymEzNKaXIkYNm04m8AkBeIwWo3fHTXB+oeGVHfE+BrUWO48afV/hir+H7RzxuRTc512Ey0J8qGOKkS9lpfib4XqWOmPrXR+Fh91dL9Y480h8Ks+riD4tcZbO2oeN3Wdselksb25NxCRri/BSEzpNKKKgQQLEsM4yzPTn61u0TfTkrGn1dI4e9yxfuTkLxrofopDIGNUruA0OczqkWouPTDa9mIyJ3N5U+Gv3emIQaAKBRs+jzmCwDMmWtdFrMZkVW2ub1kH8kG3iu8AUlb/vZ8iguSmjuwSDCWr9F4rwEqIbP7biPqCcsYGvuOwFlW6hV0uH0Am7pBTAXrEsWhX5rD0ebmvzP0RZedGAscySWGahzi02UH8EnAS6zE6rmsuunyQiPD5VAQZG+u8886V9tP5gMhngdWfPAV/EWAmnFByDkq1BvAV1JjYyipejkLwRxavB2cNf050wQgfzxDsAe/17fy0lAEpGEqVzW+sEFcs+f57SbmYvTE2c+hSvITVr/E0ciNttAp3F0JuLOyquXfetZJfsa0ohKtc9UEReu8A3TUHkGbIqn/6BpcjlywaChB3UB8CTPI6Nfh439TblX7/RLuDbOChA7I1Q3q58YDuO3C9M3wKAoijfxZARq3ScXtT3NjLIHzGpEt8tRef8YqrJFRw9hXWmAMxTQUlTa4lG29dm3Edf8Pv8DDjlJSWX9xOHyXysNwxXaLlZymw4hZ3KshQ0oN/khD0QBligkQTQzZ39E0y5dPqn3QJokgYIJwJBo1uxf0h/TbCq8vIt6E9a6B8mY5lYEng7F/AJ2kcp5+VuxKZvYMMTbRTW6APO1ceBubnQc09c3V1d4/9FQEmJ0LaHm6c/XdgU/i9zCc8G2bSojMm5VXhjKsi3vJDa6pJPNSgRrXZh1f2H5dXbHQl8jhW16BCYGihoj2fEUbZfnIpcXnHdu+tblYiDmQvK+tsHymyAi2cks8PtvRPN+46+vouhyFMS5OhIbmwfD5TYcNST8m6qzKa7iw5sz2PQY+IF0ZnIiY5ILqoXA1aDjA7LlYfXJIrQMw9chnO2860iDo=
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