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_category gc ON g.grant_id = gc.grant_id LEFT JOIN gw_recipient grc ON g.grant_id = grc.grant_id LEFT JOIN gw_grant_region gr ON g.grant_id = gr.grant_id WHERE g.grant_status = '' AND (g.official_title LIKE '% small business %' OR g.unofficial_title LIKE '% small business %' OR g.description LIKE '% small business %' OR g.fulldescription LIKE '% small business %' OR g.eligibility LIKE '% small business %' OR g.eligibility_more LIKE '% small business %') AND (g.official_title LIKE '% women owned %' OR g.unofficial_title LIKE '% women owned %' OR g.description LIKE '% women owned %' OR g.fulldescription LIKE '% women owned %' OR g.eligibility LIKE '% women owned %' OR g.eligibility_more LIKE '% women owned %') AND (g.official_title LIKE '% community %' OR g.unofficial_title LIKE '% community %' OR g.description LIKE '% community %' OR g.fulldescription LIKE '% community %' OR g.eligibility LIKE '% community %' OR g.eligibility_more LIKE '% community %') AND (g.official_title LIKE '% food %' OR g.unofficial_title LIKE '% food %' OR g.description LIKE '% food %' OR g.fulldescription LIKE '% food %' OR g.eligibility LIKE '% food %' OR g.eligibility_more LIKE '% food %' OR g.official_title LIKE '% nutrition %' OR g.unofficial_title LIKE '% nutrition %' OR g.description LIKE '% nutrition %' OR g.fulldescription LIKE '% nutrition %' OR g.eligibility LIKE '% nutrition %' OR g.eligibility_more LIKE '% nutrition %') GROUP BY g.grant_id ORDER BY CASE WHEN g.official_title LIKE '% small business %' THEN 1 WHEN g.official_title LIKE '% women owned %' THEN 2 WHEN g.official_title LIKE '% community %' THEN 3 WHEN g.official_title LIKE '% food %' THEN 4 ELSE 5 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
