+bW+1kW29aAIOX3RoWpjUjCTPce8GB1ZUc44g4K0P30X58tH+1ovClvx8fbUVuaXBDu9cqF3Q6c1rxa1Q84dwm8IE0r8/D+9WEidJIXWKlLb7za/jEjxW1urUO3orSaxV0zyRVDYZ23m2X2AOapN/gRUnr7yqRxdY5m9ghd+0pLwKEdpYBJy3kmGDIZDwOZf5xB97awdYzL0YfT/rjjfwWs1TXzYJNMUivJrHfZTnlHJof8zmU7CdxvHemHqQ7rv1LAIOl8no/Ldjb/Gt4IJtdoucaSaMuBzycm7cP6fXrJrXVZnUeHsJeEv4hXGeTOa3hEQTTq6gEzdLsscM8UxXALrNxG7Odp+h89yHZTFeMXVvydQ+LSSEKpdhnEsh9D/DdWV+/iUMXNq61OAg85DYMGx6Obvvj3jOgXL7XIqna0lS1ZwJJGe5c7g0ccHc3EVtmOyJFTNQ7cEZ1hCW643dT1bxJTOGbQCwDJt7EKhtZi5Jg+B5ViEqej0/6xawkpul0cnQ6zfzYTPaFzhQt9LEFk4fSXKhV8pAigVd8ozR9PqsyinyFgPX9p/yGhUH2hlZsked9LV5PJRAubQHF8377ZQ4qU1iWfroX5LrqXibZAd82wbMeuEhtdFksUeyFD0LLhDTEZatkAryK5REeZpJdSJG6feXURmiovEMrKbbMwiQmdxE8VCkpxoqLTYqvrRmiCm4cd3XUCxNbSbGal/4qA+0iTTqCQV2GyjdOhXNKBbeowcPimH0SJtmC38/SYHGlWPGe6WnWWWcyKcGEZPh4NkqyiFDEO4/2hVGgbHpVtkLaTq5VdWWoeGw0bj/o7DT3fXOtfA4Dn+5Y3IHmsKOzqS6NVsb23AZ6Mv/1eaNx3EA6+3z3KphUunfrbcBKBG5BDtnR85ZQuwsc70gf3Qrea8q8XHQTXJobXYXCHLx9aQ4c7U0fkHeToEx+d+ymJFcYUET5BY2Q2298nLpROcIubgivbzqNg7PvSguxWldQstJRLjjPpeSF57wsWA7HNbmcBkgegbGmcdVsObj2AefWipJ0tkwhyfq5NZH3I/3cToKe/Ir73qf1vbTE+k8TzqQcJr3ikUFry84fSkwOBF4CSbifnibnsX6L7X2bjgHYln0FEocp1guOkXcxb/oTeFPi8pXbxUggSWL5eOCkx+Qx2kC9jvbgsEHm+FWFqFaryd320IgEOkuIBOaJt1y6hLilmQXx3SxTh1gMErWnuoebXXMVk1fOAGev4gfZAIS+jBGj7O4EZG3+P1ZkPaLvFsQdL0AYsP6/1Z96kAPKVaXj+ySKv3FIIYFOLjwkA9mz/HTW8l3mP9l8HNgGwN5hZ53CKpphiF7jCJgMw/m4vix+Q3Ac/8Mr9jdXs9hKk=
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