Информация о версии:

  Клиент: вер. 6.1.842 / 31.03.2015 18:02:43
    os: Windows 7; java: Java HotSpot(TM) Client VM, v.1.8.0_31
    ВНИМАНИЕ: Спецификация версии 1.8 не рекомендуется
  Сервер: вер. 6.1.1061 / 03.04.2015 15:11:09
    os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_67

  bill: вер. 6.1.257 / 20.03.2015 15:47:58
  card: вер. 6.1.205 / 11.03.2015 20:02:46
  inet: вер. 6.1.685 / 03.04.2015 15:11:32
  npay: вер. 6.1.189 / 03.04.2015 15:11:33
  phone: вер. 6.1.250 / 23.03.2015 19:26:46
  reports: вер. 6.1.199 / 30.03.2015 17:25:55
  ru.bitel.bgbilling.plugins.cladr: вер. 6.1.115 / 08.02.2015 20:45:26

Окружение:

  Клиент:
    os: Windows 7 x86, 6.1
    java: Java HotSpot(TM) Client VM, v.1.8.0_31
    jre home: C:\Program Files (x86)\Java\jre1.8.0_31
    default tz: 08.04.2015 23:32 MSK +0300 (Europe/Moscow)
    user tz: 08.04.2015 23:32 AST +0300 (Asia/Baghdad)
    locale: ru_RU
  Сервер:
    os: Linux amd64, 3.2.0-4-amd64
    java: Java HotSpot(TM) 64-Bit Server VM, v.1.7.0_67
    jre home: /opt/java/jdk1.7.0_67/jre
    default tz: 08.04.2015 23:16 MSK +0300 (Europe/Moscow)
    locale: ru_RU

SELECT service.title, log.sid, COUNT(log.id), SUM(log.session_time), SUM(log.round_session_time), SUM(log.cost) FROM service
LEFT JOIN log_session_73_200907 AS log ON service.id=log.sid
LEFT JOIN contract ON contract.id=log.cid
GROUP BY log.sid

SELECT session.dest_id, dest.title, codes.code, COUNT(session.id) as cnt,
SUM(session.round_session_time) as round_session_time, SUM(session.cost) as cost
FROM log_session_73_200907 as session
LEFT JOIN contract ON session.cid=contract.id
LEFT JOIN phone_dest_73 as dest ON session.dest_id=dest.id
LEFT JOIN phone_geographic_code_73
 as codes ON codes.dest_id=dest.id
GROUP BY dest_id

SELECT session.dest_id, dest.title, codes.code, COUNT(session.id) as cnt,
SUM(session.round_session_time) as round_session_time, SUM(session.cost) as cost

FROM bgbilling.log_session_4_201504 as session
LEFT JOIN bgbilling.contract ON session.cid=contract.id
LEFT JOIN bgbilling.phone_dest_4 as dest ON session.dest_id=dest.id
LEFT JOIN bgbilling.phone_geographic_code_4
 as codes ON codes.dest_id=dest.id
GROUP BY dest_id

select *
from bgbilling.phone_geographic_code_4
where code=790300

SELECT count(id)
FROM bgbilling.log_session_4_201504
where dest_id='837'
#codes='790300'
;

select dest_id,code
from bgbilling.phone_geographic_code_4
where dest_id=837
;

select group_concat(gc.code), gc.dest_id, count(*) as cc, dest.title from phone_geographic_code_73  as gc
left join phone_dest_73 as dest on gc.dest_id=dest.id
group by dest_id having cc > 1

781830,781831,781832,781833,781834,781835,781836,781837,781838,781839,781840,781841,781842,781843,781844,781845,781846,781847,781848,781849,781850,781851,781852,781854,781855,781856,781858,781859   164011   28   Архангельская область/ Ненецкий АО {1}
78173,78174,78175   164023   3   Вологодская область {1}
....

SELECT session.dest_id, dest.title, COUNT(session.id) as cnt,
SUM(session.round_session_time) as round_session_time, SUM(session.cost) as cost

FROM bgbilling.log_session_4_201504 as session
LEFT JOIN bgbilling.contract ON session.cid=contract.id
LEFT JOIN bgbilling.phone_dest_4 as dest ON session.dest_id=dest.id

GROUP BY session.dest_id