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