SELECT Count(*)  FROM   "workorder" "wo"
       LEFT JOIN "workorder_fields" "wof"
              ON "wo"."workorderid" = "wof"."workorderid"
       LEFT JOIN "servicecatalog_fields" "scf"
              ON "wo"."workorderid" = "scf"."workorderid"
       LEFT JOIN "wotoprojects" "wtp"
              ON "wo"."workorderid" = "wtp"."workorderid"
       LEFT JOIN "sitedefinition"
              ON "wo"."siteid" = "sitedefinition"."siteid"
       LEFT JOIN "sdorganization"
              ON "sitedefinition"."siteid" = "sdorganization"."org_id"
       INNER JOIN "workorderstates" "wos"
               ON "wo"."workorderid" = "wos"."workorderid"
       LEFT JOIN "categorydefinition" "cd"
              ON "wos"."categoryid" = "cd"."categoryid"
       LEFT JOIN "aaauser" "ti"
              ON "wos"."ownerid" = "ti"."user_id"
       LEFT JOIN "aaauser" "aau"
              ON "wo"."requesterid" = "aau"."user_id"
       LEFT JOIN "prioritydefinition" "pd"
              ON "wos"."priorityid" = "pd"."priorityid"
       LEFT JOIN "statusdefinition" "std"
              ON "wos"."statusid" = "std"."statusid"
       INNER JOIN "workorder_queue" "wo_queue"
               ON "wo"."workorderid" = "wo_queue"."workorderid"
       INNER JOIN "queuedefinition" "qd"
               ON "wo_queue"."queueid" = "qd"."queueid"
       LEFT JOIN "departmentdefinition" "dpt"
              ON "wo"."deptid" = "dpt"."deptid"
       LEFT JOIN "leveldefinition" "lvd"
              ON "wos"."levelid" = "lvd"."levelid"
       LEFT JOIN "modedefinition" "mdd"
              ON "wo"."modeid" = "mdd"."modeid"
       LEFT JOIN "urgencydefinition" "urgdef"
              ON "wos"."urgencyid" = "urgdef"."urgencyid"
       LEFT JOIN "impactdefinition" "impdef"
              ON "wos"."impactid" = "impdef"."impactid"
       LEFT JOIN "requesttypedefinition" "rtdef"
              ON "wos"."requesttypeid" = "rtdef"."requesttypeid"
       LEFT JOIN "subcategorydefinition" "scd"
              ON "wos"."subcategoryid" = "scd"."subcategoryid"
       LEFT JOIN "itemdefinition" "icd"
              ON "wos"."itemid" = "icd"."itemid"
       LEFT JOIN "servicedefinition" "serdef"
              ON "wo"."serviceid" = "serdef"."serviceid"
       LEFT JOIN "aaauser" "cbau"
              ON "wo"."createdbyid" = "cbau"."user_id"
       LEFT JOIN "aaauser" "oboaau"
              ON "wo"."oboid" = "oboaau"."user_id"
       LEFT JOIN "sduser"
              ON "wo"."requesterid" = "sduser"."userid"
       LEFT JOIN "sduser" "SDUSER_ONBEHALFOF"
              ON "wo"."oboid" = "SDUSER_ONBEHALFOF"."userid"
       LEFT JOIN "workorder_fields"
              ON "wo"."workorderid" = "workorder_fields"."workorderid"  WHERE  ( ( ( "wos"."statusid" IN ( 1, 2, 301 ) )
           AND ( "wo_queue"."queueid" IN (SELECT "queuedefinition"."queueid"
                                          FROM   "queuedefinition"
                                          WHERE  ( "queuedefinition"."queuename"
                                                   COLLATE
                                                   latin1_general_cs_as =
                                                   N'Zm ICT'
                                                 )) ) )
         AND ( ( "wo"."isparent" = 1 )
               AND ( ( ( "wos"."ownerid" = 90954 )
                        OR ( "wo"."requesterid" = 90954 ) )
                      OR ( ( "wo"."siteid" IN (SELECT "usersitemapping"."siteid"
                                               FROM   "usersitemapping"
                                               WHERE  (
                                              "usersitemapping"."userid" =
                                              90954 ))
                           )
                            OR ( "wo"."siteid" IS NULL ) ) ) ) );