Template:Diocese map: Difference between revisions

From Saintapedia
Jump to navigation Jump to search
No edit summary
(add where)
Line 6: Line 6:
tables=Parishes
tables=Parishes
|fields=Parishes._pageName, Parishes.Dedication, Parishes.City, Parishes.ParishLocation
|fields=Parishes._pageName, Parishes.Dedication, Parishes.City, Parishes.ParishLocation
|where=Parishes.Diocese HOLDS LIKE "%Arlington%"
|where=Parishes.Diocese HOLDS LIKE "%{{{Where}}}%"
|format=leaflet
|format=leaflet
|width=400
|width=400

Revision as of 10:44, 24 October 2024

{{{Diocese}}}
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 "%{{{Where}}}%" ORDER BY `cargo__Parishes`.`_pageID`,`cargo__Parishe' 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`.`Diocese` HOLDS LIKE "%{{{Where}}}%" 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 (Purge) View