Drilldown: Cities
Jump to navigation
Jump to search
Choose a table:
- Authors (435)
- Books (9)
- BPMN Event (5)
- Buildings (0)
- Cities (21)
- Employees (5)
- Fruits (12)
- Glossary (0)
- HELLO (0)
- Ingredients (1)
- Instruments (2)
- Items (3226)
- Items2 (0)
- Item references (62)
- Manuals (0)
- Musicians (5)
- NotRealTable (2)
- Opinions (3694)
- Pages (0)
- Performances (2)
- Products (0)
- Projects (0)
- Project labels (4)
- Sandbox (0)
- Sources (129)
- Statuses (6)
- TableWithALotOfValuesOnOnePage (8)
- Tasks (0)
- Task labels (4)
- Topics (99)
- Versions (0)
- bpmnData (52)
- All files (639)
- ganttData (9)
- All pages (5942)
Use the filters below to narrow your results.
Showing below up to 1 result in range #1 to #1.
Error 1054: Unknown column 'Cities_alias.Coordinates' in 'group statement'
Function: CargoSQLQuery::run
Query: SELECT `Cities_alias`.`_pageName` AS `_pageName`,`Coordinates__full` AS `Coordinates`,`Coordinates__lat` AS `Coordinates lat`,`Coordinates__lon` AS `Coordinates lon` FROM `cargo__Cities` `Cities_alias` WHERE (YEAR(`Cities_alias`.`Date_founded`) >= 1780 AND YEAR(`Cities_alias`.`Date_founded`) <= 1789 ) GROUP BY `Cities_alias`.`_pageName`,`Cities_alias`.`Coordinates` ORDER BY `Cities_alias`.`_pageName`,`Cities_alias`.`Coordinates__full` LIMIT 250