SELECT DISTINCT Finishs.* FROM ( SELECT as 'finish_id', PSA.sort_order, PSAT.* FROM pri_store_attribute AS PSA INNER JOIN pri_store_attribute_text AS PSAT ON = WHERE PSA.super_attribute_id = 2 AND PSAT.language_id = 'en' ) AS Finishs INNER JOIN ( SELECT DISTINCT PSP.*, PSPA.attribute_id as 'finish_id' FROM pri_store_product AS PSP INNER JOIN pri_store_product_attribute AS PSPA ON PSPA.product_id = INNER JOIN pri_store_product_attribute AS PSPA2 ON PSPA2.product_id = INNER JOIN pri_store_product_attribute AS PSPA3 ON PSPA3.product_id = INNER JOIN pri_store_product_category AS PC1 ON = PC1.product_id INNER JOIN pri_store_product_category AS PC2 ON = PC2.product_id INNER JOIN pri_store_category_text AS PCT ON ( IN (36) AND PCT.language_id = 'en') WHERE PSP.status = 1 AND PC.category_id IN (36) AND PSPA.attribute_id IN ( SELECT I.finish_id FROM pri_store_product_index_2 AS I WHERE I.categories_urls LIKE CONCAT('%', PCT.url ,'%') ) ) as Products ON Products.finish_id = ORDER BY Finishs.sort_order ASC