[ETInteractive.com]

select * from xcart_products a, xcart_products_categories b
where a.forsale = 'Y'
and a.avail > 0
and a.productid = b.productid
and b.categoryid = '123'
order by Rand() limit 5


you need to use "xcart_product_categories" table, not categories.