select product_brand_id from products group by product_brand_id order by count(product_brand_id) desc limit 2
select * from products inner join product_categories on products.product_category_id = product_categories.id where products.product_category_id=22 or product_categories.parent_id=22 order by products.id desc limit 5
http://www.cqeiie.com/web/tohtm?urls=/Index.do&xx=/index.html
http://www.cqeiie.com/web/tohtmurls=/Index_Service.do&xx=/index_service.html
http://www.cqeiie.com/web/tohtm?urls=/Index_Fdx.do&xx=/index_fdx.html
http://www.cqeiie.com/web/tohtm?urls=/Index_Ylbj.do&xx=/index_ylbj.html
http://www.cqeiie.com/web/tohtm?urls=/News_Center.do&xx=/news_center.html