guilarzm

Untitled

Jan 4th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. ?[35m(C:/Users/Perduco/PycharmProjects/corlytic/go/src/api/resources/patient_device.go:211)?[0m
  2. ?[33m[2018-01-04 10:23:58]?[0m ?[36;1m[0.00ms]?[0m SELECT `patient_devices`.* FROM `patient_devices` JOIN device_models ON device_models.guid = patient_devices.model_guid JOIN devices ON devices.guid = de
  3. vice_models.device_guid JOIN patients ON patients.guid = patient_devices.patient_guid LEFT JOIN patient_device_events AS implant_event ON implant_event.patient_device_guid = patient_devices.guid AND (implan
  4. t_event.patient_device_guid, implant_event.event_date) IN (SELECT patient_device_guid, MIN(event_date) FROM `patient_device_events` GROUP BY patient_device_guid) LEFT JOIN patient_device_events AS latest_
  5. event ON latest_event.patient_device_guid = patient_devices.guid AND (latest_event.patient_device_guid, latest_event.event_date) IN (SELECT patient_device_guid, MAX(event_date) FROM `patient_device_events`
  6. GROUP BY patient_device_guid)
  7. ?[36;31m[1 rows affected or returned ]?[0m
Advertisement
Add Comment
Please, Sign In to add comment