How can I write this query with Active Records?

[eluser]Pert[/eluser]
Wouldn't simple query like this be enough?

Code:

SELECT * FROM products_table, products_status
WHERE
products_table.class = 3 AND
products_table.status = products_status.id
ORDER BY products_table.id
LIMIT 50