Template:Factions: Difference between revisions

Revision as of 03:46, 7 November 2024

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

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