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 = 208 " 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 = 386 " 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 = 302 " 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 = 152 " 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 = 151 " 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 = 384 " 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 = 205 " 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 = 481 " 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 = 385 " 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 = 234 " 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 = 393 " 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 = 522 " 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 = 427 " string(843) " 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 = 68 " 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 = 388 " 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 = 206 " 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 = 536 " 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 = 259 " 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 = 321 " 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 = 552 " 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 = 190 " 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 = 189 " 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 = 246 " string(843) " 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 = 56 " 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 = 505 " 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 = 256 " 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 = 286 " 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 = 355 " 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 = 535 " 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 = 541 " 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 = 540 " 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 = 499 " string(843) " 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 = 59 " 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 = 149 " 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 = 197 " 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 = 387 " string(842) " 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 = 7 " 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 = 160 " 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 = 232 " Construction Administration | Genesis

Construction Administration

Portfolio

Construction Administration

Portfolio

Premier Projects

Balm Boyette Road - Force Main
Riverview, FL
Services: Engineering

Bond Elementary School K
Tallahassee, FL
Services: Engineering, Surveying

Dunedin Community Center - LEED Certified
Dunedin, FL
Services: Engineering, Landscape Architecture, Surveying

Econfina Springs Complex
Bay and Washington Counties, FL
Services: Engineering, Landscape Architecture, Surveying

Falkenburg Road Force Main
Riverview, FL
Services: Engineering

Howard Avenue Drainage / Utility Improvements
Dade City, FL
Services: Engineering, GIS / Geospatial

Mission San Luis
Tallahassee, FL
Services: Engineering, Landscape Architecture, Planning

New Port Richey Street Improvement Projects
New Port Richey, FL
Services: Engineering, Landscape Architecture, Planning

Oelsner Street Drainage
New Port Richey, FL
Services: Engineering

Okaloosa Island Master Plan
Okaloosa County, FL
Services: Engineering, Landscape Architecture, Planning

Reserve at Pradera Amenity Center
Hillsborough County, FL
Services: Engineering, Landscape Architecture, Planning

Rowdies Soccer Training Facility
Hillsborough County, FL
Services: Engineering, Landscape Architecture

Other Projects

Azalea City Trail
Valdosta, GA
Services: Engineering, Landscape Architecture, Planning, Surveying

Buffalo Wild Wings
Brandon, FL
Services: Engineering, Planning

Citrus Park Towncenter Blvd.
Hillsborough County, FL
Services: Engineering, Landscape Architecture

County Line Farms - Utility Extension
Plant City, FL
Services: Engineering, Surveying

FDOT District Five, Districtwide Landscape Architect Design/Review Services
Marion, Sumter, Lake, Flagler, Volusia, Seminole, , FL
Services: Engineering, Landscape Architecture

Gandy & 4th
St. Petersburg, FL
Services: Engineering

HCC Courtyard Plaza, YLRC Building
Ybor City, FL
Services: Engineering, Landscape Architecture

Hillsborough Construction Management Services
Hillsborough County, FL
Services: Engineering

Hogan Street Restoration / ASE
Jacksonville, FL
Services: Engineering, Landscape Architecture

Howard Avenue Drainage Improvement Project
Dade City, FL
Services: Engineering, GIS / Geospatial

JAX Refrigeration Office
City of Jacksonville Beach, FL
Services: Engineering, Landscape Architecture

Little Harbor Bridge Replacement
Bahia Beach, Ruskin, FL
Services: Engineering

Miracle League Field
Tallahassee, FL
Services: Engineering, Surveying

Mission San Luis Historic Reconstruction
Tallahassee, FL
Services: Engineering

Mission San Luis Visitor Parking Area
Tallahassee, FL
Services: Engineering

New Port Richey - 16-Inch Water Main Extension
New Port Richey, FL
Services: Engineering

OceanGate Affordable Housing Community
Atlantic Beach, FL
Services: Engineering, Landscape Architecture, Planning

Okaloosa County Computerized Signal System, Phase 1
Okaloosa County, FL
Services: Engineering, Intelligent Transportation Systems (ITS)

Salt Life Food Shack
St. Augustine Beach, FL
Services: Engineering, Landscape Architecture, Planning

Select Medical Site Expansion
Leon County, FL
Services: Engineering

SR 61 Reconstruction
Tallahassee, FL
Services: Engineering

Stonewood
Brandon, FL
Services: Engineering, Landscape Architecture, Planning

Thomasville Road Flyover
Tallahassee, FL
Services: Engineering

U.S. 41 Symmes Road Force Main Extension
Hillsborough County, FL
Services: Engineering

Westchase
Tampa, FL
Services: Engineering, GIS / Geospatial, Landscape Architecture

Westchase - Swim & Tennis Center
Hillsborough County, FL
Services: Engineering, Landscape Architecture, Planning

Westfield Brandon Town Center
Brandon, FL
Services: Engineering, Landscape Architecture

Disciplines::__set_state(array( ))