Sub ID 2813
Last Updated 2012-10-29 18:47:11
Name ID Software Beta
Billing Type ProofOfPrepurchaseOnly
Cost (in cents) 0
Period (in minutes) 0
On Subscribe Run App ID -1
On Subscribe Launch Option -1
Is Preorder false
Requires Shipping Address false
Domestic Cost 0
International Cost 0
Required Key Type 1
Is Cyber Cafe false
Game Code 8
Game Code Description IDBeta
Is Disabled false
Requires CD false
Territory Code 146
Is Steam3 Subscription true
Extended Info state = eStateAvailable
ReleaseStateOverride = released
(default) 3 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `sub`24241
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SELECT `Subscription`.`sub_id`, `Subscription`.`name`, `Subscription`.`billing_type`, `Subscription`.`cost_in_cents`, `Subscription`.`period_in_minutes`, `Subscription`.`on_subscribe_run_app_id`, `Subscription`.`on_subscribe_run_launch_option_index`, `Subscription`.`rate_limits`, `Subscription`.`discounts`, `Subscription`.`is_preorder`, `Subscription`.`requires_shipping_address`, `Subscription`.`domestic_cost_in_cents`, `Subscription`.`international_cost_in_cents`, `Subscription`.`required_key_type`, `Subscription`.`is_cyber_cafe`, `Subscription`.`game_code`, `Subscription`.`game_code_description`, `Subscription`.`is_disabled`, `Subscription`.`requires_cd`, `Subscription`.`territory_code`, `Subscription`.`is_steam3_subscription`, `Subscription`.`extended_info`, `Subscription`.`app_count`, `Subscription`.`date_updated` FROM `sub` AS `Subscription` WHERE `Subscription`.`sub_id` = 2813 LIMIT 1110