Taky nefunguje:
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 where final_price = (SELECT MAX(final_price) as maxcena 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)
Hlásí:
Could not run query: Can't reopen table: 'p'