公司档案
|
table=news&condition=status=3 and username='xinsaiyang'&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='xinsaiyang') AS t WHERE rn = 1 ORDER BY addtime desc LIMIT 0,5
table=type&condition=item='product-90760'&pagesize=10&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-90760') AS t WHERE rn = 1 ORDER BY listorder asc,typeid desc LIMIT 0,10
站内搜索
table=honor&condition=status=3 and username='xinsaiyang'&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='xinsaiyang') AS t WHERE rn = 1 ORDER BY addtime desc LIMIT 0,5
table=link&condition=status=3 and username='xinsaiyang'&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='xinsaiyang') AS t WHERE rn = 1 ORDER BY listorder desc LIMIT 0,5
|
您当前的位置:首页 »
公司档案
收到的评价(作为卖家) | 发出的评价(作为买家)
|