Time : 12:02:32
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
Raw SQL : insert into invoicedetail(CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,ADJUSTMENTDATE,adjustmentamount,suborder,DRCR,ROOTID,STRIPID,REFERENCENO,invoicefromdate,invoicetodate,LEDGER) values(:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:ADJUSTMENTDATE,:adjustmentamount,:suborder,:DRCR,:ROOTID,:STRIPID,:REFERENCENO,:invoicefromdate,:invoicetodate,:LEDGER)

Time : 12:01:29
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
Raw SQL : insert into invoicedetail(CREATEDDATE,CREATEDBY,UPDATEDBY,UPDATEDDATE,ADJUSTMENTDATE,adjustmentamount,suborder,DRCR,ROOTID,STRIPID,REFERENCENO,invoicefromdate,invoicetodate,LEDGER) values(:CREATEDDATE,:CREATEDBY,:UPDATEDBY,:UPDATEDDATE,:ADJUSTMENTDATE,:adjustmentamount,:suborder,:DRCR,:ROOTID,:STRIPID,:REFERENCENO,:invoicefromdate,:invoicetodate,:LEDGER)

Time : 06:40:29
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'MAGZINEEDITIONID' in 'where clause'
Raw SQL : select DATEOFEDITIONS from magzineeditions where MAGZINEEDITIONID=145

Time : 06:28: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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=30 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:48
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:47
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=30 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:47
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:47
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:47
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:47
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27: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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27: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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27: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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27: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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:44
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:40
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=30 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:26
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:27:24
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 'Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 10
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=15 Apr 2017
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:26:32
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 'group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 11
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 06:26: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 'group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc' at line 11
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,ps.PAGENAME,m.VALUE as color,ab.ORDERNO,if(sos.ISPAGEFIX=0,'UnFix',if(sos.ISPAGEFIX is null, 'UnFix','Fix')) as pagefixval from advertisementbooking ab 
inner join suborders sos on sos.ADVERTISEBOOKINGID=ab.ADVERTISEMENTBOOKINGID
inner join partydetail p on p.PARTYID=ab.PARTY
inner join contact co on co.PARTY=p.PARTYID
inner join countrystatecity csc on csc.COUNTRYSTATECITYID=co.CITY
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
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 03:38:50
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 NAME from partydetail where PARTYID=

Time : 03:38:49
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 NAME from partydetail where PARTYID=

Time : 03:38:49
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 NAME from partydetail where PARTYID=

Time : 03:38:49
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 NAME from partydetail where PARTYID=

Time : 03:38:48
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 NAME from partydetail where PARTYID=

Time : 03:38:48
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 NAME from partydetail where PARTYID=

Time : 03:38:47
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 NAME from partydetail where PARTYID=

Time : 03:38:47
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 NAME from partydetail where PARTYID=