uff, no v takom matrixe len tazko najdes chybu. trochu by to chcelo aj strukturovat, nech sa to da citat.
V ktorej tabulke je vlastne pole final_price?

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
      )