/* /store/goods_view.php */ select count(*) as cnt from breed_store_category a inner join breed_store_multicategory b on a.cateno=b.category_id inner join breed_store_goods c on b.goods_id=c.goodsno where a.lft between and and is_delete=0 and goods_display=0