options
string(833) "SELECT (((ACOS(SIN(r.lat * PI() / 180) * SIN(i.lat * PI() / 180) + COS(r.lat * PI() / 180) * COS(i.lat * PI() / 180) * COS((r.lon - i.lon) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) * 1.609344) AS distance, ABS(TIMESTAMPDIFF(SECOND,r.first_reported,i.first_reported)) as seconds_difference, i.id, i.severity, i.region, i.location, i.type, i.advice, i.response, i.last_updated, i.first_reported, i.suburb, i.lat, i.lon, i.code, i.accuracy, i.state, TIMESTAMPDIFF(SECOND,i.last_updated,REPLACE_TIME) as ago, TIMESTAMPDIFF(SECOND,i.first_reported,REPLACE_TIME) as timeago, i.suburb_links, i.lanes, i.extrainfo, i.reported_by_department, i.ended FROM brisbane_incidents i, brisbane_incidents r WHERE r.id = 233699 AND i.code = "Y" AND i.accuracy >= 4 AND i.id != 233699 HAVING distance < 3.000 ORDER BY seconds_difference ASC LIMIT 0, 2"
Incident Details
Suburb Burpengary
Location Uhlmann Road Off Ramp
Reported 14 Jun, 2012 - 11:55 PM
Information Uhlmann Road Off Ramp, Burpengary - Hazard: Signal fault All directions - No blockage. No delays expected. Proceed with caution. Lights on flash at the intersection of Bruce Highway Exit 146 SB off ramp and Uhlmann Road.
Source 131940