select category_id from categories where parent_id=0 and category_type=3 and state<>0 order by lower(name_en)

select * from categories where category_id=107 and state<>0

select * from categories where category_id=113 and state<>0

select * from categories where category_id=115 and state<>0

select * from categories where category_id=118 and state<>0

select * from categories where category_id=123 and state<>0

select * from categories where category_id=126 and state<>0

select * from categories where category_id=129 and state<>0

select * from categories where category_id=132 and state<>0

select * from categories where category_id=137 and state<>0

select * from categories where category_id=142 and state<>0

select * from categories where category_id=143 and state<>0

select * from categories where category_id=144 and state<>0

select * from categories where category_id=152 and state<>0

The In Community Resource Guide

Resource Guide

This guide is a comprehensive list of over 164 community resources and services available to people with disabilities, their families, service providers and the general public.

Search by as many as applicable

SELECT CASE WHEN (name_en is null OR name_en = '') THEN name_fr ELSE name_en END name_mixed, resource_id FROM resources WHERE state<>0 ORDER BY `name_mixed`