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 New%' OR subject1 LIKE '%Recent Events%' OR subject1 LIKE '%Meetings%' OR s' at line 2

SELECT identifier FROM research WHERE available = '1' AND approved = '1' AND subdomain != '1' AND research.identifier IN ('2002_annual_update_of_and_justice_for_all_dvrpcs_strategy_for_fair_treatment_and_meaningful_involvement_of_all_people', '2003_annual_update_to_and_justice_for_all_dvrpcs_strategy_for_fair_treatment_and_meaningful_involvement_of_all_people', '2004_annual_update_to_and_justice_for_all_dvrpcs_strategy_for_fair_treatment_and_meaningful_involvement_of_all_people', '2009_regional_safety_action_plan_improving_transportation_safety_in_the_delaware_valley', '2009_safety_action_plan_emphasis_area_cards', 'active_transportation_for_america', 'affordability_index_a_new_tool_for_measuring_the_true_affordability_of_a_housing_choice', 'automobile_at_rest_toward_better_parking_policies_in_the_delaware_valley', 'automotive_efficiency_using_technology_to_reduce_energy_use_in_passenger_vehicles_and_light_trucks', 'background_paper_2_finances_profiteering_and_infrastructure', 'benchmarking_data_bicycling_and_walking_in_the_us_2007', 'bicycles_pedaling_into_the_spotlight', 'bicycle_bus_conflict_area_study', 'bicycle_retailers_and_advocacy_survey', 'bicycle_safety_campaign_review', 'bicycling_and_walking_in_the_us_2007_benchmarking_report', 'bicycling_and_walking_in_the_us_2010_benchmarking_report', 'bicycling_in_the_delaware_valley_in_2005_use_safety_and_demographics', 'breakin_the_heart_of_it_all_how_odot_subverts_the_nepa_environmental_review_process_and_damage_ohios_environment_and_communities', 'bus_rapid_transit_systems_expanding_transit_investment_alternatives_at_the_federal_level', 'car_and_the_city_24_steps_to_safe_streets_and_healthy_communities', 'cascadia_scorecard_2006_focus_on_sprawl_and_health', 'cascadia_scorecard_2007_seven_key_trends_shaping_the_northwest', 'commercializing_alternative_fuels_and_advanced_vehicle_technologies_the_governments_role', 'connections_the_regional_plan_for_a_sustainable_future', 'creating_new_jobs_cutting_carbon_emissions_and_reducing_oil_imports_by_investing_in_renewable_energy_and_energy_efficiency', 'crossroads_ii_marshall_report_996', 'data_highlights_americas_century_long_love_affair_with_the_car_may_be_coming_to_an_end', 'debunking_portland_the_city_that_doesnt_work', 'diesel_buses_oil_prices_and_premature_deaths_from_particulate_matter_understanding_the_connections_exploring_solutions', 'does_rail_transit_save_energy_or_reduce_greenhouse_gas_emissions', 'do_you_know_the_way_to_la_san_jose_shows_how_to_turn_an_urban_area_into_los_angeles_in_three_stressful_decades', 'driven_to_spend_pumping_dollars_out_of_our_households_and_communities', 'economic_impacts_of_planned_transportation_investments_in_new_jersey', 'employment_in_new_york_citys_air_transportation_subsector', 'employment_in_new_york_citys_support_activities_for_transportation_subsector', 'employment_in_new_york_citys_transit_and_ground_passenger_transportation_subsector', 'employment_in_new_york_citys_truck_transportation_subsector', 'energy_solutions_for_a_livable_community', 'environmental_justice_at_dvrpc_fiscal_policy_2008', 'environmental_justice_at_dvrpc_fiscal_year_2007', 'environmental_justice_at_dvrpc_fiscal_year_2009', 'fact_sheet_clean_and_green_school_buses_reducing_fuel_use_and_exposure_to_diesel_exhaust', 'fact_sheet_plug_in_electric_vehicles', 'federal_forests_and_the_renewable_fuel_standard', 'flight_or_fight_metropolitan_philadelphia_and_its_future', 'fueling_up_gasoline_consumption_in_the_pacific_northwest', 'fuel_cells', 'gas_pricesbike_sales_survey', 'getting_from_here_to_there_the_bridges_to_work_demonstration_first_report_to_the_field', 'healthy_communities_for_young_and_old_how_transit_and_better_community_design_help_the_most_vulnerable_generations', 'high_speed_rail_the_wrong_road_for_america', 'how_a_washington_lobbyist_gives_lawmakers_free_trips_despite_the_ban_on_lobbyist_funded_travel', 'hybrid_buses_costs_and_benefits', 'increasing_intermodal_access_to_transit_phase_iii', 'increasing_intermodal_access_to_transit_phase_iv', 'increasing_inter_modal_access_to_transit_phase_ii', 'innovations_in_zoning_for_smart_growth', 'integrating_land_use_transportation_and_economic_development', 'international_mountain_bicycling_association_imba_1999_advocacy_survey_summary', 'investing_in_transportation_a_benchmarking_study_of_transportation_funding_and_policy', 'in_the_drivers_seat', 'is_world_oil_production_peaking', 'its_about_how_and_where_we_build_connecting_energy_and_smart_growth', 'mapping_long_island', 'measure_of_america_data_chart_housing_and_transportation', 'municipal_implementation_tool_14_safe_routes_to_school', 'municipal_implementation_tool_16_road_diets', 'municipal_resource_guide_2009', 'overcoming_roadblocks_on_the_way_to_work_bridges_to_work_field_report', 'over_the_horizon_jobs_in_the_suburbs_of_major_metropolitan_areas', 'plan_b_update_us_car_fleet_shrinks_by_four_million_in_2009', 'portland_exception_sprawl_smart_growth_and_rural_land_lost_in_15_cities', 'price_of_inaction_an_analysis_of_economic_impacts_associated_with_septas_fy_2008_operating_budget_plan_b_alternative', 'public_health_effects_of_sprawl', 'public_participation_plan_a_strategy_for_citizen_involvement', 'rails_wont_save_america', 'rating_the_region_the_state_of_the_delaware_valley', 'roadmap_to_gridlock_the_failure_of_long_range_metropolitan_transportation_planning', 'road_riding_events', 'run_cars_on_green_electricity_not_natural_gas', 'safe_routes_to_school_2009_policy_report_moving_to_the_future_and_building_on_early_achievements', 'safe_routes_to_school_a_catalyst_for_building_partnerships_and_leveraging_resources', 'safe_routes_to_school_improves_the_built_environment', 'safe_routes_to_school_increases_physical_activity_and_improves_health', 'safe_routes_to_school_leads_to_greater_collaboration_with_public_health_and_school_officials', 'safe_routes_to_school_putting_traffic_safety_first', 'safe_routes_to_school_state_network_project_final_report_2007_2009_making_change_through_partners_and_policies', 'safe_routes_to_school_steps_to_a_greener_future', 'seeking_a_sustainable_journey_to_work_findings_from_the_national_bridges_to_work_demonstration', 'sprawl_and_smart_growth_in_greater_seattle_tacoma', 'sprawl_and_smart_growth_in_greater_vancouver_a_comparison_of_vancouver_british_columbia_with_seattle_washington', 'sprawl_and_smart_growth_in_metropolitan_portland_comparing_portland_oregon_with_vancouver_washington_during_the_1990s', 'stimulus_for_greater_philadelphia_what_it_means_for_transportation_investment_in_the_region', 'supermarkets_and_service_stations_now_competing_for_grain', 'time_for_plan_b_cutting_carbon_emissions_80_percent_by_2020', 'traffics_human_toll', 'transportation_operations_master_plan', 'travel_patterns_of_destination_mountain_bikers', 'understanding_occupationalskill_demand_in_njs_transportationlogistics_industry', 'visions_project_choosing_a_future_for_growing_communities') AND subject1 LIKE '%News Newsroom%' OR subject1 LIKE '%Newsletter%' OR subject1 LIKE '%What's New%' OR subject1 LIKE '%Recent Events%' OR subject1 LIKE '%Meetings%' OR subject1 LIKE '%Public Affairs%' OR subject1 LIKE '%Media.%' ORDER BY identifier