SELECT DISTINCT g.grant_id, g.grant_status, g.deadline, g.unofficial_title, g.description, g.date_display, g.letter_date, g.conference_deadline, g.is_conference_date_manditory, g.is_letter_date_manditory FROM gw_grantwatch_grant_view g INNER JOIN grants_most_recent_date_view_alt gd ON g.grant_id = gd.id INNER JOIN gw_grant_category gc ON g.grant_id = gc.grant_id INNER JOIN gw_grant_region gr ON g.grant_id = gr.grant_id where g.grant_status = '' AND gc.category_id = 41 ORDER BY gd.mostRecentDate ASC LIMIT 0, 50