zcXTgr+hOqc8PZR58JqbFgBzOP/oIr0RB0hy3v3zGDUajwAa4a8lJvl6K2kyZ9p3OqeGdr9knfF8eDGBH9a5KUkgXv1RRBdkg6wwDpgdlCGVJDJMvuUfX9tQPP5roz6JecTBIi6PJtCc0tfjEzxa+B4sKfmj3Nc6vX/M45Tr9k8SgGtoa1ZJrUaF+tmHxHyQJeZUhm3GzlNH+cdP4rY0Ej/Fw+k28giKgk0n6n8qOUA1J1DtnQl5cO9XvfGJTHhOBmN2OKTVqN5KzFA20NdCgt0etEupDM5WEdbWo4Eu+rr6zu5jy10dv6TovsQD4kOwP90j88nACOT3iKRhCzQAY18mu4QrisyaZf8xJLOd0ktTK6p8e1DSG9TQtE5fNffjFboxTX1LhehOTEAKql9zBEan1yvLDOst76t6LMnQYr05QKdMHsUREYq6CgqG1OR4t013OuklFIpWpDlBBZBJ2NHRBhzzAzdZoA//0ueAjT4lEvGb2fMl9wCX3PSjyaJa166f4JZ1RjeX/8CDv4s4UYvUGojNF/qZOcktUojdyvIlC/QRlhXM3TEH9ZjI5xDr5bTZM8dv0W3rcMEEuvC9i+ch0pOOWNUtnpwbiSAp2Mop1LCmUOmTL8EVP6QfHsdFE/byYS6Mw6Os01vg7yRx3ridiqVDZXo0SV2pRcVkIUXIqp97ZffbR45FIxYwaK0pZMA1uAxJfiGGVJPJNZ0PJIo1Zq2mLHST+46K0hZlKstGHSZf//zOb1JPdCEYI30+HYSVAjk1cocs8NrXX08719Xyq0IV6UURb7Jn6TCozpxq42IQyCan79pPGPlyGjbU3w1mvol9OjIMJ6mIn53wU31zhNL9DM4tZTIeWsqPHH6ihZEHpylTi+wD0ysC3PhDSfM9bUUBbZyr5NJsSbUNAorh81TjwKqBmX2EAOGQMSTkktQpRAd8na1/PX8+ebPKUFs53UvhVDWHbp9GQNNIjU+aJy43GMIl2JWpF61SNknPgpNv4i3X+W7jq9UqviKeUG0TmbiZG+cWjkfSu1BrFmRcCOGK1QaSaqDYc6SHmJreYJh0QtWAVbVvfvU6OyRi//8DPAV3MgVX3SLQk79N37mnopCmgr9AJp561YjZAaZ3SGIJb+tM1MR39+0Xz3yqAdAbpgGuHNESSNd4QrWKzr+34byG7LQaCyozRkoN/drnIrhLmw0cBlXhnVYpRhq6NdYdMfg/D1M/AHQGfhguDIqGYY//wBLCUd++Vpg6EHisAZbi7tYMd+df+JxaMteDW2uEyqUVCzTtPZ+iOF5nrWnLqzK6LD4gfF82qfMb7mymYC0Ypa4vF1bzIiMHBtlA9W3S5Z2ejnJOXRUYY8hQitxz7tADMCpGmloHISw=
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