Array ( [0] => bridge-stam-nor [1] => newhaven [2] => atlanticcity [3] => newark-nj [4] => newton-nj [5] => salem-nj [6] => tomsriver-nj [7] => trenton [8] => statewide-nj [9] => longisland [10] => longisland-e [11] => longisland-m [12] => longisland-w [13] => nyc [14] => rock-put-orange [15] => westchesterco ) SELECT city1, artist_id, metro_id, Metro, ST, state_id, State_Prov FROM artistable, lmetros, lstates WHERE ( artistable.city1 = lmetros.metro_id AND lmetros.ST = lstates.state_id AND artistable.artist_id = 'michaelgl' AND artistable.type = 'p' AND (artistable.status = 'ok' OR artistable.access_key='') ) Resource id #10Array ( [city2] => longisland [artist_id] => michaelgl [metro_id] => longisland [Metro] => Long Island [ST] => NY [state_id] => NY [State_Prov] => New York ) Array ( [0] => CT [1] => CT [2] => NJ [3] => NJ [4] => NJ [5] => NJ [6] => NJ [7] => NJ [8] => NJ [9] => NY [10] => NY [11] => NY [12] => NY [13] => NY [14] => NY [15] => NY )
Array ( [0] => ct [1] => ct [2] => nj [3] => nj [4] => nj [5] => nj [6] => nj [7] => nj [8] => nj [9] => ny [10] => ny [11] => ny [12] => ny [13] => ny [14] => ny [15] => ny )
Array ( [0] => Connecticut [1] => Connecticut [2] => New Jersey [3] => New Jersey [4] => New Jersey [5] => New Jersey [6] => New Jersey [7] => New Jersey [8] => New Jersey [9] => New York [10] => New York [11] => New York [12] => New York [13] => New York [14] => New York [15] => New York )