aoDXKhoTeOKDCvzGRzh+uyEcgB7Jlsx/EPYgbc5lMvYtu2dcIbLnZul2merECbGJVQq5l8ENigg32pYdCFD27PV04CqKQfMm6ZI78hfHG6LcAun6i4TjjaIHDkNNo8Co43jYAaHRBGsulER7vD4hJAdqMl8HDuNI0C8T8njAt/v4wPbFS8/qZOcqCsc1Gi26X7Pvu5vx+hnc0i6R4MflD8AIilnIDv67+HHkGmas97DsgBOAihqfvfWs3eimWmlXnBR400V05FRlp4UzQHMkgLq2JL/0BAKWMeYpX7WdRYpH09Jw7P1CsKp7Eryzy3v7SmEc0zBRXYEt5fq8e3hMBK80yUIdDbT4imyQnIkAAUU4EhGPcONVJMIVNrtNNath8g309hmAxDp7fW3fit0K9caZV2bl1klewziJ9ssKGfcElvKvg9hO/WW8axdGp355HWviDoKNlsbMMDTH/L+uXtcLfqbP3c19CWHgBfpXvVbLjTDJk+o8wLLIgxvhA9Ru1t4B+FXaxo8XFpu3D/Cxq8LFHOHWYBhL7hKSEkvb8DBAiftjj2UiUgZD1XAnsn7bXhT8W+pVzik/up4h04S2WrLmO5qAHoeSLuXqh87kLyhI3c7e9Gw2tB87EWmls5cjh9rChS0lEPi7CYLTpsOVlgrKAOoucmw03KcDz8OUkNdvjIg0qZfzx8vuxmk0e6zm3MV4wmGxAsfS0RX6KCWMnmSUKQ0u7BfHnwEfCzyEGTmY7tlBtFTa1l6Yu/BdmQojAeS5J1+TIH6ZxO5os4ZCc+Tu+CKU1f5OiW1SM5VMEbg/GswEk7nFxJ9+CHUGt1OtOK9iRuDz2Rx2fcvbKNeuoPfmN/+sdlNNpvbJHKx0k+4OE6nzJIazmXYY06mSrDn5y7uC/bmU9IuycNg61itdZA1CAvcSuUCS3Cpn0Xr66qAcv8OJJo08jiIT++08GBhjYsrl1Wh1J8kByFfe3WypLeh4LYilZmRS2O8aVtRN7+jL4nZs0PkIrEkua3hJhz+mfEZfEyc0xG/RBdu0Ipx5acYuD1DNFn9d1nOtyWd4pvLmUqLDYdQ4Tw+J5FT6JtHv9SPTWIY0N3aqCozX4Kv+Fzj8+0Wq8Wgt1plgfuiHYkn+hTENhAf1zfFWOVdfICToKd1JRkAlE0cYdUT26wTHDc41eehKuU7axGUpjTuDwa49p79ofiutUIqeXNROICAc+1AzHy9BeMcm1xMVixJdKbxxikRT24gq39SewIa4AZorgkeSUMjHfoP4npL2f4ZB2CbylL1psDa56dupp/pUeadYV93JgrjOoZSwXVuUMOQ8c+diqajs32j6aeilmiY75zyHF/UY6vGtV4x3dkeW6l/uHZ2ZY5VMlDY+mJ4=
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