A Database Error Occurred

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 'DESC ORDER BY diameter ASC LIMIT 0, 12' at line 3

SELECT * FROM `product` INNER JOIN `product_by_style` ON product.productId = product_by_style.productId WHERE `productStatus` = 1 AND product_by_style.usageId = 3 GROUP BY product.productId DESC ORDER BY diameter ASC LIMIT 0, 12

Filename: /home/nichibom/public_html/models/product_model.php

Line Number: 59