Template:VT Query

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`="{{{VT}}}") 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`="{{{VT}}}") 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}") 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}") 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}") 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}") 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" 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`="{{{VT}}}" and (`cargo__EventDeck`.`Houses` like '%Untamed%') and (`cargo__EventDeck`.`SetName`="Call of the Archons") ORDER BY count() DESC LIMIT 100	16

Anonymous

Search

Template:VT Query

Namespaces

More

Page actions

Call of the Archons Houses

Navigation

Quick Links

Cards

Navigation

Wiki tools

Wiki tools

Anonymous

Search

Template:VT Query

Call of the Archons Houses

Navigation

Wiki tools

Page tools