SELECT * FROM products
LEFT JOIN cats ON products.ID = cats.PID LEFT JOIN `classification` ON `products`.`ID` = `classification`.`product_id` WHERE `type` IN ('Gas') AND `style` ='Freestanding Stove' AND `name` ='Contemporary' AND `type` ='Gas' ORDER BY `ID`