vh0Fz+lE2yeCKQSWL2l+HBVOx6dvX6+qFjfqssBDf4O/T82XcAQRL27ZJtjceWgHUAQdkxgTwoA24qRTscm2uoY1OWT0565DmkaAzyZZXCsKcFfyW6XS9/cu3/6o/hNK2zIaLbqcyMpr2cEs65TXnhzIdapOlw2ZjST/4mWELGKfjvvRNaQkp9dDNJVw9tJME2AhVpeIbR0b2yx4gg6DZbo3VPrUM4BOrDqaBXAaZWuxzXm8kjSboSnHYEs6Pwg9amDU3D4AREAenFePsx3LL6FNQoxBs3NXuOUPkrtxRtPnzYCNAeCCvqJIKUPq3no1YDRMYTV6JeI3G4v2ASGXmZrh5o7fYYllYYvBVqlvqQmfspxLBZMQPD1fVhQSCx8U0YQRMe5gNfem2OUq1bDhpl8f6w1IHVob7/ZCJfyu/R5oQj0D+lQK3j4xpny4vMSlDtS070LHiWVBrt1lq+mASMYeedUXzPDq4nDG4mV4hDyRH6xG+7UIW3oHXeSiILMACP1dXF3pJWO0dC7mqdpts6VrFP+YEee2wEzrG51t9kUVznYSoOyq44vcaiFPtZG3DPO5wZQTekrLh6aQCrN8HwdKrtv8xiCRMlmXsetv9+NDlr93ZC1NyEUGRwCGiG1Fvu2lB3sChMeIpxynA+YN+OdFCSfBRQ3jI/xq5i3sAIirXw7ZgiUB38c17E0e06w2typQIgC2Z5nIO7aKgsqFCxGOQLIbGWzRYcmxjGvnbah63T2MyMTEV3cQaxtd2bQE8+VHIeFNcrBnyK/ZKtZTLJSZXu3gANKCIZcI4OR1sMX4eTTeFBCH2t+XnHPNdRiFq1i+RV9zzJjJO9UEyDMUSYu1IfOtfa4um/ul7RplYFD4W/XK/TVIHBiiPd2snyrURdY79GLddPOwBUr4Af3sNYTjSKB7V5irvBlyPIV0fmxkHcEXSa4rw7CgX4FRfeDFD7EOVUoFqLuma7nPBLzSoPLGqvMOFBlrUlZBnf5XUVRXECtqqzm1uRYybTL1avds3U7mTTBVlQeQ4B2updIaVjZY33NoGchX8WeHdhCCzpX4ByEWVtGbMm0K8b3TiG5pspcaLF2nCuitsM1GaOTHyQC1Id5hbtg9iWsL5MlgxWbLtQHtQOWaoalXdFPaEP2KuRotEAwdyqvAbsW39BB1uYlxNW0k2UboA4X9I1nag5oaTkjEws6GFa6uP9HAm3GfoDjUzAY4CdxhKmlkKAkl+85ud8MsdU51hn0ZDs/OtGO1X+Mmjd9lZ8u+6HrT9jgusI/yW0qmvFdJXcwRRNv9IR6vVKzBbWz6LKl5xlmkEH34+a3FVJ0RwNZcnOLi7WlW4pEfU9ARILkmO4rS4dXDEKjYb9uzAHp2I2m37PU=
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