SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 13
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1023098502 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
这条sql语句有误,应该是 SELECT
thread.threadid
FROM thread
WHERE thread.forumid ='13'
AND thread.sticky='0'
AND thread.visible=1
AND lastpost >= '1023098502' AND sticky='0'
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
thread.threadid
FROM thread
WHERE thread.forumid = 13
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1023098502 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
这条sql语句有误,应该是 SELECT
thread.threadid
FROM thread
WHERE thread.forumid ='13'
AND thread.sticky='0'
AND thread.visible=1
AND lastpost >= '1023098502' AND sticky='0'
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
另外 thread.sticky=0 AND sticky=0是什么意思?
用repair table命令修复
或用myisamchk -r thread.MYD程序修复