string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 314 " Non-Structural Design | Genesis

Non-Structural Design

Portfolio

Non-Structural Design

Portfolio

Premier Projects

Other Projects

Riverview Farms Streambank Restoration
Madison County, FL
Services: Engineering

Disciplines::__set_state(array( ))