Category, Subcategory and Item reporting

Hi

I have written a sql report to display category, subcategory and item details and would like to ignore the greyed-out records but I cannot work out which tables I need to access to achieve this. I tried isdeleted fields but they refer to genuinely deleted record.

BUILD 9317 MSSQL

Report so far:
SELECT "cd"."categoryname" as "Category Name", "cd"."categorydescription" as "Description", "sd"."name" as "Subcategory Name", "sd"."description" as "Description", "id"."name" as "Item Name", "id"."description" as "Description" FROM "CATEGORYDEFINITION" "cd"
LEFT JOIN "SUBCATEGORYDEFINITION" "sd" ON "cd"."categoryid"="sd"."categoryid"
LEFT JOIN "ITEMDEFINITION" "id" ON "id"."subcategoryid"="sd"."subcategoryid" WHERE "cd"."isdeleted"='false'
ORDER BY "cd"."categoryname", "sd"."name", "id"."name"

Any help would be appreciated
Thanks
Chris Cann