query for cities optimized and currency service added