Hibernate: select jobdescrip0_.id as id1_2_, jobdescrip0_.account_manager_name as account_2_2_, jobdescrip0_.additional_info as addition3_2_, jobdescrip0_.assignment_count as assignme4_2_, jobdescrip0_.bill_rate_currency as bill_rat5_2_, jobdescrip0_.bill_rate_period as bill_rat6_2_, jobdescrip0_.bonus as bonus7_2_, jobdescrip0_.bonus_currency as bonus_cu8_2_, jobdescrip0_.bonus_period as bonus_pe9_2_, jobdescrip0_.budget as budget10_2_, jobdescrip0_.city as city11_2_, jobdescrip0_.commission as commiss12_2_, jobdescrip0_.company_contact as company13_2_, jobdescrip0_.company_description as company14_2_, jobdescrip0_.company_id as company15_2_, jobdescrip0_.company_job_id as company16_2_, jobdescrip0_.company_name as company17_2_, jobdescrip0_.country as country18_2_, jobdescrip0_.created_by_id as created19_2_, jobdescrip0_.created_by_name as created20_2_, jobdescrip0_.created_date as created21_2_, jobdescrip0_.description as descrip22_2_, jobdescrip0_.duration as duratio23_2_, jobdescrip0_.education as educati24_2_, jobdescrip0_.external_display_id as externa25_2_, jobdescrip0_.external_id as externa26_2_, jobdescrip0_.high_level_requirements as high_le27_2_, jobdescrip0_.hmid as hmid28_2_, jobdescrip0_.hiring_manager_name as hiring_29_2_, jobdescrip0_.industry as industr30_2_, jobdescrip0_.irp_job_id as irp_job31_2_, jobdescrip0_.isfeatured as isfeatu32_2_, jobdescrip0_.job_type as job_typ33_2_, jobdescrip0_.last_modified_by_id as last_mo34_2_, jobdescrip0_.last_modified_by_name as last_mo35_2_, jobdescrip0_.last_modified_date as last_mo36_2_, jobdescrip0_.matching_category_id as matchin37_2_, jobdescrip0_.matching_category_label as matchin38_2_, jobdescrip0_.matching_category_title as matchin39_2_, jobdescrip0_.max_bill_rate as max_bil40_2_, jobdescrip0_.max_pay_rate as max_pay41_2_, jobdescrip0_.max_salary as max_sal42_2_, jobdescrip0_.min_bill_rate as min_bil43_2_, jobdescrip0_.min_pay_rate as min_pay44_2_, jobdescrip0_.min_salary as min_sal45_2_, jobdescrip0_.number_of_positions as number_46_2_, jobdescrip0_.opportunity_referral as opportu47_2_, jobdescrip0_.pay_rate_currency as pay_rat48_2_, jobdescrip0_.pay_rate_period as pay_rat49_2_, jobdescrip0_.probability as probabi50_2_, jobdescrip0_.published as publish51_2_, jobdescrip0_.published_date as publish52_2_, jobdescrip0_.qualification as qualifi53_2_, jobdescrip0_.responsibilities as respons54_2_, jobdescrip0_.salary_currency as salary_55_2_, jobdescrip0_.salary_period as salary_56_2_, jobdescrip0_.state as state57_2_, jobdescrip0_.status as status58_2_, jobdescrip0_.stock as stock59_2_, jobdescrip0_.target_date as target_60_2_, jobdescrip0_.title as title61_2_, jobdescrip0_.work_experience as work_ex62_2_, jobdescrip0_.zipcode as zipcode63_2_ from requisitions jobdescrip0_ where (jobdescrip0_.id in (?)) and jobdescrip0_.status=? and (jobdescrip0_.account_manager_name not like ?)