делаю отчёт в jasper reports и столкнулся с такой задачей:

SELECT itemstocke0_.id AS id1_431_0_,
         itemstockl1_.id AS id1_0_1_,
         lotentity2_.id AS id1_467_2_,
         itementity3_.id AS id1_237_3_,
         stocknodee4_.id AS id1_292_4_,
         itemstocke0_.created_at AS created_2_431_0_,
         itemstocke0_.created_by AS created_3_431_0_,
         itemstocke0_.mdm_code AS mdm_code4_431_0_,
         itemstocke0_.storm_single_string AS storm_si5_431_0_,
         itemstocke0_.changed_at AS changed_6_431_0_,
         itemstocke0_.changed_by AS changed_7_431_0_,
         itemstocke0_.version AS version8_431_0_,
         itemstocke0_.complect_id AS complec11_431_0_,
         itemstocke0_.contract_id AS contrac12_431_0_,
         itemstocke0_.contractor_id AS contrac13_431_0_,
         itemstocke0_.customerorder_id AS custome14_431_0_,
         itemstocke0_.itemrevision_id AS itemrev15_431_0_,
         itemstocke0_.kit_id AS kit_id16_431_0_,
         itemstocke0_.markettype_id AS markett17_431_0_,
         itemstocke0_.option_id AS option_18_431_0_,
         itemstocke0_.primarydemand_id AS primary19_431_0_,
         itemstocke0_.is_nonnettabale AS is_nonne9_431_0_,
         itemstocke0_.item_id AS item_id20_431_0_,
         itemstocke0_.lot_id AS lot_id21_431_0_,
         itemstocke0_.qty_onhand AS qty_onh10_431_0_,
         itemstocke0_.stock_node_id AS stock_n22_431_0_,
         itemstocke0_.stockcell_id AS stockce23_431_0_,
         itemstockl1_.is_non_analytic AS is_non_a2_0_1_,
         itemstockl1_.qty_allocated AS qty_allo3_0_1_,
         itemstockl1_.qty_available AS qty_avai4_0_1_,
         itemstockl1_.qty_free AS qty_free5_0_1_,
         itemstockl1_.qty_reserved AS qty_rese6_0_1_,
         itemstockl1_.totalcost AS totalcos7_0_1_,
         lotentity2_.created_at AS created_2_467_2_,
         lotentity2_.created_by AS created_3_467_2_,
         lotentity2_.mdm_code AS mdm_code4_467_2_,
         lotentity2_.storm_single_string AS storm_si5_467_2_,
         lotentity2_.changed_at AS changed_6_467_2_,
         lotentity2_.changed_by AS changed_7_467_2_,
         lotentity2_.version AS version8_467_2_,
         lotentity2_.comment AS comment9_467_2_,
         lotentity2_.date_conservation AS date_co10_467_2_,
         lotentity2_.date_release AS date_re11_467_2_,
         lotentity2_.delivery_lot_id AS deliver46_467_2_,
         lotentity2_.delivery_lot AS deliver12_467_2_,
         lotentity2_.dim_height AS dim_hei13_467_2_,
         lotentity2_.dim_length AS dim_len14_467_2_,
         lotentity2_.dim_section AS dim_sec15_467_2_,
         lotentity2_.dim_thickness AS dim_thi16_467_2_,
         lotentity2_.dim_width AS dim_wid17_467_2_,
         lotentity2_.expiration_date AS expirat18_467_2_,
         lotentity2_.gauge_id AS gauge_i47_467_2_,
         lotentity2_.gauge_standard_id AS gauge_s48_467_2_,
         lotentity2_.is_scrap AS is_scra19_467_2_,
         lotentity2_.item_id AS item_id49_467_2_,
         lotentity2_.labour_cost AS labour_20_467_2_,
         lotentity2_.material_cost AS materia21_467_2_,
         lotentity2_.material_grade_id AS materia50_467_2_,
         lotentity2_.material_standard_id AS materia51_467_2_,
         lotentity2_.melting AS melting22_467_2_,
         lotentity2_.name AS name23_467_2_,
         lotentity2_.qualitymap AS quality24_467_2_,
         lotentity2_.qualitymapdate AS quality25_467_2_,
         lotentity2_.shelf_life_date AS shelf_l26_467_2_,
         lotentity2_.testcertificate AS testcer27_467_2_,
         lotentity2_.testcertificatedate AS testcer28_467_2_,
         lotentity2_.testreport AS testrep29_467_2_,
         lotentity2_.testreportdate AS testrep30_467_2_,
         lotentity2_.trace_id AS trace_i52_467_2_,
         lotentity2_.udf_bool_1 AS udf_boo31_467_2_,
         lotentity2_.udf_bool_2 AS udf_boo32_467_2_,
         lotentity2_.udf_bool_3 AS udf_boo33_467_2_,
         lotentity2_.udf_classifier1_id AS udf_cla53_467_2_,
         lotentity2_.udf_classifier2_id AS udf_cla54_467_2_,
         lotentity2_.udf_classifier3_id AS udf_cla55_467_2_,
         lotentity2_.udf_date_1 AS udf_dat34_467_2_,
         lotentity2_.udf_date_2 AS udf_dat35_467_2_,
         lotentity2_.udf_deci_1 AS udf_dec36_467_2_,
         lotentity2_.udf_deci_2 AS udf_dec37_467_2_,
         lotentity2_.udf_deci_3 AS udf_dec38_467_2_,
         lotentity2_.udf_int_1 AS udf_int39_467_2_,
         lotentity2_.udf_int_2 AS udf_int40_467_2_,
         lotentity2_.udf_int_3 AS udf_int41_467_2_,
         lotentity2_.udf_str_1 AS udf_str42_467_2_,
         lotentity2_.udf_str_2 AS udf_str43_467_2_,
         lotentity2_.udf_str_3 AS udf_str44_467_2_,
         lotentity2_.unitcost AS unitcos45_467_2_,
         itementity3_.created_at AS created_2_237_3_,
         itementity3_.created_by AS created_3_237_3_,
         itementity3_.mdm_code AS mdm_code4_237_3_,
         itementity3_.storm_single_string AS storm_si5_237_3_,
         itementity3_.changed_at AS changed_6_237_3_,
         itementity3_.changed_by AS changed_7_237_3_,
         itementity3_.version AS version8_237_3_,
         itementity3_.alt_grp_id AS alt_grp_9_237_3_,
         itementity3_.analyticsgroup_id AS analyti86_237_3_,
         itementity3_.buffer_in AS buffer_10_237_3_,
         itementity3_.buffer_out AS buffer_11_237_3_,
         itementity3_.str_code AS str_cod12_237_3_,
         itementity3_.confclassification_id AS confcla87_237_3_,
         itementity3_.crooked_planning AS crooked13_237_3_,
         itementity3_.days_supply AS days_su14_237_3_,
         itementity3_.define_of_setup_yield AS define_15_237_3_,
         itementity3_.define_of_test_yield AS define_16_237_3_,
         itementity3_.description AS descrip17_237_3_,
         itementity3_.dim_diameter AS dim_dia18_237_3_,
         itementity3_.dim_height AS dim_hei19_237_3_,
         itementity3_.dim_length AS dim_len20_237_3_,
         itementity3_.dim_section AS dim_sec21_237_3_,
         itementity3_.dim_thickness AS dim_thi22_237_3_,
         itementity3_.dim_width AS dim_wid23_237_3_,
         itementity3_.dispatch_starting AS dispatc24_237_3_,
         itementity3_.executor_id AS executo88_237_3_,
         itementity3_.ext_name AS ext_nam25_237_3_,
         itementity3_.for_forecast AS for_for26_237_3_,
         itementity3_.gauge_id AS gauge_i89_237_3_,
         itementity3_.gauge_standard_id AS gauge_s90_237_3_,
         itementity3_.is_by_lot AS is_by_l27_237_3_,
         itementity3_.is_by_serial AS is_by_s28_237_3_,
         itementity3_.is_critical_item AS is_crit29_237_3_,
         itementity3_.is_ebom_node AS is_ebom30_237_3_,
         itementity3_.is_incoming_control_on AS is_inco31_237_3_,
         itementity3_.is_planned_item AS is_plan32_237_3_,
         itementity3_.is_sale_item AS is_sale33_237_3_,
         itementity3_.iss_deviation_minus AS iss_dev34_237_3_,
         itementity3_.iss_deviation_plus AS iss_dev35_237_3_,
         itementity3_.iteminventorygroup_id AS iteminv91_237_3_,
         itementity3_.itemplanninggroup_id AS itempla92_237_3_,
         itementity3_.itemtype_id AS itemtyp93_237_3_,
         itementity3_.labour_unitcost AS labour_36_237_3_,
         itementity3_.launch_project_rule AS launch_37_237_3_,
         itementity3_.launch_window AS launch_38_237_3_,
         itementity3_.lead_time AS lead_ti39_237_3_,
         itementity3_.lowlevel AS lowleve40_237_3_,
         itementity3_.machine_unitcost AS machine41_237_3_,
         itementity3_.manufactory_type AS manufac42_237_3_,
         itementity3_.material_grade_id AS materia94_237_3_,
         itementity3_.material_standard_id AS materia95_237_3_,
         itementity3_.material_unitcost AS materia43_237_3_,
         itementity3_.model_id AS model_i96_237_3_,
         itementity3_.mps_demand_time_fence AS mps_dem44_237_3_,
         itementity3_.name AS name45_237_3_,
         itementity3_.obsoleted AS obsolet46_237_3_,
         itementity3_.order_maximum AS order_m47_237_3_,
         itementity3_.order_minimal AS order_m48_237_3_,
         itementity3_.order_multiply AS order_m49_237_3_,
         itementity3_.order_optimal AS order_o50_237_3_,
         itementity3_.overhead_unitcost AS overhea51_237_3_,
         itementity3_.parent_flashing AS parent_52_237_3_,
         itementity3_.part_by_allocate AS part_by53_237_3_,
         itementity3_.phantom_type AS phantom54_237_3_,
         itementity3_.planner_id AS planner97_237_3_,
         itementity3_.planning_horizon AS plannin55_237_3_,
         itementity3_.planning_type AS plannin56_237_3_,
         itementity3_.po_analytics_group_id AS po_anal98_237_3_,
         itementity3_.printing_description AS printin57_237_3_,
         itementity3_.productclassification_id AS product99_237_3_,
         itementity3_.qualclassification_id AS qualcl100_237_3_,
         itementity3_.reset_analytic AS reset_a58_237_3_,
         itementity3_.revision_rule AS revisio59_237_3_,
         itementity3_.route_rule AS route_r60_237_3_,
         itementity3_.safety_stock_allocate_horizon AS safety_61_237_3_,
         itementity3_.safety_stock_allocate_if_overdue AS safety_62_237_3_,
         itementity3_.scrap AS scrap63_237_3_,
         itementity3_.setup_yield AS setup_y64_237_3_,
         itementity3_.shelf_life AS shelf_l65_237_3_,
         itementity3_.single_lot AS single_66_237_3_,
         itementity3_.skip_bom AS skip_bo67_237_3_,
         itementity3_.split_lot AS split_l68_237_3_,
         itementity3_.status_id AS status101_237_3_,
         itementity3_.stock_node_id AS stock_102_237_3_,
         itementity3_.stocktrans_id AS stockt103_237_3_,
         itementity3_.substitution_item_id AS substi104_237_3_,
         itementity3_.test_yield AS test_yi69_237_3_,
         itementity3_.udf_bool_1 AS udf_boo70_237_3_,
         itementity3_.udf_bool_2 AS udf_boo71_237_3_,
         itementity3_.udf_bool_3 AS udf_boo72_237_3_,
         itementity3_.udf_classifier1_id AS udf_cl105_237_3_,
         itementity3_.udf_classifier2_id AS udf_cl106_237_3_,
         itementity3_.udf_classifier3_id AS udf_cl107_237_3_,
         itementity3_.udf_date_1 AS udf_dat73_237_3_,
         itementity3_.udf_date_2 AS udf_dat74_237_3_,
         itementity3_.udf_deci_1 AS udf_dec75_237_3_,
         itementity3_.udf_deci_2 AS udf_dec76_237_3_,
         itementity3_.udf_deci_3 AS udf_dec77_237_3_,
         itementity3_.udf_int_1 AS udf_int78_237_3_,
         itementity3_.udf_int_2 AS udf_int79_237_3_,
         itementity3_.udf_int_3 AS udf_int80_237_3_,
         itementity3_.udf_str_1 AS udf_str81_237_3_,
         itementity3_.udf_str_2 AS udf_str82_237_3_,
         itementity3_.udf_str_3 AS udf_str83_237_3_,
         itementity3_.unitmeasure_id AS unitme108_237_3_,
         itementity3_.use_expiration_date AS use_exp84_237_3_,
         itementity3_.weight_per_unit AS weight_85_237_3_,
         stocknodee4_.created_at AS created_2_292_4_,
         stocknodee4_.created_by AS created_3_292_4_,
         stocknodee4_.mdm_code AS mdm_code4_292_4_,
         stocknodee4_.storm_single_string AS storm_si5_292_4_,
         stocknodee4_.changed_at AS changed_6_292_4_,
         stocknodee4_.changed_by AS changed_7_292_4_,
         stocknodee4_.version AS version8_292_4_,
         stocknodee4_.str_code AS str_code9_292_4_,
         stocknodee4_.description AS descrip10_292_4_,
         stocknodee4_.is_distributable AS is_dist11_292_4_,
         stocknodee4_.is_nonnettabale AS is_nonn12_292_4_,
         stocknodee4_.mlm_node_id AS mlm_nod16_292_4_,
         stocknodee4_.name AS name13_292_4_,
         stocknodee4_.obsoleted AS obsolet14_292_4_,
         stocknodee4_.usemi AS usemi15_292_4_,
         stocknodee4_.warehouse_type_id AS warehou17_292_4_,
         stocknodee4_1_.is_by_address AS is_by_ad1_291_4_,
         stocknodee4_1_.warehouse_id AS warehous3_291_4_,
         stocknodee4_2_.default_location_id AS default_2_296_4_
FROM wm_itemstock itemstocke0_
INNER JOIN 
    (SELECT *
    FROM itemstocklot_view ) itemstockl1_
    ON itemstocke0_.id=itemstockl1_.id
INNER JOIN wm_lot lotentity2_
    ON itemstocke0_.lot_id=lotentity2_.id
INNER JOIN mdm_item itementity3_
    ON itemstocke0_.item_id=itementity3_.id
INNER JOIN mlm_stocknode stocknodee4_
    ON itemstocke0_.stock_node_id=stocknodee4_.id LEFT OUTER
JOIN mlm_stocklocation stocknodee4_1_
    ON stocknodee4_.id=stocknodee4_1_.id LEFT OUTER
JOIN mlm_warehouse stocknodee4_2_
    ON stocknodee4_.id=stocknodee4_2_.id
    ORDER BY itemstocke0_.id