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'
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people