SELECT TOP 10 * FROM power,tree,user1
WHERE user1.limitid=power.limitid AND tree.id = power.treeid AND power.limitid='1'
and (tree.id >=(SELECT top 1 id
FROM (SELECT TOP 11 tree.id FROM newjsj ORDER BY tree.id) AS T order by id desc))
ORDER BY tree.id
WHERE user1.limitid=power.limitid AND tree.id = power.treeid AND power.limitid='1'
and (tree.id >=(SELECT top 1 id
FROM (SELECT TOP 11 tree.id FROM newjsj ORDER BY tree.id) AS T order by id desc))
ORDER BY tree.id
WHERE user1.limitid=power.limitid AND tree.id = power.treeid
AND power.limitid='1' and (tree.id >=
(SELECT MAX(tree.id) FROM newjsj ORDER BY tree.id)