SELECT * FROM buildings WHERE (type = '#category#') AND (description <> 'Unassigned') ORDER BY displaypriority,description SELECT * FROM projects WHERE ((primarytype = '#buildingtype#') OR (secondarytype = '#buildingtype#')) ORDER BY displaypriority,description SELECT * FROM projects WHERE ((primarytype = '#buildingtype#') OR (secondarytype = '#buildingtype#')) ORDER BY displaypriority,description SELECT * FROM projects WHERE id = #nProjectID# SELECT * FROM images WHERE projectid = #nProjectID# ORDER BY displaypriority,description SELECT * FROM config

#ucase(category)# #buildingtype# #description#

Commercial | Residential | Land Planning #description##Description# |  #qProject.description# #qProject.subtitle# #qImages.description# Project Statistics Structural System #StructuralSystem# Building Area #buildingarea# Facade #Facade# Location #Location# Completion Date #CompletionDate# Project Number #ProjectNumber# Site Use #StructuralSystem# Site Area #buildingarea# Location #Location# Completion Date #CompletionDate# Units Per Acre #Facade# Direct Design, Ltd. - Architects, 3321 South Route 31, Prairie Grove, IL 60012 (815) 444-8444