DdA4VsmbpiwyS+2KPDxa/qSkV374LZrl5BPWx8DyTTg+vxekjVdq7EfdbGql1QnzrTfkxWQ/EH5732uxNxKJu0Dhdk/7UFHqVtUCE6quCwunLvLWyuI9PBahFfE1vNT2tMMe/zs7PaJjtpBaFD+eL0hGlb/mADvXwtILaeL9A/L2f28sY83OzXeIWsUHFfXRGBuyb4y/SP20kATlyl66DWvK8OZzzb2Pi3mZ5eBbSu8oGfMWkiHoqYmIU4UXd6x7q7LVxybnDsJvgoz8eSWOMXJ2WBILYULMz1aiKvXjIh69uycFiHkmPuAEnuuflMGBIwyYAQCOy5+d7WdO/pbGVoM3BjeXouXEh0XQpOzfVbGBMz0o9sTG0Z9zVX6GzKGOIQNLMi+FKVwtOwTC9CZZxSm3SFaKPuzfBeO67nznzUFjA0hukPSqhaUzXrDWQzkeii7kU94sRHlrgIDpVYBW5OCi6l+8eTbriWd75e3XtTCKxQG5teCHhV+TLsE3IoaqvJe7CfmJvs65g3PeQnE/Iy+YWLFu9C5+y5TLqKcfMYRjHaZw/UnA0+VOe/yksV/87eBPOEGKQrl8fSb7bqCBKQMiBllEC2jFPN+QiDJXj3mLYycbhmopDAG7ffezZsOD4oUqYQgKejWKwVk83SFUgiC14GIOeIHoz8T4LtZthKw3csIwh/YOBIaLijklkKU5CRzheZl27dzF5gkuyXp6fDK264zxXpjPS8KBDYBUmoFMqsaVR/5fwyzftoBp0oyW/aY4jDxAaZVpmEKg85fU2VkkdH9dashBhm7HcmSINlS4zSSpJ6bHfHk3mUUNq66Oynya98Dpc52kAnOA8irD7vFlA33gHjM0PmP+uZXx7y0o3hTSUbyVnszRMQkZkozCmeP+yIbmwfQHWS5OAY6ZK1+gBrbHSKo1dECFkZuEPhtsQ4aYcV4h4qda8zD8KmSjC88+mkRJDnWSgdzr2lAfR4Dvy48HyKXgeFf7UZM1EoFKBhhap3F5faVvt21Gb/Q/TF0r/Yt1McRkxsN8PQO48EpKRWRxk3cZTQDplEX0gaQddTwtXat2YQoZa5AWEBhZfXUhvTCZo+g5DIa2NcGfBooF+rBfdHtB8mMmB6jVH8YECixMl+nHUtX6HnzUxF46FbYvtNCDwUHK4+nDoWP4u8TW7oQNXGpqg/RGUBlxgIPyRj12g3O2POeJF4bNnzQ/44bOqtCPdjQz0G6xDIPRyz3QlkO8urjT1sikGm3VWvp1wB1LBgDr6GpM1x/Jmh/AMlqxcTStW/Ys57KRe+KY03+ByaSI5ovprs+3oTSBHXArpI4G101a/pzU7hJujH06GXIKx0A+DRGMIRtEf64/gy16zHQe07H/mFOQwPQ=
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