select part_urls.id, part_urls.part_number, part_urls.brand, replacement_parts.id, replacement_parts.part_number, replacement_parts.brand from part_urls inner join part_replacements on part_urls.id = part_replacements.part_id inner join part_urls as replacement_parts on part_replacements.replacement_part_id = replacement_parts.id where part_urls.brand = 'CHAMPION' limit 10