http://www.iofast.com en Fri, 05 Jun 2026 13:44:14 -0400 Great Prices and Great Service. IOFAST Computer and Network Solutions. : SQL error Unknown column 'categories.parent_id' in 'on clause'| sql = select concat( 'http://www.iofast.com/product_info.php/products_id/' ,products.products_id) AS product_url, products_description.products_name AS name, products.products_date_added AS dateadded, products_description.products_description AS description, FORMAT(products.products_price,2) AS price, CONCAT( 'http://www.iofast.com/images/' ,products.products_image) AS image_url, concat_ws( ' > ' , catdescparent.categories_name , catdesccurrent.categories_name ) AS category FROM categories , products, products_description, categories_description as catdesccurrent, products_to_categories left join categories_description as catdescparent on ( catdescparent.categories_id = categories.parent_id ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND catdesccurrent.categories_id = categories.categories_id ORDER BY products.products_date_added DESC LIMIT 30