/* /store/goods_list.php */ select * 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 287 and 288 and is_delete=0 and goods_display=0 order by goods_price desc limit 0, 20