26 lines
924 B
SQL
26 lines
924 B
SQL
-- ANALYSE DER OrderRequest-Logfiles
|
|
|
|
|
|
-- Debitoren mit aktiviertem Autoresponder identifizieren
|
|
SELECT * FROM parameter WHERE par_key like '%AUTO_RESPONSE%' ORDER BY par_value ASC LIMIT 0, 1000
|
|
|
|
|
|
-- t:m Debitoren
|
|
SELECT hq.hq_id, hq.hq_mnemonic, cs.cs_eid, cmp.cmp_comp
|
|
FROM headquarters AS hq, customer AS cs, company AS cmp
|
|
WHERE cs.cs_id IN (823922,839904,823862,819783,832514,835016,833194,819825,823978,203463,835489) AND cs.cmp_id = cmp.cmp_id AND cs.hq_id = hq.hq_id
|
|
ORDER BY cs.hq_id, cs.cs_eid
|
|
|
|
|
|
Bsp."time:matters":
|
|
1 HB STHB922142 time:matters GmbH
|
|
2 HH STHH927621 Time:matters GmbH
|
|
3 B STB975597 time:matters GmbH
|
|
4 H STH910930 time:matters GmbH
|
|
5 F STF909226 time:matters GmbH
|
|
6 DD STDD908923 time:matters GmbH
|
|
7 E STE900608 Time:matters GmbH
|
|
7 E STE902147 Time:matters GmbH
|
|
8 L STL908468 time:matters GmbH
|
|
9 M STM900029 time:matters GmbH
|
|
11 S STS910215 time:matters GmbH |