User:Coffeesaga/Sandbox/VT Query

From Archon Arcana - The KeyForge Wiki

2019 Indianapolis Sealed Worlds Collide Vault Tour

Deck Name
Set
Houses
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
T16
CotA
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
Call of the Archons
   
T16
CotA
   
Call of the Archons
   
Call of the Archons
   


Call of the Archons Houses

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Set and House Breakdown
of Top 16 Decks
Set Number of Decks in Each House Total
CotA
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

16
Total
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

16
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="housebrobnar" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="housedis" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="houselogos" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="housemars" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="housesanctum" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="houseshadows" style="height:Expression error: Unexpected < operator.px;">
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

<div class="houseuntamed" style="height:Expression error: Unexpected < operator.px;">
Total
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

16


Analysis

Vault Tours

CotA

2019 Seattle Vault Tour • 2019 Eindhoven Vault Tour • 2019 AdeptiCon Vault Tour • 2019 Denver Vault Tour • 2019 Atlanta Vault Tour

AoA

2019 UK Games Expo Vault Tour • 2019 Origins Vault Tour • 2019 Bologna Vault Tour • 2019 Nürnberg Vault Tour • 2019 Indianapolis (Gen Con) Sealed Vault Tour • 2019 Indianapolis (Gen Con) Archon Vault Tour • 2019 Krakow Sealed Vault Tour • 2019 Krakow Archon Vault Tour • 2019 Collinsville Vault Tour • 2019 Madrid Vault Tour • 2019 Las Vegas Vault Tour • 2019 Richmond Vault Tour

WC

2019 Indianapolis Sealed Worlds Collide Vault Tour • 2019 PAX Unplugged Archon Vault Tour • 2019 PAX Unplugged Sealed Vault Tour • 2020 Albany Vault Tour • 2020 Fort Worth Vault Tour


Eindhoven Houses

