suggested_grants sql: SELECT DISTINCT g.grant_id, g.grant_status, g.deadline, ga.upcoming, g.unofficial_title, g.description, g.date_display, g.letter_date, g.conference_deadline, g.is_conference_date_manditory, g.is_letter_date_manditory, gr.location FROM main_grant_view g LEFT JOIN grants_additional ga ON g.grant_id = ga.grant_id LEFT JOIN gw_grant_region gr ON g.grant_id = gr.grant_id WHERE g.grant_status = '' AND (g.official_title LIKE '% child care %' OR g.unofficial_title LIKE '% child care %' OR g.description LIKE '% child care %' OR g.fulldescription LIKE '% child care %' OR g.eligibility LIKE '% child care %' OR g.eligibility_more LIKE '% child care %') AND (gr.location LIKE '%indiana%' OR gr.region_id = 'IN') ORDER BY CASE WHEN g.official_title LIKE '% child care %' THEN 1 WHEN g.unofficial_title LIKE '% child care %' THEN 2 ELSE 3 END, g.deadline ASC LIMIT 100 The Number #1 Advanced Grant Search EngineThe Number #1 Advanced Grant Search Engine
We use cookies to enhance your browsing experience on GrantWatch.com. By continuing to use our site, you consent to the use of cookies. Learn more by exploring our comprehensive Cookie Policy
