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