产品分类
 新闻中心
table=news&condition=status=3 and username='gatz'&pagesize=5&order=addtime desc&template=null
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY company ORDER BY addtime desc) AS rn FROM destoon_news WHERE status=3 and username='gatz') AS t WHERE rn = 1 ORDER BY addtime desc LIMIT 0 ,5
联系方式
站内搜索 荣誉资质
table=honor&condition=status=3 and username='gatz'&pagesize=5&order=addtime desc&template=null
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY company ORDER BY addtime desc) AS rn FROM destoon_honor WHERE status=3 and username='gatz') AS t WHERE rn = 1 ORDER BY addtime desc LIMIT 0 ,5
友情链接
table=link&condition=status=3 and username='gatz'&pagesize=5&order=listorder desc&template=null
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY company ORDER BY listorder desc) AS rn FROM destoon_link WHERE status=3 and username='gatz') AS t WHERE rn = 1 ORDER BY listorder desc LIMIT 0 ,5
|
产品分类
table=type&condition=item='product-90726'&pagesize=40&order=listorder asc,typeid desc&template=null
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY company ORDER BY listorder asc,typeid desc) AS rn FROM destoon_type WHERE item='product-90726') AS t WHERE rn = 1 ORDER BY listorder asc,typeid desc LIMIT 0 ,40 显示全部 我公司经营以下几类产品，请查看：
以橱窗方式浏览 | 以目录方式浏览
供应产品
|
