Browse CELTA and DELTA Course locations

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

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

    [1] => stdClass Object
        (
            [provider] => Athens, Greece
            [provider_longitude] => 23.7300185
            [provider_latitude] => 37.9830886
            [provider_district_city] => Athens
            [provider_country] => Greece
        )

    [2] => stdClass Object
        (
            [provider] => Auckland, New Zealand
            [provider_longitude] => 174.7626763
            [provider_latitude] => -36.8496572
            [provider_district_city] => Auckland
            [provider_country] => New Zealand
        )

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

    [4] => stdClass Object
        (
            [provider] => Auvergne, France
            [provider_longitude] => 3.8833918
            [provider_latitude] => 45.0446478
            [provider_district_city] => Auvergne
            [provider_country] => France
        )

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

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

    [7] => stdClass Object
        (
            [provider] => Bari, Italy
            [provider_longitude] => 16.8728465
            [provider_latitude] => 41.1195029
            [provider_district_city] => Bari
            [provider_country] => Italy
        )

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

    [9] => stdClass Object
        (
            [provider] => Birmingham, UK
            [provider_longitude] => -1.900203
            [provider_latitude] => 52.4762463
            [provider_district_city] => Birmingham
            [provider_country] => United Kingdom
        )

    [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] => Boston, USA
            [provider_longitude] => -71.0777779
            [provider_latitude] => 42.3508033
            [provider_district_city] => Boston
            [provider_country] => United States
        )

    [12] => stdClass Object
        (
            [provider] => Bournemouth (Central), UK
            [provider_longitude] => -1.8963128
            [provider_latitude] => 50.7208116
            [provider_district_city] => Bournemouth
            [provider_country] => United Kingdom
        )

    [13] => stdClass Object
        (
            [provider] => Brighton (Grand Parade), UK
            [provider_longitude] => -0.1356963
            [provider_latitude] => 50.8247854
            [provider_district_city] => Brighton
            [provider_country] => United Kingdom
        )

    [14] => stdClass Object
        (
            [provider] => Brighton (Hove), UK
            [provider_longitude] => -0.1664705
            [provider_latitude] => 50.8273356
            [provider_district_city] => Hove
            [provider_country] => United Kingdom
        )

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

    [16] => stdClass Object
        (
            [provider] => Budapest, Hungary
            [provider_longitude] => 19.0382089
            [provider_latitude] => 47.525435
            [provider_district_city] => Budapest
            [provider_country] => Hungary
        )

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

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

    [19] => stdClass Object
        (
            [provider] => Cambridge (Central), UK
            [provider_longitude] => 0.0981539
            [provider_latitude] => 52.2086722
            [provider_district_city] => Cambridge
            [provider_country] => United Kingdom
        )

    [20] => stdClass Object
        (
            [provider] => Canterbury (Abbey), UK
            [provider_longitude] => 1.0853192
            [provider_latitude] => 51.2751024
            [provider_district_city] => Canterbury
            [provider_country] => United Kingdom
        )

    [21] => 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
        )

    [22] => stdClass Object
        (
            [provider] => Cardiff, UK
            [provider_longitude] => -3.1850433
            [provider_latitude] => 51.4863255
            [provider_district_city] => Cardiff
            [provider_country] => United Kingdom
        )

    [23] => stdClass Object
        (
            [provider] => Cork (Bridge Street), Ireland
            [provider_longitude] => -8.4729693
            [provider_latitude] => 51.901073
            [provider_district_city] => Cork
            [provider_country] => 
        )

    [24] => stdClass Object
        (
            [provider] => Cork (St Patrick's Hill), Ireland
            [provider_longitude] => -8.471845
            [provider_latitude] => 51.9022351
            [provider_district_city] => Cork
            [provider_country] => Ireland
        )

    [25] => 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
        )

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

    [27] => stdClass Object
        (
            [provider] => Eastbourne, UK
            [provider_longitude] => 0.2841779
            [provider_latitude] => 50.767072
            [provider_district_city] => Eastbourne
            [provider_country] => United Kingdom
        )

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

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

    [30] => stdClass Object
        (
            [provider] => Gran Canaria, Spain
            [provider_longitude] => -15.4176022
            [provider_latitude] => 28.1042373
            [provider_district_city] => Gran Canaria
            [provider_country] => Spain
        )

    [31] => stdClass Object
        (
            [provider] => Istanbul (Cekmekoy), Turkey
            [provider_longitude] => 29.2566625
            [provider_latitude] => 41.0324841
            [provider_district_city] => Istanbul
            [provider_country] => Türkiye
        )

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

    [33] => stdClass Object
        (
            [provider] => Istanbul (Taksim), Turkey
            [provider_longitude] => 28.9842533
            [provider_latitude] => 41.0333093
            [provider_district_city] => ?stanbul
            [provider_country] => Türkiye
        )

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

    [35] => stdClass Object
        (
            [provider] => Johannesburg, South Africa
            [provider_longitude] => 28.0272591
            [provider_latitude] => -26.1815273
            [provider_district_city] => Johannesburg
            [provider_country] => South Africa
        )

    [36] => stdClass Object
        (
            [provider] => Karachi, Pakistan
            [provider_longitude] => 67.0285344
            [provider_latitude] => 24.8047819
            [provider_district_city] => Karachi City
            [provider_country] => Pakistan
        )

    [37] => stdClass Object
        (
            [provider] => Kyiv, Ukraine
            [provider_longitude] => 30.4710276
            [provider_latitude] => 50.4512204
            [provider_district_city] => Kyiv
            [provider_country] => Ukraine
        )

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

    [39] => stdClass Object
        (
            [provider] => Leeds (Park Square), UK
            [provider_longitude] => -1.5542248
            [provider_latitude] => 53.7977463
            [provider_district_city] => Leeds
            [provider_country] => United Kingdom
        )

    [40] => stdClass Object
        (
            [provider] => Lisbon, Portugal
            [provider_longitude] => -9.2635005
            [provider_latitude] => 39.093172
            [provider_district_city] => Lisbon
            [provider_country] => Portugal
        )

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

    [42] => stdClass Object
        (
            [provider] => London (Covent Garden, Zone 1), UK
            [provider_longitude] => -0.1240321
            [provider_latitude] => 51.5183005
            [provider_district_city] => London
            [provider_country] => United Kingdom
        )

    [43] => 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
        )

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

    [45] => stdClass Object
        (
            [provider] => Los Angeles, (Koreatown) California, USA
            [provider_longitude] => -118.3091387
            [provider_latitude] => 34.0608055
            [provider_district_city] => Los Angeles
            [provider_country] => United States
        )

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

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

    [48] => stdClass Object
        (
            [provider] => Malaga, Spain
            [provider_longitude] => -4.4269156
            [provider_latitude] => 36.721795
            [provider_district_city] => Malaga
            [provider_country] => Spain
        )

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

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

    [51] => stdClass Object
        (
            [provider] => Manchester, UK
            [provider_longitude] => -2.2398282
            [provider_latitude] => 53.4786129
            [provider_district_city] => Manchester
            [provider_country] => United Kingdom
        )

    [52] => stdClass Object
        (
            [provider] => Marseille, France
            [provider_longitude] => 5.3695247
            [provider_latitude] => 43.2898413
            [provider_district_city] => Marseille
            [provider_country] => France
        )

    [53] => stdClass Object
        (
            [provider] => Melbourne (Town Hall), Australia
            [provider_longitude] => 144.9631476
            [provider_latitude] => -37.8160678
            [provider_district_city] => Melbourne
            [provider_country] => Australia
        )

    [54] => stdClass Object
        (
            [provider] => Mexico City, Mexico
            [provider_longitude] => -99.1758966
            [provider_latitude] => 19.409376
            [provider_district_city] => Mexico City
            [provider_country] => Mexico
        )

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

    [56] => stdClass Object
        (
            [provider] => Milan, Italy
            [provider_longitude] => 9.1675624
            [provider_latitude] => 45.4495207
            [provider_district_city] => Milan
            [provider_country] => Italy
        )

    [57] => stdClass Object
        (
            [provider] => Montreal, Canada
            [provider_longitude] => -73.5768245
            [provider_latitude] => 45.5057207
            [provider_district_city] => Montreal
            [provider_country] => Canada
        )

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

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

    [60] => stdClass Object
        (
            [provider] => Oxford (Summertown), UK
            [provider_longitude] => -1.2714938
            [provider_latitude] => 51.7746352
            [provider_district_city] => Oxford
            [provider_country] => United Kingdom
        )

    [61] => stdClass Object
        (
            [provider] => Padua, Italy
            [provider_longitude] => 11.8760856
            [provider_latitude] => 45.4092067
            [provider_district_city] => Padua
            [provider_country] => Italy
        )

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

    [63] => stdClass Object
        (
            [provider] => Perth, Australia
            [provider_longitude] => 115.85339
            [provider_latitude] => -31.9540897
            [provider_district_city] => Perth
            [provider_country] => Australia
        )

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

    [65] => stdClass Object
        (
            [provider] => Portland, Oregon, USA
            [provider_longitude] => -122.6800968
            [provider_latitude] => 45.5272148
            [provider_district_city] => Portland
            [provider_country] => United States
        )

    [66] => stdClass Object
        (
            [provider] => Portsmouth, UK
            [provider_longitude] => -1.09191
            [provider_latitude] => 50.79852
            [provider_district_city] => Portsmouth
            [provider_country] => United Kingdom
        )

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

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

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

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

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

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

    [73] => stdClass Object
        (
            [provider] => Siem Reap, Cambodia
            [provider_longitude] => 103.8410535
            [provider_latitude] => 13.3523311
            [provider_district_city] => Siem Reap
            [provider_country] => Cambodia
        )

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

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

    [76] => stdClass Object
        (
            [provider] => Sydney (Central), Australia
            [provider_longitude] => 151.1994863
            [provider_latitude] => -33.8800125
            [provider_district_city] => Sydney
            [provider_country] => Australia
        )

    [77] => stdClass Object
        (
            [provider] => Sydney (Town Hall), Australia
            [provider_longitude] => 151.2048118
            [provider_latitude] => -33.8733343
            [provider_district_city] => Sydney
            [provider_country] => Australia
        )

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

    [79] => stdClass Object
        (
            [provider] => Toronto (University Avenue), Canada
            [provider_longitude] => -79.3899902
            [provider_latitude] => 43.6546837
            [provider_district_city] => Toronto
            [provider_country] => Canada
        )

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

    [81] => stdClass Object
        (
            [provider] => Vancouver (New Westminster), Canada
            [provider_longitude] => -122.9338793
            [provider_latitude] => 49.1990635
            [provider_district_city] => Vancouver
            [provider_country] => Canada
        )

    [82] => stdClass Object
        (
            [provider] => Vienna, Austria
            [provider_longitude] => 16.4029013
            [provider_latitude] => 48.1941553
            [provider_district_city] => Vienna
            [provider_country] => Austria
        )

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

)