1 of 1
Sub ID Name Origin CDR
61 Steam Master 1
264 ValveTestSub 264 Complimentary 1
297 Thief: Deadly Shadows 1
771 Eidos Collector Pack 1
772 Eidos Collector Pack (DE) 1
2687 Eidos Collector Pack 1
2688 Eidos Collector Pack (DE) 1
4581 Square Enix Eidos Collector's Pack 1
4582 Square Enix Eidos Collector's Pack 1
4583 Square Enix Eidos Collector's Pack 1
4811 Square Public Released Comp 1
6931 Square Holiday Pack (NA) 1
6932 Square Holiday Pack (DE) 1
6933 Square Holiday Pack (AU) 1
6934 Square Holiday Pack (RU) 1
6935 Square Holiday Pack (JP) 1
6936 Square Holiday Pack (RoW) 1
7304 Square Complete Pack - Feb 2011 (NA) 1
7305 Square Complete Pack - Feb 2011 (DE) 1
7306 Square Complete Pack - Feb 2011 (AU) 1
7307 Square Complete Pack - Feb 2011 (RU) 1
7308 Square Complete Pack - Feb 2011 (JP) 1
7309 Square Complete Pack - Feb 2011 (RoW) 1
8592 Thief Deadly Shadows Comp 1
12816 Holiday Sale 2011 Gift: Thief: Deadly Shadows 1
13068 Winter Sale 2011: Square Pack 1
13069 Winter Sale 2011: Square Pack 1
13070 Winter Sale 2011: Square Pack 1
13071 Winter Sale 2011: Square Pack 1
13072 Winter Sale 2011: Square Pack 1
13073 Winter Sale 2011: Square Pack 1
13074 Winter Sale 2011: Square Pack 1
13075 Winter Sale 2011: Square Pack 1
13076 Winter Sale 2011: Square Pack 1
13870 Square Enix Hit Collection (ROW) 2489
13871 Square Enix Hit Collection (DE) 2489
13872 Square Enix Hit Collection (RU) 2489
13873 Square Enix Hit Collection (CN) 2489
14734 Thief Bundle 2012 3624
14817 Thief Collection 3818
15299 Square Hit Collection (Summer 2012) 4946
15580 Square Collection 5304
18676 SQUARE ENIX HIT COLLECTION - RU (December 2012) 10553
18677 SQUARE ENIX HIT COLLECTION - DE (December 2012) 10553
18678 SQUARE ENIX HIT COLLECTION - ROW (December 2012) 10553
18679 SQUARE ENIX HIT COLLECTION - CIS (December 2012) 10553
18680 SQUARE ENIX HIT COLLECTION - ASIA (December 2012) 10553
1 of 1

(default) 3 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Application`.`app_id`, `Application`.`name`, `Application`.`install_dir`, `Application`.`min_cache_size`, `Application`.`max_cache_size`, `Application`.`launch_options`, `Application`.`on_first_launch`, `Application`.`is_bandwidth_greedy`, `Application`.`current_version_id`, `Application`.`trickle_version_id`, `Application`.`user_defined`, `Application`.`beta_version_password`, `Application`.`beta_version_id`, `Application`.`legacy_install_dir`, `Application`.`skip_mfp_overwrite`, `Application`.`use_filesystem_dvr`, `Application`.`manifest_only`, `Application`.`app_of_manifest_only`, `Application`.`sub_count`, `Application`.`date_updated` FROM `app` AS `Application` WHERE `Application`.`app_id` = 6980 LIMIT 1110
2SELECT COUNT(*) AS `count` FROM `sub` AS `Subscription` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`sub_id` = `Subscription`.`sub_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`app_id` = 6980 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`, (`AppsSubs`.`cdr_id`) AS `Subscription__cdr_id`, `AppsSubs`.`app_id`, `AppsSubs`.`sub_id`, `AppsSubs`.`cdr_id`, `AppsSubs`.`cdr_id_last` FROM `sub` AS `Subscription` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`sub_id` = `Subscription`.`sub_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`app_id` = 6980 ORDER BY `Subscription`.`sub_id` asc LIMIT 10047470