Finn Guest Chair

SELECT * FROM `furniture_db` WHERE (collection IN ('chairs', 'conference') OR collection2 IN ('chairs', 'conference') ) AND collection2 <> 'lounge' AND (`hide` = '0') AND (slug_name = 'finn-guest-chair' OR slug_name = 'finn-conference') AND category LIKE '%finn%' ORDER BY collection, CASE WHEN `product_name` LIKE '%Ottoman%' THEN `sort_cat` WHEN `category` LIKE '%Cot%' THEN `sort_cat` END ,`com`,`col`,`product_name` ASC