1 of 1
CDR ID State Changes
12691 user_defined => {"icon": "steam/games/icon_Thief_Deadly_Shadows", "order": "1", "state": "eStateAvailable", "gamedir": "Thief Deadly Shadows", "homepage": "http: //www.eidos.co.uk/gss/thief_ds/", "NoServers": "1", "developer": "Eidos", "CWDOverride": "System", "primarycache": "6981", "InstallScript": "installscript.vdf", "LaunchEULA": "http: //store.steampowered.com/eula/eula_eidos", "serverbrowsername": "", "DisableOverlay": "1"}
10553 sub_count => 47
5304 sub_count => 42
4946 sub_count => 41
3818 sub_count => 40
3624 sub_count => 39
2489 sub_count => 38
1 Created
1 of 1

(default) 7 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `app`20201
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `app_state_capture`21211
4SELECT `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
5SELECT COUNT(*) AS `count` FROM `app_state_capture` AS `AppStateCapture` WHERE `app_id` = 6980 110
6SELECT `AppStateCapture`.`cdr_id`, `AppStateCapture`.`created`, `AppStateCapture`.`app_id`, `AppStateCapture`.`name`, `AppStateCapture`.`install_dir`, `AppStateCapture`.`min_cache_size`, `AppStateCapture`.`max_cache_size`, `AppStateCapture`.`launch_options`, `AppStateCapture`.`on_first_launch`, `AppStateCapture`.`is_bandwidth_greedy`, `AppStateCapture`.`current_version_id`, `AppStateCapture`.`trickle_version_id`, `AppStateCapture`.`user_defined`, `AppStateCapture`.`beta_version_password`, `AppStateCapture`.`beta_version_id`, `AppStateCapture`.`legacy_install_dir`, `AppStateCapture`.`skip_mfp_overwrite`, `AppStateCapture`.`use_filesystem_dvr`, `AppStateCapture`.`manifest_only`, `AppStateCapture`.`app_of_manifest_only`, `AppStateCapture`.`sub_count` FROM `app_state_capture` AS `AppStateCapture` WHERE `app_id` = 6980 ORDER BY `AppStateCapture`.`cdr_id` desc LIMIT 100881
7SHOW FULL COLUMNS FROM `cdr`771