select
v.printed_code,
id_to_text(vd.id) as id_,
id_to_time(vd.id) as created_at,
vd.*
from vehicle_diagnostic vd
left join vehicle v on vd.vehicle_id = v.id
where v.printed_code = '999007'
order by 3 desc
----
select
v.printed_code,
id_to_text(vr.id) as id_,
id_to_time(vr.id) as created_at,
vr.*
from vehicle_repair vr
left join vehicle v on vr.vehicle_id = v.id
where v.printed_code = '999007'
order by 3 desc
----
----
select
*
from vehicle_distribution v
order by id desc
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter