SELECT DISTINCT 
 CASE WHEN concept_name_1>concept_name_2 THEN concept_name_1 ELSE concept_name_2 END as condition1,
CASE WHEN concept_name_1>concept_name_2 THEN concept_name_2 ELSE concept_name_1 END AS condition2
  FROM (
    SELECT concept_name_1, concept_name AS concept_name_2
     FROM (
       SELECT condition_concept_id_2, concept_name AS concept_name_1
       FROM (
          SELECT table1.condition_concept_id AS condition_concept_id_1, table2.condition_concept_id AS condition_concept_id_2
          FROM (SELECT * FROM condition_era WHERE person_id = 8802) AS table1,
             (SELECT * FROM condition_era WHERE person_id = 8802) AS table2 
          WHERE table2.condition_era_start_date <= table1.condition_era_end_date 
          AND (table2.condition_era_end_date IS NULL OR table2.condition_era_end_date >= table1.condition_era_start_date)
          AND table1.condition_concept_id<>table2.condition_concept_id
        ) AS comorb
       LEFT JOIN (SELECT concept_id, concept_name FROM vocabulary.concept) AS concept_list
       ON comorb.condition_concept_id_1=concept_list.concept_id
      ) AS comorb2
    LEFT JOIN (SELECT concept_id, concept_name FROM vocabulary.concept) AS concept_list
    ON comorb2.condition_concept_id_2=concept_list.concept_id
   ) AS condition_pairs