ZAQ/9H9PloXu0Q5MBAOR961c1PLp8yTtg+BxFunZwbs5IYHSsW7iDTF3UNVi+ahj9g/4Q+FBe+hLSXymMVmjiL1Q+7bXetcMPtUfCk1O+f9AJyS4vsEvanEIfNYEXMEQJlHMW5imLMVz5pqOVAqppgMdm4asUkTfA22ayTD2K5IqqoMLv2mugv+nqXw0l+1LHyPH8zGC4CrR0qtDUOBwpb2YReKTeFpSVeq77JULoiQVd1mOXCPcnYR6yty1BdBeRmp0tXq2jRujVMiC9R/Uv/2EmYmh3wPBPpoMuE6p0wxkyAeq26faKsWYWXcCwsYzg9/59wIbwjdpRmvndvg2Ot8sS9AhyCBwK1Qz9GFXoBs1BKMxYIcb8K7ijyvpR+JxH49xcHTU3OKKz0cGf08z9NLJdNqvjU0G3y1CnpHYZZInVlBPaROgM+IR5BGUEIEjgMqE3u1fUraQYvV0oxqLJK8A8aVLpTJyfgtQdn4HJiTsiw9CKpZBb9kNGinvzUukw/ovcLunL3VzGjD63TangkqLLsH/mg/93FL/GJ/pMCmLaVsTyD7z6wB1QqFX7g1BUTKzfANelm0CA/EbsRMLtr7R0E4DehJbxT5BtqPFB57R0+yXKcUACEDjgcBLV4XBTX/EMRg5nskq9nfmiSTsNCtZ1C76j6+vMRSoqlmA8rlTzok7v3/0daELPLFO9u6SC8vkcPAbbx8LCkuNICfVS7asapQzkwKK0XS3dlz0uegxZQxkXGkDmZmqF2SLa0c7EUM/kstHiqFdaLxqvlnm+YFtnF07lNd+ydRFcJNEMx3cETG/QN6DGqD3Qr33fS52gLGuVoqwB0pvOXgcYNAXWznlm7F9YqVgVrgCZq3ZSq6w++i/qonlUJAyCsyBfj0XZjybiCLxHCFjMZHPwAM1x7BcsDkZYa0RMl9/FPTs0rOWsGPxuqJPRsME4n1Q021SZaSE9AziX/xaKlG8D9UWL3Cw+yA/zvMdw2Hdjia/s/rg87BgrPRUA50cVQqTl6xOy/fbkM4avKaVxTsymBa3tZT/nFgOp11dg8oQhstDvW1+QTdVRaeWJ+YnvzBBfjrmarRhX/tI/LvEAdHK6hFYC9RHbqavnDR3k+bQF5S6UaYgIdEpaHPt7JDfAoY6QCQONiXskuvPZhjM5MMYnzWPSu+S3D3FD6A4rDFHIi3SER5bELglUxZvXALFc5AAsN0NaaHFY2oDiM7HEFZkV1aTwILeF5lgnqTPji8d/ptIicm8o0jcsd2h3YAyamcgb4437LBr8j206Mzl2UBMIVF4f366+km9zVjliXzzOUrIajRFam9irHUvnKBTmLxE4RapmijWszv85hdV4yxLmYnF0+s2JDE6IjHmn6eOrpM=
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