Changes between Version 9 and Version 10 of OnyxDatabaseReporting

Timestamp:

03/07/12 10:14:30 (13 years ago)

Author:

Nick Holden

Comment:

--

OnyxDatabaseReporting

@@ -168 +168 @@
 AND category_answer.category_name = 'Study_specific'
 ; " > mysql-output.txt 
+
+Any one of a number of related primary or secondary diagnoses, aged under 65.
+
+SELECT count(distinct participant.id) as 'Number of Participants' 
+FROM participant, questionnaire_participant, question_answer, category_answer 
+WHERE participant.id = questionnaire_participant.participant_id 
+AND birth_date > '1947-03-01'
+AND question_answer.questionnaire_participant_id = questionnaire_participant.id 
+AND ( question_answer.question_name = 'epi_pridiag' OR question_answer.question_name = 'epi_secdiag' ) 
+AND category_answer.question_answer_id = question_answer.id 
+AND ( category_answer.category_name = 'Troponin_pos_ACS' 
+OR category_answer.category_name = 'Troponin_neg_ACS' 
+OR category_answer.category_name = 'STEMI' 
+OR category_answer.category_name = 'Stable_Angina' 
+OR category_answer.category_name = 'Stable_CAD' 
+OR category_answer.category_name = 'Ischaemic_Cardiomyopathy' 
+OR category_answer.category_name = 'Acute_Stent_Thrombosis' )
+;