Template:CardChange table/t1

{{safesubst:#invoke:Cargo|query|tables=Table2, Table1
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table2.dbfId=0) AND (Table1.name IS NULL AND NOT Table2._pageName LIKE "%upcoming%")
|fields=Table2.dbfId=dbfId, CONCAT("135540")=build, CONCAT("added")=type
|template=CardChange table
|limit=2000
}}{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table1.dbfId=Table2.dbfId
|where=(NOT Table1.dbfId=0) AND (Table2.name IS NULL AND NOT Table1._pageName LIKE "%removed%")
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("removed")=type
|template=CardChange table
|limit=2000
}}{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.textInHand=Table2.textInHand) OR (Table1.textInHand IS NULL AND Table2.textInHand IS NOT NULL) OR (Table1.textInHand IS NOT NULL AND Table2.textInHand IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("textInHand")=type, Table2.name=name, Table1.textInHand=old, Table2.textInHand=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.gameplayEvent=Table2.gameplayEvent) OR (Table1.gameplayEvent IS NULL AND Table2.gameplayEvent IS NOT NULL) OR (Table1.gameplayEvent IS NOT NULL AND Table2.gameplayEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("gameplayEvent")=type, Table2.name=name, Table1.gameplayEvent=old, Table2.gameplayEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.craftingEvent=Table2.craftingEvent) OR (Table1.craftingEvent IS NULL AND Table2.craftingEvent IS NOT NULL) OR (Table1.craftingEvent IS NOT NULL AND Table2.craftingEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("craftingEvent")=type, Table2.name=name, Table1.craftingEvent=old, Table2.craftingEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.goldenCraftingEvent=Table2.goldenCraftingEvent) OR (Table1.goldenCraftingEvent IS NULL AND Table2.goldenCraftingEvent IS NOT NULL) OR (Table1.goldenCraftingEvent IS NOT NULL AND Table2.goldenCraftingEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("goldenCraftingEvent")=type, Table2.name=name, Table1.goldenCraftingEvent=old, Table2.goldenCraftingEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.suggestionWeight=Table2.suggestionWeight) OR (Table1.suggestionWeight IS NULL AND Table2.suggestionWeight IS NOT NULL) OR (Table1.suggestionWeight IS NOT NULL AND Table2.suggestionWeight IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("suggestionWeight")=type, Table2.name=name, Table1.suggestionWeight=old, Table2.suggestionWeight=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.changeVersion=Table2.changeVersion) OR (Table1.changeVersion IS NULL AND Table2.changeVersion IS NOT NULL) OR (Table1.changeVersion IS NOT NULL AND Table2.changeVersion IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("changeVersion")=type, Table2.name=name, Table1.changeVersion=old, Table2.changeVersion=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.name=Table2.name) OR (Table1.name IS NULL AND Table2.name IS NOT NULL) OR (Table1.name IS NOT NULL AND Table2.name IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("name")=type, Table2.name=name, Table1.name=old, Table2.name=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.flavorText=Table2.flavorText) OR (Table1.flavorText IS NULL AND Table2.flavorText IS NOT NULL) OR (Table1.flavorText IS NOT NULL AND Table2.flavorText IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("flavorText")=type, Table2.name=name, Table1.flavorText=old, Table2.flavorText=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.howToGetCard=Table2.howToGetCard) OR (Table1.howToGetCard IS NULL AND Table2.howToGetCard IS NOT NULL) OR (Table1.howToGetCard IS NOT NULL AND Table2.howToGetCard IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("howToGetCard")=type, Table2.name=name, Table1.howToGetCard=old, Table2.howToGetCard=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.howToGetGoldCard=Table2.howToGetGoldCard) OR (Table1.howToGetGoldCard IS NULL AND Table2.howToGetGoldCard IS NOT NULL) OR (Table1.howToGetGoldCard IS NOT NULL AND Table2.howToGetGoldCard IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("howToGetGoldCard")=type, Table2.name=name, Table1.howToGetGoldCard=old, Table2.howToGetGoldCard=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.howToGetSignatureCard=Table2.howToGetSignatureCard) OR (Table1.howToGetSignatureCard IS NULL AND Table2.howToGetSignatureCard IS NOT NULL) OR (Table1.howToGetSignatureCard IS NOT NULL AND Table2.howToGetSignatureCard IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("howToGetSignatureCard")=type, Table2.name=name, Table1.howToGetSignatureCard=old, Table2.howToGetSignatureCard=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.howToGetDiamondCard=Table2.howToGetDiamondCard) OR (Table1.howToGetDiamondCard IS NULL AND Table2.howToGetDiamondCard IS NOT NULL) OR (Table1.howToGetDiamondCard IS NOT NULL AND Table2.howToGetDiamondCard IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("howToGetDiamondCard")=type, Table2.name=name, Table1.howToGetDiamondCard=old, Table2.howToGetDiamondCard=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.targetArrowText=Table2.targetArrowText) OR (Table1.targetArrowText IS NULL AND Table2.targetArrowText IS NOT NULL) OR (Table1.targetArrowText IS NOT NULL AND Table2.targetArrowText IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("targetArrowText")=type, Table2.name=name, Table1.targetArrowText=old, Table2.targetArrowText=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.artistName=Table2.artistName) OR (Table1.artistName IS NULL AND Table2.artistName IS NOT NULL) OR (Table1.artistName IS NOT NULL AND Table2.artistName IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("artistName")=type, Table2.name=name, Table1.artistName=old, Table2.artistName=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.signatureArtistName=Table2.signatureArtistName) OR (Table1.signatureArtistName IS NULL AND Table2.signatureArtistName IS NOT NULL) OR (Table1.signatureArtistName IS NOT NULL AND Table2.signatureArtistName IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("signatureArtistName")=type, Table2.name=name, Table1.signatureArtistName=old, Table2.signatureArtistName=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.shortName=Table2.shortName) OR (Table1.shortName IS NULL AND Table2.shortName IS NOT NULL) OR (Table1.shortName IS NOT NULL AND Table2.shortName IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("shortName")=type, Table2.name=name, Table1.shortName=old, Table2.shortName=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.creditsCardName=Table2.creditsCardName) OR (Table1.creditsCardName IS NULL AND Table2.creditsCardName IS NOT NULL) OR (Table1.creditsCardName IS NOT NULL AND Table2.creditsCardName IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("creditsCardName")=type, Table2.name=name, Table1.creditsCardName=old, Table2.creditsCardName=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.featuredCardsEvent=Table2.featuredCardsEvent) OR (Table1.featuredCardsEvent IS NULL AND Table2.featuredCardsEvent IS NOT NULL) OR (Table1.featuredCardsEvent IS NOT NULL AND Table2.featuredCardsEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("featuredCardsEvent")=type, Table2.name=name, Table1.featuredCardsEvent=old, Table2.featuredCardsEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.battlegroundsActiveEvent=Table2.battlegroundsActiveEvent) OR (Table1.battlegroundsActiveEvent IS NULL AND Table2.battlegroundsActiveEvent IS NOT NULL) OR (Table1.battlegroundsActiveEvent IS NOT NULL AND Table2.battlegroundsActiveEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("battlegroundsActiveEvent")=type, Table2.name=name, Table1.battlegroundsActiveEvent=old, Table2.battlegroundsActiveEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.battlegroundsEarlyAccessEvent=Table2.battlegroundsEarlyAccessEvent) OR (Table1.battlegroundsEarlyAccessEvent IS NULL AND Table2.battlegroundsEarlyAccessEvent IS NOT NULL) OR (Table1.battlegroundsEarlyAccessEvent IS NOT NULL AND Table2.battlegroundsEarlyAccessEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("battlegroundsEarlyAccessEvent")=type, Table2.name=name, Table1.battlegroundsEarlyAccessEvent=old, Table2.battlegroundsEarlyAccessEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.battlegroundsEveryGameEvent=Table2.battlegroundsEveryGameEvent) OR (Table1.battlegroundsEveryGameEvent IS NULL AND Table2.battlegroundsEveryGameEvent IS NOT NULL) OR (Table1.battlegroundsEveryGameEvent IS NOT NULL AND Table2.battlegroundsEveryGameEvent IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("battlegroundsEveryGameEvent")=type, Table2.name=name, Table1.battlegroundsEveryGameEvent=old, Table2.battlegroundsEveryGameEvent=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.cardTextBuilderType=Table2.cardTextBuilderType) OR (Table1.cardTextBuilderType IS NULL AND Table2.cardTextBuilderType IS NOT NULL) OR (Table1.cardTextBuilderType IS NOT NULL AND Table2.cardTextBuilderType IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("cardTextBuilderType")=type, Table2.name=name, Table1.cardTextBuilderType=old, Table2.cardTextBuilderType=new
|template=CardChange table
|limit=1000
}}
{{safesubst:#invoke:Cargo|query|tables=Table1, Table2
|join=Table2.dbfId=Table1.dbfId
|where=(NOT Table1.dbfId=0) AND ((NOT (Table1.watermarkTextureOverride=Table2.watermarkTextureOverride) OR (Table1.watermarkTextureOverride IS NULL AND Table2.watermarkTextureOverride IS NOT NULL) OR (Table1.watermarkTextureOverride IS NOT NULL AND Table2.watermarkTextureOverride IS NULL)) AND Table2.dbfId IS NOT NULL)
|fields=Table1.dbfId=dbfId, CONCAT("135540")=build, CONCAT("watermarkTextureOverride")=type, Table2.name=name, Table1.watermarkTextureOverride=old, Table2.watermarkTextureOverride=new
|template=CardChange table
|limit=1000
}}