Time : 09:03:56
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 LOWER(productName) = ?' at line 1
Raw SQL : select productId from product where category= and LOWER(productName) = :productName

Time : 05:34:17
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'REMARKS' in field list is ambiguous
Raw SQL : select MAGZINEEDITIONS,ADVERTISEMENTBOOKINGID,ORDERNO,PARTY,NAME,PAGENO,DUMMYPAGENO,TARRIF,PAGESIZE,ISPAGEFIX,REMARKS,SUBORDERSID,POSITION  from advertisementbooking,suborders,partydetail where advertisementbooking.ADVERTISEMENTBOOKINGID=suborders.ADVERTISEBOOKINGID and advertisementbooking.PARTY=partydetail.PARTYID and (ISCANCEL=0 || ISCANCEL IS NULL)  and suborders.MAGZINEEDITIONS=143 order by ADVERTISEMENTBOOKINGID asc limit 0,20

Time : 05:31:36
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'partydetail.PARTYID' in 'where clause'
Raw SQL : select count(advertisementbooking.ADVERTISEMENTBOOKINGID) as totalnew_parties from advertisementbooking,suborders where advertisementbooking.ADVERTISEMENTBOOKINGID=suborders.ADVERTISEBOOKINGID and advertisementbooking.PARTY=partydetail.PARTYID and (ISCANCEL=0 || ISCANCEL IS NULL)  and suborders.MAGZINEEDITIONS=143 order by ADVERTISEMENTBOOKINGID asc