Неконтрактные позиции : Супермаг Плюс (Супермаг 2000)

 select distinct c.article from smdocuments d, smspec c
where d.doctype=c.doctype
and d.id=c.docid
and d.docstate>=2
and d.createdat between &DateStart and &DateEnd
and d.doctype='WI'

minus
(select distinct c1.article from smdocuments d1, smspec c1, smcontracts k
where
d1.doctype=c1.doctype
and d1.id=c1.docid
and d1.docstate>=2
and k.id=d1.id
and k.doctype=d1.doctype
and k.beginsat<=&DateStart and (k.endsat>=&DateEnd or k.endsat is null)
and d1.doctype='CO')

select distinct q2.clientindex, q2.locationto, q2.createdat, q1.article
from smspec q1, smdocuments q2
    where q1.doctype=q2.doctype
      and q1.docid=q2.id
      and q1.doctype='WI'
      and q2.doctype='WI'
      and q2.opcode=0
      and q2.docstate>=2
      and q2.createdat BETWEEN &DateStart and &DateEnd
MINUS      
select distinct s1.clientindex, s1.locationto, s1.createdat, d2.article
    from smdocuments s1, smspec s2, smdocuments d1, smspec d2, SMContractLocations d3, smcontracts d4 
    where s2.doctype=s1.doctype
      and s2.docid=s1.id
      and s2.doctype='WI'
      and s1.doctype='WI'
      and s1.opcode=0
      and s1.docstate>=2
      and s1.createdat BETWEEN &DateStart and &DateEnd

      and d1.doctype='CO'
      and d2.doctype=d1.doctype
      and d2.docid=d1.id
      and d2.doctype='CO'
      and d3.doctype=d1.doctype
      and d3.id=d1.id
      and d3.doctype='CO'
      and d4.doctype=d1.doctype
      and d4.id=d1.id
      and d4.doctype='CO'
      and d4.endsat >= &DateStart 
    
      and s1.createdat BETWEEN d4.beginsat and d4.endsat
      and s2.article=d2.article
      and s1.locationto=d3.locationid
      and s1.clientindex=d1.clientindex

select distinct q2.clientindex, q2.locationto, q1.article
from smspec q1, smdocuments q2
    where q1.doctype=q2.doctype
      and q1.docid=q2.id
      and q1.doctype='WI'
      and q2.doctype='WI'
      and q2.opcode=0
      and q2.docstate>=2
      and q2.createdat BETWEEN &DateStart and &DateEnd
MINUS      
select distinct d1.clientindex, d3.locationid,  d2.article
    from smdocuments d1, smspec d2, SMContractLocations d3, smcontracts d4 
    where 
d1.doctype='CO'
      and d2.doctype=d1.doctype
      and d2.docid=d1.id
      and d2.doctype='CO'
      and d3.doctype=d1.doctype
      and d3.id=d1.id
      and d3.doctype='CO'
      and d4.doctype=d1.doctype
      and d4.id=d1.id
      and d4.doctype='CO'
      and d4.endsat >= &DateStart 
      and d4.beginsat <= &Dateend and (d4.endsat>=&dateStart or d4.endsat is null)