Database Error in includes/classes/split_page_results.php at line 37 Called via includes/modules/master_listing.php at line 12 Called via includes/modules/master_products.php at line 166 Called via product_info_tabs.php at line 533 Called via product_info.php at line 117: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 ') k' at line 23
select count(*) as total FROM (SELECT DISTINCT p.products_model,pd.products_name,
p.products_id,
p.manufacturers_id,
p.products_tax_class_id,
p.products_price,
pd.custom_spec_1,
pd.custom_spec_2,
pd.custom_spec_3,
pd.custom_spec_4,
pd.custom_spec_5,
pd.custom_spec_6,
pd.custom_spec_7,
pd.custom_spec_8,
pd.custom_spec_9,
s.specials_new_products_price,
s.status FROM products_description pd, products p
INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id
LEFT JOIN manufacturers m on p.manufacturers_id = m.manufacturers_id
LEFT JOIN specials s on p.products_id = s.products_id
WHERE p.products_id = pd.products_id
AND p.products_master =1049
AND p.products_status = '1'
AND pd.language_id = '1' order by ) k
[TEP STOP]
|