| 1 | SELECT `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` = 15379 LIMIT 1 | | 1 | 1 | 1 |
| 2 | SELECT 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` = 15379 | | 1 | 1 | 35 |
| 3 | SELECT `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` = 15379 ORDER BY `Application`.`app_id` asc LIMIT 100 | | 15 | 15 | 62 |
