Guest User

Untitled

a guest
May 23rd, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.99 KB | None | 0 0
  1. SELECT 'Patient' AS polymorphic_parent_class, 'readings' AS polymorphic_association_id, bg_readings.created_at AS t0_r3, bg_readings.id AS t0_r0, bg_readings.is_control_reading AS t0_r10, bg_readings.measured_at AS t0_r2, bg_readings.measurement AS t0_r6, bg_readings.measurement_context AS t0_r8, bg_readings.patient_id AS t0_r1, bg_readings.relationship AS t0_r9, bg_readings.rid AS t0_r5, bg_readings.serial_number AS t0_r4, bg_readings.time_source AS t0_r11, bg_readings.units AS t0_r7, bp_readings.created_at AS t1_r6, bp_readings.dbp AS t1_r4, bp_readings.id AS t1_r0, bp_readings.map AS t1_r2, bp_readings.measured_at AS t1_r5, bp_readings.measurement_context AS t1_r7, bp_readings.patient_id AS t1_r1, bp_readings.relationship AS t1_r8, bp_readings.rid AS t1_r10, bp_readings.sbp AS t1_r3, bp_readings.serial_number AS t1_r9, bp_readings.time_source AS t1_r11, ecg_readings.bits_per_sample AS t2_r6, ecg_readings.created_at AS t2_r3, ecg_readings.ecg_type AS t2_r4, ecg_readings.id AS t2_r0, ecg_readings.measured_at AS t2_r2, ecg_readings.measurement AS t2_r7, ecg_readings.measurement_context AS t2_r8, ecg_readings.patient_id AS t2_r1, ecg_readings.relationship AS t2_r9, ecg_readings.rid AS t2_r11, ecg_readings.sample_rate AS t2_r5, ecg_readings.serial_number AS t2_r10, ecg_readings.time_source AS t2_r12, evaluations.created_at AS t3_r1, evaluations.derived_outcome AS t3_r2, evaluations.has_been_followed_up AS t3_r5, evaluations.id AS t3_r0, evaluations.patient_id AS t3_r3, evaluations.reading_id AS t3_r8, evaluations.reading_type AS t3_r7, evaluations.rid AS t3_r6, evaluations.status AS t3_r4, pulse_readings.created_at AS t4_r3, pulse_readings.id AS t4_r0, pulse_readings.measured_at AS t4_r2, pulse_readings.measurement AS t4_r4, pulse_readings.measurement_context AS t4_r6, pulse_readings.patient_id AS t4_r1, pulse_readings.relationship AS t4_r7, pulse_readings.rid AS t4_r9, pulse_readings.serial_number AS t4_r8, pulse_readings.time_source AS t4_r10, pulse_readings.units AS t4_r5, symptom_readings.created_at AS t5_r3, symptom_readings.id AS t5_r0, symptom_readings.measured_at AS t5_r2, symptom_readings.measurement_context AS t5_r4, symptom_readings.patient_id AS t5_r1, symptom_readings.relationship AS t5_r5, symptom_readings.response0 AS t5_r9, symptom_readings.response1 AS t5_r10, symptom_readings.response10 AS t5_r19, symptom_readings.response2 AS t5_r11, symptom_readings.response3 AS t5_r12, symptom_readings.response4 AS t5_r13, symptom_readings.response5 AS t5_r14, symptom_readings.response6 AS t5_r15, symptom_readings.response7 AS t5_r16, symptom_readings.response8 AS t5_r17, symptom_readings.response9 AS t5_r18, symptom_readings.rid AS t5_r7, symptom_readings.serial_number AS t5_r6, symptom_readings.time_source AS t5_r8, weight_readings.created_at AS t6_r3, weight_readings.id AS t6_r0, weight_readings.measured_at AS t6_r2, weight_readings.measurement AS t6_r4, weight_readings.measurement_context AS t6_r6, weight_readings.patient_id AS t6_r1, weight_readings.relationship AS t6_r7, weight_readings.rid AS t6_r9, weight_readings.serial_number AS t6_r8, weight_readings.time_source AS t6_r10, weight_readings.units AS t6_r5 FROM `evaluations` JOIN `users` AS polymorphic_parent ON `evaluations`.patient_id = polymorphic_parent.id LEFT JOIN `bg_readings` ON `evaluations`.reading_id = `bg_readings`.id AND `evaluations`.reading_type = 'BgReading' LEFT JOIN `bp_readings` ON `evaluations`.reading_id = `bp_readings`.id AND `evaluations`.reading_type = 'BpReading' LEFT JOIN `pulse_readings` ON `evaluations`.reading_id = `pulse_readings`.id AND `evaluations`.reading_type = 'PulseReading' LEFT JOIN `ecg_readings` ON `evaluations`.reading_id = `ecg_readings`.id AND `evaluations`.reading_type = 'EcgReading' LEFT JOIN `weight_readings` ON `evaluations`.reading_id = `weight_readings`.id AND `evaluations`.reading_type = 'WeightReading' LEFT JOIN `symptom_readings` ON `evaluations`.reading_id = `symptom_readings`.id AND `evaluations`.reading_type = 'SymptomReading' WHERE ((`evaluations`.patient_id = 1)) ORDER BY created_at DESC LIMIT 1
Add Comment
Please, Sign In to add comment