lpqg2GEQ5DE80jJHuRtw1LNDjJVh8yUUn5ElDZKQhi1AeEVmegOhfONAPGVe/s1i4cWHmh72bJRAUoz0HV35ZwcT8J1GXUBhkKTB37S8EmIe0XgGqKBJBrgzrwLn4lTy9aGQhwMcUL3VdzxGNaPisiKQLzwsXnB5Jq1d+x5jOzFYp0N7hJQ/FMLeq+EwqmATHZdAUDaOWlgbsfWw+WVvAvEYRT+Ixok9nP6Y4ZdgbzXvYMhfloyjPsNNNupX+ih5q7usy8VQIidW+7eEC206xk9f/hBpImTlCx1nRaVw058znfm6F81yL3KPUd4+Yw3jGId++DhtJKPkFJHdmFu+2VV5r/nc2KK1hZX8CpcvPXs9Lue4TWlyJ2nrkAuPXJmgOcxHw6AeiN6+OkbX1gaVQ8WADMxp1GsPvk3eSUJ0w5uRFMWi1ma7Hs7xjBlEBTL+ym7Z3UWUo2J1wm3BjVfBkdXxvdgoaOXWfkOHyeNnIXI2iSWyXkUOteN8vEUHZM8Wd4hOUBenFFtBwpd1w9qgmMDzCGh2sekrCAO9yFTuTHWxPDS7FsnMH6PdK0gHGCnJ8Qx7Esfa7WU1jmMvbFy5iYQDKfsXOALD/2DJ1WvAkmqiIapD7D4ol0J3HnLIARqSxJBpw4eKq6A188UbwIiwrpTYyjvzrYhK8fyBok6qPRQd2Jj5FAErVJpWdakYGaSn9zQ1WDAChE7yLaikp+OqNYLjkhVnSRrZmNafeK3IeyGk9PjikApYCopZO4iBPVDqN3nCbud5TgLxCrDASxDjZHHNr8fsabgK99PwJm6aTbMRgQJZpFyzFtKbTp+xs2jm22f37UhyILryMhCvsRKmYvykjctBpos2mpU0wPYs4/eWGxoHkZZZASiZp/Tqmd20nMfn2Cj3/Zp8qwB/JtSSCKxP6wKUoAS1W4B+bFebMHNH91TxgiTa8+K9IxMnI172AUdamIr7Jt223PP+OjWgZNjnzx7lfCu6xvmdYUMC0Qp0sTY0fnXiPOzEt7GlZkI4k7t8ak9rdpWjyR5hjxyyJUgMQn9E/GDUvySLOeDteDu2PUjvEcIXISuSd1/rbxCqhdGGf5h7OaVStQRUazvF7vpsCz6Po3aMFvOLJUEoCvevZLYc+O0orwJnWIPBVKoVHUO6uAykvyGDppfaNsW5Tnccq3zGfLf6Ck3WMV918SP+OyGOgj54x/jVTXyXrdDXH1oDoCqt+OeI1Bx7XFwR66A1hPDpEESLXWEZgbUFJoKy+Zf+3dmUvGhcZDMQ/nQff4gcQ4QMYp4iDvxtue0RRNNTiLU6cJQSGgR9ulNBEYKixw2IKEjjLliL/CJq8bYNxtlnj+Elkf68EvPy0iGMVAS0JbD08oRhvYQ/HRk=
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