0E5gqZCTk/f7HXv+SL1OQ2/FCLumhLlpoxIoIv2jzCivdj10zq+ns4wqPF11YGvUuT4bMABMqObfxZXwyHLSLV9Il6TJh9vFjTCTdHeSK40QmaEjnfrtOioWxVlAnKN6KUsD+JiJ+qG6o4x3m/AOUgAoSXGTJGTLccjzzG1xfHkv9ZLLeG3zCAy834Bt5F0HDOIc8B/YI9M95lEjzYQtPSd5XqUwPyIsx2OXXVRvRmQT2yZu0+QP3LjbL5cEAd3ooXaUwCjiYHUfh3kXe3yS93BVKivTlnpEr6eEP2L+goILkZD2WEOZmFbUR8R/MeK9glVvs44vAhDITQ7P0wpancyL8EbQWcJrSTmFXjRtrfbs372raecS+tyi8jYpim29gy58PtI4+uBdeQZli8b75kCk0uXHwXDI68VoWsOJ5HE2fCL0ldF3ooAc5a6fdUEhw7ZeEFcPt6FE4oYN3C/t9ejzZ/oj80dQH9vybgPelXMNEGAq43qbF1WP4YFFHQB1SJizi+vTfXdMdjADyMVgNGvkj0OkGeWyyCYFQ6JU2etpv71jgIgy8LiFq9goYkVio8Q+1YTCqIcWXvJK74gOeg5utglxbRf2t+PBmixzeBNRWBgvDKFD0+VOYAUI3N1tWyd3jA811uWL2qk49dgc5/aYKGlLcKDqooDBHDu+GN9sXVb+hS4/V5F9pbOC9Xs0UK4DOPfIusXc3PCw1SVyxpI+TfevpqUz1TID+ToqXphTg6e5fyQGzkyFhxknO6jCHqnpj/hucycPI4S0kfirZGLa2nRD/f3BBduNbhrV7bNYqUIOFKikL3uBF8wUANAR3PNE8ZuPb0cJmKDafpSY8olLX11eQGhGRbYfISN+cq1q900i9PEyHMnISAHcZKA9EGPDRf9Brm6RbGOxR9EveY1AW9c5aGhqgXNhRrn/B3ANoVM1Mb2W05NpOkEwy9aanVy6QythT2EUfXaDZHce9RketEhWu2ftNGJW47Q0QCKEKhuK/mKW7gynPD0TSF8KDQhU6aWmJ1QGNmioS+RzmQ7g3f5eIwL+VUPx+fq5G2G1l1M9mnE7dwt6W0o73ZmoCjhGabeDW7ho2WZ4kCBkgm6lReWmEbVTqNUMmq9EErmsJvFR58GXnxoueHyPpUBKEP+vE3Q5fErT1yI4wn4BlY0avjaTd3lHAgWeAQEH5AgxkXiOlOsrkTcP9L4D5KNZy/2/nw3h5rKdxKC2hXRrNBBA63u6t70bn77s2ZeJWRFeCHOFXoLiKjdjhV5tREw6ULl5Jergkv/ud42Pv/mfkT+Lrddxv1pzmvfmZyD+G0GzZeTyZqHaZ5/9Hd5M2ggSqpm0vbCdq+5zbk6df7qUuMT9YPToLtBQUaLEW9w=
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