PQv3pTI3By2tJaJq5hDBd5JkNoQu9Ohly/fvLHnw8cO8ch1JCFleAArCDWwWKBoLBYe6T2o3strdPEMq8xo19015zC+/3lF5SSW+qfm2w675E1b8Zz4J2fAN8mwHzd1Xe4VC6T0/gpPXsg49jnhLGH4mty3F+GQPsxoqSaK7kGhYfXJsaSzmuV1Qe8GbvCoQrojR1Ri5u1SYXDI9I/GW4IHKPaP/4VM19qHOmujUP8loZATQl+ZKrEHqbZtKeQyUvlpaOysDdNasvSL4VuXC/0S+SWHomwlSCFZbQOptLw6NWD1U2KyNaKZD+PQfsenthvoXyTsm+AcbyChb9Uijy4+a43Vu+OKENeWGV5z7vwzslpEz8nlvqnigTNxzDim2mcGmSOq9waVQLGpUaDUMeDDX06hBkjNjSBVeHkJN0QnLbxLDa4vUWtU54dBREAwluLEC0CubzguObMuuv4Y0odfW0XR0Q+xOTJ370KNw1ZbXUIrUOQ/UYhxPNABJaMPOKgcRr8zD8NbrqWHfOrswGPRH/1NmgrJRoxvRbzjbIWhWZox43XUHv1RByBimZQqYraZlXcsvKihKtm2fSz/qqMXu0iRcg1zgSHLh1zbtCXSqJKJ3xOxWdYGiF615OaFQEgd5ET6VLYdnOefI7IMA6c0OVUKmmfBYuH6ph8MG+peJ4IWgZGkBDd1vmBNVnIS1rOHZzk+uPw2Ii+71dvTW+gbb2/Kv5ln1HVy74cPdNDSmRd43Jc+ZKEHPfLGK4JIK5KotUjFY1cgHBqEuPspAlg3qKwPVDWQmZRqFmbgsfLnwgzC9YW3fTzYBYoi0fCECB5rtSJZECgA+Od8zRa/S3x2PAxFZkSeEjevpUOVbouG42/heHJHWu7idpx39GvwNnaD+YXJf0WV3WyIyT9T8M/ZUvv3LSoBlfdjKCCpJQniCqctk8MYdzsqFPBwL8QAi+1omiLTJm3F8xrLa4CeCdRf+38V/gncC5GyhIlDKYpUV4ItFvXNsSeITSF3DhPpvRCYyghlRjEMAZE0gKmPP3aqtji/DqrWph0vL71BxER0uUhrXEdIYHbR8/OaZVJpeosE7JxvoVkBbIivYZ3D5rjjnx4X1YUkuQtlkzBJrl2nTrAiecF3C/Xa9iLhgWrZtRodV6O12d56POnfbpWq0QuMFzuap+CKqwsgrnDJZX5Fpu4x3LPqNXw+vVoGFLmV7pcyhgnxS3dDRTIhRNPyvTNO0GkvkpQITSNr4kLlF6wRYks8ITRjqJntc5he4Rtrh+aj4hVeAJjdFMv4HSP0ilIU4rxtIUp/mRzUvkoRMKCx3yhPdYtS575B2kFqMEKyJM8EuS8+tt5g5L6npgA6v4hGJaA+qKekVrX9+hKM=
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