1054 - Unknown column 'pc.root_id' in 'where clause'

SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered FROM products p, products_to_categories pc WHERE ( pc.root_id = 261) and p.products_status = '1' and pc.products_id = p.products_id ORDER BY p.products_last_modified DESC, p.products_date_added DESC, p.products_ordered DESC

[TEP STOP]