SELECT*
FROM pre_forum_posts
WHERE fid =42
AND tid =1
AND subject
IN (SELECT t.subject
FROM (SELECT*
FROM pre_forum_posts
ORDERBY`pre_forum_post`.`dateline`ASC
LIMIT 10
) AS t)
LIMIT 0 , 30
FROM pre_forum_posts
WHERE fid =42
AND tid =1
AND subject
IN (SELECT t.subject
FROM (SELECT*
FROM pre_forum_posts
ORDERBY`pre_forum_post`.`dateline`ASC
LIMIT 10
) AS t)
LIMIT 0 , 30
FROM pre_forum_posts A,(SELECT*
FROM pre_forum_posts
ORDERBY`pre_forum_post`.`dateline`ASC
LIMIT 10 )B
WHERE A.fid =42
AND A.tid =1 and A. subject=B. subject
LIMIT 0 , 30
我的可以,就是不知道放到PHP页面里会不会报错?