SELECT src, prefix, number, billsec, z.price ,ROUND(ROUND(billsec/60, 2)*z.price, 2) as bill, t.numbertype, i.ispname,s.subregionname,r.regionname
FROM(
SELECT h.src,  SUBSTRING( RIGHT( LPAD( h.dst, 12,  '9' ) , 10 ) , 1, 3 ) AS prefix ,SUBSTRING( RIGHT( LPAD( h.dst, 12,  '9' ) , 10 ) , 3, 7 ) AS number, h.billsec
FROM  `asteriskcdrdb`.`cdr` h
WHERE  `calldate` 
BETWEEN  '2015-05-06 00:00:00'
AND  '2015-05-12 23:59:00'
AND h.disposition='ANSWERED'
AND LENGTH( h.src ) <=3
AND LENGTH( h.dst ) >3) as b 
inner join astcdr.`codes`  c on prefix=c.abcdef
inner join astcdr.`isp` i on i.uid=c.ispuid
inner join astcdr.`numtype` t on t.uid=c.type
inner join astcdr.`region` r on r.uid=c.regionuid and r.regiontype=t.uid
inner join astcdr.`subregion` s on s.uid=c.subregionuid
inner join astcdr.`zone` z on z.uid=r.zoneuid
WHERE number between `c`.`start` and `c`.`end`

SELECT src, prefix, number, billsec, z.price ,ROUND(ROUND(billsec/60, 2)*z.price, 2) as bill, t.numbertype, i.ispname,s.subregionname,r.regionname
FROM(
SELECT h.src,  SUBSTRING( RIGHT( LPAD( h.dst, 12,  '9' ) , 10 ) , 1, 3 ) AS prefix ,SUBSTRING( RIGHT( LPAD( h.dst, 12,  '9' ) , 10 ) , 3, 7 ) AS number, h.billsec
FROM  `asteriskcdrdb`.`cdr` h
WHERE  `calldate` 
BETWEEN  '2015-05-01 00:00:00'
AND  '2015-05-31 23:59:59'
AND LENGTH( h.src ) <=3
AND LENGTH( h.dst ) >3 AND h.disposition='ANSWERED') as b 
inner join astcdr.`codes`  c on prefix=c.abcdef
inner join astcdr.`zoneinfo` zi on zi.uid=c.zoneinfouid
inner join astcdr.`zone` z on z.uid=zi.zoneuid
inner join astcdr.`isp` i on i.uid=zi.ispuid
inner join astcdr.`numtype` t on t.uid=c.type
inner join astcdr.`region` r on r.uid=zi.regionuid
inner join astcdr.`subregion` s on s.uid=zi.subregionuid
WHERE number between `c`.`start` and `c`.`end`;

+------+-------------+-------+--------+------------------+------------------+---------+------------------------+------+-------------------------------------------------+
| id   | select_type | table | type   | possible_keys    | key              | key_len | ref                    | rows | Extra                                           |
+------+-------------+-------+--------+------------------+------------------+---------+------------------------+------+-------------------------------------------------+
|    1 | SIMPLE      | t     | ALL    | PRIMARY          | NULL             | NULL    | NULL                   |    1 |                                                 |
|    1 | SIMPLE      | h     | ALL    | calldate,bill    | NULL             | NULL    | NULL                   | 4568 | Using where; Using join buffer (flat, BNL join) |
|    1 | SIMPLE      | c     | ref    | abcdef+start+end | abcdef+start+end | 2       | func                   | 1072 | Using index condition; Using where              |
|    1 | SIMPLE      | zi    | eq_ref | PRIMARY,uid      | PRIMARY          | 4       | astcdr.c.zoneinfouid   |    1 |                                                 |
|    1 | SIMPLE      | s     | eq_ref | PRIMARY,uid      | PRIMARY          | 4       | astcdr.zi.subregionuid |    1 |                                                 |
|    1 | SIMPLE      | i     | eq_ref | PRIMARY,uid      | PRIMARY          | 4       | astcdr.zi.ispuid       |    1 |                                                 |
|    1 | SIMPLE      | r     | eq_ref | PRIMARY          | PRIMARY          | 4       | astcdr.zi.regionuid    |    1 |                                                 |
|    1 | SIMPLE      | z     | ALL    | PRIMARY          | NULL             | NULL    | NULL                   |    2 | Using where; Using join buffer (flat, BNL join) |
+------+-------------+-------+--------+------------------+------------------+---------+------------------------+------+-------------------------------------------------+