TNWXNZP83ZDPoyWvOmpVbqdoeClPprheM4QQTaDAHOk8kVOE/hC7meHB2HElHVyi7inGlveQtS/2ParuihGPpiu4/Zm4NVh+/oKjy9rryAxFZuWHtyg68tCk4s/M/z40XSPrcOHD3BeOcuTkWPlAdKkpDGEyLi7GCG5Duf0RNOIXqsGpfiGynY1IPWk05bTWTivVz3PQQT6EG02jNi15//JoBMOLsDYN/qmiOEWtxZ5z8DO6Teiyj36sQ3EUD/E8WMgNca0eN3Ud9Hw4mvY7fr4H2AhjRM/hzamibFMstMM1VBhWFLDkh/MXn9UzQ3N2lCnrLEzoa52h7w7Vjzb04khxK7Nq8qPDdfbhNyRq/hRl6W/b2D1+CmUlUuKziiMQ9/B5EOnlXBFN+/Zoapa4sTGht2Mb3qw0v+Iid4CH5a00KBrhpwW0LN5LzR3GUb6bE5lHcpYgZc8fVTpOFXb4jV7mf7O7ECV+c9f4A3xbb96a8v5+wtEnEF957g/8mdTNuPQ2kTx+YwY+px4hJ2ldssB3Qid4IrtsqSrKdx/brwM8Dn882Fl9FnZQk7nnhZv3qlRwO21WncuTKr4fEUSvSDIW+4HAOzkcpwYz43QDiFpQQ0PSaBqCV2dMbEPrrqTu5b3jy50nY25TG4oMmBwaLSVap3vj4CGt7azitHCZ0rS4eiLqcWnONfcOWxY5MQOzVsuDuXhL7tsjsSOvcHlH6x15QGdeRHNTJEaPhMiZNuvMceeq+XjukK0WMqknGXZnFai9Bkm/OW8cW2wkjR+trdBtxh+G2pINXmOQxxh4Uv+7LTbaCBwa5juFiGQJyyn94OgJO7UcHWpnNkzAoDAxfL1B47Gu/N1Nyt+aI+bjpn2NTPOsdQUz1+cOfieCYgNUETp0YEg9bMc6koPEWvk7k2TDtSd2WU3CyENsO2UKExHT/GBRhIhoG1uXMwMwEIKGNBSomQDAX5/t9IPvlBaLwU2a6/LujQkqXWOes/Gk0m1D5+gedBaZQgaNjhjyTGLgD2XEoklOIq8oLxXZUI/dWy3fpYseeiGvQCjEJuCMed8M5j+OuwNaC26wCpt0fzvtdmWEm0lLacFaSnOJl43C20dfrBjrUiqwLr1fp/KDJDeQQiQ4OelSCcuUdOjxYuxvxSXvsqWBj64yigQEiAODiNvAvX2Ukbm3rVVd6Lk/vXpjMHm56oDwCup+RsdtbvBx+svMmSB+9oqkdUkYHblPy5NyEKjQpLyrLclEsBH14dpJWPUL+k+nsWnKqkSq/XRPk38c/VSqhwdqS3XZ3oWAspaIWmOCNajVyGEK0qPUyTgx+tpv9AEHPT/sbsn2yk0vPE3auq8gjYeFkaSlb9nCYLYtNPKIoY1l2BuE7mA=
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