【商品列表】查詢某子站areaid和該地區(qū)下子區(qū)域商品

{ anxinMall:prod $sql=select top 10 bookname,thumb,bookid,areaid,onshow,onpass,refreshtime,adddate,classid,shichangjia,huiyuanjia,vipjia from [Mall_books] where  areaid in(select id from [anxinmall_district] where id=1 or fid=1) order by bookid desc $cache=0 }

/item/[prod:bookid].html
[prod:bookname]
[prod:adddate]
[prod:refreshtime]
[prod:thumb $empty=/tpl/images/emptybook.jpg]

{ /anxinMall:prod }