Location SQL

SELECT * FROM (SELECT start_index, end_index, query_cid FROM aggregator.query_flow_t 
WHERE flow_id=(SELECT id FROM query.flow_t WHERE name='Country')) as t, aggregator.insight_t as u
WHERE u.query_cid=t.query_cid AND u.data_index BETWEEN t.start_index AND t.end_index;