select
   this_.id as id1_17_8_,
   this_.name as name2_17_8_,
   this_.clazz as clazz3_17_8_,
   this_.data_source_id as data_source_id6_17_8_,
   this_.fullName as fullName4_17_8_,
   this_.module_id as module_id5_17_8_,
   datasource2_.id as id1_7_0_,
   datasource2_.name as name2_7_0_,
   datasource2_.active as active3_7_0_,
   datasource2_.database as database4_7_0_,
   datasource2_.driver_class as driver_class5_7_0_,
   datasource2_.host as host6_7_0_,
   datasource2_.initial_pool_size as initial_pool_size7_7_0_,
   datasource2_.max_pool_size as max_pool_size8_7_0_,
   datasource2_.min_pool_size as min_pool_size9_7_0_,
   datasource2_."password" as password10_7_0_,
   datasource2_.port as port11_7_0_,
   datasource2_.ssh_tunnel_id as ssh_tunnel_id15_7_0_,
   datasource2_.type as type12_7_0_,
   datasource2_.url as url13_7_0_,
   datasource2_."user" as user14_7_0_,
   sshtunnel3_.id as id1_26_1_,
   sshtunnel3_.name as name2_26_1_,
   sshtunnel3_.host as host3_26_1_,
   sshtunnel3_."password" as password4_26_1_,
   sshtunnel3_.port as port5_26_1_,
   sshtunnel3_."user" as user6_26_1_,
   views4_.product_id as product_id11_17_10_,
   views4_.id as id1_19_10_,
   views4_.id as id1_19_2_,
   views4_.name as name2_19_2_,
   views4_.data_source_id as data_source_id10_19_2_,
   views4_.half_size as half_size3_19_2_,
   views4_.no_records as no_records4_19_2_,
   views4_.display_name as display_name5_19_2_,
   views4_.need_request_operations as need_request_opera6_19_2_,
   views4_.num as num7_19_2_,
   views4_.num_recs_in_widget as num_recs_in_widget8_19_2_,
   views4_.product_id as product_id11_19_2_,
   views4_.type as type9_19_2_,
   datasource5_.id as id1_7_3_,
   datasource5_.name as name2_7_3_,
   datasource5_.active as active3_7_3_,
   datasource5_.database as database4_7_3_,
   datasource5_.driver_class as driver_class5_7_3_,
   datasource5_.host as host6_7_3_,
   datasource5_.initial_pool_size as initial_pool_size7_7_3_,
   datasource5_.max_pool_size as max_pool_size8_7_3_,
   datasource5_.min_pool_size as min_pool_size9_7_3_,
   datasource5_."password" as password10_7_3_,
   datasource5_.port as port11_7_3_,
   datasource5_.ssh_tunnel_id as ssh_tunnel_id15_7_3_,
   datasource5_.type as type12_7_3_,
   datasource5_.url as url13_7_3_,
   datasource5_."user" as user14_7_3_,
   operations6_.product_view_id as product_view_id7_19_11_,
   operations6_.id as id1_18_11_,
   operations6_.id as id1_18_4_,
   operations6_.name as name2_18_4_,
   operations6_.clazz as clazz3_18_4_,
   operations6_.dashboard_visible as dashboard_visible4_18_4_,
   operations6_.data_source_id as data_source_id6_18_4_,
   operations6_.group_name as group_name5_18_4_,
   operations6_.product_view_id as product_view_id7_18_4_,
   datasource7_.id as id1_7_5_,
   datasource7_.name as name2_7_5_,
   datasource7_.active as active3_7_5_,
   datasource7_.database as database4_7_5_,
   datasource7_.driver_class as driver_class5_7_5_,
   datasource7_.host as host6_7_5_,
   datasource7_.initial_pool_size as initial_pool_size7_7_5_,
   datasource7_.max_pool_size as max_pool_size8_7_5_,
   datasource7_.min_pool_size as min_pool_size9_7_5_,
   datasource7_."password" as password10_7_5_,
   datasource7_.port as port11_7_5_,
   datasource7_.ssh_tunnel_id as ssh_tunnel_id15_7_5_,
   datasource7_.type as type12_7_5_,
   datasource7_.url as url13_7_5_,
   datasource7_."user" as user14_7_5_,
   operationm8_.id as id1_15_6_,
   operationm8_.name as name2_15_6_,
   operationm8_.caption as caption3_15_6_,
   operationm8_.clazz as clazz4_15_6_,
   operationm8_.data_source_id as data_source_id5_15_6_,
   operationm8_.focus_validation as focus_validation6_15_6_,
   operationm8_.icon_name as icon_name7_15_6_,
   operationm8_.js_client_script as js_client_script8_15_6_,
   operationm8_.load_validation as load_validation9_15_6_,
   operationm8_.meta as meta10_15_6_,
   operationm8_.type as type11_15_6_,
   operationm8_.vbs_client_script as vbs_client_script12_15_6_,
   datasource9_.id as id1_7_7_,
   datasource9_.name as name2_7_7_,
   datasource9_.active as active3_7_7_,
   datasource9_.database as database4_7_7_,
   datasource9_.driver_class as driver_class5_7_7_,
   datasource9_.host as host6_7_7_,
   datasource9_.initial_pool_size as initial_pool_size7_7_7_,
   datasource9_.max_pool_size as max_pool_size8_7_7_,
   datasource9_.min_pool_size as min_pool_size9_7_7_,
   datasource9_."password" as password10_7_7_,
   datasource9_.port as port11_7_7_,
   datasource9_.ssh_tunnel_id as ssh_tunnel_id15_7_7_,
   datasource9_.type as type12_7_7_,
   datasource9_.url as url13_7_7_,
   datasource9_."user" as user14_7_7_
from
   product_list this_
   inner join
      data_source datasource2_
      on this_.data_source_id = datasource2_.id
   left outer join
      ssh_tunnel sshtunnel3_
      on datasource2_.ssh_tunnel_id = sshtunnel3_.id
   left outer join
      product_view views4_
      on this_.id = views4_.product_id
   left outer join
      data_source datasource5_
      on views4_.data_source_id = datasource5_.id
   left outer join
      product_operation operations6_
      on views4_.id = operations6_.product_view_id
   left outer join
      data_source datasource7_
      on operations6_.data_source_id = datasource7_.id
   left outer join
      operation_meta operationm8_
      on operations6_.name = operationm8_.name
      and operations6_.clazz = operationm8_.clazz
      and operations6_.data_source_id = operationm8_.data_source_id
   left outer join
      data_source datasource9_
      on operationm8_.data_source_id = datasource9_.id
where
   this_.module_id = 'FIND_CLIENT';