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