Time : 11:29:04 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 productId,productName from product where category= Time : 10:16:18 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 productId,productName from product where category= Time : 09:53:54 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 productId,productName from product where category= Time : 09:45:20 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 's Bay Automobiles Ltd.' and ADD1='Plot 1 '' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2134 and NAME='Haq's Bay Automobiles Ltd.' and ADD1='Plot 1 ' Time : 09:44:45 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 's Bay Automobiles Ltd.' and ADD1='Plot 1 '' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2134 and NAME='Haq's Bay Automobiles Ltd.' and ADD1='Plot 1 ' Time : 09:12:31 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 's' and ADD1='Bay Es Ploned'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2134 and NAME='Chowdhury Car's' and ADD1='Bay Es Ploned' Time : 09:12:15 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 's' and ADD1='Bay Es Ploned'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2134 and NAME='Chowdhury Car's' and ADD1='Bay Es Ploned' Time : 09:12:04 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 's' and ADD1='Bay Es Ploned'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2134 and NAME='Chowdhury Car's' and ADD1='Bay Es Ploned' Time : 07:44:11 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 's' and ADD1='54/B-5, Inner Circular Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2072 and NAME='Zaki Car's' and ADD1='54/B-5, Inner Circular Road' Time : 07:43:33 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 's' and ADD1='54/B-5, Inner Circular Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2072 and NAME='Zaki Car's' and ADD1='54/B-5, Inner Circular Road' Time : 07:43:16 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 's' and ADD1='54/B-5, Inner Circular Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2072 and NAME='Zaki Car's' and ADD1='54/B-5, Inner Circular Road' Time : 07:40:16 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 'and NAME='Zaki Car's'' at line 1 Raw SQL : select NAME,CITY,PARTYID from partydetail,contact where PARTYID=PARTY and CITY= and NAME='Zaki Car's' Time : 07:40:12 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 's' and ADD1='54/B-5, Inner Circular Road'' at line 1 Raw SQL : select PARTYID from partydetail,contact where PARTYID=PARTY and CITY=2072 and NAME='Zaki Car's' and ADD1='54/B-5, Inner Circular Road' Time : 03:13:34 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 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