BiTel

Звонок правила не тарифицирован!

Contract:    itemId: 162
StartTime=02.07.2010 01:31:36SessionTime=20 PORT_FROM=0 PORT_TO=0 NUM_FROM=79258932211 NUM_FROM_164=79258932211 NUM_TO=74955555020 NUM_TO_164=74955555020ConnectTime=20CallClientCost=0.00

-------------------------------------

SELECT item.*, contract.title
FROM phone_client_item_<mid> AS item
LEFT JOIN contract ON item.cid=contract.id
WHERE item.id=162

mysql> SELECT item.*, contract.title FROM phone_client_item_8 AS item LEFT JOIN contract ON item.cid=contract.id WHERE item.id=179 limit 25;
+-----+------+-----------+------+-----------+------------+-------+-----------------+-----------------+-------+---------+--------+
| id  | cid  | object_id | type | source_id | date1      | date2 | client_services | oper_service_id | alias | comment | title  |
+-----+------+-----------+------+-----------+------------+-------+-----------------+-----------------+-------+---------+--------+
| 179 | 1840 |         0 |    2 |        12 | 2010-05-01 | NULL  |                 |               0 |       |         | 999999 |
+-----+------+-----------+------+-----------+------------+-------+-----------------+-----------------+-------+---------+--------+