query.sql

SELECT DISTINCT tommy_john_filter_values.id,
    tommy_john_filter_values.name,
    spree_variants.id
  FROM tommy_john_filter_values
  INNER JOIN tommy_john_filter_values_colors
    ON (tommy_john_filter_values_colors.filter_value_id = tommy_john_filter_values.id)
  INNER JOIN spree_variants
    ON (spree_variants.color_id = tommy_john_filter_values_colors.color_id)
 WHERE spree_variants.product_id = 98683658;