3sjSPWWbl+4aOJnSoU0zvJj8gLKbW3zGytWtdH+kZiTJ7OmJlADKX+ISP35x84tXbu0Yz9ezd9nHpXLaNFqgNcR/f0DDGimeRj3V8L9SNbszNojraC4XzG+qVJNQEWEueRv7enfzlsnJymwy9WM60/8EtNjrx3BWAEAWiMMTd2m31T6+GDssHyrVBFqcxB+FVv+pPE9507VfHj2XwQEI1Dl1KftKHmuJ3YIv9wIQJKthRTbcPd345kz0vUK1SteGndwLScQsHQRuMdAulfvcYLPvLWS8F9oBuVJRHR5hKTi3iK8LhZ+Eilt01ypcSdDvFVQFVSjpiDbPjkNy9YNoR510E0Tx/XJMssrDty3ej+Z6NdVptM5FCLuZy32w9jh3A1hgVu8qkbanTDNTpvtu1N3oCm/ZrhYKHXwk55YO4Z7ngAiSQInEpljV0f4XVU8dWWgYRjOLR2KIRiMvCjqz5UAZ3SoqicCOlTcgOwBTsjhWfHXagvTCB4sKTaLhnhag5erkHeqHGysfHX6ngOTlEfJQupfH5juXLO8it2wrP12QX/KGYa1HPiYJddo9YV26SmS/aiZAXKaHR/WoItTQzYkzNlgjSpRKBc05yAi4LpXL7hBJPWVNzBJh9a+aMNMB8Ic2++LZy88iyp1PiY4hqTV91pIZr1JjdSjSPrCod1Nrur+4C9RZ8h3FYC1KT10DshKumTpWR0PHpSRZj/33cmkwTmffSUbwzSQ6XBmz3hyZjx/NUsl90/3RSeiSm8rmkRKXnJ/mx5EoB4RICMstOep3c0LEF3NVGdl9owGhUfywLo978MhxtmDEvq3iI/Asl7QjQuYwcV9oXGlXYwXCq4CeePEuZPC+hNQYpQptjtCs8U42dyIELEHfuZ4+Yb+E+JKanbzbKinKBEWzaFKEkROHgqhPLJEJwWNPyN2+IL+BykCH5WM9BbXelehjXhBjbAFgXyQj3CpgMtV2AhlbOfU17yhK2bDPrvV88B73tq3m7HLe85Gi5zI3LZOh6EiTt/O/gYqx9SYfxtZ3CVE4/+Qn6EXt1TexEeqKfzzHe1VfpV1b64ika8bCE7aLq2efGhC/3Q+e19ac5nNEXKJ2A5cOYr2JgouQa+6T+HOTyVMwx4x3arLX9Eg54W2H/nk4Cl3KUmcG4g5BYjs9jfzHnNZJcfBbGL1/5KHO0bGBMdFGt/dY1Va/cusSJiTycwrm7dYKRb7V1gWqX1dC6N8231oCQENKm0ePXGDIUEDd4DbhWc6MvO4E0U5RNW/AV+iFBuvhemiyONm972AOD6NwiGSr+ZTTAQkK6rd+EKPPf56JN71kk6P/82W2UFjXWcWV+WpuGstjhAF2PCGQieEQo0/9Ci02FlODRkCO2/k=
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