Help!!!!! with this query
select this_.id as id15_0_, this_.creation_date as creation2_15_0_, this_.last_modified as last3_15_0_, this_.advanced_batch_class as advanced4_15_0_, this_.curr_user as curr5_15_0_, this_.batch_class_description as batch6_15_0_, this_.identifier as identifier15_0_, this_.is_deleted as is8_15_0_, this_.last_modified_by as last9_15_0_, this_.batch_class_name as batch10_15_0_, this_.priority as priority15_0_, this_.process_name as process12_15_0_, this_.unc_folder as unc13_15_0_, this_.batch_class_version as batch14_15_0_ from batch_class this_ where this_.id in (/* criteria query */ select distinct this_.id as y0_ from batch_class this_ inner join batch_class_groups assignedgr1_ on this_.id=assignedgr1_.batch_class_id where assignedgr1_.group_name in ()) and (this_.is_deleted is null or this_.is_deleted=?) order by this_.id asc];