Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'pd.name' in 'order clause'<br />Error No: 1054<br />SELECT * FROM (SELECT c.parent_id, c.sort_order, cd.name, COUNT(DISTINCT p2c.product_id) AS total, cp.level, cp.path_id AS category_id, (SELECT MAX(cp2.level) FROM oc_category_path cp2 WHERE cp2.category_id = cp.category_id ) AS max_level, (SELECT GROUP_CONCAT(cp3.path_id ORDER BY cp3.level SEPARATOR '_') FROM oc_category_path cp3 WHERE cp3.category_id = cp.category_id AND cp3.level <= cp.level) AS path FROM oc_category_path cp RIGHT JOIN (SELECT p2c.category_id, p2c.product_id FROM oc_product_to_category p2c RIGHT JOIN (SELECT p.product_id FROM oc_product p WHERE p.status = '1' AND p.date_available <= '2019-01-22' AND p.manufacturer_id = '36') p ON (p2c.product_id = p.product_id)) p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product_to_store p2s ON (p2c.product_id = p2s.product_id) LEFT JOIN oc_category c ON (cp.path_id = c.category_id) LEFT JOIN oc_category_description cd ON (c.c in /home/saniluxc/public_html/system/library/db/mysqli.php on line 40