lUVn4+LTiTmhgs4EB1+Y0SRnqbp1ZKSCFf3Ixwrhqq3hqaSVJaCrfVQvloIBecygLOKPLq2bRy6M3gDpKOsIm9BxtWvbX9nFxg5MoY3SWg6u+35dUXw8kDDagz3SiVo0VB9AZs1ZBPb/IMoXVshlDjNDOhNu4dIZfInXRB+fQZ0lkNwECmkQvb8VG55Lu99plvI+WZt2dLg6PE8mdlS38OEvc4ZalvN7cgBL3a7bEFEOTdI1xggmPck+Zdk/NRYuMniKdh6FceEAMpjYf5UNCgDHrXwtD//jSVdGDNI23N4em2U0idbXIAsWqw5iNIJCnkxojcazL+DxNNm1oYTV16fLHJ4kaxviuTlbzJZtqK5eA9IrMl9uu+6n7bHNH8JVrR1HsuwzG+NHuv9xedLN1N1i9YXG2s+RnCTux1cJza8Ok8SrOdeDdfG/RA1DK3v5prS6xzSzxjznhUTfJ0zQWmcQkV4knMs0Q/EYPtfBmEUZE352PZB5iZPYiKIzeZxUNGp6WUt4FQvSWEbLB/IZXpN2ESjtmdNwwCnzdiAlMyyv6phOnUPswyHMu/+8LiVQXbf3rD5a7izYQEDxTtvWFnll87mguRmZ5aETCrMDGIPwi1MO3orvBilWh3YXFwcXdaICeQ8RoCKSCwf0bzpFdUjzCRs6nmD7Iuw/sc8nYTovtMvhrnMo7v/uCN2Z7LMD2XWXHJz+qiYc/HHXSRtJTdqvvq1knuECkYkpVMhhhGVL7L/RPHH8iB+LIckTv/WwM6zUpyX5bKg6mPAUdmBMZttE+MgF4EQQoFg4NRWNopFn0C37doYjzShQ7Oa/hgVTzVRFdOKVV1VBhe/XI0weF3DEPs2Cc9UUJTIdoNbKn51YQT4o+7+6cRaO45vjewJTXR79UWKopdV6byQSPM3UWNLulmZheUX7POBxJE35WcKTBwcSFPXPAdrus9COHk6NuEPlJ8RYYNUXrtVBYblp0OsKsmTJbD7gIGlh9NfPEJPSrDvPgcF/3uOytUKUZDKGbXwkGcaNJv99d+yANb5FmAixvVVLMt5y+2waUd4tMLAfripXBrQNjFQkaVgLyJN/JheLZzIZbUrLZg6akz//kZJ3/ek302TJpgwctyqsruK6068WGETj5ziwjHPzsc8zadMgC8wGptS44HXBRw4k249PXf0MewA4xUHKgzyfdPepvFSFzLiUlfQnP1q6qgJw6LhcUuWGJy6oNVTb1Zo5RBZpceixqZMqfJUzKcAv42tJuusE/6/dAgxK5HNVj08x41jVhGQEnA1DE37Ih7qdILb9U8a35zR6AUD2mLqYwQqQ3KHcXt7LFgBh7QfpZPTLDebPLcbF9tjEARWA14p2lYE8jVRqwmGgY9dldeU=
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