SELECT SP_Projects.*, State_Lookup.State
FROM SP_Projects
INNER JOIN State_Lookup ON SP_Projects.ProjectState=State_Lookup.Abbreviation
WHERE Abbreviation=''
ORDER BY State
|
|
file="data/sk8folio/"+data.IMAGE_Photo1;
store="data/sk8folio/60w/"+data.IMAGE_Photo1;
file="data/sk8folio/"+data.IMAGE_Photo2;
store="data/sk8folio/60w/"+data.IMAGE_Photo2;
|
,
Skatepark Location:
Completed:
|
|
back to search
SELECT Distinct ProjectState, Abbreviation, State
FROM SP_Projects
INNER JOIN State_Lookup ON SP_Projects.ProjectState=State_Lookup.Abbreviation
ORDER BY ProjectState
Click here to view our photo gallery of Sk8park International installs throughout the nation.
|
