BCcVMu1Cs/3XWNlPuAsFI/j8qm5oIj+HIEmk5d/JMafoio9+rFuSb6I9tYIwB7ZPYcQI4i7m997PnvB+LEZ3VnrbZKGrycV1fuyAwqUABHvpu5zfANcoUMT6aQsAZz+JNfC8/sHAOhBqZ8bX5AF4T0UmaZgsCqCJsbesQI2qI5oSAta1cRisWrjtBJVK7zmGRMitcoK1XrEOmHCk+tvtt6dUd6VnF95W15GodfB84LC6qb7ayAJYRPh1BOw1NXkK8wp3RjSf8PoMyBKW4l9olsPaInhYoVw5lRh7aVgCmQnjWRhk12jSI1pJcLGgcRDthkNSIuyK3Pc728ZDJKcnokVieRkfiaZTNj9psjYVTZHDTVHkz7hqkBYRhlfxx/v5CW7xpdL3HskNK26nqhlnfYRJCxRXyncQs8E4wdG1hUKGpMe2eVvU6ccCaLJeHZS3bmubU1hqHec95JY7riF2r1/xNeDlHhOQDyd3JbXljho5PAUF76EIQSeamA2SJnfqElLAV64t8SFcDOxsCrZhC2OzdmTAE/3JZG9mYQ0wCJe0dItOaT1C9+21J4VNUI966ToeM+goILpRIUTaglVt22MS9vjJEMv07RJCtsd9VA/aiWe0xacRUiSw4enVg9UtzyX1wOmlW+LVVVk7TYi33RXPIFSu7jY+QLPTpqqmCP3/h9dgHbVxvkzbmC1fNINmCTMUDM5TsU2no+TB2f7gSztS3fyo9uKbLmDuLYOwuuan9OKjdk/cGnMwgAsguBQ1KdjSejctJ66MfBnEr5LZNpSc38VoMIQR07tiHtv74tNDUk/UwFKXKrp9h7O1sfkr91kRBcmHsNHZVD9gRlVBOba3k7wRtC7MgJbTq9HLnJ+wu2GXav+hppf5PuB2EqrJODqsxsjnnQ1kxRrp0KgUpiGDxePHJAqS3rKaqqzXrA2TvtsHdvtO6SJ/hassXmok5CkoPYOipdox186mizJsTtHF05L6efOqssv1sIrJgblPSOen+2dFHQ9sD4TF+q6xj3SwX5ycw+jVQqHIxIPkELY1KVNydjyQpitKplrGBom9MMbUCk1V5qa24RC3wMq0EZH0f7576CKGdnL99N2KcFQif+qbBCTnzIhhDRqRDVXXotepQH3URZA7AUs/3VL8RNKxVlkHAddgTWIVGz0issS1Tob2i3NBv/bGN/azhe2d0+WyVSSZTRCfnO/RuZ2IXlCakJah7hMXbv4aJsJ7/6+KEwXDMshHaNaLp62unp6tsqN2EyfuUv+nMI67JZotB5ODJj49lbb9pg/0zmtmLKa0TVX5RwCXLZldDo01v3NDVcX3KWd9P6Qdk/JZzETGSEP0SLaIeP8EXpZB2z8Ye8EA5c7kaN9p/X5H47Y=
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