Time : 14:57:36
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 12
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,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 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
left outer join master mpos on mpos.MASTERID=sos.POSITION
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 14:55:05
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 12
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,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 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
left outer join master mpos on mpos.MASTERID=sos.POSITION
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 14:51:13
SQLSTATE[42S22]: Column not found: 1054 Unknown column '$mgiid' in 'where clause'
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,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 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
left outer join master mpos on mpos.MASTERID=sos.POSITION
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=$mgiid
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc

Time : 14:49:28
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 12
Raw SQL : select sos.DUMMYPAGENO,p.NAME,csc.NAME as cityname,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 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
left outer join master mpos on mpos.MASTERID=sos.POSITION
where (sos.ISCANCEL=0 || sos.ISCANCEL IS NULL) 
and sos.MAGZINEEDITIONS=
 group by ab.ADVERTISEMENTBOOKINGID
  order by sos.DUMMYPAGENO asc