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 LEFT JOIN gw_grant_category gc ON g.grant_id = gc.grant_id LEFT JOIN gw_recipient grc ON g.grant_id = grc.grant_id WHERE g.grant_status = '' AND (g.official_title LIKE '% international affairs %' OR g.unofficial_title LIKE '% international affairs %' OR g.description LIKE '% international affairs %' OR g.fulldescription LIKE '% international affairs %' OR g.eligibility LIKE '% international affairs %' OR g.eligibility_more LIKE '% international affairs %' OR g.official_title LIKE '% public university %' OR g.unofficial_title LIKE '% public university %' OR g.description LIKE '% public university %' OR g.fulldescription LIKE '% public university %' OR g.eligibility LIKE '% public university %' OR g.eligibility_more LIKE '% public university %' OR g.official_title LIKE '% school of international affairs %' OR g.unofficial_title LIKE '% school of international affairs %' OR g.description LIKE '% school of international affairs %' OR g.fulldescription LIKE '% school of international affairs %' OR g.eligibility LIKE '% school of international affairs %' OR g.eligibility_more LIKE '% school of international affairs %') GROUP BY g.grant_id ORDER BY CASE WHEN g.official_title LIKE '% international affairs %' THEN 1 WHEN g.unofficial_title LIKE '% international affairs %' THEN 2 WHEN g.description LIKE '% international affairs %' THEN 3 ELSE 4 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
