views 3 incompatability with Rotor module

with rotor module , not working
result is : n/a

query is :
SELECT RAND() AS _random
FROM dr_node node
INNER JOIN dr_term_node term_node ON node.vid = term_node.vid
WHERE (node.status <> 0) AND (node.type in ('rotor_item')) AND (term_node.tid = 61)
ORDER BY _random ASC