/BVCJKXFyTjyIKUp1lGIWD+zTTBNMxQSuRqhajldaJIdE/TxD4a21Hee+ObtIzWBCQ71AFPkLCS816Xy3RXSpo+1zhVpcW11prdrJzYBm3t6BA/g4lIfS3c+Q6s59B7o80ia15ewzuRafsyba59dIc5VmU2BwkY+/owEMLVpVjPJXsje/5ERaFnZAfXHEHWqcCRkUaTFUmNf2aChXeMHcb/OdmtMWg02H2bU6bgE1mE5RLEBmwlsTRSbYRnKKmaF6GvrsNw9j/lcSzOs0NYnBIoBygJ+n90hZCnKnLkwQuF7UP0yNb5M44z/fLQMBiQboJBjmZT0kaJneDWSlUXQq++dh+g90wn8HVSXONZo5/tYCcWS7/fZ4dw3hgG39PG9Sma/J6T4ob3FE5kWMHje7tg6l/Up93qegxoBIhDET+Xr1OF5q0vBZfjmA9K0Ii0OMih5P6J+QR3k6E88siS7N/BpQdtNQHgptNKNniS5/IDfAwlsS/VkMCTBIkQl+gPoi5hZjvoH20JjnX5fxr2jGRTcE+e2+QRs1S9nS/e1WsyXARD2PlixTsv0fp+78IdrpXsXEBv02WA45c5p9E67+mejyLARaGHrIn98BHkk9rJmPSjepErdFKWooBkWDMMFfamMI10URaP8GGkrgux8k8OjRijQmn0/zEQPNWmeC5xc2rf9d8TVan+EJquJcyofTM9veEo9vbUpl9TSH1kuDo695nrCijJEYI2sU8wV1EZeMghCywrcRqQglM9hLi5RHu21vXgfFowKKwpw05dHrousuM1lWLFkI7YnrHiuhCA9jhRwgbJzo7PM4Xll9W0rqg0CB9IRolZ8y/j1JHkDFyF0e9MGf93G5Cu3IT2ZaVssOOyCt0cC/vXGYUwmApH/9UB046u3vtxG+qPQh7vDtKBsEa3VeklP4GFwXEAjIHiVZ39+8XlGpjmFJjnDXQFiJgZSc6urz6X2qdBGhHn0zXqEX/Tt3P7YdTLwzpGOmYJtS6huTiBBwO+AlWgQP6y940HXpbNxJdaGl8OFRomdtkZi6WZ/+TizawG7l5xRWO8PbnKsmpWJQ98fqVXmUKzqqR8MKQN0l9oSCHoExMRee248UsFI/ylOHD2NgJkLdVv0A5lecuIjuggwrS0r2qQilsXqoSF19+IWjKoXC4a3sJfHRi7IFa0lkJk+nGV43yx7NcTurUR2Kdp1t6L4haROOy/hPR30Fjw9FOnL5cFjjtbUFRCABpdxd5/Se385bhm+8qWUPXs6jNDtlbDRDkwgmaPPdEHyUbXCbMBVqPXNSTnFPUBv3heyu73fvbak9l10ow2z1DcMd01KyTfuoznn0gU1oqIwe/+Il0M7Z2kXQ2feiF/GvQXn69FJm70=
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