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
