mysql> SELECT SUM(case when calltransactiontype='01' AND inservicekey IN (11,25) THEN callduration END)/60 as min_moc_prepago, SUM(case when calltransactiontype='01' AND inFlag IS NULL THEN callduration END)/60 as min_moc_pospago, SUM(case when calltransactiontype='02' THEN callduration END)/60 as min_entrante -> FROM cdr_20070510 -> WHERE calltransactiontype IN ('01','02') AND NOT (tgrpnameog like '_IP%' AND (dialledotherpartyb!='a600' AND dialledotherpartyb!='a666')) AND NOT(calltransactiontype='02' AND (dialledotherpartyb regexp '^30[01234]' OR dialledotherpartyb regexp '^5730[01234]')) -> ;+-----------------+-----------------+--------------+| min_moc_prepago | min_moc_pospago | min_entrante |+-----------------+-----------------+--------------+| 5590123.0167 | 3097814.6167 | 2219658.0000 | +-----------------+-----------------+--------------+1 row in set (2 min 18.30 sec)mysql> flush tables;Query OK, 0 rows affected (0.00 sec)mysql> flush query cache;Query OK, 0 rows affected (0.00 sec)mysql> SELECT SUM(case when calltransactiontype='01' AND inservicekey IN (11,25) THEN callduration END)/60 as min_moc_prepago, SUM(case when calltransactiontype='01' AND inFlag IS NULL THEN callduration END)/60 as min_moc_pospago, SUM(case when calltransactiontype='02' THEN callduration END)/60 as min_entrante -> FROM cdr_20070510 -> WHERE calltransactiontype IN ('01','02') AND IF(tgrpnameog like '_IP%' AND NOT (dialledotherpartyb='a600' OR dialledotherpartyb='a666'),0,1) AND IF(calltransactiontype='02' AND (dialledotherpartyb regexp '^30[01234]' OR dialledotherpartyb regexp '^5730[01234]'),0,1);+-----------------+-----------------+--------------+| min_moc_prepago | min_moc_pospago | min_entrante |+-----------------+-----------------+--------------+| 5590123.0167 | 3097814.6167 | 2219658.0000 | +-----------------+-----------------+--------------+1 row in set (43.43 sec)mysql> desc SELECT SUM(case when calltransactiontype='01' AND inservicekey IN (11,25) THEN callduration END)/60 as min_moc_prepago, SUM(case when calltransactiontype='01' AND inFlag IS NULL THEN callduration END)/60 as min_moc_pospago, SUM(case when calltransactiontype='02' THEN callduration END)/60 as min_entrante -> FROM cdr_20070510 -> WHERE calltransactiontype IN ('01','02') AND NOT (tgrpnameog like '_IP%' AND (dialledotherpartyb!='a600' AND dialledotherpartyb!='a666')) AND NOT(calltransactiontype='02' AND (dialledotherpartyb regexp '^30[01234]' OR dialledotherpartyb regexp '^5730[01234]'));+----+-------------+--------------+------+---------------------------------------------+------+---------+------+----------+-------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+----+-------------+--------------+------+---------------------------------------------+------+---------+------+----------+-------------+| 1 | SIMPLE | cdr_20070510 | ALL | ix_nombre_tabla_ctt,ix_nombre_tabla_dialled | NULL | NULL | NULL | 18068346 | Using where | +----+-------------+--------------+------+---------------------------------------------+------+---------+------+----------+-------------+1 row in set (0.00 sec)mysql> desc SELECT SUM(case when calltransactiontype='01' AND inservicekey IN (11,25) THEN callduration END)/60 as min_moc_prepago, SUM(case when calltransactiontype='01' AND inFlag IS NULL THEN callduration END)/60 as min_moc_pospago, SUM(case when calltransactiontype='02' THEN callduration END)/60 as min_entrante -> FROM cdr_20070510 -> WHERE calltransactiontype IN ('01','02') AND IF(tgrpnameog like '_IP%' AND NOT (dialledotherpartyb='a600' OR dialledotherpartyb='a666'),0,1) AND IF(calltransactiontype='02' AND (dialledotherpartyb regexp '^30[01234]' OR dialledotherpartyb regexp '^5730[01234]'),0,1);+----+-------------+--------------+------+---------------------+------+---------+------+----------+-------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+----+-------------+--------------+------+---------------------+------+---------+------+----------+-------------+| 1 | SIMPLE | cdr_20070510 | ALL | ix_nombre_tabla_ctt | NULL | NULL | NULL | 18068346 | Using where | +----+-------------+--------------+------+---------------------+------+---------+------+----------+-------------+1 row in set (0.00 sec)