User:Tom/Sandbox8: Difference between revisions
< User:Tom
Jump to navigation
Jump to search
No edit summary Tag: Reverted |
No edit summary Tag: Reverted |
||
| Line 2: | Line 2: | ||
tables=Parishes | tables=Parishes | ||
|fields=_pageName,City,ParishLocation | |fields=_pageName,City,ParishLocation | ||
|where=Diocese | |where=Parishes.Diocese HOLDS "Diocese of Arlington" | ||
|format=leaflet | |format=leaflet | ||
|width=400 | |width=400 | ||
|zoom=10 | |zoom=10 | ||
}} | }} | ||
Revision as of 22:09, 4 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 "Diocese of Arlington" ORDER BY `cargo__Parishes`.`_pageID`,`_pageName`,`' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Parishes`.`_pageID` AS `cargo_backlink_page_id_Parishes`,`_pageName` AS `_pageName`,`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 "Diocese of Arlington" ORDER BY `cargo__Parishes`.`_pageID`,`_pageName`,`City`,`ParishLocation__full` LIMIT 100