TxNGRqgW4Q2xLq99GDqYZ3gMPr+gZ68ISHzmlE3JsxuRMIMwGoP+eE3fMsK8n6/gh/Ru4dxF9Iv1TljvV/xqPdt6KwGRqj5MwG7JKZoqbv/9yUnzuTqk3FItlL+MRingmB3fEKtXHtJdujVjo+c7JeJ81Y2SXoyTYCVLD89J0wCdIQnKVL6aELjHlEKX8MGClmPQp5itx9YOJNU5bZ247hFtAMJVsY61HD9nYCUoGs4buX/vDhEHsluLRgksHLEPuFqG+zA+IpQEoPajA9/NXeXfxCGvAbqeQrDCGSLc0c4hQtIaR2oHUuPzFlMWtZ/JKF9+Gv6a/7/vx0WkRWdVA1mJoI02r0QokLRA3v9EIXQQk//xSsA61PmSNL2JZsavEyHeZ2I3ZFQB+/bzQn4T8EL6+WSNjCQaIFhLq/O759F5NXnd/Zp8Q4laIKiUMn2CRji0DRi1p10t8wRGGzI5gt8aWFVbHqlXH0PR0HA1Sxw9pBxUsYAuuMTWqFjAFouzgW5fNQsnIcjG4jX7eks3VBZmt2y+UI/lXtZ2NGmU+kBP/v04vqULdUVavk4G7yI7cwH+dn8rh0gWcaqJ/lXHePrGZevLWQzKDRjOdG3eUKEt11FDJ3IU64S6Y3ZnhwXqweJeVRRhNJJ1PwwNDSRDN6iwgyuTksR2vs1OdeDHdQSP6Ol5k4H8sIHisOJu4zuaN18C2sbLt9yXSCyUg/QlJbyRcq7GvRZYztwqVPsC6yamLOI00RMyySp6mwDkNoEzzLBlMN/iw6faUlh8+hSATtng9Ee45RRrjza8UgVIOuKim54yLfoe5fTBQPv16iErfB38gyMvV+UGai63EX50VXk2APbKvkxDJX6ztMkdK2dj3vKy6ZIsTIhcdiMiSThKH7dXp8ssDVbnEoZwGFxVrtSp9nW+axDUOSrfhQvaAWECvVDdpseF5EWMGz84I4paUlCMtch785T5kGywtUXzucEz+9o2Ccyi5AaeTQgoiZR8UKqzKZjjdso+dvy58P84r8v5S4OFm6sYp9izE+1C11yaxK9kmkxUtyBr6uDZyGwMsa9NkZTLq68LcmWC1VE/xEJrmlIdjr8kr52QV+XIcNaezfAAHuogDaV32De3vN3shQJep/l3TfO8TENpIMQS8+iUus8ySSSATkO3cbdh/sS6vfOMbeBCHoWTplKg75Ko0rQY4aswfPkm8SOUcsCv3MPMrkOvWXJIpnhKwKXnj2WOuVq3tjn+ZRY99RqGHhAodEWoYsBZamLz7iB+Y/KmUs1vQqk1lrAUouoMZ29ExTgxT1cUgu1lDiUgoxDuNJ2qVZSm/BpQhG+a5qg/ZIXHtoxUXu+BE9ex44GGpFy+2ldB/w6co9HHATkeVNw=
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