An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Bureau of Justice Statistics (BJS)%' OR subject1 LIKE '%prison sentencing%' O' at line 2

SELECT identifier FROM research WHERE available = '1' AND approved = '1' AND subdomain != '1' AND research.identifier IN ('1991_nccd_prison_population_forecast_the_impact_of_declining_drug_arrests_focus', '2005_human_rights_in_the_heartland_an_assessment_of_social_economic_civil_and_political_rights_in_the_midwest', '2008_presidential_candidates_platforms_on_criminal_justice', '25_year_quagmire_the_war_on_drugs_and_its_impact_on_american_society', 'accelerated_release_a_literature_review_focus', 'accelerating_pace_of_juvenile_justice_reform', 'adolescents_competence_to_stand_trial_macarthur_juvenile_competence_study', 'advances_in_juvenile_justice_reform_2007_2008', 'aid_to_children_of_imprisoned_mothers_an_ethnographic_study', 'alameda_county_placement_risk_assessment_validation', 'alaskas_citizens_lock_out_private_prisons', 'alternatives_to_incarceration_for_women', 'americas_growing_correctional_industrial_complex', 'and_justice_for_some_differential_treatment_of_youth_of_color_in_the_justice_system', 'attitudes_of_californians_toward_effective_correctional_policies_focus', 'attitudes_of_us_voters_toward_nonserious_offenders_and_alternatives_to_incarceration', 'attitudes_of_us_voters_toward_prisoner_rehabilitation_and_reentry_policies_focus', 'attitudes_of_us_voters_toward_youth_crime_and_the_justice_system', 'breaking_the_cycle_of_abuse_in_juvenile_facilities', 'california_corrections_at_the_crossroads_focus', 'california_juvenile_justice_reentry_partnership', 'call_to_action_how_programs_in_three_cities_responded_to_the_prisoner_reentry_crisis', 'case_for_shorter_prison_terms_the_illinois_experience_focus', 'changing_direction_state_sentencing_reforms_2004_2006', 'china_organ_procurement_and_judicial_execution_in_china', 'continuing_the_struggle_for_justice_100_years_of_the_national_council_on_crime_and_delinquency', 'cost_effective_youth_corrections_rationalizing_the_fiscal_architecture_of_juvenile_justice_systems', 'criminal_justice_and_opportunity', 'criminal_justice_sentencing_policy_statement', 'dangers_of_detention_the_impact_of_incarcerating_youth_in_detention_and_other_secure_facilities', 'decade_of_reform_felony_disenfranchisement_policy_in_the_united_states', 'disparity_by_design_how_drug_free_zone_laws_impact_racial_disparity_and_fail_to_protect_youth', 'disproportionate_minority_contact_alameda_county', 'disproportionate_minority_contact_alameda_county_focus', 'doing_the_arts_justice_a_review_of_research_literature_practice_and_theory', 'drug_decriminalization_in_portugal_lessons_for_creating_fair_and_successful_drug_policies', 'educate_or_incarcerate_girls_in_the_florida_and_duval_county_juvenile_justice_systems', 'escalating_the_use_of_imprisonment_the_case_study_of_florida_focus', 'evaluation_of_the_ryse_program_alameda_county_probation_department', 'executive_summary_reforming_juvenile_detention_in_florida', 'extravagance_of_imprisonment_revisited', 'facing_the_future_juvenile_detention_in_alameda_county', 'faith_in_their_futures_the_youth_and_congregations_in_partnership_program_of_the_kings_county_brooklyn_ny_district_attorneys_office', 'feeding_america_agencies_and_food_programs_products_purchased_from_sources_other_than_food_banks', 'felony_disenfranchisement_laws_in_the_united_states', 'findings_from_the_philadelphia_detention_utilization_and_planning_study', 'from_options_to_action_a_roadmap_for_city_leaders_to_connect_formerly_incarcerated_individuals_to_work', 'from_options_to_action_a_roadmap_for_city_leaders_to_connect_formerly_incarcerated_individuals_to_work_executive_summary', 'general_corrections_review_of_the_california_youth_authority', 'getting_back_to_work_employment_programs_for_ex_offenders', 'getting_the_genie_back_in_the_bottle_californias_prison_gulag_special_report', 'human_rights_in_the_heartland', 'impact_of_the_power_to_change_performance_program_on_stress_and_health_risks_in_correctional_officers', 'implementation_and_outcome_evaluation_of_the_intensive_aftercare_program_final_report', 'investigation_of_philadelphias_youth_aid_panel_a_community_based_diversion_program_for_first_time_youthful_offenders', 'jailing_communities_the_impact_of_jail_expansion_and_effective_public_safety_strategies', 'joyce_foundations_transitional_jobs_reentry_demonstration_testing_strategies_to_help_former_prisoners_find_and_keep_jobs_and_stay_out_of_prison', 'juveniles_taken_into_custody_research_program_estimating_the_prevalence_of_juvenile_custody_by_race_and_gender_focus', 'juvenile_justice_in_florida_what_kind_of_future', 'juvenile_justice_redeeming_our_children', 'locking_up_family_values_the_detention_of_immigrant_families', 'mentoring_formerly_incarcerated_adults_insights_from_the_ready4work_reentry_initiative', 'mentoring_former_prisoners_a_guide_for_reentry_programs', 'models_for_change_building_momentum_for_juvenile_justice_reform', 'national_evaluation_of_community_assessment_centers_cac', 'nations_most_punitive_states_for_women', 'native_american_youth_and_juvenile_justice_system_amp40focusamp41', 'nccd_fact_sheet_youth_under_age_18_in_the_adult_criminal_justice_system', 'nccd_focus_a_rallying_cry_for_change_charting_a_new_direction_in_the_state_of_floridas_response_to_girls_in_juvenile_justice_executive_summary', 'nccd_focus_the_plight_of_children_whose_parents_are_in_prison', 'novel_condom_distribution_program_for_county_jail_prisoners', 'no_place_to_hide_understanding_and_meeting_the_needs_of_girls_in_the_california_juvenile_justice_system', 'prisons_in_crisis_a_state_of_emergency_in_california', 'prisons_pay_studies_research_or_ideology_focus', 'question_of_evidence_a_critique_of_risk_assessment_models_used_in_the_justice_system_a', 'rallying_cry_for_change_charting_a_new_direction_in_the_state_of_floridas_response_to_girls_in_juvenile_justice_executive_summary', 'rallying_cry_for_change_charting_a_new_direction_in_the_state_of_floridas_response_to_girls_in_the_juvenile_justice_system_amp40full_reportamp41_a', 'ranking_the_nations_most_punitive_and_costly_states_focus', 'ready4work_in_brief_update_on_outcomes_reentry_may_be_critical_for_states_cities', 'reducing_the_incarceration_of_women_community_based_alternatives', 'reforming_floridas_unjust_costly_and_ineffective_sentencing_laws', 'reforming_juvenile_detention_in_florida', 'reinventing_juvenile_justice', 'relief_from_the_collateral_consequences_of_a_criminal_conviction_a_state_by_state_resource_guide', 'report_and_recommendations_to_new_york_state_on_enhancing_employment_opportunities_for_formerly_incarcerated_people', 'report_on_people_under_criminal_justice_supervision_in_alameda_county', 'safe_passage', 'sentencing_reform_for_nonviolent_offenses_benefits_and_estimated_savings_for_illinois', 'spiral_of_risk_health_care_provision_to_incarcerated_women', 'state_of_the_art_in_jail_drug_treatment_programs', 'stopping_sexual_assaults_in_juvenile_corrections_facilities_a_case_study_of_the_california_division_of_juvenile_justice', 'substance_abuse_treatment_and_public_safety', 'survey_of_mental_health_care_delivery_to_youth_in_the_california_juvenile_justice_system_a', 'task_force_on_california_prison_crowding', 'transitional_jobs_for_ex_prisoners_early_impacts_from_a_random_assignment_evaluation_of_the_center_for_employment_opportunities_ceo_prisoner_reentry_program', 'transitional_jobs_for_ex_prisoners_implementation_two_year_impacts_and_costs_of_the_center_for_employment_opportunities_ceo_prisoner_reentry_program', 'uneven_justice_state_rates_of_incarceration_by_race_and_ethnicity', 'us_rates_of_incarceration_a_global_perspective_focus', 'vortex_the_concentrated_racial_impact_of_drug_imprisonment_and_the_characteristics_of_punitive_counties', 'when_the_gates_open_ready4work_a_national_response_to_the_prisoner_reentry_crisis', 'who_goes_to_prison', 'why_punish_the_children_a_reappraisal_of_the_children_of_incarcerated_mothers_in_america', 'women_in_the_criminal_justice_system', 'working_dads_final_report_on_the_fathers_at_work_initiative_executive_summary') AND subject1 LIKE '%U.S. Department of Justice's Bureau of Justice Statistics (BJS)%' OR subject1 LIKE '%prison sentencing%' ORDER BY identifier