SELECT DISTINCT ...>The following query works - to a point.
>select ri.id, > st.station_name, > ri.invoice_no, > ri.user_name, > ri.done_date_time > from document doc > join media_order mo on mo.document = doc.id > join media_order_detail mod on mod.media_order = mo.id > join recon_info ri on ri.mod_dtid = mod.id > join station st on st.id = doc.station > where st.station_name= 'KTLA' >