Template:Church map: Difference between revisions

From Saintapedia
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
{{#cargo_query:
{{#cargo_query:
tables=Churches
tables=Churches
|fields=_pageName={{PAGENAME}},ParishLocation,MailingAddress
|fields=_pageName=Name,ParishLocation,MailingAddress
|where=Church._pageName LIKE "%{{PAGENAME}}%"
|format=openlayers
|format=openlayers
}}
}}

Revision as of 23:13, 3 November 2024

Short title not found
Error 1054: Unknown column 'Church._pageName' in 'where clause'

Function: CargoSQLQuery::run Query: SELECT `cargo__Churches`.`_pageID` AS `cargo_backlink_page_id_Churches`,`_pageName` AS `Name`,`ParishLocation__full` AS `ParishLocation`,`MailingAddress` AS `MailingAddress`,`ParishLocation__lat` AS `ParishLocation lat`,`ParishLocation__lon` AS `ParishLocation lon` FROM `cargo__Churches` WHERE Church._pageName LIKE "%Church map%" ORDER BY `cargo__Churches`.`_pageID`,`_pageName`,`ParishLocation__full`,`MailingAddress` LIMIT 100

This map created from a Cargo query (Purge)