|
This Pimsleur Product Combo contains the following items: |
|
Product: |
Availibility: |
Price: | 1054 - Unknown column 'pb.subproduct_id' in 'on clause'
SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_quantity, p.products_lead_time, p.products_date_available, p.products_price, s.specials_new_products_price, p.products_tax_class_id, p.products_image
FROM products p
LEFT JOIN specials s
ON pb.subproduct_id=s.products_id
INNER JOIN products_description pd
ON p.products_id=pd.products_id
INNER JOIN products_bundles pb
ON pb.subproduct_id=pd.products_id
WHERE pb.bundle_id = 246 and language_id = '1' order by pd.products_name
[TEP STOP]
|