Template:Virginia map: Difference between revisions
Jump to navigation
Jump to search
(start) |
(Virginia) |
||
| Line 5: | Line 5: | ||
tables=Parishes | tables=Parishes | ||
|fields=Parishes._pageName, Parishes.Dedication, Parishes.City, Parishes.ParishLocation | |fields=Parishes._pageName, Parishes.Dedication, Parishes.City, Parishes.ParishLocation | ||
|where=Parishes.AdministrativeSubdivision HOLDS LIKE "% | |where=Parishes.AdministrativeSubdivision HOLDS LIKE "%Virginia%" | ||
|format=leaflet | |format=leaflet | ||
|width=400 | |width=400 | ||
Revision as of 09:34, 23 October 2024
|
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HOLDS LIKE "%Virginia%" ORDER BY `cargo__Parishes`.`_pageID`,`cargo__Parishes`.' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Parishes`.`_pageID` AS `cargo_backlink_page_id_Parishes`,`cargo__Parishes`.`_pageName` AS `_pageName`,`cargo__Parishes`.`Dedication` AS `Dedication`,`cargo__Parishes`.`City` AS `City`,`ParishLocation__full` AS `ParishLocation`,`ParishLocation__lat` AS `ParishLocation lat`,`ParishLocation__lon` AS `ParishLocation lon` FROM `cargo__Parishes` WHERE `cargo__Parishes`.`AdministrativeSubdivision` HOLDS LIKE "%Virginia%" ORDER BY `cargo__Parishes`.`_pageID`,`cargo__Parishes`.`_pageName`,`cargo__Parishes`.`Dedication`,`cargo__Parishes`.`City`,`cargo__Parishes`.`ParishLocation__full` LIMIT 100 |
| This map created from a Cargo query () View |