Time : 13:59:03 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by sos.DUMMYPAGENO,tf.COLOR,tf.PAGESIZE,tf.ID,p.NAME asc' at line 1 Raw SQL : select p.PARTYID,sos.DUMMYPAGENO,p.NAME,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,mpos.VALUE as positionfix,ab.remarks,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval,tf.CODE from advertisementbooking ab inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID inner join partydetail p on p.PARTYID=ab.PARTY inner join tarrifdetail tf on tf.ID=sos.TARRIF inner join pagesizes ps on ps.ID=tf.PAGESIZE inner join master m on m.MASTERID=tf.COLOR left outer join master mpos on mpos.MASTERID=sos.POSITION where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) and sos.MAGZINEEDITIONS= order by sos.DUMMYPAGENO,tf.COLOR,tf.PAGESIZE,tf.ID,p.NAME asc