|
|
Invalid query: Column 'products_capacity' in field list is ambiguous
SELECT distinct p.products_name1,p.products_volt,p.products_type,products_capacity,p.products_weight,p.products_color,p.products_length,w.website_price,w.special_price,w.special_end_date, c.countries_cansale,c.countries_balance,c.countries_baltip ,c.warranty
FROM products p,websiteprices w, countries c
WHERE p.languages_id = 1
and
p.products_id = w.products_id
AND p.products_id = c.products_id
AND p.products_id = 1397
AND c.countries_id = 1
AND w.website_id = 1
LIMIT 1 |
