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 'order by q.id desc limit 0 , 10' at line 1

SELECT q.*,qc.name as categoryname,qc.page_url as categorypage_url,qc.id as categoryid,@rownum := @rownum +1 AS serial_number FROM quiz q LEFT JOIN quiz_category qc ON qc.id=q.quiz_category,(SELECT @rownum := 0) r where q.id <> 0 and q.is_active=1 and q.quiz_category= order by q.id desc limit 0 , 10

Filename: models/Quiz_model.php

Line Number: 21