|
|
|
1054 - Unknown column 'p.products_id' in 'on clause' SELECT p.products_id, p.products_model, p.products_price, if(length(pd1.products_name), pd1.products_name, pd.products_name) as products_name, p.products_tax_class_id FROM products p left join products_description pd1 on pd1.products_id = p.products_id and pd1.language_id='1' and pd1.affiliate_id = '0', products_description pd left join products_prices pp on p.products_id = pp.products_id and pp.groups_id = '1' and pp.currencies_id = '0' WHERE p.products_id = pd.products_id AND p.products_status = 1 and if(pp.products_group_price is null, 1, pp.products_group_price != -1 ) AND pd.language_id = '1' and pd.affiliate_id = 0 ORDER BY products_name [TEP STOP] |