options
string(815) "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 incidents i, incidents r WHERE r.id = 175245 AND i.code = "Y" AND i.accuracy >= 4 AND i.id != 175245 HAVING distance < 3.000 ORDER BY seconds_difference ASC LIMIT 0, 2"
Incident Details
This incident has ended.
Suburb South Nowra
Location M1 Princes Highway
Region Southern NSW
Reported 24 Aug, 2013 - 11:51 AM
Updated 24 Aug, 2013 - 11:59 AM
Type Accident - Car - Bicycle
Information
Source Transport for NSW