9SjVN3RgdRR5NpVvTZM46zGV1DLwC9WwSNBJ0id5yv7sGCd7zQPX0uuIUEC0vuQSwhbvqXUa6ijo5FWu98wXKO11/Topj8Hxq1OhYiEti7EXUwbn7BVOgTt50Br6b3BXtmVo2PfAWyj7tMbAsyhlReFK8O3R8T7WvjGvumV+KbBkmiZ+Tl1AZhG5z6wY6BUG/G4W+e2NvE/Vq9WDbRMeA1w70rlY6YZZ7LKgYUIhS5eLr5v6P4MI6HBw7eN9ZGG4GuOKCJ7I4z2xBHmivSOxB/Txzz9Vd/lqsrUgc/EMkzxCitnkJ9sn5TlI4vFkH4+m7EpIquoVe3TvwBBBxxiaDqIZpiIdK3OlBbvxI+O6WQDbvX+YgnyCRCTgT1LBL2FZkiKGhqU8lXzUXBlio5vGcNiP76ObwWiKKiTGNraUm0SOja0SbE9/hRVH2Dx0xxDo9wEV9hA0D8uApxY1nArwGhnZxCnT8SnjzOFbIsLy7VKyFAia6EBvBnOPe1ba3M5UwIqD2hqySdoNassIQ9xiWKQk/grDGyLeih9rU1nRqSZbQ8sKqhgJ0KWYXRJ4kaYjLWZ68gh+ameevcW4E0FgXIeUIVMwU65BC6dpChgeX3EgluQ3tWPuNks9Htuh3Jx2zWi4zCJhFJVFVDDt+dNo7Zu1CFz6iKXWyi3Ax7sLbF3kpiYyNvBidK18b4L0JNCFD2nPRkBrHR/lmzEZEi0bK3wQbu2u38AuZkKegWjNLHXrIxDXaViE4YGFmGp+7O2Jxwkrvyw5E25OclfFSqdDPlmmTNEIKicxTdP2Ht3xZE5junLis0NZoyLYP6HTmFHTOAbG0XolFH5zdzRoa6EBrG9dYd6ZlLykQRYOrzFbsgyuOqIPuyMqP1pLlbJthwmrcYtlh6iNVfO1Qqs6iLGcLGgyqecNQEaePyKFAzgKlqRWnqBtks3ofUm9ZzhO8ZgIzfXbQkkmBpkcKFhly64zrPKM62Huz14/P8m9cWRKgM+4NP2162VCduhW1SvskElw/xIghQE3w3E5VL3XNeU766cwm+oCXQbso6zpGmmn60UaYyvtPmnQGchw9R6Uca5kaVuGoBtfx5GcDH+kG27wVKXBLWCRxOV3A9aVsQKWhjjONLWVRKuAZ7bSkpraUQtQnMgaWokfgrxJAPYWr/qQod+ao1vWaTFjOfw6K6jhQSoA5jM/vtWEP9D4oe4qMR1eXVqeZqFi4hZgTbLTkvREMdNsBnl/bu9wQZUzY+Izfvlc1kqOPXIMuyfDvFAAFb9EYdGWSFnpcrT4tx33dtxZfo7Wlq94sJ7GCf7vKezGfEq/jmLQgDpON2CxbDl1vHU1J4sHYq2pw58ZsbRVh2V1vshbXtSmOa7GXj2vjhU=
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