User:Tom/Sandbox10: Difference between revisions

Revision as of 23:52, 21 October 2024

Archdiocese of Washington
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 "%Washington%" 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`.`Diocese` HOLDS LIKE "%Washington%" 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) V

@@ Line 1: / Line 1: @@
+{| class="wikitable" style="float: right; margin-left: 10px;"
+![[Archdiocese of Washington]]
+|-
+|
 {{#cargo_query:
 tables=Parishes
 |fields=Parishes._pageName, Parishes.Dedication, Parishes.City, Parishes.ParishLocation
-|where=Parishes.Dedication HOLDS LIKE "%Rita%"
+|where=Parishes.Diocese HOLDS LIKE "%Washington%"
 |format=leaflet
 |width=400
 |zoom=8
 }}
+|-
+|This map created from a [https://saintapedia.org/wiki/Special:CargoQuery?title=Special%3ACargoQuery&tables=Parishes%2C+&fields=Diocese%2C+Parishes.ParishLocation%2C+&where=&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=&offset=&format=leaflet&height=&width=400&icon=&zoom=&center=&cluster=&image= Cargo query] ({{Purge}}) [[Template:Diocese of Arlington map|V]]
+|}