County

Details of the item

< Previous   Next >

   

   Accomack County
   VA
   51001
   01480091
   
   
   
   
   Non-metro < 5k non-metro-adjacent
   manufacturing-dependent


   

 

PLACE (INCORPORATED)

[08] Error: during query execution. SELECT `place_vw`.`place`, `place_vw`.`place_geoid`, `place_vw`.`place_id`, `place_vw`.`ansi_code`, `place_vw`.`county_geoid`, `county_vw____2`.`county` AS `county_vw____county____2`, `county_vw____2`.`county_geoid` AS `county_vw____county_geoid____2`, `place_vw`.`state_code`, `state____1`.`state_abbrev` AS `state____state_abbrev____1`, `place_vw`.`functstat_code`, `functstat____1`.`functstat` AS `functstat____functstat____1`, `functstat____1`.`functstat_code` AS `functstat____functstat_code____1`, `place_vw`.`lsad_code`, `lsad____1`.`lsad` AS `lsad____lsad____1`, `lsad____1`.`lsad_code` AS `lsad____lsad_code____1`, `place_vw`.`cbsa_code`, `cbsa____1`.`cbsa` AS `cbsa____cbsa____1`, `cbsa____1`.`cbsa_code` AS `cbsa____cbsa_code____1`, `place_vw`.`csa_code`, `csa____1`.`csa` AS `csa____csa____1`, `csa____1`.`csa_code` AS `csa____csa_code____1`, `place_vw`.`principal_city`, `place_vw`.`map_query` FROM `place_vw` LEFT JOIN `county_vw` AS `county_vw____2` ON `place_vw`.`county_geoid` = `county_vw____2`.`county_geoid` LEFT JOIN `state` AS `state____1` ON `place_vw`.`state_code` = `state____1`.`state_code` LEFT JOIN `functstat` AS `functstat____1` ON `place_vw`.`functstat_code` = `functstat____1`.`functstat_code` LEFT JOIN `lsad` AS `lsad____1` ON `place_vw`.`lsad_code` = `lsad____1`.`lsad_code` LEFT JOIN `cbsa` AS `cbsa____1` ON `place_vw`.`cbsa_code` = `cbsa____1`.`cbsa_code` LEFT JOIN `csa` AS `csa____1` ON `place_vw`.`csa_code` = `csa____1`.`csa_code` WHERE `place_vw`.`county_geoid` = '51001' ORDER BY `cnecta____cnecta____1` ASC, `cnecta____cnecta_code____1`, `place_vw`.`place_id` LIMIT 0, 10
The DBMS server said: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cnecta____cnecta____1' in 'order clause'