SELECT GGUID
FROM DATABASE.ADDRESS0 AS ADDRESS
WHERE (
        (
            ADDRESS.GGUID IN (
                SELECT rel.GUID1
                FROM DATABASE.TableRelation AS rel
                INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID2 = ADDRESS.GGUID
                    AND (rel.RelationName LIKE 'ADD_PENSION')
                WHERE (
                        (ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142)
                        AND (
                            ADDRESS.GGUID IN (
                                SELECT TABLEGUID
                                FROM DATABASE.ADDRESSORel
                                WHERE EIMRight >= 64
                                    AND (
                                        OID IN (
                                            1
                                            ,- 8
                                            ,0
                                            )
                                        )
                                )
                            )
                        )
                    AND (
                        ADDRESS.ISDELETED = 0
                        AND ADDRESS.ISTEMPLATE = 0
                        )

                UNION ALL

                SELECT rel.GUID2
                FROM DATABASE.TableRelation AS rel
                INNER JOIN DATABASE.ADDRESS0 AS ADDRESS ON rel.GUID1 = ADDRESS.GGUID
                    AND (rel.RelationName LIKE 'ADD_PENSION')
                WHERE (
                        (
                            (ADDRESS.GGUID = 0xA3443B6122463EB4921531E14D8D5142)
                            AND (
                                ADDRESS.GGUID IN (
                                    SELECT TABLEGUID
                                    FROM DATABASE.ADDRESSORel
                                    WHERE EIMRight >= 64
                                        AND (
                                            OID IN (
                                                1
                                                ,- 8
                                                ,0
                                                )
                                            )
                                    )
                                )
                            )
                        AND (
                            ADDRESS.GGUID IN (
                                SELECT TABLEGUID
                                FROM DATABASE.ADDRESSORel
                                WHERE EIMRight >= 64
                                    AND (
                                        OID IN (
                                            1
                                            ,- 8
                                            ,0
                                            )
                                        )
                                )
                            )
                        )
                    AND (
                        ADDRESS.ISDELETED = 0
                        AND ADDRESS.ISTEMPLATE = 0
                        )
                )
            )
        AND (
            ADDRESS.GGUID IN (
                SELECT TABLEGUID
                FROM DATABASE.ADDRESSORel
                WHERE EIMRight >= 64
                    AND (
                        OID IN (
                            1
                            ,- 8
                            ,0
                            )
                        )
                )
            )
        )
    AND (
        ADDRESS.ISDELETED = 0
        AND ADDRESS.ISTEMPLATE = 0
        )