blob: 41aaebd531ac73ad3db9144728d379bf0c86947b (
plain)
1
2
3
4
5
6
7
8
9
10
|
SELECT V2.id,V2.description,V2.violation_date,V2.street_id,V2.license_plate FROM public.traffic_violations AS V1,public.traffic_violations AS V2
WHERE V1.license_plate LIKE 'AZ__36_'
AND V1.violation_date >= timestamp '2059-12-03 21:00:00' - interval '1 h'
AND V1.violation_date <= timestamp '2059-12-03 21:00:00' + interval '1 h'
AND (
V1.description = 'SPEED_AND_TRAFFIC_VIOLATION'
OR V1.description = 'RECKLESS_AND_DANGEROUS_DRIVING'
)
AND V1.license_plate = V2.license_plate
AND V2.violation_date::date = '2059-12-03 21:00:00'::date
|
