SELECT TOP 5 a.apkid, a.apkname, a.apkicon, a.apkcontent, a.apkversion, a.apkmobile,
b.name AS bigclass, s.name AS smallclass,
(SELECT COUNT(apkid)
FROM apkdown
WHERE apkdown.apkid = a.apkid) AS num
FROM apk a, bigclass b, smallclass s
WHERE a.bigclass = b.id AND a.smallclass = s.id AND
a.apkurl = '山东旅科科技有限公司' AND a.bigclass = 34 a.smallclass = 109 AND
a.apkname LIKE '%%' AND (apkid NOT IN
(SELECT TOP 0 apkid
FROM apk
WHERE apkurl = '山东旅科科技有限公司' AND bigclass = 34 AND
smallclass = 109 AND apkname LIKE '%%'
ORDER BY apkid DESC))
ORDER BY num, a.apkid DESC运行出现 第 1 行: 'a' 附近有语法错误。~~~
b.name AS bigclass, s.name AS smallclass,
(SELECT COUNT(apkid)
FROM apkdown
WHERE apkdown.apkid = a.apkid) AS num
FROM apk a, bigclass b, smallclass s
WHERE a.bigclass = b.id AND a.smallclass = s.id AND
a.apkurl = '山东旅科科技有限公司' AND a.bigclass = 34 a.smallclass = 109 AND
a.apkname LIKE '%%' AND (apkid NOT IN
(SELECT TOP 0 apkid
FROM apk
WHERE apkurl = '山东旅科科技有限公司' AND bigclass = 34 AND
smallclass = 109 AND apkname LIKE '%%'
ORDER BY apkid DESC))
ORDER BY num, a.apkid DESC运行出现 第 1 行: 'a' 附近有语法错误。~~~
b.name AS bigclass, s.name AS smallclass,
(SELECT COUNT(apkid)
FROM apkdown
WHERE apkdown.apkid = a.apkid) AS num
FROM apk a, bigclass b, smallclass s
WHERE a.bigclass = b.id AND a.smallclass = s.id AND
a.apkurl = '山东旅科科技有限公司' AND a.bigclass = 34 /*这里少and*/and a.smallclass = 109 AND
a.apkname LIKE '%%' AND (apkid NOT IN
(SELECT TOP 0 apkid
FROM apk
WHERE apkurl = '山东旅科科技有限公司' AND bigclass = 34 AND
smallclass = 109 AND apkname LIKE '%%'
ORDER BY apkid DESC))
ORDER BY num, a.apkid DESC