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