U5JbL/WPJcjNNdyMsFE2yJdvrCtxSZx+DFE/BPzUv/WXdGAyQOjCOyuKvaHgNcteTZVaZMg0P40CJRVp2JK7qfsgYxMKOQrY9SAWwH/IhYSyMa7lQUo0jjtQolbxQOshFO0s1tb+vNChSuGGrLdC3q7H0JVX8fM1qnQxBjDsrgRHCz3M8+Yq9tBEpFuF969ShLoA3N7UBbpF4gCJuyO0hE5RCg7sxnducgjoQJgIRirSrALBbxl8Ke7wbcUHfyzdOgJ/LDK6Mte1xUjwUCeoLvm5r0KCgZplCjXkEoKmOALI1piHVxjZlxfHkQhPfCGDnPA7UHdvSUjv+ZNTy63zw0OUQjFKW1cjuvfq9S5IKhPKwD+IBZHZ3ACc7DlCCJ3Rfs3CJ30iDDM5yHer1dIz5WUtaAMUm3KaF8J9MgFkLc3edVPAu0cLYYwq6Kt5utAckfhNthSZ7p5RpXvzLuaxoZGRjGg2TCsO4oRsOQcOhdNZ0V23FWFgzcUll2jhAX6lxvK6OEA8Jv/WH9n/Ksn7hENiWQZ527GCJjbr7MEIcUxMVwdozx6O+gOMqw47fewusVeyWc/B0CHERaIipUhGG/xg4+oPtCsoNKf+6Bg6caxLr9YpQA8DGA8a/A8zWaJydJVlUIf6J+zkrZ+xzU1xxiaDbl8hN24qrBSDHp/hh1l6Lw5r1o7hmOUIo0WUIx3V16xj0JJwtFNe74MNg6eDMgeTgn/HDHuiD2igqsFPho6xTHK6jK/MVH7d7GJJ5IwPQ109XWwWHxcj7AuKYOoaX8upEXqB65ddYOKovUx0t3/hX6eC0XNz3rcV9lpEACtNhvhQYRl1zdjhxgou54m9X6D9MeBMjF+qasohAxAgtSAoyjIcChq9EEQZYxk4hh6V7e/Wg7p6eEG8DbfJ0A2ekkPcfRH49m9L8KcuXY18jvwgSqPMqnOvKY2XdpoScHNZSnUTSUiNoRMRoTarJ86Nbu2nHMwqedNk9ifvaC8gG9Cs+1HzLjq5zpHXANYvR7P0eNL9Q7pF9vh12AJDL+2rcIdBOVW45G1fdSn5F4wcHz4EZ916UnXmS/6hjZsjqo7tIvoPRjHV9d7ZxVnsR6ybsmQv4ESNG+SVpPcNpQuvQzzAEAwZCCgDIyeeNqrTj9EcLbD+7Scmzmchg/ZlwLAZSFeuYX3CGEDoS/YphcPK0TdGxagMoGPSlW9vN0rXgPDXosXuJkdiG26iVpeWHIbOTpBveZuFofWU+uRYNGSIaDHCAqOUg6jNCWex8LAei5rVPSagBIpFiV8eX3lZFxTpYORg7gOLsvFjSvTQZ9U+UT35YUHOzacBNQnqguu0uurEUPHVkxp5r9iYcbDstC8S6DY7URuKGBDUs75yCC4=
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