Chart.

SELECT dttm, response_text, round(response_tm/100,2) as response_tm, timeout FROM accounts.key_uid ku LEFT JOIN accounts.membership_openid_url mou ON (ku.UID=mou.UID) LEFT JOIN accounts.membership_accounts ma ON (ku.UID=ma.UID) LEFT JOIN accounts.membership_services ms ON (ma.AID=ms.AID) LEFT JOIN accounts.key_services ks1 ON (ms.service_id=ks1.service_id) LEFT JOIN accounts.key_status_codes ksc ON (ms.status_id=ksc.status_id) LEFT JOIN accounts.uid_roles ur ON (ms.ms_id=ur.ms_id AND ma.ma_id=ur.ma_id) LEFT JOIN milliguard.config_services cs ON (ms.ms_id=cs.ms_id) LEFT JOIN milliguard.status_log sl ON (cs.remote_host_service_id=sl.remote_host_service_id) LEFT JOIN milliguard.membership_remote_hosts mrh ON (cs.remote_host_service_id=mrh.remote_host_service_id) LEFT JOIN milliguard.key_remote_hosts krm ON (mrh.remote_host_id=krm.remote_host_id) LEFT JOIN milliguard.key_regions kr1 ON (krm.region_id=kr1.region_id) LEFT JOIN milliguard.key_services ks ON (mrh.service_id=ks.service_id) LEFT JOIN milliguard.key_responses kr2 ON (sl.response_id=kr2.response_id) WHERE ks1.service_code='MILLIGUARD' AND ksc.status_code='LIVE' AND (ku.username='https://clickpass.com/public/gmillikan' OR mou.openid_url='https://clickpass.com/public/gmillikan') AND cs.milliguard_joint_id='' #8 = AND ks.service_code='HTTP' AND dttm between '' AND '' AND ( response_tm/100>=timeout OR response_text!='HTTP/1.1 200 OK' ) ORDER BY 1