fXQa5aOgSFh6h/ITdGjaI6+jbGcNV6MSih5/B7UNbl9MxxrZluAHqiPOlGUu3UBn4pHe4q7hVgFkRt8gnE+YEX+dTiH6kjk7c0l6CRyxLqf6gixxH9NKWkTyjJT1qvcTM4645Rqz3qFl0zMDxqUULB24jzZPo5Ufhw91FBRFOWVv3XLHxoVZrFsiMUy4LHXoZAPwlZf87uJwbrSmccTSVzP+SqaWs5d83DlzHCUjXefdcwzaQ8e25kn2VHah0HsXwCrLM3HlFw521FgNuisW0LVWdmDusgAtHef/DeKcz7x/WmQfM7paa/6pYfwwvTYh84aYyFThFCIoNo+rk0Go8S2/sn4JrqnvdpNSLR5gCIhaGDeJQp2Yk4M5LNDyNjpDMlxLCN6AwBFpuGihV/VPL6qlhBUVpjf5EvdTiEdta69+8bzMXBKiiGto2h0SCLLrle/XJmKP/x+qZudjBLJmCaDMnowcC+GIcP7OTeYwRfj/91HyLqLgjhd90ExjclcCH4JQYr9aAVIUdLD7ZnnqQCJ48Lg+dTPn26p9c6nsHuKh8uVrUzpztcMaxr6A6stwUMb35SCsglHp0g/Uq1xkV8g4qq1wrcFJRFHwYgli492OqgOIN4NgnQmcGPVypxxkn+FibZ8XYYqaqCw0OAghkwGbeBu2eHlc4SL9kG23S73GHi9VNaei7tZDtWRQPqn5yVkb70h3FzVx705fJWDB2fQkzAJEVYKPLJ4CGh+KVVdqV0LMqBhHg/lNdkOMZhnGh5QTZ3smVNWQiat6mXRmpZ79hnqxl+5nBCF1QehzXagYTU12gKMkRIZn53ixzOT+9WkC32YERXOqzXcrHV3w+UOLkAZeH8T2iSlPzHgMp9kHm08e2jJnOEzu4FG8WJw7ZeZ1HtYVq/RYTnpf/ATLKUX++6m9DwlLWOdGpNRXpbvqwWkjf3EKwwK5UKcdfnETyRL2lIqdsYlJfNPFSAk12NPXDxIf/wfjnq3Mh+TEQdI8nkQIVqY/oXRLGDXHAOZIWR0C350XxuFrtRpXcI+DlheeDOkcCrqP4JQkylkfuwJkz6m/6aoSqpiGNirgAk7ZJ8dl8xDRMwUuhdxVuKF6t4fqsr18jO3eZJTFVjkAnd8SRc8vqt5RRMzUkiGXtGJ1KdOOZ/jZQQOafGH9HOMODLxXctbHzq10hHB+I3aFkKsKOWU+EGxEY8buB5r0ejpvWhXybVHqDrO1VYhlzxJJzz2mOf2+zNvv3wMJnV5VzaAcwe+oDOwh9R3/RauyH0iHK4K1bfrCjan/iVVhQSX2WIcX21n4IOW+ILG7vyCQRvMwOXHW6vinaOFy+K4NPO0hzcqvSid4fSxFU8IiEx6t01viNR0xJ73iaDxfrHA=
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