| 4 | 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` FROM `app` AS `Application` WHERE `name` LIKE '%planescape%' ORDER BY `Application`.`app_id` asc LIMIT 100 | | 2 | 2 | 34 |