Time : 14:29:21
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'PARTYID' in field list is ambiguous
Raw SQL : select distinct PARTYID,WEBSITE,PARTYCODE,EMAIL,NAME,logo from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid  and PARTYID in (select PARTY from contact where STATE in (7)) order by partydetail.NAME asc

Time : 14:28:43
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'PARTYID' in field list is ambiguous
Raw SQL : select distinct PARTYID,WEBSITE,PARTYCODE,EMAIL,NAME,logo from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid  and PARTYID in (select PARTY from contact where STATE in (7)) order by partydetail.NAME asc

Time : 14:28:23
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'PARTYID' in field list is ambiguous
Raw SQL : select distinct PARTYID,WEBSITE,PARTYCODE,EMAIL,NAME,logo from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid  and PARTYID in (select PARTY from contact where STATE in (7)) order by partydetail.NAME asc

Time : 14:20:09
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'PARTYID' in field list is ambiguous
Raw SQL : select count(PARTYID) as totalnew_contact from dealsin,contact,partydetail,productmapping where partydetail.PARTYID=dealsin.PARTY and contact.PARTY=partydetail.PARTYID and partydetail.PARTYID=productmapping.partyid  order by partydetail.NAME asc

Time : 14:16: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 '' at line 1
Raw SQL : select ipaddress from p_customers where customerid=

Time : 14:16:42
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 ipaddress from p_customers where customerid=

Time : 14:16:10
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 ipaddress from p_customers where customerid=

Time : 14:15:59
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 ipaddress from p_customers where customerid=

Time : 14:15:55
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 ipaddress from p_customers where customerid=

Time : 14:15: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 ipaddress from p_customers where customerid=

Time : 14:15: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 '' at line 1
Raw SQL : select ipaddress from p_customers where customerid=

Time : 14:15:30
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 ipaddress from p_customers where customerid=

Time : 13:40:12
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(3)) order by partydetail.NAME asc

Time : 13:39:27
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(3)) order by partydetail.NAME asc

Time : 13:34:12
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(3)) order by partydetail.NAME asc

Time : 13:33:27
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(21)) order by partydetail.NAME asc

Time : 12:28: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 '' at line 1
Raw SQL : select ipaddress from p_customers where customerid=

Time : 11:47: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 ipaddress from p_customers where customerid=

Time : 11:47: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 '' at line 1
Raw SQL : select ipaddress from p_customers where customerid=

Time : 11:47:29
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 ipaddress from p_customers where customerid=

Time : 11:36:26
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where productid in(6)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 11:29:56
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where productid in(6)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 11:29:11
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where productid in(6)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 11:16:57
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subjectid' cannot be null
Raw SQL : insert into p_queries(party_id,customer_id,query,subjectid,adddate) values(:party_id,:customer_id,:query,:subjectid,:adddate)

Time : 11:15:45
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'subjectid' cannot be null
Raw SQL : insert into p_queries(party_id,customer_id,query,subjectid,adddate) values(:party_id,:customer_id,:query,:subjectid,:adddate)

Time : 10:51:27
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 * from partydetail,contact where partydetail.PARTYID=contact.PARTY and partydetail.PARTYID=

Time : 10:50: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 '' at line 1
Raw SQL : select * from partydetail,contact where partydetail.PARTYID=contact.PARTY and partydetail.PARTYID=

Time : 10:49:55
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:46:25
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:45:41
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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 10:45:25
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:35:55
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:34:55
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:34:10
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in ( select PARTYID from productmapping where categoryid in(2)) and LOWER(NAME) like :NAME order by partydetail.NAME asc

Time : 10:13: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 'and p_vacancyapply.vacancy_id=p_vacancy.vacancy_id and p_vacancy.customer_id=2 o' at line 1
Raw SQL : select count(p_vacancyapply.vacancy_id) as totalnew_vacancy from p_vacancyapply,p_vacancy where p_vacancyapply.vacancy_id= and p_vacancyapply.vacancy_id=p_vacancy.vacancy_id and p_vacancy.customer_id=2 order by title asc

Time : 10:12: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 'and p_vacancyapply.vacancy_id=p_vacancy.vacancy_id and p_vacancy.customer_id=1 o' at line 1
Raw SQL : select count(p_vacancyapply.vacancy_id) as totalnew_vacancy from p_vacancyapply,p_vacancy where p_vacancyapply.vacancy_id= and p_vacancyapply.vacancy_id=p_vacancy.vacancy_id and p_vacancy.customer_id=1 order by title asc

Time : 09:17: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 '' at line 1
Raw SQL : select ipaddress from p_customers where customerid=

Time : 09:17:42
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 ipaddress from p_customers where customerid=

Time : 08: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 '' at line 1
Raw SQL : select count(PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in (select PARTY from contact where STATE in (7)) and PARTYID in ( select PARTYID from productmapping where categoryid in(2) order by partydetail.NAME asc

Time : 08:26:59
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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:45: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:32:29
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dealsin.DEALSIN' in 'where clause'
Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in (select PARTY from contact where CITY in (831,832,833)) and dealsin.DEALSIN in(195) order by partydetail.NAME asc

Time : 06:23:17
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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:23:13
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 ipaddress from p_customers where customerid=

Time : 06:22: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 ipaddress from p_customers where customerid=

Time : 06:21: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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:21: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:20: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 COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:20: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:20: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:19: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:19: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 '' at line 1
Raw SQL : select COUNTRYSTATECITYID,NAME from countrystatecity where PARENTID=

Time : 06:06:26
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.CITY' in 'where clause'
Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in (select PARTY from contact where STATE in (8)) and contact.CITY in (831,832,833) order by partydetail.NAME asc

Time : 06:05:40
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.CITY' in 'where clause'
Raw SQL : select count(partydetail.PARTYID) as totalnew_contact from partydetail where NAME!='' and NAME is not NULL  and PARTYID in (select PARTY from contact where STATE in (8)) and contact.CITY in (831,832,833) order by partydetail.NAME asc

Time : 06:04: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 '' at line 1
Raw SQL : select rating from p_ratings where party_id=