Maureen's Query

bmdb-query.sql

SELECT
    biomarkers.id        AS 'BM ID',
    biomarker_names.name AS 'BM Name',
    organs.name          AS 'Organ',
    organ_data.phase     AS 'Organ phase',
    studies.FHCRC_ID     AS 'Protocol ID',
    studies.title        AS 'Protocol',
    study_data.phase     AS 'Protocol phase'
FROM
    biomarker_names,
    biomarkers,
    organ_data,
    organs,
    studies,
    study_data
WHERE
    biomarker_names.biomarker_id = biomarkers.id 
    AND `isPrimary`
AND
    organ_data.biomarker_id = biomarkers.id
AND
    organ_data.organ_id = organs.id
AND
    study_data.organ_data_id = organ_data.id
AND
    study_data.study_id = studies.id
ORDER BY
    biomarkers.id,
    organs.name,
    studies.title
;