0x1ARoU9PzGXsI0wNYp3ploB8F0oiOXrNFgZcGOgFaMwZ4XQqs2tUHv0l+eOC+yALi9WKEZAdUig/SWDplLqD/L2+2xmuluDsyFDHyP16okKMUSL2LpjZGcjZBcyoeNyCHY7rlp7QQGyTXkGa7Ijpd6V5CKBmXFDpOl8YOzdBox/Vj/CaWrr+fLbOqdYnawrB45TdHN4vwDdXL4qmtWYaFbQdDPxsL4lWSvfROg/u7Ku2hDmfE666AsDYFbG7zEwtPCJe+OLjas5mBDHc9J2eadmMDLp910Vmzxa2ylMmyUo3n7kk9jcyQqTbMuGNm7isbBoIvn2UokT8pCGblce7BtYVqx1+dAqVEu4I9M/bTtwtcc8Vns62GwIRtavJ75HLREXzxazi0ZMzLaZGA76Y7EXntxZp6FG26dqHmdHIDdMI5qgte3vb+368sS5fkrm2zqBxA5UfcI2kyVH21f7rs/XZbzKH1/rzQgmXwFJ/e0WHsVZH7XLXOcLt7EWTLNMa+IFTwz+BmlkiWXgZUhAcrzugtHue3ZrPdjvNaOp5zhJYQim9TAZKw0vHIzJseW9yqVeanIwi7SpXQ+C5bIqUG1wSLPnHL1UOG3Pg1NbD1WmdDKKI+n+qv40t/LHGByBc1RjoUgyze3IvhN7E5caM7WmZXUp/HI+SRQz5v/HRqGidv7kc2zAFHxqofKyb6k5Gv41/NIBNfi841lxWz5+ZVUGOaleFoVPyOPQxnuvKMEWFEuYt7kluc4P8mxKsihWgmRNfiiov24thDT+a8NPBK/v+n/wM2358xtWu8L01kw+IKtvNzXaR5XVM1LFtgsHPDZnkTFme0pYDS+04TnDy5FS8EDGQUvsdfpegtxPuklqjv/U9C2l7aTBQqL0DtmhHv1HW0HMM5mCE5y1IdfA6b/gIfE1eAgQmWcdSfDNWiAGwyrBk95woJR2fn8eIpdxOZtIeNn3LOthVCaf41G/2aZqA4IQr7f8Yefa4AtAhY22+yG3KDuE0du0JSh7KY48iVMhzEEWwncIUwy5px72vd5m8KMR6aG923XSo50GJt0kqnoF2X2LFLQl+nFmIVhQZVSc4I7QJsf3rtkFU69mgiuhHfSsqk7u16KIyGgGgVVxioJXql/h74uxWh5CtNlYra+nCphKeVCN2jA8YuUMjcX/+aTdWN+W+RE3lzd5djFEyI4i6/T0cffMeyV8lwuUUWRy5cRtkrjRIeL3Tb1PzQ09cjCGuoTChkvlEo3qdHMVZOINSAynaunJz0eiAlGROhAiycvfDl8CGTdHF5A1gANkAfMeJTAp7GIpXLWvsx3Fpi7k28+g/r7LZsgFr5IOy6K8Bepp2Eb9Ll+TVNoNlWK2lfgyLvJOG0iRdtk=
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