SELECT
        C.parent_path,
        PARENT_TITLE.value,
        C.target_path,
        TARGET_TITLE.value,
        IF(M_ICON.name IS NOT NULL, M_ICON.name, M_PHOTO.name)
    FROM stats_relations R
        LEFT OUTER JOIN stats_catalog C
            ON (C.target_path = IF(R.target_a_path = %(path)s, R.target_b_path, R.target_a_path))
        LEFT OUTER JOIN stats_metadata TARGET_TITLE
            ON (TARGET_TITLE.name = 'title' AND TARGET_TITLE.target_path = C.target_path)
        LEFT OUTER JOIN stats_metadata PARENT_TITLE
            ON (PARENT_TITLE.name = 'title' AND PARENT_TITLE.target_path = C.parent_path)
        LEFT OUTER JOIN stats_metadata M_PHOTO
            ON (C.target_path = M_PHOTO.target_path AND M_PHOTO.name = 'photo')
        LEFT OUTER JOIN stats_metadata M_ICON
            ON (C.target_path = M_ICON.target_path  AND M_ICON.name  = 'icon')
        WHERE (R.target_a_path = %(path)s or R.target_b_path = %(path)s)
            AND C.parent_path != %(path)s
            AND %(filter)s
    ORDER BY C.parent_path, R.freshness DESC