4V4VOS2xG5aXGnn6EmBNwO5AmOD6vm4PZ2RT7qxQlcwbJ39CjB7CUFGyeWuPwsVwwGi64KeuOwNspaYCckOMA3I1gdESm3mpTWJsz9VHQmBLrCbG3mxGU8SAjCtwVr5XVTSvSeD4qOQ+trL2OUG467XXfJLLbLZsfA+3pulnKUZTw07BUhYQEO1aS++IgLlJO3GoQC6/yVoalGvhG/0mvqjbRmJ5I5dWZYUjxidaU8IcqCg1oa4TuiW/toGbjU6H7SfTAwwF/YyONOu8r+HPdEh5DkNpxaLj6fDNICU+5dRNuI8yKEdSCZppsEwMLdSf5ei4ob918x8pGqnrH696zKDaxX4AZ5kKtFp+ebc7K28kWCqEi13vCWciaW0Ilvce0LmYMDhs977hymUgKU5cat3wjqCNt2bs3GIYl7aMgVA9DHSwJh26z0v6oamac8paSdDUp8mfVa72DAgDk0jq6kiJpwHsMdyTWME2dAi8naXiAL5rLGHz7EuAaXLiC0S1UsuDyCYo9MlAr0GDAI8u22hpi/Ix8uDAVWoIHda5LH4NI/A6OzxxGJ2zKJLHDZzips26U1wi/ZeV1gG5khKDeVmqM9ReHNj/usHcKBaDPL2Ah83QE1XKRYoKiAZQ0EfNPQTIoZVPMVexpmn8GGGEx6x9X4o6pixCGqf5uPsSQoM6tbUlAz18gjegYBOBOBIV4JrwGlO5bpsZQlbJeJzDvWOzBZGyva86MvvkHMwhA2Rg5E0yU+JcrySDpvbZJZvnGek3NEQrkgSe3PH9Dsh0aluxMQKWlRe/5FYGa+gXEfJMI/sz3Sxsr6YgjO9n1vD4qYfOfHj+1hSfefZlftlEMasEAHCawdjya6som5gQw011ch/gccJZWNNDT8MEo6cqaI03hSZACv8SpRrAY/8nHYxPl0XMHC7/+S/sQHxf3P8z/eihO/HCZg9y3eihjNkwoAljAb32ci7cUs7ijuk5xE2oVHwfkVdUARLuy25kLkZ1UJgL/OIGiP6HOdkIGF2cTQVsI6pyPRh+bYrAMtUQhsOrqbUR0n6r4P7JZzUyKyHmP8R/qowyjj93IyKlyAMxakPLDVCVZnQpbHvts6VdTzJ5xOMFXDn4iKsrnc9XB8LKez59CxuxK8X/TuDszHCIKa/8OHHDt481oDTKr+W7E16+poCoAzFGDZwxnq5vWjrMNOOOhVcqt8/pLJajr1xRh3G8qtxV9y2an3reU/4J/9YivmOgnUTBiMbvAkPX24VVDv+0tRU09Xf7l7ruQQutXhio1g+YTwUgJZGGBWe4onnGfPJW3thEVzrIs+sm7Z7u0/z/UcNXamms4mZ5w+M3P21nxmpVc+OwBM0ytputa8AOQBAPQBM/EuigaCo=
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