Nebo zkouším to i takhle:

Mám tento dotaz:


SELECT products_tax_class as tax_min
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
order by pd.products_name where final_price = min(final_price)


A tady to hlásí:

Could not run query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where final_price = min(final_price)' at line 1