8YR0PfgbC+JJFCr9Q2gEPU3iLdDeA1XKPGRhYNWPvsdsvScoDUG199arKxIcCg7lVj66aCHbnsD1yoTtkg2MNKk4Ro5zBj+Naz3zC562UenCyM3mLLYTg3UHs3OLHc0CqylxLx/D8EbBrUuEI9ak6dUua6ad1s+rsKpZD4d2GpjODzqCiyxz0p+rSfr+XBwQ7lMTDi7sLaHQEHZEEvz1aCS29pAF5p91t4Fb/Zw1PFpwFSVD0OOx8EiocSXUY9gqx63EyPYTldE94epIOgSz8JVKT12TWiCeP6Jx75cPGhBbUnPJvKwSosskvOcFg5eQbfaIXCdNupiX/MQKBOHPkCLQfG0orkoaanJwxOW3k+zChUg4xZxJ6x9MVh1OCs18Ns26G33KvKM0v4xaV5GrwXqeV3e2bk27O0b/+T7aPCRkR9gm1hSdeYVCdhtqXHeAvbG9s+p6f8esuVKT18X+1Q1flnELhAamRAjsph1JqA9GG6mbQctjBff60bpjLWg+qb6PcymvqON+A4C470Q3RSf4svC42OvuuxzIjRcHNOLD6GJ9Iiq3yZCohzuPrZKnGSQ+MPjzj+bVAGWduhCLNYjpoex2J8GB68rqLtfD335D80nz7NmcO38J74szz/ZzAA2MDsAiew+MhD3suE2zn6PAnvXlxZrTsfBpjs+KTm+9HRyDaIGZ5W1LOeyMlkc5T7DomDm1vlGDcwPMNsymaEh+egTRTO1tjYKfGL5NeUtxdrN3LoMaU0BHsEJglY+mDVdyS38jchHnzkHfE5tMiMaOkJXAvtmdcM00PFlYZeHfXUD1vNAYSjZ+TPjMhCOXQwEursDkoFEE5r2hpYZ43xHXR6DeimiEMCqapbM+0Z3D6HCQuJmunLjHycWvM9HRHYzsVZRYh/ZOlgzH1mUBPnXeQTAgRo6NovL5/RE7MBX9l1RlJcwxLlBw5ivwRN8K4wQng8L53S4ABN64n+lMNLXufyI2mcmr3jrEFq8dNVXUfpFPJMzEBswHjSxB+ykkoybQPRU88/3aLH1K5YqyM9FH1hi1q5vktMc1tDXKBlkkMc0ebAk+sOahmMLASfzblVP5R8n8PthO65QuFS5AsqUpWSkSbdNOUQR7XIFKtefnbqCc8aap9fIOzBNuqFCOJcoxDo37eUXcvKFF/ePYJ3fbQ4bYPMhKGEPE3ZpKSOurcyrdfrvCkWwxU7YSzsayETEG+PEiI0z8/Mg7XApKUY23vuz0bYaUm9fx9KArTzYbKmut8QdaFwxYQ4vq1MK/sBnhyTKqjZgwfPg+dkKuyaBGXoB0NymFgWOU+xVbhjl850xlcKf18enrMc4pqy1xATed85vyio7wiocSWKh5CAhPWnjuSl8DqXz+sUw=
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