看下随机调用的问题

[ecmsinfo]"SELECT *
FROM `phome_ecms_hua` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `phome_ecms_hua`)-(SELECT MIN(id) FROM `phome_ecms_hua`))+(SELECT MIN(id) FROM `phome_ecms_hua`)) AS id) AS t2
WHERE t1.id >= t2.id
ORDER BY newstime desc LIMIT 40;
",40,32,0,24,13,0[/ecmsinfo]
=============================
表中有字段 id, title,classid,
id是系统产生的文章序号
title 是文章标题
classid 是栏目的ID号
上面是提过的万能标签，我用了SQL随机调用
现在是可以正常调用title,classid的值，
但id的值只能调用第一条，就是调用40条的话，后面的id都是第一条的
感觉是混了，高手指点

看着比较有效率

SELECT t1.*
FROM `phome_ecms_hua` AS t1
JOIN (
SELECT ROUND(RAND() * ((
SELECT MAX(id)
FROM `phome_ecms_hua`)-(
SELECT MIN(id)
FROM `phome_ecms_hua`))+(
SELECT MIN(id)
FROM `phome_ecms_hua`)) AS id) AS t2
WHERE t1.id >= t2.id
ORDER BY newstime DESC
LIMIT 40;