Array ( [1] => hartford [2] => albany-ny [3] => nyc [4] => boston [5] => brattleboro-vt [6] => bennington-vt [7] => burlington-vt [8] => keene-nh [9] => manchester [10] => westchesterco [11] => longisland-w [12] => statewide-ct [13] => statewide-ma ) 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 = 'johngr' AND artistable.type = 'd' AND (artistable.status = 'ok' OR artistable.access_key='') ) Resource id #10Array ( [city2] => albany-ny [artist_id] => johngr [metro_id] => albany-ny [Metro] => Albany [ST] => NY [state_id] => NY [State_Prov] => New York ) Array ( [1] => CT [2] => NY [3] => NY [4] => MA [5] => VT [6] => VT [7] => VT [8] => NH [9] => NH [10] => NY [11] => NY [12] => CT [13] => MA )
Array ( [1] => ct [2] => ny [3] => ny [4] => ma [5] => vt [6] => vt [7] => vt [8] => nh [9] => nh [10] => ny [11] => ny [12] => ct [13] => ma )
Array ( [1] => Connecticut [2] => New York [3] => New York [4] => Massachusetts [5] => Vermont [6] => Vermont [7] => Vermont [8] => New Hampshire [9] => New Hampshire [10] => New York [11] => New York [12] => Connecticut [13] => Massachusetts )