9jDvmx1JZ6Sh4fSS2QkZ8FJAC2zApOp6Sb4GL8NGMwkhoyAUEOwGie0qv7CXLnRkNpAejqYrO0GvRX4seYil45xxRpoLQJtfRih3grMihj0+AjD4eT3eRMD3hsyyVaDrA6iEOCeviGPwgO3NSZAwXwPvqBauwGFHSul3XklXkoARG4+yFxFS6bchRyYSXqINDXgwF277eZd775zzob7KzjxeQGn8pRXlhTT6Xq2B/2Dc3YhS1f/nA+Zm3cPVgqHfslJA3kFLHbtpLFsJDwbGRIaJOwxcV8lhhpZXbsv6h9ACzX4Jxb+UKDJd1iFb22OHLcQD9H2ATXjGog6++ChXToZ4IWd7mqDWvOudmVTRoheaIkl5hdGcpJBVOJcd1PchK24Twnp3KxFJyUljAh3kIVddSi2WKTeUl1zDk4IWe2jPPLJX81z1Isidq/HHDv8y6ukxVabQVZIQIopDT8YyExAugNgCC0bzd/wYkMyd8K8aPHkPtwaYfiCeaK6Fvq8Fa6EBeG8Ov2J9+qltBWQVCajAX5Sb6kSrO7b5xAsrOnAayouwiHg/H5XM61WbrXs8oaWRBAj/0kRUCiEy3BsukACLqvfkvc7EDOX3ltWXN9CzCOIrQx2Z3o8SBj+nVfZHaiUxaydL32krjE8n/Qm2zAWKGZGdgAbGQjg91sKqCmUzPoS0FZs8xNuFEhEx20HaiT/1/rRPSCDNSvMFVSko+AeK+0xQAvR/wNcARehR1biiax3fT6xAGF0QGoaI6n3M9qCEb/xcAt03tS93pPeYf+osS3OKfmbFHRUiimRexpkKFIcccBwAgbJAuZXyqLMc1TbnmB+zMGPx9/7dNBC7ivT7cOKhx4QliLDt/nIaF+lzoP99KuaYc8kpVH9vEecAk71TrBfcUdv83vNjd4nsSrLmw+VN2GyyuTDj5AX7IQMYhVHIDDdWd/n0bcuyrFyPDFgut7TXRPmf8j+opIkBHqsQefTPDqHfJ6q0zufjdsSIKoStKWxSUaHMFJjh/En34BJtw9+Iv6QE2RZsBWv+XvqTHTdYN3sw/Cti0dw+3+nvDhCEMjEGWebqjIyI4AMzZkps/4TDF/r49klRI6SQgdw7WBKE+Cw6SRK9tw6sy9qeAdwik48VZ1UZ0JZ0e+oIiVb/NVBV0jQpmW4w+7qxnnjOsWozWoRpmkAZfSEYAWKx1E0XKZsYqt8ZC8ucOChwoVIFkbV3+G2qUfzWCt/ylcivLLZQUVJABpgeK+YYvwbOKWo+aYs5nweZkexf2IBYM6NPoQPifX53GfiWhitC/0jTd9Mp5svY07orFHAU/tEh7FmSyFMbgF5RIEoJpyLwbdS81HrtdWRJ9obg8XKqJHRha1vzOzK4dwbdFaY=
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