BiTel

04.03.2009 10:05:06 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9)  ORDER BY contract.title
04.03.2009 10:05:06 getting results
131
04.03.2009 10:05:44 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (10)  ORDER BY contract.title
04.03.2009 10:05:44 getting results
90
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
[Fatal Error] :1:1: Content is not allowed in prolog.
04.03.2009 10:07:43 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9)  ORDER BY contract.title
04.03.2009 10:07:43 getting results
114
04.03.2009 10:51:40 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13)  ORDER BY contract.title
04.03.2009 10:51:40 getting results
138
04.03.2009 11:02:12 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13)  ORDER BY contract.title
04.03.2009 11:02:12 getting results
125
04.03.2009 11:02:53 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13)  ORDER BY contract.title
04.03.2009 11:02:53 getting results
116
04.03.2009 11:03:08 SELECT contract.title, contract.comment, address.address,  phone.val as phone_number, contract.status,  tariff_plan.title as tariff, contract.date1 as date_start, contract.date2 as date_end, que.val as queue, (b.summa1 + b.summa2 - b.summa3 - b.summa4) as balance, status.date1 as statusDate, status.status as statusN, status.comment as reason,   service.date1 as serviceDate,  mobile.val as mobile_number, serviceCer.date1 as cerDate FROM contract  LEFT JOIN contract_parameter_type_1 as phone ON contract.id=phone.cid AND phone.pid=1 LEFT JOIN contract_parameter_type_2 as address ON contract.id=address.cid AND address.pid=3 LEFT JOIN contract_tariff  on contract_tariff.cid = contract.id AND (contract_tariff.date1 <= ? OR contract_tariff.date1 is NULL)  AND  (contract_tariff.date2 >= ? OR contract_tariff.date2 is NULL)  LEFT JOIN tariff_plan  on contract_tariff.tpid= tariff_plan.id LEFT JOIN contract_parameter_type_1 as que ON contract.id=que.cid AND que.pid=1 LEFT JOIN address_house as house ON house.id=address.hid LEFT JOIN temp_balance  ON temp_balance.cid=contract.id  LEFT JOIN contract_balance as b  ON b.cid=contract.id AND  b.mm = temp_balance.mm AND b.yy = temp_balance.yy LEFT JOIN temp_status  ON temp_status.cid=contract.id  LEFT JOIN contract_status as status  on status.cid = contract.id AND (status.date1 <= ? OR status.date1 is NULL)  AND  (status.date2 >= ? OR status.date2 is NULL) AND status.date1 = temp_status.date  AND (status.status = 3 OR status.status = 4) LEFT JOIN temp_service ON temp_service.cid=contract.id  LEFT JOIN contract_service as service  on service.cid = contract.id AND (service.date1 <= ? OR service.date1 is NULL)  AND  (service.date2 >= ? OR service.date2 is NULL) AND service.date1 = temp_service.date AND  service.sid = 1 LEFT JOIN contract_parameter_type_1 as mobile ON contract.id=mobile.cid AND mobile.pid=1 LEFT JOIN  contract_service as serviceCer ON serviceCer.cid = contract.id AND serviceCer.sid = 1 WHERE 1=1 AND contract_tariff.tpid IN (6, 7, 8, 9, 10, 11, 12, 13)  ORDER BY contract.title
04.03.2009 11:03:08 getting results
114