1 of 1
App ID Name Origin CDR
23490 Tropico 3: Steam Special Edition 4967
23491 tropico 3 content 4967
23492 Tropico 3: Steam Special Edition French 4967
23493 Tropico 3: Steam Special Edition German 4967
23494 Tropico 3: Steam Special Edition Italian 4967
23495 Tropico 3: Steam Special Edition Spanish 4967
23496 Tropico 3: Steam Special Edition English 4967
33670 Disciples 3 4967
33671 Disciples 3 Main 4967
33672 Disciples 3 English 4967
33673 Disciples 3 French 4967
33674 Disciples 3 German 4967
57650 Dungeons: Steam Special Edition 4967
57651 dungeons content 4967
57652 Dungeons: Steam Special Edition English 4967
57653 Dungeons: Steam Special Edition French 4967
57654 Dungeons: Steam Special Edition German 4967
57690 Tropico 4 4967
57691 Tropico 4 Main 4967
57692 Tropico 4 English 4967
57693 Tropico 4 German 4967
57694 Tropico 4 French 4967
57698 Tropico 4 spanish 4967
57699 Tropico 4 italian 4967
57740 Jagged Alliance - Back in Action 4967
57741 Jagged Alliance - Back in Action Binaries 4967
57742 Jagged Alliance - Back in Action Main 4967
57743 Jagged Alliance - Back in Action english 4967
57744 Jagged Alliance - Back in Action german 4967
57745 Jagged Alliance - Back in Action french 4967
57746 Jagged Alliance - Back in Action italian 4967
57747 Jagged Alliance - Back in Action spanish 4967
57748 Jagged Alliance - Back in Action Russian 4967
57749 Jagged Alliance - Back in Action Czech 4967
91100 SkyDrift 4967
91101 Skydrift final 4967
200550 Dungeons - The Dark Lord 4967
200551 Dungeons - The Dark Lord Content 4967
200552 Dungeons - The Dark Lord english 4967
200553 Dungeons - The Dark Lord german 4967
200554 Dungeons - The Dark Lord french 4967
200670 Disciples III Resurrection 4967
200671 Disciples III Resurrection Main 4967
200672 Disciples III Resurrection english 4967
200673 Disciples III Resurrection german 4967
201490 Airline Tycoon 2 4967
201491 Airline Tycoon 2 Release 4967
201492 Airline Tycoon 2 english 4967
201493 Airline Tycoon 2 german 4967
201494 Airline Tycoon 2 Base 4967
201495 Airline Tycoon 2 french 4967
203343 Jagged Alliance Back in Action DLC Urban Specialist Kit 4967
205610 Port Royale 3 4967
205611 pr3_depot_exe 4967
205612 pr3_depot_all 4967
205613 Port Royale 3 english 4967
205614 Port Royale 3 german 4967
207020 BangBangRacing 4967
207021 BangBangRacing Content 4967
211101 Jagged Alliance - Back in Action Polish 4967
1 of 1

(default) 3 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `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` = 15324 LIMIT 1110
2SELECT COUNT(*) AS `count` FROM `app` AS `Application` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`app_id` = `Application`.`app_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`sub_id` = 15324 110
3SELECT `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`, (`AppsSubs`.`cdr_id`) AS `Application__cdr_id`, `AppsSubs`.`app_id`, `AppsSubs`.`sub_id`, `AppsSubs`.`cdr_id`, `AppsSubs`.`cdr_id_last` FROM `app` AS `Application` LEFT JOIN `apps_subs` AS `AppsSubs` ON (`AppsSubs`.`app_id` = `Application`.`app_id` AND cdr_id_last IS NULL) WHERE `AppsSubs`.`sub_id` = 15324 ORDER BY `Application`.`app_id` asc LIMIT 10060600