|
Tags:
|
 |
| |
Customer Reviews on Nature's Aid Vitamin E 200iu 90 Caps |
|
|
|
|
|
|
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 's Aid%' and pd.products_id = p.products_id and pd.language_id = '1' limit 6) uni' at line 1
(select p.products_id, p.products_image, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, if(length(pd1.products_description_short), pd1.products_description_short, pd.products_description_short) as products_description_short, p.products_tax_class_id, p.products_quantity, p.out_of_stock from products_description pd, products p LEFT join products_to_affiliates p2a on p.products_id = p2a.products_id and p2a.affiliate_id = '5' left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '5' where p.products_status = 1 and p2a.affiliate_id is not null and pd.affiliate_id = 0 and p.products_id <> '166' and pd.products_name like '%Nature's Aid%' and pd.products_id = p.products_id and pd.language_id = '1' limit 6) union (select p.products_id, p.products_image, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, if(length(pd1.products_description_short), pd1.products_description_short, pd.products_description_short) as products_description_short, p.products_tax_class_id, p.products_quantity, p.out_of_stock from products_description pd, orders_products opa, orders_products opb, orders o, products p left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '5' LEFT join products_to_affiliates p2a on p.products_id = p2a.products_id and p2a.affiliate_id = '5' left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '0' and pp.currencies_id = '0' where opa.products_id = '166' and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) and p2a.affiliate_id is not null and opa.orders_id = opb.orders_id and opb.products_id != '166' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 and pd.language_id = '1' and pd.products_id = p.products_id and pd.affiliate_id = 0 group by p.products_id order by o.date_purchased desc limit 6)
[TEP STOP]
| |
