tWXqcsyA6rP8Zp6+Ned//l88sSA0wb5HeQgl1BLBBkbd13hWNo8bfDfQnkSvhG2CgH4Arrf4CrdGD/VABdm/5a0GhB6TIciFX8juLIzoceP2JkI/5ZLOEAs1ERflXNPhM8Dhi0TuQfrRqqWkUGngvX+9Sm7284JeCAlCFQJuHfnv+0ipwlct2aN0O7gbroA3c+IS5NsPhMPZPYJ0eUu55PLJcKZYheT9mv77AmR2ukyy/rFnpVEYMHJaE64BKXB6ZJcKtA361/eL1OKnMdwtUNZMrIOfMXE5atmdCpsMEQR8de/c7Tb9KKERTFDPqCvadZjt0EgaZL6VTzSmWicNCAXSXiRtkHCUf1F9Qo9I1RQBc/gj8yDfWmfaj03w352i/3dh5z07sU7oCvp+XIpZ8bO1j6DRMosafvwPfKP8u1B6t2CxbQxP4wz2NO+xfffwPu9jrG00eimgl5SiRwlYXcpv29a+Y3U4QwJWRAqQG+zXgNGi3wnnUE+8F0P4OOieWEbwHbbuTcbrk9bldg4x2N8TiRzAB56GXcAlfv9jDcgaWaMO7qdB1wExg6c+esoJkuq9uHvnimk2O1cNXoYnzJgPlmxf4bH36swfL99RcSs5J8yFT0iMNRxl4Z/eAyVkZKROu9UWtilnq0lMajB6z0oyEzfip+/w+I8zOTCbtgLqCyyaW1ou4T6dPZ7Qks9nZlPIstoiO8upVq9nvdVoo/4SdZhkRJHM60id9RxVUiB4rFKf9WR2EL7hxQMZVj9iaI1ImqkmZxUOXEL3fDUsKIxZidCA+itX3+TBQeVjxXk2WkAMKEBQfyKhcBgc8d+WVdD4utCAfLknTeJYCbH7d8DBgpeEMIHhMhKi/aF8FZBdOl+LTszcBWnB3WkzVL/gHdTwzm8m9E1tNgLK11Pqc9Bi+OQ8CdQ1QuD5tJ7CBbYhoeZZkZuFJjuj/9YeUdvgHc3fO2PZ9tVt8clOw2mWsBwzu+kxsBnPt88ppFqmfC2Fb/6/lFpcYCA+H2qFeabIG6fc73Z//PD5H0jTY2iWdu9Aq/xGvz4e5y47nc0QMwe/oUVC5P6gjw8Bmyocyq+0+ijEtaHNvmSClsmPCeU73T0zlPxHWx5pyN6syomvpbx992lCCFDqdVHvTEsxg3zo4dUz56U4pNTCL3IpnC3q/vsCtPfwrK5ylG1Ff26/oD1YzZWNWoF027HroUfqdYL5C+7KIeNpO2AgCc70FHTwuL5L82rhydTz8xjUCmSI8v3sHeQy/4ch4alCM5LGnAZtDOjHvWnV3vILMSpDhh9JK/TqMf87evPMNGy2h71fIbGUxAPvAljL10rUhkIhSgrvLNk8BmgjgQ+nx5i1lgJd1bwCG2jrmFfG1iUaxj8=
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