SELECT  aa.indData1 /*0*/, aa.indData2 /*1*/, 320*(aa.dblData1+bb.dblData1)+400*(cc.dblData1+dd.dblData1) /*2*/
FROM    crm_org_sch_data        AS aa
JOIN    crm_org_sch_data        AS bb ON (bb.indData1=aa.indData1 AND bb.indData2=aa.indData2)
JOIN    crm_org_sch_data        AS cc ON (cc.indData1=aa.indData1 AND cc.indData2=aa.indData2)
JOIN    crm_org_sch_data        AS dd ON (dd.indData1=aa.indData1 AND dd.indData2=aa.indData2)
JOIN    crm_org_sch_keys_row    AS a1 ON a1.dataID=aa.id
JOIN    crm_org_sch_keys_row    AS b1 ON b1.dataID=bb.id
JOIN    crm_org_sch_keys_row    AS c1 ON c1.dataID=cc.id
JOIN    crm_org_sch_keys_row    AS d1 ON d1.dataID=dd.id
JOIN    crm_org_sch_keys        AS a2 ON a2.id=a1.keyID
JOIN    crm_org_sch_keys        AS b2 ON b2.id=b1.keyID
JOIN    crm_org_sch_keys        AS c2 ON c2.id=c1.keyID
JOIN    crm_org_sch_keys        AS d2 ON d2.id=d1.keyID
WHERE   1        
    AND ((aa.indData1 BETWEEN 1380650399 AND 1380736799 ))
    AND a2.keyVal="summ.sch.data.1"
    AND b2.keyVal="summ.sch.data.2"
    AND c2.keyVal="summ.sch.data.3"
    AND d2.keyVal="summ.sch.data.4"
GROUP BY   aa.id
ORDER BY   aa.indData1 ASC,
           aa.indData2 ASC

[mysqld]
port                    = 3306
socket                  = /tmp/mysql.sock
disable-log-bin
key_buffer              = 256M
max_allowed_packet      = 1M

table_open_cache        = 2048
sort_buffer_size        = 32M
net_buffer_length       = 8K
read_buffer_size        = 32M
read_rnd_buffer_size    = 32M
myisam_sort_buffer_size = 16M
init_connect            = 'SET NAMES utf8'
character-set-server    = utf8
collation-server        = utf8_general_ci

tmp_table_size          = 512M
max_heap_table_size     = 512M

thread_cache_size       = 64

innodb_buffer_pool_size = 768M
innodb_log_file_size    = 256M

query_cache_size        = 64M
long_query_time         = 1
slow_query_log          = 1
slow_query_log_file     = /var/log/mysql.slow.log

CREATE TABLE IF NOT EXISTS `crm_org_sch_data` (
  `id`       int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cDate`    int(10) unsigned NOT NULL,
  `sessID`   int(10) unsigned NOT NULL,
  `indData1` int(10) unsigned NOT NULL,
  `indData2` int(10) unsigned NOT NULL,
  `indData3` int(10) unsigned NOT NULL,
  `intData1` int(10) unsigned NOT NULL,
  `intData2` int(10) unsigned NOT NULL,
  `intData3` int(10) unsigned NOT NULL,
  `intData4` int(10) unsigned NOT NULL,
  `intData5` int(10) unsigned NOT NULL,
  `dblData1` double NOT NULL,
  `dblData2` double NOT NULL,
  `dblData3` double NOT NULL,
  `dblData4` double NOT NULL,
  `dblData5` double NOT NULL,
  `dblData6` double NOT NULL,
  `dblData7` double NOT NULL,
  `dblData8` double NOT NULL,
  `dblData9` double NOT NULL,
  `txtData1` char(255) NOT NULL,
  `txtData2` char(255) NOT NULL,
  `isActive` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `sessID` (`sessID`),
  KEY `ind1` (`indData1`),
  KEY `ind2` (`indData2`),
  KEY `ind3` (`indData3`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с данными счётчиков'

CREATE TABLE IF NOT EXISTS `crm_org_sch_keys` (
  `id`     int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cDate`  int(10) unsigned NOT NULL,
  `sessID` int(10) unsigned NOT NULL,
  `keyVal` char(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `keyVal` (`keyVal`),
  KEY `sessID` (`sessID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с информацией о ключах для данных счётчиков';

CREATE TABLE IF NOT EXISTS `crm_org_sch_keys_row` (
  `id`     int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cDate`  int(10) unsigned NOT NULL,
  `sessID` int(10) unsigned NOT NULL,
  `keyID`  int(10) unsigned NOT NULL,
  `dataID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_key` (`keyID`,`dataID`),
  KEY `sessID` (`sessID`),
  KEY `dataID` (`dataID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Таблица с информацией о связи ключей с данными счётчиков' 

+----+--------------------+-------+--------+----------------+--------+---------+-----------------+-------+-----------------------------+
| id | select_type        | table | type   | possible_keys  | key    | key_len | ref             | rows  | Extra                       |
+----+--------------------+-------+--------+----------------+--------+---------+-----------------+-------+-----------------------------+
|  1 | PRIMARY            | aa    | ALL    | ind1,ind2      | NULL   | NULL    | NULL            | 21238 | Using where; Using filesort |
|  1 | PRIMARY            | bb    | ref    | ind1,ind2      | ind1   | 4       | crm.aa.indData1 |     1 | Using where                 |
|  1 | PRIMARY            | cc    | ref    | ind1,ind2      | ind1   | 4       | crm.bb.indData1 |     1 | Using where                 |
|  1 | PRIMARY            | dd    | ref    | ind1,ind2      | ind1   | 4       | crm.aa.indData1 |     1 | Using where                 |
|  5 | DEPENDENT SUBQUERY | d2    | const  | PRIMARY,keyVal | keyVal | 96      | const           |     1 | Using index                 |
|  5 | DEPENDENT SUBQUERY | d1    | eq_ref | sc_key,dataID  | sc_key | 8       | const,crm.dd.id |     1 | Using index                 |
|  4 | DEPENDENT SUBQUERY | c2    | const  | PRIMARY,keyVal | keyVal | 96      | const           |     1 | Using index                 |
|  4 | DEPENDENT SUBQUERY | c1    | eq_ref | sc_key,dataID  | sc_key | 8       | const,crm.cc.id |     1 | Using index                 |
|  3 | DEPENDENT SUBQUERY | b2    | const  | PRIMARY,keyVal | keyVal | 96      | const           |     1 | Using index                 |
|  3 | DEPENDENT SUBQUERY | b1    | eq_ref | sc_key,dataID  | sc_key | 8       | const,crm.bb.id |     1 | Using index                 |
|  2 | DEPENDENT SUBQUERY | a2    | const  | PRIMARY,keyVal | keyVal | 96      | const           |     1 | Using index                 |
|  2 | DEPENDENT SUBQUERY | a1    | eq_ref | sc_key,dataID  | sc_key | 8       | const,crm.aa.id |     1 | Using index                 |
+----+--------------------+-------+--------+----------------+--------+---------+-----------------+-------+-----------------------------+
12 rows in set (0.00 sec)