Any
select category_id from categories where parent_id=1 and state=1 order by lower(name_en)
select * from categories where category_id=2 and state<>0
select * from categories where category_id=3 and state<>0
Any Accomodation housing categories
Housing Information
Supportive Housing For Persons With Physical Disabilities
select category_id from categories where parent_id=4 and state=1 order by lower(name_en)
select * from categories where category_id=5 and state<>0
select * from categories where category_id=6 and state<>0
select * from categories where category_id=187 and state<>0
select * from categories where category_id=8 and state<>0
select * from categories where category_id=9 and state<>0
select * from categories where category_id=7 and state<>0
Any Assistive devices categories
Assistive Devices Program
Care Supplies
General Information on Assistive Devices
Rental, Loan and 2nd Hand Equipment
Repairs and Modifications
Specialized Equipment
select category_id from categories where parent_id=10 and state=1 order by lower(name_en)
select * from categories where category_id=185 and state<>0
Any Barrier-free design categories
Barrier-Free Design
select category_id from categories where parent_id=11 and state=1 order by lower(name_en)
select * from categories where category_id=186 and state<>0
Any Community health and resource centres categories
Community Health and Resource Centres
select category_id from categories where parent_id=12 and state=1 order by lower(name_en)
select * from categories where category_id=188 and state<>0
select * from categories where category_id=13 and state<>0
select * from categories where category_id=14 and state<>0
select * from categories where category_id=15 and state<>0
select * from categories where category_id=16 and state<>0
select * from categories where category_id=17 and state<>0
select * from categories where category_id=18 and state<>0
select * from categories where category_id=19 and state<>0
Any Community support services categories
General Community Support Service Information
Home Care Services
Meals
Respite Services
Safety
Social Service Supports
Special Services
Visiting / Delivery Services
select category_id from categories where parent_id=20 and state=1 order by lower(name_en)
select * from categories where category_id=21 and state<>0
select * from categories where category_id=22 and state<>0
select * from categories where category_id=24 and state<>0
select * from categories where category_id=23 and state<>0
select * from categories where category_id=189 and state<>0
select * from categories where category_id=25 and state<>0
Any Counselling categories
Abuse
Addictions
Care Giver Support / Self Help Groups
Crisis Intervention and Counselling Services
General Information on Counseling Services
Inspirational
select category_id from categories where parent_id=47 and state=1 order by lower(name_en)
select * from categories where category_id=48 and state<>0
select * from categories where category_id=190 and state<>0
select * from categories where category_id=49 and state<>0
select * from categories where category_id=50 and state<>0
select * from categories where category_id=51 and state<>0
Any Education and training categories
Assessments and Vendors for Tech. Aids
General Information on Education and Training Opportunities
Lifeskills
Literacy and Numeracy Education
Student Services
select category_id from categories where parent_id=75 and state=1 order by lower(name_en)
select * from categories where category_id=78 and state<>0
select * from categories where category_id=76 and state<>0
select * from categories where category_id=77 and state<>0
select * from categories where category_id=191 and state<>0
select * from categories where category_id=88 and state<>0
select * from categories where category_id=80 and state<>0
Any Employement/vocational supports categories
Employer Supports
Employment - Legislation
Employment Support
General Information on Employment
Human Rights
Vocational Rehabilitation Evaluation
select category_id from categories where parent_id=52 and state=1 order by lower(name_en)
select * from categories where category_id=53 and state<>0
select * from categories where category_id=54 and state<>0
select * from categories where category_id=192 and state<>0
select * from categories where category_id=56 and state<>0
select * from categories where category_id=57 and state<>0
select * from categories where category_id=58 and state<>0
select * from categories where category_id=59 and state<>0
select * from categories where category_id=79 and state<>0
select * from categories where category_id=55 and state<>0
Any Financial categories
Equipment, Supplies and Prescriptions
Eviction Prevention
General Financial Information
Income Programs
Income Tax Info.
Rebate Programs
Renovations and Modifications Home/Vehicle
Scholarships and Financial Resources
Service Clubs
select category_id from categories where parent_id=81 and state=1 order by lower(name_en)
select * from categories where category_id=85 and state<>0
select * from categories where category_id=82 and state<>0
select * from categories where category_id=193 and state<>0
select * from categories where category_id=86 and state<>0
select * from categories where category_id=87 and state<>0
select * from categories where category_id=83 and state<>0
select * from categories where category_id=84 and state<>0
select * from categories where category_id=89 and state<>0
select * from categories where category_id=90 and state<>0
select * from categories where category_id=91 and state<>0
select * from categories where category_id=92 and state<>0
Any Legal categories
Advocacy Act
Consumer Rights
General Legal/Advocacy Information
Health Care Consent Act
Human Care Consent Act
Landlord Tenant Act
Legal Advice and Mediation Services
Long Term Care Act
Ontarians with Disability Act
Power of Attorney
Substitute Decisions Act
select category_id from categories where parent_id=60 and state=1 order by lower(name_en)
select * from categories where category_id=61 and state<>0
select * from categories where category_id=62 and state<>0
select * from categories where category_id=63 and state<>0
select * from categories where category_id=173 and state<>0
select * from categories where category_id=74 and state<>0
select * from categories where category_id=175 and state<>0
select * from categories where category_id=176 and state<>0
select * from categories where category_id=177 and state<>0
select * from categories where category_id=65 and state<>0
select * from categories where category_id=66 and state<>0
select * from categories where category_id=64 and state<>0
select * from categories where category_id=67 and state<>0
select * from categories where category_id=68 and state<>0
select * from categories where category_id=69 and state<>0
select * from categories where category_id=71 and state<>0
select * from categories where category_id=70 and state<>0
select * from categories where category_id=72 and state<>0
select * from categories where category_id=73 and state<>0
Any Miscellaneous categories
Adaptive Wear
Alternative Formats
Artists with Disabilities
Biography
Children/Youth
Dental
Developmental
Elections
Fire Prevention and Safety
Francophone Services
Humour
Medical
Mental Health
Parenting
Services for Seniors
Services in Quebec
Sexuality
Statistics
select category_id from categories where parent_id=171 and state=1 order by lower(name_en)
select * from categories where category_id=184 and state<>0
Any Periodical/magazine categories
Periodical/Magazine
select category_id from categories where parent_id=93 and state=1 order by lower(name_en)
select * from categories where category_id=94 and state<>0
select * from categories where category_id=194 and state<>0
select * from categories where category_id=96 and state<>0
select * from categories where category_id=97 and state<>0
select * from categories where category_id=95 and state<>0
Any Recreation and leisure categories
Accessible Camp Grounds / Trails
General information on Recreation and Leisure opportunities
Individual Leisure and Recreation, Day Programs
Residential Camps
Team Sports
select category_id from categories where parent_id=98 and state=1 order by lower(name_en)
select * from categories where category_id=99 and state<>0
select * from categories where category_id=100 and state<>0
select * from categories where category_id=101 and state<>0
select * from categories where category_id=103 and state<>0
select * from categories where category_id=102 and state<>0
select * from categories where category_id=104 and state<>0
select * from categories where category_id=105 and state<>0
select * from categories where category_id=106 and state<>0
Any Transportation and travel categories
Accessible Taxis
Driver Evaluation and Training
General Information
Medical Transportation
OC Transpo Low Floor Buses
Paratranspo
Travel
Vehicle Modifications
