select clubname,phone,resort,executive,publi_,private,semiprivate,azfairways,clubid,city from clubs where semiprivate=1 and state='AZ' order by city,clubname num: 51
AJO ALPINE ARIZONA CITY BULLHEAD CITY CASA GRANDE CAVE CREEK CHANDLER DUNCAN EL MIRAGE FLORENCE GOODYEAR GREEN VALLEY KINGMAN LAKE HAVASU LAKE MONTEZUMA MESA MESA MESA MESA MESA MESA MIAMI/GLOBE MUNDS PARK NOGALES OVERGAARD PEARCE/SUNSITES PEORIA PEORIA PHOENIX PHOENIX PRESCOTT SAFFORD SAN MANUAL SEDONA SEDONA SHOW LOW SHOW LOW SUN CITY SUN CITY WEST SUN LAKES SURPRISE SURPRISE TUCSON TUCSON TUCSON TUCSON TUCSON TUCSON WICKENBURG WICKENBURG YUMA select image1name from clubs where image1name is not null order by rand() limit 4 num: 4 index: 86
