P8H5ZuKelyV6eEfO8RWumnetMXFhouVzwnIhpuGp+BJvDqym+beLJ3txSE6+xzlf/8amaW7xNSkAWQztMGPOjms5AxTVaJ7U+G+n8l5lvpWd0IcC4hBBBnC/EuT524IbYxw/BhTvoLp4JAu7c6zjbQrwbqpV+9F9ba2ooGlQdS5wmM9mfEsbmImZhrHOGAoNdIbL5dQZuAqxpowea+AfjGKgN1hWM8EybvTyxDO7713hsdp41iZOgettLL60g/451+5CxpGamn/rP0906+SklmjHGUmdeTrAxCTwiQ34ZvH/UfiAsACn3lrfnHgaTwz7gEniC8YX4tz5Y7OW0126DOqWEqii4aS4GUcHkgaTgwcZZGsG3yH0WTCdwqA//xekkXRJQrFFVru1oI/N0uT/1gB6ffxK471e64lbwwS8gSEnh+J9MMkzw8l8RT9nQq9dHABbMQuegi2zhFQsovT0HHZh5n5WrvCpObH/v0gge8H8Enf6r2qlNssTD0qKz/WyE4UTF52hpilmutjamAxFh3GXzcCeGp2vviotPxIGArPHiXYMzcKMGxSzHcx19hWKw4UTVzo3CNYrkBsa8e/GuqcupJ0WsAEZyL+amwN0fEY78PpS2Npwryg+wNEjSiW0G5Fxmi0I7O1n6l8okuKv0Gy13fxbBofv4pzypplrpcrgjL8GmtcI2LBPtwnDdKAfJ60fRvH5Ls+T78pZg4m/03ofTi45UrD3XMrm9hK7X8dsi3iJ4lwZqkCtDnq7f8uSSVL0rD7qDU+PAo43pC1Ko1R+UNU8zn3qmecgRn4vK7gv6CdLlYtjb7PHSzkcBQeI2AHsgEbxJxOiRxZL4jmsTmngU+S+i2pv4eXoVMkgISuT58cw0eqN3le5d5rHeZxUYG7pzlfxKvIe5M5X2ZtnQo3sVtd+woAGS5+oKvjrO/N1/ujyQvt/alBTVGPwRFZXOG9P+g1zKLI21MbXr1AHaZaB7ZIiqf6S6HW8YomHnHqKdUJMhoTFn4I0MeJDE0hMRr6Pt8jD3cvZhmR+m4u9PXOvi5e424nCxBxucw19IMulQ7F3kcOWzJivNMeTEFcSrudufEcixRgOORj54cJDIYnWYvbzv1LzZH903RYeu3XrW+G4yfpX5urYyCIJp4HXcnzC/b283WMFW//L02HR5KLyfwKeb6SWKDeQe32jFD52fviedqSIMg39VBYUX9DRa6Rkpc1QDMcuC5t8UUOr2Qmn6Aw+NWki7HdtREiBAAx+gVWI2nRarUhQaFFOrWb44bJGyOo+cokH9RhmfODHKSqUGiNe9aw/ZxWcpJLmpwqm3DugjT6znN8zPPH1TSkeeGzo3QX6/bgii4b7H4e6HS349E6PiT88YhqxydA=
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