SELECT
contract.title, /*название договора*/
contract.id, /*код договора*/
account.contractId, /*код устройства?*/
SUM(account.amount), /*наработка сессии в байтах/секундах*/
SUM(account.account) /*наработка сессии в рублях*/
FROM
   inet_session_log_account_2_201311 AS account /* наработка по услугам для завершенных сесиий*/
      LEFT JOIN inet_session_log_2_201311 AS session_log /*завершенные сессии */
         ON account.sessionId = session_log.id
      LEFT JOIN inet_serv_2 AS serv /*сервис*/
         ON session_log.servId = serv.id
      LEFT JOIN contract as contract /*договор*/
         ON serv.contractId   = contract.id
   GROUP BY contract.id
   WITH  ROLLUP;

SELECT * FROM (
   SELECT
      SUM(a.amount),
      contract.title as cttl,
      type.title,
      type.id AS tid,
      contract.id
   FROM
      inet_session_log_detail_2_201311 AS a
         LEFT JOIN inet_session_log_2_201311 AS log
            ON a.sessionId=log.id
       LEFT JOIN inet_serv_2 AS serv
          ON log.servId=serv.id
       LEFT JOIN inet_traffic_type_2 AS type
          ON a.trafficTypeId=type.id
       LEFT JOIN contract AS contract
          ON serv.contractId=contract.id 
   GROUP BY tid, contract.id WITH  ROLLUP)

AS pres ORDER BY pres.id DESC, pres.title DESC

SELECT * FROM (
   SELECT
      SUM(a.amount),
      contract.title as cttl,
      contract.id
   FROM
      inet_session_log_detail_2_201311 AS a /*детализация завершенных сессий*/
         LEFT JOIN inet_session_log_2_201311 AS log /*завершенные сессии*/
            ON a.sessionId=log.id
       LEFT JOIN inet_serv_2 AS serv /*сервис*/
          ON log.servId=serv.id
       LEFT JOIN contract AS contract
          ON serv.contractId=contract.id 
   GROUP BY contract.id WITH  ROLLUP)

AS pres ORDER BY pres.id DESC;

SELECT
   pres.title,
   pres.amount,
   money.account

FROM (
   SELECT
      SUM(a.amount) AS amount,
      contract.title AS title,
      contract.id
   FROM
      inet_session_log_detail_2_201311 AS a
       LEFT JOIN inet_session_log_2_201311 AS log
            ON a.sessionId=log.id
       LEFT JOIN inet_serv_2 AS serv
          ON log.servId=serv.id
       LEFT JOIN inet_traffic_type_2 AS type
          ON a.trafficTypeId=type.id
       LEFT JOIN contract AS contract
          ON serv.contractId=contract.id
       WHERE a.trafficTypeId IN (1,2)
   GROUP BY contract.id WITH  ROLLUP ) AS pres
LEFT JOIN (
   SELECT
      SUM(account.account) AS account,
      contract.title,
      contract.id
   FROM
      inet_session_log_account_2_201311  AS account
      LEFT JOIN inet_session_log_2_201311 AS log
         ON account.sessionId = log.id
      LEFT JOIN inet_serv_2 AS serv
         ON log.servId = serv.id
      LEFT JOIN contract AS contract
         ON serv.contractId=contract.id
      GROUP BY contract.id WITH  ROLLUP ) AS money
   ON pres.id = money.id

ORDER BY pres.id DESC