>SELECT FALSE AS checked, > ' ' AS invoiceid, > ' ' AS ISCI, > ' ' AS dayofweek, > ' ' AS Phone, > doc.id AS docid, > doc.station, > doc.client, > mod.actual_air_date, > mod.actual_air_time, > mo.show_title, > mo.order_rate AS gross, > mo.program_name, > mo.order_qty AS ordqty, > mo.id AS line_id, > FROM Document doc > JOIN Client cl ON cl.id = doc.client > JOIN Station st ON st.id = doc.station > JOIN Media_Order mo ON mo.Document = doc.id > JOIN Show_title sht ON sht.id = mo.show_title > JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id > WHERE doc.id = 14113 > >