Xbs5s7qbSxWO7kszoorLTeJ4UZYXcKmZdvnvLNFzQkyUz+3EgEHFKNJsk3Ofv+mnMnXFz2/GnjJvycd2elygI0E5rz572Li9IUGnkzYqMKeXXHGjVrw4jxSrh4k5Hoznr1Q/eN4H/FOBi07N+86/ih/bcYxhcCVd1IoHXEqQcTRWqeg24thgf7Tcgha+GiVAthcg/ZcWJk+uHcPxtXab56IUapSZwQb5DvZULBoi6V4tRul/MvYQYJa8wUuIfx1LwutFbljDLwWBGkxHOI+3WRyMvkxb2K+yOj4vO4ReizTw8vzBF0JG/UaezoMmzghuAxLHmZhFGtQPjd11jytP8AqnSi1XWopohaAD5tTL928Gii9Tu4GgRvUb7hwMxQjcomPZhu7qz1erpptprK23r6AbfKJbNpPYNNF7XOhnd7s/aECohP3CYuKyyVVL897HnfbfUOour3MnOvV2RfjWL2+K2C0ybSxW38+3YtP3O3MZOhufMVcZyJFVRE+L02Aaa5qTWj9a/J9aR0C6F+QFa1NOhIUZZjiCUXvbF0dpt5kTkqVGRvZkEyxtKdJyoNHQd1SmDLDTOOlZKKgc+V7sHeUzcTMZkWpx0KR/lawpS/4JPw2q3Mx4f28TkVsmCGctngTPwmN3VrPuzkM5D0sNDx8VM0wdls9226z6bEd4ZrEXyZo+acELXmXXjiaqhAhmSaOnXYuz5hjaUFviDOypScXQgnyJ2jSOg3eUAzVWtEponQEnqPPKO1Of3OiFhGQt/LtSF6R1ry/JDVml50kgk5XsPNmXlyAf3quVV3CZ3mC7oHXPBLOmgzxa947/mcPiMitCkObcy0fJAUoQUq7x4goDyfXX9+osklZLSuht647ovQm7e6fZ4zLVCIpkiUSsZ36cTLg0aGXjpjF9PNIgDvXPhjbK9tGORnUGlCfp9E4JEmbaxwfoUFaVDgSYGTRdBUyoDFvhF1pR+yqcgABLghrR4A+v9+LlDUeN5neINbmiouWKNSC0aPBnYsz/JtC6wCyEuPhwinjePJGiOwvzlRz8vmk7S0xBwLThDFyRroroEIURel2LQWvy2hDhWt8m/pDAL1DHaMpbxmmCGGKiCgn33VLn8/C1BwnDQNxkuQfx/TnOut88WBtNOM3c2Wd6jQ/IFkGf/FEoi3JBzV9YXw87c3v9KM77uSw+NvelK9qOy08i0HyxAkejvK7YD/oModhWf8w0u6G7whMkSzFQKM11gqirWAKvp9ATHhRK1P0pB8WBMuNaacOHxKqywX8qbziCELb3+Gne2XvM3KWeAkkoe4VrPXa2Trhr6pAdj+xRyIU+dQSPT0sjG4j17pYRkP14Vs03ojPA59U8EIeJ89AacSumhxMabJHOIAg=
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