SQL Werahouse

--select
--afaktura.CHANGEDAT,
--afaktura.EXTFAKTURANR
--from atour
--left join atasend on atour.nr = atasend.tournr
--left join ASDGABRECHNUNG on atasend.nr = ASDGABRECHNUNG.ATAID
--left join afaktura on ASDGABRECHNUNG.FK_IDAFAKTURA = afaktura.IDAFAKTURA
--where atour.TOURNUMMER = 489160

SELECT  DISTINCT atour.tournummer
FROM atour
LEFT JOIN atasend ON atour.nr = atasend.tournr
LEFT JOIN asendung ON atasend.ASENDUNGID = asendung.SENDUNGID
LEFT JOIN akopf ON asendung.AKOPFNR  = akopf.nr
WHERE atour.lockstatus = 1
AND akopf.auftragsnummer IN (1080409,1084875,1085647,1090338,1090387,1092018,1092351,1092767,1093869,1094120,1094288,1094724,1095017,1095394,1095670,1095773,1096148,1096422,1096789,1096794,1096982,1097284,1098300,1098416,1098431,1098448,1098673,1098894,1098913,1098960,1099139,1099163,1099251,1099294,1099493,1099493,1099493,1099600,1099646,1099731,1100118,1100135,1100204,1100204,1100282,1100724,1100794,1100813,1100815,1100852,1101173,1101802,1101896,1102012,1102930,1103495,1103595,1103690,1103778,1103900,1103998,1104378,1104477,1104524,1104597,1104686,1105092,1105139,1105326,1105359,1105367,1105801,1105900,1106213,1106551,1106706,1106905,1106965,1107027,1107609,1108087,1108098,1108152,1108337,1108405,1108420,1108439,1108797,1108882,1108970,1109229,1109434,1109490,1109546,1110153,1110183,1110225,1110228,1110362,1110435,1110575,1110839,1111041,1111096,1111291,1111579,1111634,1112013,1112080,1112203,1112238,1112323,1112633,1112811,1113202,1113209,1113318,1113318,1113318,1113433,1113510,1113577,1113577,1113713,1114028,1114092,1114228,1114342,1114544,1114660,1114688,1114780,1114959,1115067,1115200,1115295,1115662,1116231,1117359,1119314,1119332);