select m.alias as catalias, g.token, g.parent, p.* from pros p inner join global_pros g on g.token=p.token inner join global_mpros t on t.token=g.parent inner join mpros m on t.token=m.token where 1=1 and p.ustatus='1' and p.lang_id='1' group by p.token, p.lang_id, m.alias order by p.token desc , p.lang_id asc limit 0, 9
vnplusinvest-CÔNG TY CP ĐẦU TƯ ĐỊA ỐC VNPLUS