I am trying to run this query in phpmyadmin but getting strange results
SELECT pov.products_options_values_id, pov.products_options_values_name, pas.quantity, pa . *
FROM products_with_attributes_stock pas, products_attributes pa, products_options_values pov
WHERE pa.products_id = '150'
AND pas.stock_attributes = pa.products_attribute_id
AND pa.options_id = '1'
AND pa.options_values_id = pov.products_options_values_id
AND pov.language_id = '1'
ORDER BY LPAD( pa.products_options_sort_order, 11, "0" ) , pov.products_options_values_name
LIMIT 0 , 30
MySQL said:
#1054 - Unknown column 'pa.products_attribute_id' in 'where clause'
MySQL said:
#1054 - Unknown column 'pa.products_attribute_id' in 'where clause'
Well, I can see that the table does has the products_attributes_id
Then why this error?