Redmine

I see one problem (probably THE problem). The sql that gets executed doesn't return anything:

mselect * from (SELECT "ISSUES"."ID" AS t0_r0, "ISSUES"."TRACKER_ID" AS t0_r1, "ISSUES"."PROJECT_ID" AS t0_r2, "ISSUES"."SUBJECT" AS t0_r3, "ISSUES"."DESCRIPTION" AS t0_r4, "ISSUES"."DUE_DATE" AS t0_r5, "ISSUES"."CATEGORY_ID" AS t0_r6, "ISSUES"."STATUS_ID" AS t0_r7, "ISSUES"."ASSIGNED_TO_ID" AS t0_r8, "ISSUES"."PRIORITY_ID" AS t0_r9, "ISSUES"."FIXED_VERSION_ID" AS t0_r10, "ISSUES"."AUTHOR_ID" AS t0_r11, "ISSUES"."LOCK_VERSION" AS t0_r12, "ISSUES"."CREATED_ON" AS t0_r13, "ISSUES"."UPDATED_ON" AS t0_r14, "ISSUES"."START_DATE" AS t0_r15, "ISSUES"."DONE_RATIO" AS t0_r16, "ISSUES"."ESTIMATED_HOURS" AS t0_r17, "ISSUES"."PARENT_ID" AS t0_r18, "ISSUES"."ROOT_ID" AS t0_r19, "ISSUES"."LFT" AS t0_r20, "ISSUES"."RGT" AS t0_r21, "PROJECTS"."ID" AS t1_r0, "PROJECTS"."NAME" AS t1_r1, "PROJECTS"."DESCRIPTION" AS t1_r2, "PROJECTS"."HOMEPAGE" AS t1_r3, "PROJECTS"."IS_PUBLIC" AS t1_r4, "PROJECTS"."PARENT_ID" AS t1_r5, "PROJECTS"."CREATED_ON" AS t1_r6, "PROJECTS"."UPDATED_ON" AS t1_r7, "PROJECTS"."IDENTIFIER" AS t1_r8, "PROJECTS"."STATUS" AS t1_r9, "PROJECTS"."LFT" AS t1_r10, "PROJECTS"."RGT" AS t1_r11, "ISSUE_STATUSES"."ID" AS t2_r0, "ISSUE_STATUSES"."NAME" AS t2_r1, "ISSUE_STATUSES"."IS_CLOSED" AS t2_r2, "ISSUE_STATUSES"."IS_DEFAULT" AS t2_r3, "ISSUE_STATUSES"."POSITION" AS t2_r4, "ISSUE_STATUSES"."DEFAULT_DONE_RATIO" AS t2_r5 FROM "ISSUES" LEFT OUTER JOIN "PROJECTS" ON "PROJECTS".id = "ISSUES".project_id LEFT OUTER JOIN "ISSUE_STATUSES" ON "ISSUE_STATUSES".id = "ISSUES".status_id WHERE ("ISSUES"."ID" = 9) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) ) where rownum <= 1

Duh. I need to get the Trac syntax out of my head. To link to a changeset it is rNumber, e.g., r6