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` ='Outdoor' AND `type` ='Gas' AND `name` IN('Contemporary','Linear') ORDER BY `ID`