+----+-------------+------------+--------+--------------------------------+-----------+---------+---------------------------+-------+----------------------------------------------+
| id | select_type | table      | type   | possible_keys                  | key       | key_len | ref                       | rows  | Extra                                        |
+----+-------------+------------+--------+--------------------------------+-----------+---------+---------------------------+-------+----------------------------------------------+
|  1 | PRIMARY     | c          | ALL    | PRIMARY                        | NULL      | NULL    | NULL                      | 31350 | Using temporary; Using filesort              |
|  1 | PRIMARY     | cw         | eq_ref | PRIMARY                        | PRIMARY   | 4       | onespout_live.c.city_id   |     1 | Using where                                  |
|  1 | PRIMARY     | r          | eq_ref | PRIMARY                        | PRIMARY   | 4       | onespout_live.c.region_id |     1 |                                              |
|  1 | PRIMARY     | <derived2> | ALL    | NULL                           | NULL      | NULL    | NULL                      |   191 |                                              |
|  2 | DERIVED     | <derived3> | ALL    | NULL                           | NULL      | NULL    | NULL                      |  3361 | Using temporary; Using filesort              |
|  3 | DERIVED     | ddd        | range  | PRIMARY,timeindex,status_index | timeindex | 8       | NULL                      |  9462 | Using where; Using temporary; Using filesort |
|  3 | DERIVED     | geo        | ref    | deal_id                        | deal_id   | 4       | onespout_live.ddd.deal_id |     1 |                                              |
+----+-------------+------------+--------+--------------------------------+-----------+---------+---------------------------+-------+----------------------------------------------+