SELECT * FROM products
LEFT JOIN cats ON products.ID = cats.PID LEFT JOIN `classification` ON `products`.`ID` = `classification`.`product_id` WHERE `type` IN ('Wood') AND `style` ='New Construction' AND `name` IN('Wood Fireplace') AND `type` ='Wood' ORDER BY `ID`