I'm still working on this one. This query is a pared down version of
what I actually need. I killed this after 5 minutes.

There is an index on media_order.Id

use euro_temp

select mo.Document AS DocId, 
       mo.id AS MoId,
       mod.Id AS ModId,
       mo.show_title AS ShowId,
       mo.order_rate,
       mo.program_name,
       mo.order_qty,
       mod.actual_air_date,
       mod.actual_air_time
  FROM Media_Order mo
  JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id
  WHERE mo.status = 'ACTIVE'