Browse CELTA and DELTA Course locations

SELECT provider, provider_longitude, provider_latitude, provider_district_city, provider_country
    	FROM zoho_course_dates
    	
    	GROUP BY provider
    	ASC
    	

Array
(
    [0] => stdClass Object
        (
            [provider] => Adelaide, Australia
            [provider_longitude] => 138.5956627
            [provider_latitude] => -34.9261235
            [provider_district_city] => Adelaide
            [provider_country] => Australia
        )

    [1] => stdClass Object
        (
            [provider] => Alexandria, Egypt
            [provider_longitude] => 29.8147968
            [provider_latitude] => 31.2243285
            [provider_district_city] => Alexandria
            [provider_country] => Egypt
        )

    [2] => stdClass Object
        (
            [provider] => Ankara, Turkey
            [provider_longitude] => 32.650027
            [provider_latitude] => 39.8888531
            [provider_district_city] => Ankara
            [provider_country] => Turkey
        )

    [3] => stdClass Object
        (
            [provider] => Auckland, New Zealand
            [provider_longitude] => 174.7610897
            [provider_latitude] => -36.8448515
            [provider_district_city] => Auckland
            [provider_country] => New Zealand
        )

    [4] => stdClass Object
        (
            [provider] => Austin, USA
            [provider_longitude] => -97.7456221
            [provider_latitude] => 30.2883884
            [provider_district_city] => Austin
            [provider_country] => United States
        )

    [5] => stdClass Object
        (
            [provider] => Bahrain (West Manama)
            [provider_longitude] => 50.408135
            [provider_latitude] => 26.2099634
            [provider_district_city] => West Manama
            [provider_country] => Bahrain
        )

    [6] => stdClass Object
        (
            [provider] => Barcelona (Passeig de Gracia)
            [provider_longitude] => 2.1658997
            [provider_latitude] => 41.391528
            [provider_district_city] => Barcelona
            [provider_country] => Spain
        )

    [7] => stdClass Object
        (
            [provider] => Barcelona (Universitat)
            [provider_longitude] => 2.1275997
            [provider_latitude] => 41.3846883
            [provider_district_city] => Barcelona
            [provider_country] => Spain
        )

    [8] => stdClass Object
        (
            [provider] => Bari, Italy
            [provider_longitude] => 16.8803465
            [provider_latitude] => 41.1185225
            [provider_district_city] => Bari
            [provider_country] => Italy
        )

    [9] => stdClass Object
        (
            [provider] => Bergamo, Italy
            [provider_longitude] => 9.6212009
            [provider_latitude] => 45.6922934
            [provider_district_city] => Bergamo
            [provider_country] => Italy
        )

    [10] => stdClass Object
        (
            [provider] => Bogota, Colombia
            [provider_longitude] => -74.0626177
            [provider_latitude] => 4.6587809
            [provider_district_city] => Bogotá
            [provider_country] => Colombia
        )

    [11] => stdClass Object
        (
            [provider] => Bournemouth (Meyrick Park), UK
            [provider_longitude] => -1.876132
            [provider_latitude] => 50.7299825
            [provider_district_city] => Bournemouth
            [provider_country] => United Kingdom
        )

    [12] => stdClass Object
        (
            [provider] => Brisbane, Australia
            [provider_longitude] => 153.023377
            [provider_latitude] => -27.4674013
            [provider_district_city] => Brisbane
            [provider_country] => Australia
        )

    [13] => stdClass Object
        (
            [provider] => Bristol, UK
            [provider_longitude] => -2.6148873
            [provider_latitude] => 51.4607434
            [provider_district_city] => Bristol
            [provider_country] => United Kingdom
        )

    [14] => stdClass Object
        (
            [provider] => Brittany, France
            [provider_longitude] => -4.2491844
            [provider_latitude] => 48.4501595
            [provider_district_city] => Landerneau
            [provider_country] => France
        )

    [15] => stdClass Object
        (
            [provider] => Budapest, Hungary
            [provider_longitude] => 19.055800
            [provider_latitude] => 47.489440
            [provider_district_city] => Budapest
            [provider_country] => Hungary
        )

    [16] => stdClass Object
        (
            [provider] => Buenos Aires, Argentina
            [provider_longitude] => -58.455663
            [provider_latitude] => -34.5642455
            [provider_district_city] => Buenos Aires
            [provider_country] => Argentina
        )

    [17] => stdClass Object
        (
            [provider] => Cairo, Egypt
            [provider_longitude] => 31.2128526
            [provider_latitude] => 30.0411487
            [provider_district_city] => Cairo
            [provider_country] => Egypt
        )

    [18] => stdClass Object
        (
            [provider] => Cambridge (University Hospital), UK
            [provider_longitude] => 0.1419984
            [provider_latitude] => 52.1742736
            [provider_district_city] => Cambridge
            [provider_country] => United Kingdom
        )

    [19] => stdClass Object
        (
            [provider] => Cape Town (CBD Campus), South Africa
            [provider_longitude] => 18.4213035
            [provider_latitude] => -33.9209101
            [provider_district_city] => Cape Town
            [provider_country] => South Africa
        )

    [20] => stdClass Object
        (
            [provider] => Dubai (Jumeirah Lakes Towers), UAE
            [provider_longitude] => 55.1370774
            [provider_latitude] => 25.0721137
            [provider_district_city] => Dubai
            [provider_country] => United Arab Emirates
        )

    [21] => stdClass Object
        (
            [provider] => Dublin (Dame St), Ireland
            [provider_longitude] => -6.2722613
            [provider_latitude] => 53.344079
            [provider_district_city] => Dublin
            [provider_country] => Ireland
        )

    [22] => stdClass Object
        (
            [provider] => Dublin (Temple Bar), Ireland
            [provider_longitude] => -6.2710811
            [provider_latitude] => 53.3449352
            [provider_district_city] => Dublin 8
            [provider_country] => Ireland
        )

    [23] => stdClass Object
        (
            [provider] => Edinburgh (Manor Place), UK
            [provider_longitude] => -3.2198031
            [provider_latitude] => 55.9499665
            [provider_district_city] => Edinburgh
            [provider_country] => United Kingdom
        )

    [24] => stdClass Object
        (
            [provider] => Edinburgh (Queen Street), UK
            [provider_longitude] => -3.2074976
            [provider_latitude] => 55.9535862
            [provider_district_city] => Edinburgh
            [provider_country] => United Kingdom
        )

    [25] => stdClass Object
        (
            [provider] => Florence, Italy
            [provider_longitude] => 11.258914
            [provider_latitude] => 43.7724098
            [provider_district_city] => Florence
            [provider_country] => Italy
        )

    [26] => stdClass Object
        (
            [provider] => Galway, Ireland
            [provider_longitude] => -9.0514468
            [provider_latitude] => 53.273438
            [provider_district_city] => Galway
            [provider_country] => Ireland
        )

    [27] => stdClass Object
        (
            [provider] => Gran Canaria, Spain
            [provider_longitude] => -15.9795909
            [provider_latitude] => 28.0652901
            [provider_district_city] => Gran Canaria
            [provider_country] => Spain
        )

    [28] => stdClass Object
        (
            [provider] => Istanbul (Besiktas), Turkey
            [provider_longitude] => 29.0056913
            [provider_latitude] => 41.049023
            [provider_district_city] => Istanbul
            [provider_country] => Turkey
        )

    [29] => stdClass Object
        (
            [provider] => Istanbul (Levent), Turkey
            [provider_longitude] => 29.003137
            [provider_latitude] => 41.0891465
            [provider_district_city] => Istanbul
            [provider_country] => Turkey
        )

    [30] => stdClass Object
        (
            [provider] => Izmir, Turkey
            [provider_longitude] => 27.1335093
            [provider_latitude] => 38.424586
            [provider_district_city] => Izmir
            [provider_country] => Turkey
        )

    [31] => stdClass Object
        (
            [provider] => Jakarta, Indonesia
            [provider_longitude] => 106.8231231
            [provider_latitude] => -6.2261737
            [provider_district_city] => Jakarta
            [provider_country] => Indonesia
        )

    [32] => stdClass Object
        (
            [provider] => Jerez, Spain
            [provider_longitude] => -6.1373671
            [provider_latitude] => 36.6864477
            [provider_district_city] => Jerez
            [provider_country] => Spain
        )

    [33] => stdClass Object
        (
            [provider] => Johannesburg, South Africa
            [provider_longitude] => 28.0308387
            [provider_latitude] => -26.1940659
            [provider_district_city] => Johannesburg
            [provider_country] => South Africa
        )

    [34] => stdClass Object
        (
            [provider] => Kobe, Japan
            [provider_longitude] => 135.1878062
            [provider_latitude] => 34.68834
            [provider_district_city] => Kobe
            [provider_country] => Japan
        )

    [35] => stdClass Object
        (
            [provider] => Krakow, Poland
            [provider_longitude] => 19.9363621
            [provider_latitude] => 50.0610687
            [provider_district_city] => Krakow
            [provider_country] => Poland
        )

    [36] => stdClass Object
        (
            [provider] => Lahore, Pakistan
            [provider_longitude] => 74.2764913
            [provider_latitude] => 31.5001286
            [provider_district_city] => Lahore
            [provider_country] => Pakistan
        )

    [37] => stdClass Object
        (
            [provider] => Leeds, UK
            [provider_longitude] => -1.5539291
            [provider_latitude] => 53.7977573
            [provider_district_city] => Leeds
            [provider_country] => United Kingdom
        )

    [38] => stdClass Object
        (
            [provider] => Lisbon, Portugal
            [provider_longitude] => -9.1815166
            [provider_latitude] => 38.7469898
            [provider_district_city] => Lisbon
            [provider_country] => Portugal
        )

    [39] => stdClass Object
        (
            [provider] => Liverpool, UK
            [provider_longitude] => -2.9903361
            [provider_latitude] => 53.4057208
            [provider_district_city] => Liverpool
            [provider_country] => United Kingdom
        )

    [40] => stdClass Object
        (
            [provider] => London (British Museum, Zone 1) UK
            [provider_longitude] => -0.1240321
            [provider_latitude] => 51.5183005
            [provider_district_city] => London
            [provider_country] => United Kingdom
        )

    [41] => stdClass Object
        (
            [provider] => London (Highgate, Zone 3) UK
            [provider_longitude] => -0.1405025
            [provider_latitude] => 51.5779821
            [provider_district_city] => London
            [provider_country] => United Kingdom
        )

    [42] => stdClass Object
        (
            [provider] => London (Russell Square, Zone 1) UK
            [provider_longitude] => -0.1258647
            [provider_latitude] => 51.5214697
            [provider_district_city] => London
            [provider_country] => United Kingdom
        )

    [43] => stdClass Object
        (
            [provider] => London (Soho, Zone 1) UK
            [provider_longitude] => -0.1367837
            [provider_latitude] => 51.5156597
            [provider_district_city] => London
            [provider_country] => United Kingdom
        )

    [44] => stdClass Object
        (
            [provider] => Lyon, France
            [provider_longitude] => 4.8438289
            [provider_latitude] => 45.7675306
            [provider_district_city] => Lyon
            [provider_country] => France
        )

    [45] => stdClass Object
        (
            [provider] => Madrid, Spain
            [provider_longitude] => -3.6958651
            [provider_latitude] => 40.4275406
            [provider_district_city] => Madrid
            [provider_country] => Spain
        )

    [46] => stdClass Object
        (
            [provider] => Malaga, Spain
            [provider_longitude] => -4.4239245
            [provider_latitude] => 36.7218217
            [provider_district_city] => Malaga
            [provider_country] => Spain
        )

    [47] => stdClass Object
        (
            [provider] => Malta (Gzira)
            [provider_longitude] => 14.4885543
            [provider_latitude] => 35.9070757
            [provider_district_city] => Gzira
            [provider_country] => Malta
        )

    [48] => stdClass Object
        (
            [provider] => Malta (Sliema)
            [provider_longitude] => 14.5058614
            [provider_latitude] => 35.9079817
            [provider_district_city] => Sliema
            [provider_country] => Malta
        )

    [49] => stdClass Object
        (
            [provider] => Melbourne (Carlton), Australia
            [provider_longitude] => 144.9629393
            [provider_latitude] => -37.800941
            [provider_district_city] => Melbourne
            [provider_country] => Australia
        )

    [50] => stdClass Object
        (
            [provider] => Mexico City, Mexico
            [provider_longitude] => -99.1777335
            [provider_latitude] => 19.4217448
            [provider_district_city] => Mexico City
            [provider_country] => Mexico
        )

    [51] => stdClass Object
        (
            [provider] => Miami, USA
            [provider_longitude] => -80.1904187
            [provider_latitude] => 25.7820171
            [provider_district_city] => Miami Beach
            [provider_country] => United States
        )

    [52] => stdClass Object
        (
            [provider] => Milan, Italy
            [provider_longitude] => 9.2146583
            [provider_latitude] => 45.4418363
            [provider_district_city] => Milan
            [provider_country] => Italy
        )

    [53] => stdClass Object
        (
            [provider] => Montreal, Canada
            [provider_longitude] => -73.5584615
            [provider_latitude] => 45.5020316
            [provider_district_city] => Montreal
            [provider_country] => Canada
        )

    [54] => stdClass Object
        (
            [provider] => New York City, USA
            [provider_longitude] => -73.9978454
            [provider_latitude] => 40.7463438
            [provider_district_city] => New York
            [provider_country] => United States
        )

    [55] => stdClass Object
        (
            [provider] => Nottingham, UK
            [provider_longitude] => -1.1601456
            [provider_latitude] => 52.9541551
            [provider_district_city] => Nottingham
            [provider_country] => United Kingdom
        )

    [56] => stdClass Object
        (
            [provider] => Oviedo, Spain
            [provider_longitude] => -5.8706031
            [provider_latitude] => 43.3644488
            [provider_district_city] => Oviedo
            [provider_country] => Spain
        )

    [57] => stdClass Object
        (
            [provider] => Oxford (Banbury Road), UK
            [provider_longitude] => -1.2624947
            [provider_latitude] => 51.7647101
            [provider_district_city] => Oxford
            [provider_country] => United Kingdom
        )

    [58] => stdClass Object
        (
            [provider] => Penang, Malaysia
            [provider_longitude] => 100.3200943
            [provider_latitude] => 5.4263643
            [provider_district_city] => Penang
            [provider_country] => Malaysia
        )

    [59] => stdClass Object
        (
            [provider] => Phnom Penh, Cambodia
            [provider_longitude] => 104.9122771
            [provider_latitude] => 11.5342752
            [provider_district_city] => Phnom Penh
            [provider_country] => Cambodia
        )

    [60] => stdClass Object
        (
            [provider] => Prague, Czech Republic
            [provider_longitude] => 14.4506056
            [provider_latitude] => 50.0463017
            [provider_district_city] => Prague
            [provider_country] => Czech Republic
        )

    [61] => stdClass Object
        (
            [provider] => Reggio Calabria, Italy
            [provider_longitude] => 15.6486636
            [provider_latitude] => 38.1200167
            [provider_district_city] => Reggio Calabria
            [provider_country] => Italy
        )

    [62] => stdClass Object
        (
            [provider] => Riviera Maya, Mexico
            [provider_longitude] => -87.0735597
            [provider_latitude] => 20.628541
            [provider_district_city] => Playa del Carmen
            [provider_country] => Mexico
        )

    [63] => stdClass Object
        (
            [provider] => Rome, Italy
            [provider_longitude] => 12.5023187
            [provider_latitude] => 41.8900873
            [provider_district_city] => Rome
            [provider_country] => Italy
        )

    [64] => stdClass Object
        (
            [provider] => San Diego, USA
            [provider_longitude] => -117.1644841
            [provider_latitude] => 32.7187248
            [provider_district_city] => San Diego
            [provider_country] => United States
        )

    [65] => stdClass Object
        (
            [provider] => San Sebastian, Spain
            [provider_longitude] => -1.9707312
            [provider_latitude] => 43.3223768
            [provider_district_city] => San Sebastian
            [provider_country] => Spain
        )

    [66] => stdClass Object
        (
            [provider] => Santiago de Compostela, Spain
            [provider_longitude] => -8.5518393
            [provider_latitude] => 42.8728746
            [provider_district_city] => Santiago de Compostela
            [provider_country] => Spain
        )

    [67] => stdClass Object
        (
            [provider] => Seville, Spain
            [provider_longitude] => -5.9988978
            [provider_latitude] => 37.3898941
            [provider_district_city] => Seville
            [provider_country] => Spain
        )

    [68] => stdClass Object
        (
            [provider] => Sofia, Bulgaria
            [provider_longitude] => 23.3372451
            [provider_latitude] => 42.6989767
            [provider_district_city] => Sofia
            [provider_country] => Bulgaria
        )

    [69] => stdClass Object
        (
            [provider] => Springfield, Missouri, USA
            [provider_longitude] => -93.2831418
            [provider_latitude] => 37.1973139
            [provider_district_city] => Springfield
            [provider_country] => United States
        )

    [70] => stdClass Object
        (
            [provider] => Strasbourg, France
            [provider_longitude] => 7.7417812
            [provider_latitude] => 48.5553242
            [provider_district_city] => Strasbourg
            [provider_country] => France
        )

    [71] => stdClass Object
        (
            [provider] => Sydney (CBD), Australia
            [provider_longitude] => 151.2065881
            [provider_latitude] => -33.8687826
            [provider_district_city] => Sydney
            [provider_country] => Australia
        )

    [72] => stdClass Object
        (
            [provider] => Toronto (Eglinton Avenue), Canada
            [provider_longitude] => -79.4047083
            [provider_latitude] => 43.7060351
            [provider_district_city] => Toronto
            [provider_country] => Canada
        )

    [73] => stdClass Object
        (
            [provider] => Toronto (Jarvis Street), Canada
            [provider_longitude] => -79.3770525
            [provider_latitude] => 43.6578661
            [provider_district_city] => Toronto
            [provider_country] => Canada
        )

    [74] => stdClass Object
        (
            [provider] => Valencia, Spain
            [provider_longitude] => -0.3587393
            [provider_latitude] => 39.4845542
            [provider_district_city] => Valencia
            [provider_country] => Spain
        )

    [75] => stdClass Object
        (
            [provider] => Vancouver (W Pender Street) Canada
            [provider_longitude] => -123.1092906
            [provider_latitude] => 49.2804921
            [provider_district_city] => Vancouver
            [provider_country] => Canada
        )

    [76] => stdClass Object
        (
            [provider] => Warsaw, Poland
            [provider_longitude] => 21.0023121
            [provider_latitude] => 52.2175723
            [provider_district_city] => Warsaw
            [provider_country] => Poland
        )

    [77] => stdClass Object
        (
            [provider] => Wroclaw, Poland
            [provider_longitude] => 17.0272393
            [provider_latitude] => 51.1103369
            [provider_district_city] => Wroclaw
            [provider_country] => Poland
        )

)