[{"header":"cards with reduced quantities"},{"text":"We play with some, but not all, of the following cards.&nbsp; Remove the below listed quantities from your cube:"},{"sql":"SELECT (`dcdbdb`.`quantityInCube` - `dcdbdb_seasons`.`quantityLegal`) AS `value1`, `dcdbdb`.`name` AS `value3`, `dcdbdb`.`setFrom` AS `value2` FROM `dcdbdb` INNER JOIN `dcdbdb_seasons` ON `dcdbdb`.`ttsId` IN(`dcdbdb_seasons`.`ttsId`) AND `dcdbdb`.`typeKeyId` IN(1300, 1400, 1500, 1700, 1800) AND `dcdbdb`.`ttsId` NOT IN(9883) AND `dcdbdb_seasons`.`season` IN( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `dcdbdb_seasons`.`banned` IN(0) AND (`dcdbdb`.`quantityInCube` - `dcdbdb_seasons`.`quantityLegal`) != 0 ORDER BY `value2` ASC, `value3` ASC"},{"header":"banned main deck cards:"},{"sql":"SELECT `dcdbdb`.`quantityInCube` AS `value1`, `dcdbdb`.`name` AS `value3`, `dcdbdb`.`setFrom` AS `value2`, `dcdbdb`.`type` FROM `dcdbdb` INNER JOIN `dcdbdb_seasons` ON `dcdbdb`.`ttsId` IN(`dcdbdb_seasons`.`ttsId`) AND `dcdbdb`.`typeKeyId` IN(1300, 1400, 1500, 1700, 1800) AND `dcdbdb`.`ttsId` NOT IN(9883) AND `dcdbdb_seasons`.`season` IN( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `dcdbdb_seasons`.`banned` IN(1) ORDER BY `value2` ASC, `type` ASC, `value3` ASC"},{"text":"Banned Main Deck Card Count:"},{"sql":"SELECT `cardsBanned` AS `value1` FROM `dcdb_set_management` WHERE `season` = ( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `setId` = -1"},{"header":"bANNED super villains:"},{"sql":"SELECT `dcdbdb`.`name` AS `value1`, `dcdbdb`.`setFrom` AS `value2` FROM `dcdbdb` INNER JOIN `dcdbdb_seasons` ON `dcdbdb`.`ttsId` IN(`dcdbdb_seasons`.`ttsId`) AND `dcdbdb_seasons`.`season` IN( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `dcdbdb_seasons`.`banned` IN(1) AND `dcdbdb`.`typeKeyId` IN(22000) ORDER BY `dcdbdb`.`setFrom` ASC, `dcdbdb`.`name` ASC"},{"text":"Banned Super Villain Count:"},{"sql":"SELECT `svBanned` AS `value1` FROM `dcdb_set_management` WHERE `season` = ( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `setId` = -1"},{"header":"BANNED Main Characters:"},{"sql":"SELECT `dcdbdb`.`name` AS `value1`, `dcdbdb`.`setFrom` AS `value2` FROM `dcdbdb` INNER JOIN `dcdbdb_seasons` ON `dcdbdb`.`ttsId` IN(`dcdbdb_seasons`.`ttsId`) AND `dcdbdb_seasons`.`season` IN( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `dcdbdb_seasons`.`banned` IN(1) AND `dcdbdb`.`typeKeyId` IN(1250) ORDER BY `value2` ASC, `value1` ASC"},{"text":"Banned Main Character Count:"},{"sql":"SELECT `mcBanned` AS `value1` FROM `dcdb_set_management` WHERE `season` = ( SELECT `descriptionTwo` FROM `dcdb_rules_management` WHERE `id` = 4 ) AND `setId` = -1"}]