1054 - Unknown column 'p2c.products_id' in 'field list'
SELECT p2c.products_id, pd.products_name, pc.categories_id FROM products p, products_description pd, products_to_categories pc WHERE p2c.products_id = pd.products_id AND p2c.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = FLOOR(1) ORDER BY pc.categories_id, pd.products_name
