友情连接
主页
|
信息安全 Top 10 (评分)
IT相关 Top 10 (评分)
Expression #1 of ORDER BY clause is not in SELECT list, references column 'gipskys.l.rating' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT l.lid FROM xgipskys_weblinks_link l, xgipskys_weblinks_catlink c WHERE ( ( c.cid=1 ) AND l.broken < 5 AND l.lid=c.lid ) ORDER BY l.rating DESC: 10, 0
Expression #1 of ORDER BY clause is not in SELECT list, references column 'gipskys.l.rating' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT l.lid FROM xgipskys_weblinks_link l, xgipskys_weblinks_catlink c WHERE ( ( c.cid=2 ) AND l.broken < 5 AND l.lid=c.lid ) ORDER BY l.rating DESC: 10, 0