Musí fungovat tenhle základ:

SELECT min(p.final_price),pd.products_tax_class
from listing_table_products p left join listing_table_products pd
on p.products_id=pd.products_id

Pak na něj nabal ostatní (name apod.).


EDIT:

Určitě tohle:

SELECT min(p.final_price),pd.products_id
from listing_table_products p left join listing_table_products pd
on p.products_id=pd.products_id