SELECTc0_.idASid_0,c0_.production_dateASproduction_date_1,c0_.bundle_numberASbundle_number_2,c0_.mine_bundle_codeASmine_bundle_code_3,c0_.bundle_lot_numberASbundle_lot_number_4,c0_.bundle_lot_rangeASbundle_lot_range_5,c0_.bundle_lot_codeASbundle_lot_code_6,c0_.net_weightASnet_weight_7,c0_.nb_sheetsASnb_sheets_8,c0_.auto_strippingASauto_stripping_9,c0_.commentAScomment_10,c0_.entry_dateASentry_date_11,c0_.shiftASshift_12,c0_.tareAStare_13,c0_.washedASwashed_14,c0_.gross_weightASgross_weight_15,c0_.seal1ASseal1_16,c0_.seal2ASseal2_17,c0_.net_weight_from_scaleASnet_weight_from_scale_18,c0_.gross_weight_from_scaleASgross_weight_from_scale_19,c0_.encoded_by_idASencoded_by_id_20,c0_.checked_by_idASchecked_by_id_21,c0_.inspected_by_idASinspected_by_id_22,c0_.visual_grade_idASvisual_grade_id_23,c0_.status_idASstatus_id_24,c0_.unit_idASunit_id_25FROMcopper_bundlesc0_LEFT JOINlist_bundle_gradesl1_ONc0_.visual_grade_id=l1_.idWHEREc0_.idIN (?,?,?,?,?,?,?,?,?,?,?) ORDER BYc0_.visual_grade_idDESC
SELECTc0_.idASid_0,c0_.production_dateASproduction_date_1,c0_.bundle_numberASbundle_number_2,c0_.mine_bundle_codeASmine_bundle_code_3,c0_.bundle_lot_numberASbundle_lot_number_4,c0_.bundle_lot_rangeASbundle_lot_range_5,c0_.bundle_lot_codeASbundle_lot_code_6,c0_.net_weightASnet_weight_7,c0_.nb_sheetsASnb_sheets_8,c0_.auto_strippingASauto_stripping_9,c0_.commentAScomment_10,c0_.entry_dateASentry_date_11,c0_.shiftASshift_12,c0_.tareAStare_13,c0_.washedASwashed_14,c0_.gross_weightASgross_weight_15,c0_.seal1ASseal1_16,c0_.seal2ASseal2_17,c0_.net_weight_from_scaleASnet_weight_from_scale_18,c0_.gross_weight_from_scaleASgross_weight_from_scale_19,c0_.encoded_by_idASencoded_by_id_20,c0_.checked_by_idASchecked_by_id_21,c0_.inspected_by_idASinspected_by_id_22,c0_.visual_grade_idASvisual_grade_id_23,c0_.status_idASstatus_id_24,c0_.unit_idASunit_id_25FROMcopper_bundlesc0_LEFT JOINlist_bundle_gradesl1_ONc0_.visual_grade_id=l1_.idWHEREc0_.idIN (?,?,?,?,?,?,?,?,?,?,?)
ORDER BYc0_.visual_grade_idDESC
SELECTc0_.idASid_0,c0_.production_dateASproduction_date_1,c0_.bundle_numberASbundle_number_2,c0_.mine_bundle_codeASmine_bundle_code_3,c0_.bundle_lot_numberASbundle_lot_number_4,c0_.bundle_lot_rangeASbundle_lot_range_5,c0_.bundle_lot_codeASbundle_lot_code_6,c0_.net_weightASnet_weight_7,c0_.nb_sheetsASnb_sheets_8,c0_.auto_strippingASauto_stripping_9,c0_.commentAScomment_10,c0_.entry_dateASentry_date_11,c0_.shiftASshift_12,c0_.tareAStare_13,c0_.washedASwashed_14,c0_.gross_weightASgross_weight_15,c0_.seal1ASseal1_16,c0_.seal2ASseal2_17,c0_.net_weight_from_scaleASnet_weight_from_scale_18,c0_.gross_weight_from_scaleASgross_weight_from_scale_19,c0_.encoded_by_idASencoded_by_id_20,c0_.checked_by_idASchecked_by_id_21,c0_.inspected_by_idASinspected_by_id_22,c0_.visual_grade_idASvisual_grade_id_23,c0_.status_idASstatus_id_24,c0_.unit_idASunit_id_25FROMcopper_bundlesc0_LEFT JOINlist_bundle_gradesl1_ONc0_.visual_grade_id=l1_.idWHEREc0_.idIN (82,66,50,46,43,39,35,23,13,11,1) ORDER BYc0_.visual_grade_idDESC;