rendered paste body+----+-------------+------------+--------+--------------------------------+-----------+---------+---------------------------+-------+----------------------------------------------+
| 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 | |
+----+-------------+------------+--------+--------------------------------+-----------+---------+---------------------------+-------+----------------------------------------------+