test.sql

select
    x2.x3,
    x2.x4,
    x2.x5,
    x2.x6,
    x2.x7,
    x2.x8,
    x2.x9,
    x2.x10,
    x2.x11,
    x2.x12,
    x2.x13,
    x2.x14,
    x2.x15,
    (case when(x2.x16 is not null) then x2.x17 else null end),
    (case when(x2.x16 is not null) then x2.x18 else null end),
    (case when(x2.x16 is not null) then x2.x19 else null end),
    (case when(x20."closed_date" is not null) then x20."title" else null end)
from
    (
        select
            x21.x22 as x13,
            x21.x23 as x7,
            x21.x24 as x8,
            x21.x25 as x9,
            x21.x26 as x4,
            x21.x27 as x6,
            x21.x28 as x5,
            x21.x29 as x14,
            x21.x30 as x3,
            x21.x31 as x11,
            x21.x32 as x10,
            x21.x33 as x12,
            x21.x34 as x35,
            x21.x36 as x37,
            x21.x38 as x39,
            x21.x40 as x15,
            x21.x41 as x42,
            x21.x43 as x44,
            x21.x45 as x46,
            x21.x47 as x48,
            x21.x49 as x50,
            x21.x51 as x52,
            (case when(x53."repository_name" is null) then null else 1 end) as x16,
            x53."repository_name" as x54,
            x53."user_name" as x55,
            x53."color" as x19,
            x53."label_id" as x17,
            x53."label_name" as x18
        from
            (
                select
                    x56.x57 as x22,
                    x56.x58 as x23,
                    x56.x59 as x24,
                    x56.x60 as x25,
                    x56.x61 as x26,
                    x56.x62 as x27,
                    x56.x63 as x28,
                    x56.x64 as x29,
                    x56.x65 as x30,
                    x56.x66 as x31,
                    x56.x67 as x32,
                    x56.x68 as x33,
                    x56.x69 as x34,
                    x56.x70 as x36,
                    x56.x71 as x38,
                    x56.x72 as x40,
                    x56.x73 as x41,
                    (case when(x74."user_name" is null) then null else 1 end) as x43,
                    x74."user_name" as x45,
                    x74."repository_name" as x47,
                    x74."issue_id" as x49,
                    x74."label_id" as x51
                from
                    (
                        select
                            x75.x76 as x57,
                            x75.x77 as x58,
                            x75.x78 as x59,
                            x75.x79 as x60,
                            x75.x80 as x61,
                            x75.x81 as x62,
                            x75.x82 as x63,
                            x75.x83 as x64,
                            x75.x84 as x65,
                            x75.x85 as x66,
                            x75.x86 as x67,
                            x75.x87 as x68,
                            x75.x88 as x69,
                            x75.x89 as x70,
                            x75.x90 as x71,
                            x75.x91 as x72,
                            row_number() over(order by(
                                        select
                                            1
                                    )) - 1 as x73
                        from
                            (
                                select
                                    x92.x93 as x76,
                                    x92.x94 as x77,
                                    x92.x95 as x78,
                                    x92.x96 as x79,
                                    x92.x97 as x80,
                                    x92.x98 as x81,
                                    x92.x99 as x82,
                                    x92.x100 as x83,
                                    x92.x101 as x84,
                                    x92.x102 as x85,
                                    x92.x103 as x86,
                                    x92.x104 as x87,
                                    x105."user_name" as x88,
                                    x105."repository_name" as x89,
                                    x105."issue_id" as x90,
                                    x105."comment_count" as x91
                                from
                                    (
                                        select
                                            "user_name" as x101,
                                            "repository_name" as x97,
                                            "closed" as x102,
                                            "pull_request" as x100,
                                            "updated_date" as x93,
                                            "milestone_id" as x94,
                                            "assigned_user_name" as x95,
                                            "title" as x96,
                                            "opened_user_name" as x98,
                                            "issue_id" as x99,
                                            "content" as x103,
                                            "registered_date" as x104
                                        from
                                            "issue"
                                        where
                                            (
                                                (
                                                    false
                                                or  (
                                                        (
                                                            "user_name" = ?
                                                        )
                                                    and (
                                                            "repository_name" = ?
                                                        )
                                                    )
                                                )
                                            and (
                                                    "closed" = ?
                                                )
                                            )
                                        and (
                                                "pull_request" = ?
                                            )
                                    ) x92,
                                    "issue_outline_view" x105
                                where
                                    (
                                        (
                                            x92.x101 = x105."user_name"
                                        )
                                    and (
                                            x92.x97 = x105."repository_name"
                                        )
                                    )
                                and (
                                        x92.x99 = x105."issue_id"
                                    )
                                order by
                                    x92.x104 desc,
                                    x92.x99 desc
                                limit 25 offset 0
                            ) x75
                    ) x56
                    left outer join
                        "issue_label" x74
                    on  (
                            (
                                x56.x65 = x74."user_name"
                            )
                        and (
                                x56.x61 = x74."repository_name"
                            )
                        )
                    and (
                            x56.x63 = x74."issue_id"
                        )
            ) x21
            left outer join
                "label" x53
            on  (case when(x21.x43 is not null) then(
                            (
                                (
                                    x21.x45 = x53."user_name"
                                )
                            and (
                                    x21.x47 = x53."repository_name"
                                )
                            )
                        and (
                                x21.x51 = x53."label_id"
                            )
                        ) else null end)
    ) x2
    left outer join
        "milestone" x20
    on  (
            (
                x2.x3 = x20."user_name"
            )
        and (
                x2.x4 = x20."repository_name"
            )
        )
    and (
            x2.x7 = x20."milestone_id"
        )
order by
    x2.x42