Template:Factions: Difference between revisions

Revision as of 03:49, 7 November 2024

This template defines the table "Factions". View table.

@@ Line 27: / Line 27: @@
 == Enemies ==
 {{#cargo_query:
-|tables=Factions=F1, Factions=F2
+|tables=Factions
-|fields=F1._pageName=Faction, F2._pageName=EnemyFaction
+|fields=_pageName=Faction
-|join on=F1.Codename != F2.Codename
+|where=Factions.Codename!='{{{Codename}}}' AND
-|where=F2.Codename='{{{Codename}}}' AND
+       (Factions.Enemies LIKE CONCAT('%,', '{{{Codename}}}', ',%') OR
-       (F1.Enemies LIKE CONCAT('%,', F2.Codename, ',%') OR
+        Factions.Enemies LIKE CONCAT('{{{Codename}}}', ',%') OR
-        F1.Enemies LIKE CONCAT(F2.Codename, ',%') OR
+        Factions.Enemies LIKE CONCAT('%,', '{{{Codename}}}') OR
-        F1.Enemies LIKE CONCAT('%,', F2.Codename) OR
+        Factions.Enemies = '{{{Codename}}}')
-        F1.Enemies = F2.Codename)
 |format=table
 |headers=yes