SELECT DISTINCT ON (studies.nct_id) studies.nct_id,
 array_to_string(ARRAY( SELECT sponsors_1.name
       FROM public.sponsors sponsors_1
      WHERE ((studies.nct_id)::text = (sponsors_1.nct_id)::text)), ' | '::text) AS sponsor,
 studies.phase,
 studies.overall_status,
 array_to_string(ARRAY( SELECT conditions_1.name
       FROM public.conditions conditions_1
      WHERE ((studies.nct_id)::text = (conditions_1.nct_id)::text)), ' | '::text) AS condition,
 studies.brief_title,
 studies.official_title,
 ((((((('Allocation: '::text || (COALESCE(designs.allocation, ''::character varying))::text) || ' | Intervention Model: '::text) || (COALESCE(designs.intervention_model, ''::character varying))::text) || ' | Masking: '::text) || (COALESCE(designs.masking))::text) || ' | Primary Purpose: '::text) || (COALESCE(designs.primary_purpose, ''::character varying))::text) AS  study_design,
 studies.study_type,
array_to_string(ARRAY( SELECT interventions_1.name
       FROM public.interventions interventions_1
      WHERE ((studies.nct_id)::text = (interventions_1.nct_id)::text)), ' | '::text) AS intervention,
array_to_string(ARRAY( SELECT interventions_1.description
       FROM public.interventions interventions_1
      WHERE ((studies.nct_id)::text = (interventions_1.nct_id)::text)), ' | '::text) AS intervention_description,
studies.enrollment,
studies.number_of_arms,
studies.number_of_groups,
array_to_string(ARRAY( SELECT design_outcomes_1.measure
       FROM public.design_outcomes design_outcomes_1
      WHERE (((studies.nct_id)::text = (design_outcomes_1.nct_id)::text) AND ((design_outcomes_1.outcome_type)::text = 'primary'::text))), ' | '::text) AS primary_outcome_measures,
array_to_string(ARRAY( SELECT design_outcomes_1.measure
       FROM public.design_outcomes design_outcomes_1
      WHERE (((studies.nct_id)::text = (design_outcomes_1.nct_id)::text) AND ((design_outcomes_1.outcome_type)::text = 'secondary'::text))), ' | '::text) AS secondary_outcome_measures,
studies.first_received_date,
studies.last_changed_date,
studies.first_received_results_date,
studies.study_first_submitted_date,
studies.last_update_submitted_date,
studies.study_first_posted_date,
studies.last_update_posted_date,
studies.start_date,
studies.verification_date,
studies.completion_date,
studies.primary_completion_date,
studies.target_duration
FROM (((((public.studies
 LEFT JOIN public.conditions ON (((studies.nct_id)::text = (conditions.nct_id)::text)))
 LEFT JOIN public.sponsors ON (((studies.nct_id)::text = (sponsors.nct_id)::text)))
 LEFT JOIN public.interventions ON (((studies.nct_id)::text = (interventions.nct_id)::text)))
 LEFT JOIN public.designs ON (((studies.nct_id)::text = (designs.nct_id)::text)))
 LEFT JOIN public.design_outcomes ON (((studies.nct_id)::text = (design_outcomes.nct_id)::text)))