Template:CardChange table/t2

From Hearthstone Wiki
Jump to navigation Jump to search 
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.stringTags__full=Table2.stringTags__full) OR (Table1.stringTags__full IS NULL AND Table2.stringTags__full IS NOT NULL) OR (Table1.stringTags__full IS NOT NULL AND Table2.stringTags__full IS NULL)) AND Table2.stringTags__full IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("stringTags__full")=type, Table1.stringTags__full=old, Table2.stringTags__full=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.keywords__full=Table2.keywords__full) OR (Table1.keywords__full IS NULL AND Table2.keywords__full IS NOT NULL) OR (Table1.keywords__full IS NOT NULL AND Table2.keywords__full IS NULL)) AND Table2.keywords__full IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("keywords__full")=type, Table1.keywords__full=old, Table2.keywords__full=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.refs__full=Table2.refs__full) OR (Table1.refs__full IS NULL AND Table2.refs__full IS NOT NULL) OR (Table1.refs__full IS NOT NULL AND Table2.refs__full IS NULL)) AND Table2.refs__full IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("refs__full")=type, Table1.refs__full=old, Table2.refs__full=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.typeId=Table2.typeId) OR (Table1.typeId IS NULL AND Table2.typeId IS NOT NULL) OR (Table1.typeId IS NOT NULL AND Table2.typeId IS NULL)) AND Table2.typeId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("typeId")=type, Table1.typeId=old, Table2.typeId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.attack=Table2.attack) OR (Table1.attack IS NULL AND Table2.attack IS NOT NULL) OR (Table1.attack IS NOT NULL AND Table2.attack IS NULL)) AND Table2.attack IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("attack")=type, Table1.attack=old, Table2.attack=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.health=Table2.health) OR (Table1.health IS NULL AND Table2.health IS NOT NULL) OR (Table1.health IS NOT NULL AND Table2.health IS NULL)) AND Table2.health IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("health")=type, Table1.health=old, Table2.health=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.cost=Table2.cost) OR (Table1.cost IS NULL AND Table2.cost IS NOT NULL) OR (Table1.cost IS NOT NULL AND Table2.cost IS NULL)) AND Table2.cost IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("cost")=type, Table1.cost=old, Table2.cost=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.durability=Table2.durability) OR (Table1.durability IS NULL AND Table2.durability IS NOT NULL) OR (Table1.durability IS NOT NULL AND Table2.durability IS NULL)) AND Table2.durability IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("durability")=type, Table1.durability=old, Table2.durability=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.armor=Table2.armor) OR (Table1.armor IS NULL AND Table2.armor IS NOT NULL) OR (Table1.armor IS NOT NULL AND Table2.armor IS NULL)) AND Table2.armor IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("armor")=type, Table1.armor=old, Table2.armor=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.classId=Table2.classId) OR (Table1.classId IS NULL AND Table2.classId IS NOT NULL) OR (Table1.classId IS NOT NULL AND Table2.classId IS NULL)) AND Table2.classId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("classId")=type, Table1.classId=old, Table2.classId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.multipleClassesId=Table2.multipleClassesId) OR (Table1.multipleClassesId IS NULL AND Table2.multipleClassesId IS NOT NULL) OR (Table1.multipleClassesId IS NOT NULL AND Table2.multipleClassesId IS NULL)) AND Table2.multipleClassesId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("multipleClassesId")=type, Table1.multipleClassesId=old, Table2.multipleClassesId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.multiClassGroupId=Table2.multiClassGroupId) OR (Table1.multiClassGroupId IS NULL AND Table2.multiClassGroupId IS NOT NULL) OR (Table1.multiClassGroupId IS NOT NULL AND Table2.multiClassGroupId IS NULL)) AND Table2.multiClassGroupId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("multiClassGroupId")=type, Table1.multiClassGroupId=old, Table2.multiClassGroupId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.rarityId=Table2.rarityId) OR (Table1.rarityId IS NULL AND Table2.rarityId IS NOT NULL) OR (Table1.rarityId IS NOT NULL AND Table2.rarityId IS NULL)) AND Table2.rarityId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("rarityId")=type, Table1.rarityId=old, Table2.rarityId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.elite=Table2.elite) OR (Table1.elite IS NULL AND Table2.elite IS NOT NULL) OR (Table1.elite IS NOT NULL AND Table2.elite IS NULL)) AND Table2.elite IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("elite")=type, Table1.elite=old, Table2.elite=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.collectible=Table2.collectible) OR (Table1.collectible IS NULL AND Table2.collectible IS NOT NULL) OR (Table1.collectible IS NOT NULL AND Table2.collectible IS NULL)) AND Table2.collectible IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("collectible")=type, Table1.collectible=old, Table2.collectible=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.raceId=Table2.raceId) OR (Table1.raceId IS NULL AND Table2.raceId IS NOT NULL) OR (Table1.raceId IS NOT NULL AND Table2.raceId IS NULL)) AND Table2.raceId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("raceId")=type, Table1.raceId=old, Table2.raceId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.spellSchoolId=Table2.spellSchoolId) OR (Table1.spellSchoolId IS NULL AND Table2.spellSchoolId IS NOT NULL) OR (Table1.spellSchoolId IS NOT NULL AND Table2.spellSchoolId IS NULL)) AND Table2.spellSchoolId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("spellSchoolId")=type, Table1.spellSchoolId=old, Table2.spellSchoolId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.miniSet=Table2.miniSet) OR (Table1.miniSet IS NULL AND Table2.miniSet IS NOT NULL) OR (Table1.miniSet IS NOT NULL AND Table2.miniSet IS NULL)) AND Table2.miniSet IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("miniSet")=type, Table1.miniSet=old, Table2.miniSet=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.tag2=Table2.tag2) OR (Table1.tag2 IS NULL AND Table2.tag2 IS NOT NULL) OR (Table1.tag2 IS NOT NULL AND Table2.tag2 IS NULL)) AND Table2.tag2 IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("tag2")=type, Table1.tag2=old, Table2.tag2=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.tag3=Table2.tag3) OR (Table1.tag3 IS NULL AND Table2.tag3 IS NOT NULL) OR (Table1.tag3 IS NOT NULL AND Table2.tag3 IS NULL)) AND Table2.tag3 IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("tag3")=type, Table1.tag3=old, Table2.tag3=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.tag4=Table2.tag4) OR (Table1.tag4 IS NULL AND Table2.tag4 IS NOT NULL) OR (Table1.tag4 IS NOT NULL AND Table2.tag4 IS NULL)) AND Table2.tag4 IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("tag4")=type, Table1.tag4=old, Table2.tag4=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.tag5=Table2.tag5) OR (Table1.tag5 IS NULL AND Table2.tag5 IS NOT NULL) OR (Table1.tag5 IS NOT NULL AND Table2.tag5 IS NULL)) AND Table2.tag5 IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("tag5")=type, Table1.tag5=old, Table2.tag5=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.heroPowerDbfId=Table2.heroPowerDbfId) OR (Table1.heroPowerDbfId IS NULL AND Table2.heroPowerDbfId IS NOT NULL) OR (Table1.heroPowerDbfId IS NOT NULL AND Table2.heroPowerDbfId IS NULL)) AND Table2.heroPowerDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("heroPowerDbfId")=type, Table1.heroPowerDbfId=old, Table2.heroPowerDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.heroicHeroPowerDbfId=Table2.heroicHeroPowerDbfId) OR (Table1.heroicHeroPowerDbfId IS NULL AND Table2.heroicHeroPowerDbfId IS NOT NULL) OR (Table1.heroicHeroPowerDbfId IS NOT NULL AND Table2.heroicHeroPowerDbfId IS NULL)) AND Table2.heroicHeroPowerDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("heroicHeroPowerDbfId")=type, Table1.heroicHeroPowerDbfId=old, Table2.heroicHeroPowerDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.questRewardDbfId=Table2.questRewardDbfId) OR (Table1.questRewardDbfId IS NULL AND Table2.questRewardDbfId IS NOT NULL) OR (Table1.questRewardDbfId IS NOT NULL AND Table2.questRewardDbfId IS NULL)) AND Table2.questRewardDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("questRewardDbfId")=type, Table1.questRewardDbfId=old, Table2.questRewardDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.questlineRewardDbfId=Table2.questlineRewardDbfId) OR (Table1.questlineRewardDbfId IS NULL AND Table2.questlineRewardDbfId IS NOT NULL) OR (Table1.questlineRewardDbfId IS NOT NULL AND Table2.questlineRewardDbfId IS NULL)) AND Table2.questlineRewardDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("questlineRewardDbfId")=type, Table1.questlineRewardDbfId=old, Table2.questlineRewardDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.twinspellCopyDbfId=Table2.twinspellCopyDbfId) OR (Table1.twinspellCopyDbfId IS NULL AND Table2.twinspellCopyDbfId IS NOT NULL) OR (Table1.twinspellCopyDbfId IS NOT NULL AND Table2.twinspellCopyDbfId IS NULL)) AND Table2.twinspellCopyDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("twinspellCopyDbfId")=type, Table1.twinspellCopyDbfId=old, Table2.twinspellCopyDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.questlinePart=Table2.questlinePart) OR (Table1.questlinePart IS NULL AND Table2.questlinePart IS NOT NULL) OR (Table1.questlinePart IS NOT NULL AND Table2.questlinePart IS NULL)) AND Table2.questlinePart IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("questlinePart")=type, Table1.questlinePart=old, Table2.questlinePart=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.collectionRelatedCardDbfId=Table2.collectionRelatedCardDbfId) OR (Table1.collectionRelatedCardDbfId IS NULL AND Table2.collectionRelatedCardDbfId IS NOT NULL) OR (Table1.collectionRelatedCardDbfId IS NOT NULL AND Table2.collectionRelatedCardDbfId IS NULL)) AND Table2.collectionRelatedCardDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("collectionRelatedCardDbfId")=type, Table1.collectionRelatedCardDbfId=old, Table2.collectionRelatedCardDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.copyOfDbfId=Table2.copyOfDbfId) OR (Table1.copyOfDbfId IS NULL AND Table2.copyOfDbfId IS NOT NULL) OR (Table1.copyOfDbfId IS NOT NULL AND Table2.copyOfDbfId IS NULL)) AND Table2.copyOfDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("copyOfDbfId")=type, Table1.copyOfDbfId=old, Table2.copyOfDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.costBlood=Table2.costBlood) OR (Table1.costBlood IS NULL AND Table2.costBlood IS NOT NULL) OR (Table1.costBlood IS NOT NULL AND Table2.costBlood IS NULL)) AND Table2.costBlood IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("costBlood")=type, Table1.costBlood=old, Table2.costBlood=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.costDeath=Table2.costDeath) OR (Table1.costDeath IS NULL AND Table2.costDeath IS NOT NULL) OR (Table1.costDeath IS NOT NULL AND Table2.costDeath IS NULL)) AND Table2.costDeath IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("costDeath")=type, Table1.costDeath=old, Table2.costDeath=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.costUnholy=Table2.costUnholy) OR (Table1.costUnholy IS NULL AND Table2.costUnholy IS NOT NULL) OR (Table1.costUnholy IS NOT NULL AND Table2.costUnholy IS NULL)) AND Table2.costUnholy IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("costUnholy")=type, Table1.costUnholy=old, Table2.costUnholy=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.costFrost=Table2.costFrost) OR (Table1.costFrost IS NULL AND Table2.costFrost IS NOT NULL) OR (Table1.costFrost IS NOT NULL AND Table2.costFrost IS NULL)) AND Table2.costFrost IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("costFrost")=type, Table1.costFrost=old, Table2.costFrost=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgTier=Table2.bgTier) OR (Table1.bgTier IS NULL AND Table2.bgTier IS NOT NULL) OR (Table1.bgTier IS NOT NULL AND Table2.bgTier IS NULL)) AND Table2.bgTier IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgTier")=type, Table1.bgTier=old, Table2.bgTier=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgPremiumDbfId=Table2.bgPremiumDbfId) OR (Table1.bgPremiumDbfId IS NULL AND Table2.bgPremiumDbfId IS NOT NULL) OR (Table1.bgPremiumDbfId IS NOT NULL AND Table2.bgPremiumDbfId IS NULL)) AND Table2.bgPremiumDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgPremiumDbfId")=type, Table1.bgPremiumDbfId=old, Table2.bgPremiumDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgSpellcraftDbfId=Table2.bgSpellcraftDbfId) OR (Table1.bgSpellcraftDbfId IS NULL AND Table2.bgSpellcraftDbfId IS NOT NULL) OR (Table1.bgSpellcraftDbfId IS NOT NULL AND Table2.bgSpellcraftDbfId IS NULL)) AND Table2.bgSpellcraftDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgSpellcraftDbfId")=type, Table1.bgSpellcraftDbfId=old, Table2.bgSpellcraftDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgBuddyDbfId=Table2.bgBuddyDbfId) OR (Table1.bgBuddyDbfId IS NULL AND Table2.bgBuddyDbfId IS NOT NULL) OR (Table1.bgBuddyDbfId IS NOT NULL AND Table2.bgBuddyDbfId IS NULL)) AND Table2.bgBuddyDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgBuddyDbfId")=type, Table1.bgBuddyDbfId=old, Table2.bgBuddyDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgEvolutionDbfId=Table2.bgEvolutionDbfId) OR (Table1.bgEvolutionDbfId IS NULL AND Table2.bgEvolutionDbfId IS NOT NULL) OR (Table1.bgEvolutionDbfId IS NOT NULL AND Table2.bgEvolutionDbfId IS NULL)) AND Table2.bgEvolutionDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgEvolutionDbfId")=type, Table1.bgEvolutionDbfId=old, Table2.bgEvolutionDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgSkinParentDbfId=Table2.bgSkinParentDbfId) OR (Table1.bgSkinParentDbfId IS NULL AND Table2.bgSkinParentDbfId IS NOT NULL) OR (Table1.bgSkinParentDbfId IS NOT NULL AND Table2.bgSkinParentDbfId IS NULL)) AND Table2.bgSkinParentDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgSkinParentDbfId")=type, Table1.bgSkinParentDbfId=old, Table2.bgSkinParentDbfId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgDarkmoonPrizeTurn=Table2.bgDarkmoonPrizeTurn) OR (Table1.bgDarkmoonPrizeTurn IS NULL AND Table2.bgDarkmoonPrizeTurn IS NOT NULL) OR (Table1.bgDarkmoonPrizeTurn IS NOT NULL AND Table2.bgDarkmoonPrizeTurn IS NULL)) AND Table2.bgDarkmoonPrizeTurn IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgDarkmoonPrizeTurn")=type, Table1.bgDarkmoonPrizeTurn=old, Table2.bgDarkmoonPrizeTurn=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgArmorTier=Table2.bgArmorTier) OR (Table1.bgArmorTier IS NULL AND Table2.bgArmorTier IS NOT NULL) OR (Table1.bgArmorTier IS NOT NULL AND Table2.bgArmorTier IS NULL)) AND Table2.bgArmorTier IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgArmorTier")=type, Table1.bgArmorTier=old, Table2.bgArmorTier=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgHero=Table2.bgHero) OR (Table1.bgHero IS NULL AND Table2.bgHero IS NOT NULL) OR (Table1.bgHero IS NOT NULL AND Table2.bgHero IS NULL)) AND Table2.bgHero IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgHero")=type, Table1.bgHero=old, Table2.bgHero=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgPoolMinion=Table2.bgPoolMinion) OR (Table1.bgPoolMinion IS NULL AND Table2.bgPoolMinion IS NOT NULL) OR (Table1.bgPoolMinion IS NOT NULL AND Table2.bgPoolMinion IS NULL)) AND Table2.bgPoolMinion IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgPoolMinion")=type, Table1.bgPoolMinion=old, Table2.bgPoolMinion=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.bgBuddy=Table2.bgBuddy) OR (Table1.bgBuddy IS NULL AND Table2.bgBuddy IS NOT NULL) OR (Table1.bgBuddy IS NOT NULL AND Table2.bgBuddy IS NULL)) AND Table2.bgBuddy IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("bgBuddy")=type, Table1.bgBuddy=old, Table2.bgBuddy=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.mercsRoleId=Table2.mercsRoleId) OR (Table1.mercsRoleId IS NULL AND Table2.mercsRoleId IS NOT NULL) OR (Table1.mercsRoleId IS NOT NULL AND Table2.mercsRoleId IS NULL)) AND Table2.mercsRoleId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("mercsRoleId")=type, Table1.mercsRoleId=old, Table2.mercsRoleId=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.mercsIsEquipment=Table2.mercsIsEquipment) OR (Table1.mercsIsEquipment IS NULL AND Table2.mercsIsEquipment IS NOT NULL) OR (Table1.mercsIsEquipment IS NOT NULL AND Table2.mercsIsEquipment IS NULL)) AND Table2.mercsIsEquipment IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("mercsIsEquipment")=type, Table1.mercsIsEquipment=old, Table2.mercsIsEquipment=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.mercsIsMercenary=Table2.mercsIsMercenary) OR (Table1.mercsIsMercenary IS NULL AND Table2.mercsIsMercenary IS NOT NULL) OR (Table1.mercsIsMercenary IS NOT NULL AND Table2.mercsIsMercenary IS NULL)) AND Table2.mercsIsMercenary IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("mercsIsMercenary")=type, Table1.mercsIsMercenary=old, Table2.mercsIsMercenary=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.mercsCooldown=Table2.mercsCooldown) OR (Table1.mercsCooldown IS NULL AND Table2.mercsCooldown IS NOT NULL) OR (Table1.mercsCooldown IS NOT NULL AND Table2.mercsCooldown IS NULL)) AND Table2.mercsCooldown IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("mercsCooldown")=type, Table1.mercsCooldown=old, Table2.mercsCooldown=new
|template=CardChange table
|limit=2000
}}
{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.mercsSummonedMinionDbfId=Table2.mercsSummonedMinionDbfId) OR (Table1.mercsSummonedMinionDbfId IS NULL AND Table2.mercsSummonedMinionDbfId IS NOT NULL) OR (Table1.mercsSummonedMinionDbfId IS NOT NULL AND Table2.mercsSummonedMinionDbfId IS NULL)) AND Table2.mercsSummonedMinionDbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("mercsSummonedMinionDbfId")=type, Table1.mercsSummonedMinionDbfId=old, Table2.mercsSummonedMinionDbfId=new
|template=CardChange table
|limit=2000
}}
Retrieved from "https://hearthstone.wiki.gg/index.php?title=Template:CardChange_table/t2&oldid=459904"