y9Kr6dkMjiBdUyWi/V/c4vrWclVm0L0KS4eZYPaQR3HHTGagih0zkSxBbFK6F9XxgFrfd2CcOTrURukuFXxBxCf+ICmx4ZwhchKryANegt5UW62nDdGEn6hNfmIdChhy0DK5UPlb7vW1UlYLVCSqt6OYEKjezbCCfCfUjDK2T/EJOIQKoSawn78c2CYpCyy/KouuTL1gDivLGVmWmLtYphbSlxoE3WPT/iyHQAQoO+1oTZSLbonh595L6JkQ2aTyq9iFCIdnHdwQLHwk4RBuTga2hAh9UIyAVhxXLNpmoOWTzo58CBQteUAB3Hy92/kjgCxTtbJF78Nak/sCPVrfDCD3a1nuYQq88Vv75AArDdH9fMZjEn0LhTEGye90OwRjw1OBHnbdQK/4ICqLWldoar0JpB7t28dhBRx0IEg58xSPnMh9N79SKFb4K/v8nBj90wNVKukDynhziiRorsGfh0FA6trcTsHGCHsBuW1aviN9Sv9CTlH3D69T9YueaP7lTFqGqywlRnM5pPUAu7FP/UeiEP2wDH0ID61xBq3rUPfhBIJosxoTdglI8CzFZsClXJAb7Dkp39kPRDoahdeUOE/iBpfXTlYlGJVuXhOLnb1Rmmu1qsgMudyKbOeN1ykeq/WXzMMi1DYUj7jLOfvjPSpD1mZ5MaE348PPGvnI8Y+x3NXw2u+9zKuT++aRsA9itEE+gWHJrVDFSJcr4N14+89o6pCxj2YrpNobMm920D9jEEcUNHV43qPl3uwWcB4s04Uhv/5m3cZO3iwo/fw6hT28v2Tc50MSDELXz5HLM6E7nJz451vNboz4hox4sfnmvaoju1YqemBKvINOCHTnxTEORJvx1mpBQkRokoieJmZwkuTAYgTniuMDKr+xQTW0+4WlJyQru4JTH8Fq9yBNSBu5ecE3WAodUrVHEzCg7UkEUIKM9Lvmt+rg/tSYpeUihRQeWUymFriiMkGj7rcDLL66EsYYCUW97bC8yo5YsVralheYGcYhis56ULc37CYz3w5btJczXlUal6XAOnsPRXwu0pCp8RUc4f1Bw4miEsJU9qUzjzSDRLdvstmCMYDOoY8uCv8V/uNmtJevtlQ6yZziKnhMPCJkU6sPncdItaACGp6C7g7TXUlPptpRlW+pYUc3xvXqp0c1YUOdTCJLKl8mADB9iSSCVsoPqGQHOYTAWyRKF2OMtGwf4T+RapbmYaRx0Yqy6wQQufFh6NDyJoRxyuzNfEAnrO3CE0HXezTucW3hrKEtQxszmiJGL8Ile9pe80TVhHLr3QvP9L0CHA4umMdmuIpCJdCEWbw1oYmvkdSLUKx3hAVPL0wt07uYaSNJ1KTdpCMe2k8uTDI7ScNhGJvKSRb0SeYIbTs=
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