select p.products_tax_class_id from listing_table_products p left join listing_table_products_name pd on p.products_id=pd.products_id left join listing_table_manufacturers m on p.products_id=m.products_id group by p.products_tax_class_id HAVING final_price = (SELECT MAX(final_price) as maxcena2 from listing_table_products p1 left join listing_table_products_name pd1 on p1.products_id=pd1.products_id left join listing_table_manufacturers m1 on p1.products_id=m1.products_id order by pd1.products_name)




Could not run query: Can't reopen table: 'p'