Template:Diocese parish table: Difference between revisions
Jump to navigation
Jump to search
(start) |
(add where) |
||
| Line 2: | Line 2: | ||
tables=Parishes | tables=Parishes | ||
|fields=Parishes._pageName, Parishes.City, Parishes.MailingAddress | |fields=Parishes._pageName, Parishes.City, Parishes.MailingAddress | ||
|where=Parishes.Diocese HOLDS LIKE "% | |where=Parishes.Diocese HOLDS LIKE "%{{{Where}}}%" | ||
|format=table | |format=table | ||
}}<noinclude>{{Doc}}</noinclude> | }}<noinclude>{{Doc}}</noinclude> | ||
Revision as of 10:53, 24 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 "%{{{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`.`City` AS `City`,`cargo__Parishes`.`MailingAddress` AS `MailingAddress` FROM `cargo__Parishes` WHERE `cargo__Parishes`.`Diocese` HOLDS LIKE "%{{{Where}}}%" ORDER BY `cargo__Parishes`.`_pageID`,`cargo__Parishes`.`_pageName`,`cargo__Parishes`.`City`,`cargo__Parishes`.`MailingAddress` LIMIT 100
Template documentation