User:Coffeesaga/Sandbox/VT Query
2019 Indianapolis Sealed Worlds Collide Vault Tour
Call of the Archons Houses
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
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
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
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
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
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
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
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
<div class="housebrobnar" style="height:Expression error: Unexpected < operator.px;">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
<div class="housedis" style="height:Expression error: Unexpected < operator.px;">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
<div class="houselogos" style="height:Expression error: Unexpected < operator.px;">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
<div class="housemars" style="height:Expression error: Unexpected < operator.px;">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
<div class="housesanctum" style="height:Expression error: Unexpected < operator.px;">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
<div class="houseshadows" style="height:Expression error: Unexpected < operator.px;">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
<div class="houseuntamed" style="height:Expression error: Unexpected < operator.px;">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 |
||
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:
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:
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:
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:
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:
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:
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:
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)