Brobnar:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE (`cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour") and (`cargo__EventDeck`.`Houses` like '%Brobnar%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Dis:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Dis%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Logos:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Logos%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Mars:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Mars%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Sanctum:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Sanctum%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Shadows:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Shadows%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Untamed:

Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'AA139.cargo__EventResults._pageID'; this is incompatible with sql_mode=only_full_group_by

Function: CargoSQLQuery::run Query: SELECT `cargo__EventResults`.`_pageID` AS `cargo_backlink_page_id_EventResults`,`cargo__EventDeck`.`_pageID` AS `cargo_backlink_page_id_EventDeck`,count(*) FROM `cargo__EventDeck` LEFT OUTER JOIN `cargo__EventResults` ON ((`cargo__EventDeck`.`DeckID`=`cargo__EventResults`.`DeckID`)) WHERE `cargo__EventResults`.`Name`="2019 Eindhoven Vault Tour" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count(*) DESC LIMIT 100

Most popular house combos

Most popular house combos: 3 (Houses: •Dis•Mars•Shadows•), 3 (Houses: •Dis•Logos•Shadows•)

Creature, Upgrade, Action, Artifact counts

Modes

Mode of creature count: 5 (CreatureCount: 21)

Mode of action count: Mode of upgrade count: 3 (ActionCount: 16)

Mode of artifact count: 4 (ArtifactCount: 2)

Mode of upgrade count: 7 (UpgradeCount: 1)

Min/Maxes

Min of creature count: 12

Max creature count: 21

Min of action count: 8

Max action count: 18

Graphical display of creature counts

  • 0 (CreatureCount: 10)
  • 0 (CreatureCount: 11)
  • 2 (CreatureCount: 12)
  • 0 (CreatureCount: 13)
  • 0 (CreatureCount: 14)
  • 3 (CreatureCount: 15)
  • 1 (CreatureCount: 16)
  • 1 (CreatureCount: 17)
  • 0 (CreatureCount: 18)
  • 3 (CreatureCount: 19)
  • 1 (CreatureCount: 20)
  • 5 (CreatureCount: 21)
  • 0 (CreatureCount: 22)
  • 0 (CreatureCount: 23)
  • 0 (CreatureCount: 24)
  • 0 (CreatureCount: 25)
  • 0 (CreatureCount: 26)
  • 0 (CreatureCount: 27)
  • 0 (CreatureCount: 28)
  • 0 (CreatureCount: 29)

Graphical display of action counts

  • 0 (ActionCount: 5)
  • 0 (ActionCount: 6)
  • 0 (ActionCount: 7)
  • 1 (ActionCount: 8)
  • 1 (ActionCount: 9)
  • 1 (ActionCount: 10)
  • 2 (ActionCount: 11)
  • 2 (ActionCount: 12)
  • 2 (ActionCount: 13)
  • 0 (ActionCount: 14)
  • 2 (ActionCount: 15)
  • 3 (ActionCount: 16)
  • 1 (ActionCount: 17)
  • 1 (ActionCount: 18)
  • 0 (ActionCount: 19)
  • 0 (ActionCount: 20)
  • 0 (ActionCount: 21)
  • 0 (ActionCount: 22)

Another option is to only show from min --> max by setting variables

Card Counts

Most popular overall card counts (totals, not # of decks): Urchin (Total: 13, House: Shadows)
Relentless Whispers (Total: 13, House: Shadows)
Bait and Switch (Total: 13, House: Shadows)
Nerve Blast (Total: 12, House: Shadows)
Yxilo Bolter (Total: 9, House: Mars)

Top 5 commons (totals, not # of decks):

Urchin (Total: 13)
Relentless Whispers (Total: 13)
Bait and Switch (Total: 13)
Nerve Blast (Total: 12)
Yxilo Bolter (Total: 9)

Top 5 uncommons (totals, not # of decks):

Old Bruno (Total: 5)
Nepenthe Seed (Total: 4)
Too Much to Protect (Total: 4)
Tentacus (Total: 4)
Subtle Maul (Total: 4)

Top 5 rares/specials (totals, not # of decks):

Help from Future Self (Total: 5)
Timetraveller (Total: 5)
Routine Job (Total: 4)
Qyxxlyx Plague Master (Total: 2)
Gabos Longarms (Total: 2)


Top 5 commons most likely to appear in a deck:

Bait and Switch (Decks: 13, Total: 13)
Relentless Whispers (Decks: 10, Total: 13)
Urchin (Decks: 9, Total: 13)
Nerve Blast (Decks: 8, Total: 12)
Nexus (Decks: 7, Total: 9)

Top 5 uncommons most likely to appear in a deck:

Old Bruno (Decks: 5, Total: 5)
Skeleton Key (Decks: 4, Total: 4)
Subtle Maul (Decks: 4, Total: 4)
Too Much to Protect (Decks: 3, Total: 4)
Snudge (Decks: 3, Total: 3)

GLOBAL COUNTS

Most popular house combos

Most popular house combos:

39 (Houses: •Dis•Logos•Shadows•)
31 (Houses: •Dis•Shadows•Untamed•)
27 (Houses: •Dis•Sanctum•Shadows•)
18 (Houses: •Brobnar•Shadows•Untamed•)
17 (Houses: •Dis•Mars•Shadows•)
17 (Houses: •Logos•Shadows•Untamed•)
14 (Houses: •Logos•Mars•Shadows•)
13 (Houses: •Brobnar•Logos•Shadows•)
13 (Houses: •Sanctum•Shadows•Untamed•)
11 (Houses: •Brobnar•Dis•Shadows•)


Graphical display of creature counts

  • 0 (CreatureCount: 10)
  • 7 (CreatureCount: 11)
  • 10 (CreatureCount: 12)
  • 10 (CreatureCount: 13)
  • 19 (CreatureCount: 14)
  • 43 (CreatureCount: 15)
  • 53 (CreatureCount: 16)
  • 30 (CreatureCount: 17)
  • 54 (CreatureCount: 18)
  • 46 (CreatureCount: 19)
  • 28 (CreatureCount: 20)
  • 23 (CreatureCount: 21)
  • 16 (CreatureCount: 22)
  • 3 (CreatureCount: 23)
  • 4 (CreatureCount: 24)
  • 2 (CreatureCount: 25)
  • 1 (CreatureCount: 26)
  • 1 (CreatureCount: 27)
  • 0 (CreatureCount: 28)
  • 0 (CreatureCount: 29)

Graphical display of action counts

  • 0 (ActionCount: 5)
  • 0 (ActionCount: 6)
  • 4 (ActionCount: 7)
  • 4 (ActionCount: 8)
  • 11 (ActionCount: 9)
  • 16 (ActionCount: 10)
  • 28 (ActionCount: 11)
  • 38 (ActionCount: 12)
  • 38 (ActionCount: 13)
  • 56 (ActionCount: 14)
  • 41 (ActionCount: 15)
  • 44 (ActionCount: 16)
  • 30 (ActionCount: 17)
  • 11 (ActionCount: 18)
  • 13 (ActionCount: 19)
  • 7 (ActionCount: 20)
  • 6 (ActionCount: 21)
  • 0 (ActionCount: 22)
  • 3 (ActionCount: 23)
  • 0 (ActionCount: 24)

Graphical display of artifact counts

  • 14 (ArtifactCount: 0)
  • 45 (ArtifactCount: 1)
  • 81 (ArtifactCount: 2)
  • 80 (ArtifactCount: 3)
  • 62 (ArtifactCount: 4)
  • 43 (ArtifactCount: 5)
  • 11 (ArtifactCount: 6)
  • 7 (ArtifactCount: 7)
  • 4 (ArtifactCount: 8)
  • 2 (ArtifactCount: 9)
  • 1 (ArtifactCount: 10)
  • 0 (ArtifactCount: 11)


Graphical display of upgrade counts

  • 112 (UpgradeCount: 0)
  • 105 (UpgradeCount: 1)
  • 91 (UpgradeCount: 2)
  • 20 (UpgradeCount: 3)
  • 18 (UpgradeCount: 4)
  • 3 (UpgradeCount: 5)
  • 1 (UpgradeCount: 6)
  • 0 (UpgradeCount: 7)