eyDzjXaEkSQ4wIJdVDFaJ/VVgOnjka4yJJ3gC9hCvomTDrLTULQ/xaSY2bwEEqg7hBlxjYhkwH2gmPlNUFgeliZa0RCaXa00fUO7VlThjCCM3impnmAOouCN795yrGk5BUX+pwRI59+etgNAdpn0nvr6VK87s/h044N1yTW1pWdwtsSU8cl6VEe2RXcF6Y3yfz1y6XyYJ6JmDymUtUHjE7vMN1v5xfizaHBra/OPL72/kkBoot+p0NN7Z0YypgsQYzhESZvKHZUl7dr9zgr+xy4lGab6nSETwrjNr3e6k0Dh9OK49MUwPBbfV6Phi46+AXHqdDwqwe4B4VcbYrpSZR3z8Muqvik6jilLgkeYz/1tmJLKr3VtHLve5lP6tojd0rJZLJalTtTg25WtYH1nJ3OHkt8nw662lrEYLnQ/5joWULFVEO7+HoFSTSQu5rEENSBSlF572QhEgE0Ejuhi1pNgxQ/XcLo962uwQ70veFtJffzeMoVowdPKc5zhYEWCGvJXvHAogJrAJE1Ae4t6PS7ypw9f4iqUVwKmoouo2HJqdOcxJMLDcLad1JN9PwQ/jw4JIcNLw6KIxe3sUwVGREXngw/T1doddVeguU46QDhKY0IOU4Jv16u7pjvbZ1vwsB1EjIEAAfTdKwcvDpl3Y0zIOTmyLglPl0d8uLCRKPrFHWSB5JV0NHXhK+Wbbk/NJULcZhSuRFg4s5FC6/rl1q6O2GkzEhP+hdRfW2l6iBmUU9m1c5EdoPIOBcENdJ1vk5ivAOtd6yZ+4B/HcYH+CoorKOsU0jOqsgr36/Sp2diww2LxW+wXsu64iMvhKkDW8yMgD3I7GfM4v79EfT9VAehC8q824ZanQ6JR9YKygWHsUxYJM0WyvqZg7wad2YE4o0uungxWFsySCG/PvkEanLalCkJBpBNWCiyYeh8kHcpA0RSZ1pkb+pOhmmx1kqy/rGxnI7rM7ayRjFMo7KHr/YcvPqNRNEgvYI525jkh7TWS8pR25KwK9DQjsJCKtgxT/yuTHaD5qpz2xH/unhkYJw5gGFi+8WDHosoqH5IjqHidw8un/vqDcYFxRgxFk57T6k1vXLGLFRi38BH1e2HLxPBTKIAdXDuNNrOTwD/o/KUMR6tU7lwVw69Fg5Rv69vUQSpJWQaTMfwBA9UdxdQi69VJBJ5lXmg2bjeLCwjM6pfYH6ctnUhs2BNo0l5pi7pNuT23mOa/O3ZCJ4qZw5RXBHQWLmTLcBpNP09ug/DCA6cljNVzuBgGBmjYjypYaskaCmb7aSghoY59u5IjGjsOtsY42oK6tfluLZWBSRRFV5eI3JAvf9Ibf/UGEpHLquJ0EDFjpENjJ9PCERKLrwjKnLaKcCtC1Kv7bSsLhDc=
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