2013:
select cat_goods.*, cat_brands.name as bname, cat_brands.id as bid from cat_goods, cat_brands where cat_brands.id=bid and mid="2" order by cat_goods.name asc limit 2120, 40