|
|
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'select p.products_id, pd.products_name,\r\n pd.products_description, p.prod...' at line 1
select count(select p.products_id, pd.products_name,\r\n pd.products_description, p.products_model, p.products_image, p.products_price,\r\n p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as\r\n specials_new_products_price, p.products_date_added, cd.categories_name,\r\n m.manufacturers_name from products p left join products_to_categories p2c on p.products_id=p2c.products_id left join\r\n categories c on p2c.categories_id=c.categories_id left join categories_description cd on c.parent_id=\'0\' and\r\n c.categories_id=cd.categories_id left join manufacturers m on\r\n p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and\r\n pd.language_id = \'4\' left join specials s on\r\n p.products_id = s.products_id where products_status = \'1\' order by\r\n cd.categories_name, c.parent_id, c.sort_order, c.categories_id,\r\n pd.products_name) as total
[TEP STOP]
