Jedná se o MySQL:

TOTO funguje:

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

TOTO 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 = MIN(final_price)

a TOTO taky nefunguje:

select p.products_tax_class_id, MIN(final_price) as mincena 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