$sql = 'SELECT id,type,year,month,daytime,week,hour,minute,vacancy FROM way WHERE id = (SELECT route_id FROM waypointid WHERE waypoint_id = '.$row["id"].')';
$query = $this->db->query($sql);
$row2 = $query->row_array();
$data['route_id'][] = $row2['id'];
$data['type'][] = $row2['type'];