select * from db_domaininfo k left join tb_country p on (p.countryid=k.countryid) where k.brandname like '
