--BARA ELHANDEL--

SELECT DISTINCT C.CUSTACCOUNT

FROM XLN_EXU_CONTRACTPARTTABLE P

INNER JOIN XLN_EXU_CONTRACTTABLE C

ON P.CONTRACTNUM = C.CONTRACTNUM

AND P.DELIVERYCATEGORY = C.DELIVERYCATEGORY

INNER JOIN XLN_CUSTTABLE K

ON C.CUSTACCOUNT = K.ACCOUNTNUM

AND C.COMPANYID = K.DATAAREAID

WHERE P.PRODUCTNUM = 'xflexle'

AND (P.ENDDATE = '1900-01-01' OR P.ENDDATE > GETDATE())

--AND K.CUSTGROUP NOT IN ('P', 'SP', 'DB', 'FRIK') 

AND C.DELIVERYCATEGORY = 'el-ext'

AND C.CUSTACCOUNT NOT IN (

SELECT CUSTACCOUNT

FROM XLN_EXU_CONTRACTTABLE

WHERE DELIVERYCATEGORY = ''

)

---

--ELHANDEL+ELNÄT--

SELECT DISTINCT C.CUSTACCOUNT

FROM XLN_EXU_CONTRACTPARTTABLE P

INNER JOIN XLN_EXU_CONTRACTTABLE C

ON P.CONTRACTNUM = C.CONTRACTNUM

AND P.DELIVERYCATEGORY = C.DELIVERYCATEGORY

INNER JOIN XLN_CUSTTABLE K

ON C.CUSTACCOUNT = K.ACCOUNTNUM

AND C.COMPANYID = K.DATAAREAID

WHERE P.PRODUCTNUM = 'xflexle'

AND (P.ENDDATE = '1900-01-01' OR P.ENDDATE > GETDATE())

AND C.DELIVERYCATEGORY = 'el-ext'

--AND K.CUSTGROUP NOT IN ('P', 'SP', 'DB', 'FRIK') 

AND C.CUSTACCOUNT IN (

SELECT CUSTACCOUNT

FROM XLN_EXU_CONTRACTTABLE

WHERE DELIVERYCATEGORY = ''

)

---

--BARA ELNÄT--

SELECT DISTINCT C.CUSTACCOUNT

FROM XLN_EXU_CONTRACTTABLE C

WHERE C.DELIVERYCATEGORY = ''

AND (C.CONTRACTENDDATE = '1900-01-01' OR C.CONTRACTENDDATE > GETDATE())

AND C.CUSTACCOUNT NOT IN (

SELECT CUSTACCOUNT

FROM XLN_EXU_CONTRACTTABLE

WHERE DELIVERYCATEGORY = 'el-ext'

)