help with this SQL query

[ungovernable]

ok i have this very basic sql query:

$query = "SELECT t., p. FROM thread AS t, post AS p WHERE t.threadid = p.threadid AND p.parentid = 0 AND t.forumid = '84' ORDER BY t.threadid DESC LIMIT 10";

it will find all the threads started inside a forum where forum id is 84

but i would also like to get the results from forum 85, 86, 87, 88, 89, 90, 91, and 92

i tryed this:

$query = "SELECT t., p. FROM thread AS t, post AS p WHERE t.threadid = p.threadid AND p.parentid = 0 AND t.forumid = '84' OR t.forumid = '85' ORDER BY t.threadid DESC LIMIT 10";

but it mess everything up, it query from all forums instead of forum 84 and 85, and also the order is ascending and not descending

[Bjom]

try this:

SELECT t.*, p.* 
FROM thread AS t, post AS p 
WHERE t.threadid = p.threadid 
    AND p.parentid = 0 
    AND t.forumid IN (84, 85, 86, 87, 88, 89, 90, 91, 92)
ORDER BY t.threadid DESC
LIMIT 10