-
{query:name=goods as go join=left join category_extend as ca on go.id eq ca.goods_id left join category as c on c.id eq ca.category_id
where = go.name like '%$this->word%'
fields = c.name,c.id,count(*) as num
group = ca.category_id
}
{set:$tmpWord=urlencode($this->word);}
- {$item['name']}({$item['num']}) {/query}