Time : 13:39:46 SQLSTATE[42000]: Syntax error or access violation: 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 '() over (order by MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.sr' at line 1 Raw SQL : select MAGZINEEDITIONSID,DATEOFEDITIONS from (select MAGZINEEDITIONSID ROW_NUMBER() over (order by MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.srNo % 2) = 1 order by DATEOFEDITIONS Time : 13:37:39 SQLSTATE[42000]: Syntax error or access violation: 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 MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.srNo % 2) ' at line 1 Raw SQL : select MAGZINEEDITIONSID,DATEOFEDITIONS from (select id, name, ROW_NUMBER() over (order by MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.srNo % 2) = 1 order by DATEOFEDITIONS Time : 13:32:10 SQLSTATE[42000]: Syntax error or access violation: 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 MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.srNo % 2) ' at line 1 Raw SQL : select MAGZINEEDITIONSID,DATEOFEDITIONS from (select id, name, ROW_NUMBER() over (order by MAGZINEEDITIONSID) as srNo from magzineeditions) t where (t.srNo % 2) = 1 order by DATEOFEDITIONS Time : 09:20:52 SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1 Raw SQL : select PARTYCODE,PARTYID,partydetail.NAME,ADD1,ADD2,CITY,STATE,PINCODE from partydetail,contact where PARTY=PARTYID and addresstype='Billing Address' and PARTYID=