Template:GetCharUnites: Difference between revisions

Revision as of 08:02, 30 March 2025

Error 1054: Unknown column 'cargo__Unites._pageID' in 'SELECT'

Function: CargoSQLQuery::run Query: SELECT `cargo__Unites`.`_pageID` AS `cargo_backlink_page_id_Unites`,`name` AS `name`,`participants` AS `participants`,`game` AS `game` FROM `cargo__Unites` `Unites` WHERE participants like '%[[{{{name}}}]]%' AND game = "" ORDER BY `cargo__Unites`.`_pageID`,`name`,`participants`,`game` LIMIT 100

@@ Line 4: / Line 4: @@
 |fields =
    name, participants, game
-|where=participants like '%[[{{{name}}}]]%' AND game = "{{{game|}}}" OR participants like '%Hero%' AND game = "{{{game|}}}"
+|where=participants like '%{{#switch: {{{name}}}
+ | Hero = {{{name}}}
+ | #default = [[{{{name}}}]]
+}}%' AND game = "{{{game|}}}"
 |format=template
 |limit=50