Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') JOIN `products_stock` ON `products_stock`.`productsStyleID1` = `ps`.`productsS' at line 2
SELECT `ps`.*, `products_stock`.`stock` FROM ((select * from products_style order by sortNum ASC, `productsStyleID` ASC) ps) JOIN `products_stock` ON `products_stock`.`productsStyleID1` = `ps`.`productsStyleID` and products_stock.isUsed = 1 WHERE `ps`.`productsID` = '82' AND `ps`.`type` = 1 GROUP BY `ps`.`productsStyleID`
Filename: /home/dailylifecom/public_html/models/products_model.php
Line Number: 1155