DELIMITER $$

DROP PROCEDURE IF EXISTS "jes"."a_da_fertig"$$
CREATE PROCEDURE "a_da_fertig"(varSeitDatum datetime)
BEGIN


# ---- t_da_sammeln_1 erstellen
DROP TABLE IF EXISTS "jes"."t_da_sammeln_1";
CREATE TABLE "jes"."t_da_sammeln_1" (
  "StabiloNr" DOUBLE(13,0) NOT NULL,
  "ID_da_sammeln_1" INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  "TIMESTAMP" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "Lief-Art-Nr" VARCHAR(50) NULL,
  "Bildpfad" LONGTEXT DEFAULT NULL,
  "Gewicht" INTEGER(11) UNSIGNED NULL,
  "Sichtbar" INTEGER(2) NULL DEFAULT '-1',
  "Brutto_Preis" DOUBLE(15,2) NULL,
  "Kaufen_Zulassen" INTEGER(2) NULL DEFAULT '-1',
  "Sonderangebot" INTEGER(2) NULL,
  "Angebotspreis" DOUBLE(15,2) NULL,
  "Info_Text" LONGTEXT DEFAULT NULL,
  "Vorrauskasse" INT(2) DEFAULT '-1',
  "Vorrauskasse_kosten" DOUBLE(3,2),
  "Nachnahme" INT(2) DEFAULT '-1',
  "Nachnahme_kosten" DOUBLE(3,2),
  "Optionen" VARCHAR(50) NULL,
  "OptionStabiloNr" DOUBLE(13,0) NULL,
  "Werte" VARCHAR(50) NULL,
  "Brutto_Aufpreis" DOUBLE(15,2) NULL,
  "Stand_Shops" DATETIME NULL,
  PRIMARY KEY("ID_da_sammeln_1"),
  INDEX "StabiloNr"("StabiloNr")
)
ENGINE=InnoDB  CHARSET=utf8;


# ---- t_da_sammeln_1 fttern
INSERT INTO jes.t_da_sammeln_1
( StabiloNr, Bildpfad, Gewicht, `Lief-Art-Nr`, Brutto_Preis, Sichtbar, Kaufen_Zulassen, Sonderangebot, Angebotspreis, Info_Text,
Vorrauskasse, Vorrauskasse_kosten, Nachnahme, Nachnahme_kosten, Optionen, OptionStabiloNr, Werte, Brutto_Aufpreis, Stand_Shops )
select distinct
"t_artikel_main"."StabiloNr" AS "StabiloNr",
"t_artikel_main"."Bildpfad" AS "Bildpfad",
"t_artikel_main"."Gewicht" AS "Gewicht",
"t_artikel_zentrale"."Lief-Art-Nr" AS "Lief-Art-Nr",
"t_artikel_shops"."Brutto_Preis" AS "Brutto_Preis",
"t_artikel_shops"."Sichtbar" AS "Sichtbar",
"t_artikel_shops"."Kaufen_Zulassen" AS "Kaufen_Zulassen",
"t_artikel_shops"."Sonderangebot" AS "Sonderangebot",
"t_artikel_shops"."Angebotspreis" AS "Angebotspreis",
"t_artikel_shops"."Info_Text" AS "Info_Text",
"t_artikel_shops"."Vorrauskasse" AS "Vorrauskasse",
"t_artikel_shops"."Vorrauskasse_kosten" AS "Vorrauskasse_kosten",
"t_artikel_shops"."Nachnahme" AS "Nachnahme",
"t_artikel_shops"."Nachnahme_kosten" AS "Nachnahme_kosten",
"t_auswahl_optionen"."Optionen" AS "Optionen",
"t_auswahl_optionen"."OptionStabiloNr" AS "OptionStabiloNr",
"t_auswahl_optionen"."Werte" AS "Werte",
"t_auswahl_optionen"."Brutto_Aufpreis" AS "Brutto_Aufpreis",
"t_artikel_shops"."Stand_Shops" AS "Stand_Shops"
from ((("t_artikel_main"
left join "t_artikel_zentrale" on(("t_artikel_main"."StabiloNr" = "t_artikel_zentrale"."Stabi-EDV-Nr")))
left join "t_artikel_shops" on(("t_artikel_main"."StabiloNr" = "t_artikel_shops"."StabiloNr")))
left join "t_auswahl_optionen" on(("t_artikel_shops"."StabiloNr" = "t_auswahl_optionen"."StabiloNr")))
WHERE ((("t_artikel_shops"."Stand_Shops")>= varSeitDatum) AND (("t_artikel_shops"."Brutto_Preis") Is Not Null));

# ---- t_da_sammeln_2 erstellen
DROP TABLE IF EXISTS "jes"."t_da_sammeln_2";
CREATE TABLE "jes"."t_da_sammeln_2" (
  "ID_da_sammeln_2" INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  "StabiloNr" DOUBLE(13,0) NOT NULL,
  "Download" LONGTEXT DEFAULT NULL,
  "t_lang_deu_Artikelname" VARCHAR(255) NULL,
  "t_lang_eng_Artikelname" VARCHAR(255) NULL,
  "t_lang_fra_Artikelname" VARCHAR(255) NULL,
  "t_lang_deu_GruppenNr" DOUBLE(15,0) NULL,
  "t_lang_eng_GruppenNr" DOUBLE(15,0) NULL,
  "t_lang_fra_GruppenNr" DOUBLE(15,0) NULL,
  "t__gruppennamen_deu_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_deu_Gruppennameexport" VARCHAR(255) NULL,
  "t__gruppennamen_eng_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_eng_Gruppennameexport" VARCHAR(255) NULL,
  "t__gruppennamen_fra_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_fra_Gruppennameexport" VARCHAR(255) NULL,
  "t_lang_deu_Beschreibung" LONGTEXT NULL,
  "t_lang_eng_Beschreibung" LONGTEXT NULL,
  "t_lang_fra_Beschreibung" LONGTEXT NULL,
      PRIMARY KEY("ID_da_sammeln_2"),
      INDEX "StabiloNr"("StabiloNr"),
      INDEX "GrpNr_deu"("t_lang_deu_GruppenNr"),
      INDEX "GrpNr_eng"("t_lang_eng_GruppenNr"),
      INDEX "GrpNr_fra"("t_lang_fra_GruppenNr")
)
ENGINE=InnoDB  CHARSET=utf8;

# ---- t_da_sammeln_2 fttern
INSERT INTO jes.t_da_sammeln_2
( "StabiloNr", "Download", "t_lang_deu_Artikelname", "t_lang_eng_Artikelname", "t_lang_fra_Artikelname",
"t_lang_deu_GruppenNr", "t_lang_eng_GruppenNr", "t_lang_fra_GruppenNr",
"t__gruppennamen_deu_Gruppenname", "t__gruppennamen_deu_Gruppennameexport",
"t__gruppennamen_eng_Gruppenname", "t__gruppennamen_eng_Gruppennameexport",
"t__gruppennamen_fra_Gruppenname", "t__gruppennamen_fra_Gruppennameexport",
"t_lang_deu_Beschreibung", "t_lang_eng_Beschreibung", "t_lang_fra_Beschreibung" )
SELECT DISTINCTROW
"t_da_sammeln_1"."StabiloNr" AS "StabiloNr",
"t_lang_deu"."Download" AS "Download",
"t_lang_deu"."Artikelname" AS "t_lang_deu_Artikelname",
"t_lang_eng"."Artikelname" AS "t_lang_eng_Artikelname",
"t_lang_fra"."Artikelname" AS "t_lang_fra_Artikelname",
"t_lang_deu"."GruppenNr" AS "t_lang_deu_GruppenNr",
"t_lang_eng"."GruppenNr" AS "t_lang_eng_GruppenNr",
"t_lang_fra"."GruppenNr" AS "t_lang_fra_GruppenNr",
"t__gruppennamen_deu"."Gruppenname" AS "t__gruppennamen_deu_Gruppenname",
"t__gruppennamen_deu"."Gruppennameexport" AS "t__gruppennamen_deu_Gruppennameexport",
"t__gruppennamen_eng"."Gruppenname" AS "t__gruppennamen_eng_Gruppenname",
"t__gruppennamen_eng"."Gruppennameexport" AS "t__gruppennamen_eng_Gruppennameexport",
"t__gruppennamen_fra"."Gruppenname" AS "t__gruppennamen_fra_Gruppenname",
"t__gruppennamen_fra"."Gruppennameexport" AS "t__gruppennamen_fra_Gruppennameexport",
"t_lang_deu"."Beschreibung" AS "t_lang_deu_Beschreibung",
"t_lang_eng"."Beschreibung" AS "t_lang_eng_Beschreibung",
"t_lang_fra"."Beschreibung" AS "t_lang_fra_Beschreibung"
FROM ((t_da_sammeln_1
LEFT JOIN (t__gruppennamen_deu
RIGHT JOIN t_lang_deu ON t__gruppennamen_deu.GruppenNr = t_lang_deu.GruppenNr) ON t_da_sammeln_1.StabiloNr = t_lang_deu.StabiloNr)
LEFT JOIN (t__gruppennamen_eng
RIGHT JOIN t_lang_eng ON t__gruppennamen_eng.GruppenNr = t_lang_eng.GruppenNr) ON t_da_sammeln_1.StabiloNr = t_lang_eng.StabiloNr)
LEFT JOIN (t__gruppennamen_fra
RIGHT JOIN t_lang_fra ON t__gruppennamen_fra.GruppenNr = t_lang_fra.GruppenNr) ON t_da_sammeln_1.StabiloNr = t_lang_fra.StabiloNr;


DROP TABLE IF EXISTS "jes"."t_da_sammeln_3";


# ---- t_da_sammeln_3 erstellen
DROP TABLE IF EXISTS "jes"."t_da_sammeln_3";
CREATE TABLE `jes`.`t_da_sammeln_3` (
  `ID_da_sammeln_3` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `StabiloNr` DOUBLE(13,0) NOT NULL,
  `Im-Shop-1` INT(2) NULL,
  `War-Shop-1` INT(2) NULL,
  `Im-Shop-1-ANG` INT(2) NULL,
  `t_DA_S1_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S1_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S1_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-2` INT(2) NULL,
  `War-Shop-2` INT(2) NULL,
  `Im-Shop-2-ANG` INT(2) NULL,
  `t_DA_S2_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S2_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S2_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-3` INT(2) NULL,
  `War-Shop-3` INT(2) NULL,
  `Im-Shop-3-ANG` INT(2) NULL,
  `t_DA_S3_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S3_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S3_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-4` INT(2) NULL,
  `War-Shop-4` INT(2) NULL,
  `Im-Shop-4-ANG` INT(2) NULL,
  `t_DA_S4_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S4_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S4_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-5` INT(2) NULL,
  `War-Shop-5` INT(2) NULL,
  `Im-Shop-5-ANG` INT(2) NULL,
  `t_DA_S5_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S5_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S5_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-6` INT(2) NULL,
  `War-Shop-6` INT(2) NULL,
  `Im-Shop-6-ANG` INT(2) NULL,
  `t_DA_S6_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S6_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S6_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-7` INT(2) NULL,
  `War-Shop-7` INT(2) NULL,
  `Im-Shop-7-ANG` INT(2) NULL,
  `t_DA_S7_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S7_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S7_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-8` INT(2) NULL,
  `War-Shop-8` INT(2) NULL,
  `Im-Shop-8-ANG` INT(2) NULL,
  `t_DA_S8_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S8_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S8_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-9` INT(2) NULL,
  `War-Shop-9` INT(2) NULL,
  `Im-Shop-9-ANG` INT(2) NULL,
  `t_DA_S9_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S9_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S9_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-10` INT(2) NULL,
  `War-Shop-10` INT(2) NULL,
  `Im-Shop-10-ANG` INT(2) NULL,
  `t_DA_S10_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S10_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S10_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-11` INT(2) NULL,
  `War-Shop-11` INT(2) NULL,
  `Im-Shop-11-ANG` INT(2) NULL,
  `t_DA_S11_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S11_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S11_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-12` INT(2) NULL,
  `War-Shop-12` INT(2) NULL,
  `Im-Shop-12-ANG` INT(2) NULL,
  `t_DA_S12_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S12_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S12_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-13` INT(2) NULL,
  `War-Shop-13` INT(2) NULL,
  `Im-Shop-13-ANG` INT(2) NULL,
  `t_DA_S13_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S13_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S13_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-14` INT(2) NULL,
  `War-Shop-14` INT(2) NULL,
  `Im-Shop-14-ANG` INT(2) NULL,
  `t_DA_S14_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S14_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S14_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-15` INT(2) NULL,
  `War-Shop-15` INT(2) NULL,
  `Im-Shop-15-ANG` INT(2) NULL,
  `t_DA_S15_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S15_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S15_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-16` INT(2) NULL,
  `War-Shop-16` INT(2) NULL,
  `Im-Shop-16-ANG` INT(2) NULL,
  `t_DA_S16_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S16_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S16_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-17` INT(2) NULL,
  `War-Shop-17` INT(2) NULL,
  `Im-Shop-17-ANG` INT(2) NULL,
  `t_DA_S17_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S17_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S17_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-18` INT(2) NULL,
  `War-Shop-18` INT(2) NULL,
  `Im-Shop-18-ANG` INT(2) NULL,
  `t_DA_S18_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S18_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S18_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-19` INT(2) NULL,
  `War-Shop-19` INT(2) NULL,
  `Im-Shop-19-ANG` INT(2) NULL,
  `t_DA_S19_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S19_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S19_sk_titel` VARCHAR(32) NULL,
  `Im-Shop-20` INT(2) NULL,
  `War-Shop-20` INT(2) NULL,
  `Im-Shop-20-ANG` INT(2) NULL,
  `t_DA_S20_Preis_bereinigt` DOUBLE(15,2) NULL,
  `t_DA_S20_ANG_Name` VARCHAR(100) NULL,
  `t_DA_S20_sk_titel` VARCHAR(32) NULL,
      PRIMARY KEY(`ID_da_sammeln_3`),
      INDEX `StabiloNr`(`StabiloNr`)
)
TYPE=InnoDB;


# ---- t_da_sammeln_3 füttern
INSERT INTO t_da_sammeln_3
( "StabiloNr",
  "Im-Shop-1", "War-Shop-1", "Im-Shop-1-ANG", "t_DA_S1_Preis_bereinigt", "t_DA_S1_ANG_Name", "t_DA_S1_sk_titel",
  "Im-Shop-2", "War-Shop-2", "Im-Shop-2-ANG", "t_DA_S2_Preis_bereinigt", "t_DA_S2_ANG_Name", "t_DA_S2_sk_titel",
  "Im-Shop-3", "War-Shop-3", "Im-Shop-3-ANG", "t_DA_S3_Preis_bereinigt", "t_DA_S3_ANG_Name", "t_DA_S3_sk_titel",
  "Im-Shop-4", "War-Shop-4", "Im-Shop-4-ANG", "t_DA_S4_Preis_bereinigt", "t_DA_S4_ANG_Name", "t_DA_S4_sk_titel",
  "Im-Shop-5", "War-Shop-5", "Im-Shop-5-ANG", "t_DA_S5_Preis_bereinigt", "t_DA_S5_ANG_Name", "t_DA_S5_sk_titel",
  "Im-Shop-6", "War-Shop-6", "Im-Shop-6-ANG", "t_DA_S6_Preis_bereinigt", "t_DA_S6_ANG_Name", "t_DA_S6_sk_titel",
  "Im-Shop-7", "War-Shop-7", "Im-Shop-7-ANG", "t_DA_S7_Preis_bereinigt", "t_DA_S7_ANG_Name", "t_DA_S7_sk_titel",
  "Im-Shop-8", "War-Shop-8", "Im-Shop-8-ANG", "t_DA_S8_Preis_bereinigt", "t_DA_S8_ANG_Name", "t_DA_S8_sk_titel",
  "Im-Shop-9", "War-Shop-9", "Im-Shop-9-ANG", "t_DA_S9_Preis_bereinigt", "t_DA_S9_ANG_Name", "t_DA_S9_sk_titel",
  "Im-Shop-10", "War-Shop-10", "Im-Shop-10-ANG", "t_DA_S10_Preis_bereinigt", "t_DA_S10_ANG_Name", "t_DA_S10_sk_titel",
  "Im-Shop-11", "War-Shop-11", "Im-Shop-11-ANG", "t_DA_S11_Preis_bereinigt", "t_DA_S11_ANG_Name", "t_DA_S11_sk_titel",
  "Im-Shop-12", "War-Shop-12", "Im-Shop-12-ANG", "t_DA_S12_Preis_bereinigt", "t_DA_S12_ANG_Name", "t_DA_S12_sk_titel",
  "Im-Shop-13", "War-Shop-13", "Im-Shop-13-ANG", "t_DA_S13_Preis_bereinigt", "t_DA_S13_ANG_Name", "t_DA_S13_sk_titel",
  "Im-Shop-14", "War-Shop-14", "Im-Shop-14-ANG", "t_DA_S14_Preis_bereinigt", "t_DA_S14_ANG_Name", "t_DA_S14_sk_titel",
  "Im-Shop-15", "War-Shop-15", "Im-Shop-15-ANG", "t_DA_S15_Preis_bereinigt", "t_DA_S15_ANG_Name", "t_DA_S15_sk_titel",
  "Im-Shop-16", "War-Shop-16", "Im-Shop-16-ANG", "t_DA_S16_Preis_bereinigt", "t_DA_S16_ANG_Name", "t_DA_S16_sk_titel",
  "Im-Shop-17", "War-Shop-17", "Im-Shop-17-ANG", "t_DA_S17_Preis_bereinigt", "t_DA_S17_ANG_Name", "t_DA_S17_sk_titel",
  "Im-Shop-18", "War-Shop-18", "Im-Shop-18-ANG", "t_DA_S18_Preis_bereinigt", "t_DA_S18_ANG_Name", "t_DA_S18_sk_titel",
  "Im-Shop-19", "War-Shop-19", "Im-Shop-19-ANG", "t_DA_S19_Preis_bereinigt", "t_DA_S19_ANG_Name", "t_DA_S19_sk_titel",
  "Im-Shop-20", "War-Shop-20", "Im-Shop-20-ANG", "t_DA_S20_Preis_bereinigt", "t_DA_S20_ANG_Name", "t_DA_S20_sk_titel"
)
SELECT DISTINCTROW
"t_da_sammeln_1"."StabiloNr" AS "StabiloNr",
"t_da_s1"."Im-Shop-1" AS "Im-Shop-1",
"t_da_s1"."War-Shop-1" AS "War-Shop-1",
"t_da_s1"."Im-Shop-1-ANG" AS "Im-Shop-1-ANG",
"t_da_s1"."Preis_bereinigt" AS "t_DA_S1.Preis_bereinigt",
"t_da_s1"."ANG_Name" AS "t_da_S1.ANG_Name",
"t_da_s1"."sk_titel" AS "t_da_S1.sk_titel",

"t_da_s2"."Im-Shop-2" AS "Im-Shop-2",
"t_da_s2"."War-Shop-2" AS "War-Shop-2",
"t_da_s2"."Im-Shop-2-ANG" AS "Im-Shop-2-ANG",
"t_da_s2"."Preis_bereinigt" AS "t_da_S2.Preis_bereinigt",
"t_da_s2"."ANG_Name" AS "t_da_S2.ANG_Name",
"t_da_s2"."sk_titel" AS "t_da_S2.sk_titel",

"t_da_s3"."Im-Shop-3" AS "Im-Shop-3",
"t_da_s3"."War-Shop-3" AS "War-Shop-3",
"t_da_s3"."Im-Shop-3-ANG" AS "Im-Shop-3-ANG",
"t_da_s3"."Preis_bereinigt" AS "t_da_S3.Preis_bereinigt",
"t_da_s3"."ANG_Name" AS "t_da_S3.ANG_Name",
"t_da_s3"."sk_titel" AS "t_da_S3.sk_titel",

"t_da_s4"."Im-Shop-4" AS "Im-Shop-4",
"t_da_s4"."War-Shop-4" AS "War-Shop-4",
"t_da_s4"."Im-Shop-4-ANG" AS "Im-Shop-4-ANG",
"t_da_s4"."Preis_bereinigt" AS "t_da_S4.Preis_bereinigt",
"t_da_s4"."ANG_Name" AS "t_da_S4.ANG_Name",
"t_da_s4"."sk_titel" AS "t_da_S4.sk_titel",

"t_da_s5"."Im-Shop-5" AS "Im-Shop-5",
"t_da_s5"."War-Shop-5" AS "War-Shop-5",
"t_da_s5"."Im-Shop-5-ANG" AS "Im-Shop-5-ANG",
"t_da_s5"."Preis_bereinigt" AS "t_da_S5.Preis_bereinigt",
"t_da_s5"."ANG_Name" AS "t_da_S5.ANG_Name",
"t_da_s5"."sk_titel" AS "t_da_S5.sk_titel",

"t_da_s6"."Im-Shop-6" AS "Im-Shop-6",
"t_da_s6"."War-Shop-6" AS "War-Shop-6",
"t_da_s6"."Im-Shop-6-ANG" AS "Im-Shop-6-ANG",
"t_da_s6"."Preis_bereinigt" AS "t_da_S6.Preis_bereinigt",
"t_da_s6"."ANG_Name" AS "t_da_S6.ANG_Name",
"t_da_s6"."sk_titel" AS "t_da_S6.sk_titel",

"t_da_s7"."Im-Shop-7" AS "Im-Shop-7",
"t_da_s7"."War-Shop-7" AS "War-Shop-7",
"t_da_s7"."Im-Shop-7-ANG" AS "Im-Shop-7-ANG",
"t_da_s7"."Preis_bereinigt" AS "t_da_S7.Preis_bereinigt",
"t_da_s7"."ANG_Name" AS "t_da_S7.ANG_Name",
"t_da_s7"."sk_titel" AS "t_da_S7.sk_titel",

"t_da_s8"."Im-Shop-8" AS "Im-Shop-8",
"t_da_s8"."War-Shop-8" AS "War-Shop-8",
"t_da_s8"."Im-Shop-8-ANG" AS "Im-Shop-8-ANG",
"t_da_s8"."Preis_bereinigt" AS "t_da_S8.Preis_bereinigt",
"t_da_s8"."ANG_Name" AS "t_da_S8.ANG_Name",
"t_da_s8"."sk_titel" AS "t_da_S8.sk_titel",

"t_da_s9"."Im-Shop-9" AS "Im-Shop-9",
"t_da_s9"."War-Shop-9" AS "War-Shop-9",
"t_da_s9"."Im-Shop-9-ANG" AS "Im-Shop-9-ANG",
"t_da_s9"."Preis_bereinigt" AS "t_da_S9.Preis_bereinigt",
"t_da_s9"."ANG_Name" AS "t_da_S9.ANG_Name",
"t_da_s9"."sk_titel" AS "t_da_S9.sk_titel",

"t_da_s10"."Im-Shop-10" AS "Im-Shop-10",
"t_da_s10"."War-Shop-10" AS "War-Shop-10",
"t_da_s10"."Im-Shop-10-ANG" AS "Im-Shop-10-ANG",
"t_da_s10"."Preis_bereinigt" AS "t_da_S10.Preis_bereinigt",
"t_da_s10"."ANG_Name" AS "t_da_S10.ANG_Name",
"t_da_s10"."sk_titel" AS "t_da_S10.sk_titel",

"t_da_s11"."Im-Shop-11" AS "Im-Shop-11",
"t_da_s11"."War-Shop-11" AS "War-Shop-11",
"t_da_s11"."Im-Shop-11-ANG" AS "Im-Shop-11-ANG",
"t_da_s11"."Preis_bereinigt" AS "t_da_S11.Preis_bereinigt",
"t_da_s11"."ANG_Name" AS "t_da_S11.ANG_Name",
"t_da_s11"."sk_titel" AS "t_da_S11.sk_titel",

"t_da_s12"."Im-Shop-12" AS "Im-Shop-12",
"t_da_s12"."War-Shop-12" AS "War-Shop-12",
"t_da_s12"."Im-Shop-12-ANG" AS "Im-Shop-12-ANG",
"t_da_s12"."Preis_bereinigt" AS "t_da_S12.Preis_bereinigt",
"t_da_s12"."ANG_Name" AS "t_da_S12.ANG_Name",
"t_da_s12"."sk_titel" AS "t_da_S12.sk_titel",

"t_da_s13"."Im-Shop-13" AS "Im-Shop-13",
"t_da_s13"."War-Shop-13" AS "War-Shop-13",
"t_da_s13"."Im-Shop-13-ANG" AS "Im-Shop-13-ANG",
"t_da_s13"."Preis_bereinigt" AS "t_da_S13.Preis_bereinigt",
"t_da_s13"."ANG_Name" AS "t_da_S13.ANG_Name",
"t_da_s13"."sk_titel" AS "t_da_S13.sk_titel",

"t_da_s14"."Im-Shop-14" AS "Im-Shop-14",
"t_da_s14"."War-Shop-14" AS "War-Shop-14",
"t_da_s14"."Im-Shop-14-ANG" AS "Im-Shop-14-ANG",
"t_da_s14"."Preis_bereinigt" AS "t_da_S14.Preis_bereinigt",
"t_da_s14"."ANG_Name" AS "t_da_S14.ANG_Name",
"t_da_s14"."sk_titel" AS "t_da_S14.sk_titel",

"t_da_s15"."Im-Shop-15" AS "Im-Shop-15",
"t_da_s15"."War-Shop-15" AS "War-Shop-15",
"t_da_s15"."Im-Shop-15-ANG" AS "Im-Shop-15-ANG",
"t_da_s15"."Preis_bereinigt" AS "t_da_S15.Preis_bereinigt",
"t_da_s15"."ANG_Name" AS "t_da_S15.ANG_Name",
"t_da_s15"."sk_titel" AS "t_da_S15.sk_titel",

"t_da_s16"."Im-Shop-16" AS "Im-Shop-16",
"t_da_s16"."War-Shop-16" AS "War-Shop-16",
"t_da_s16"."Im-Shop-16-ANG" AS "Im-Shop-16-ANG",
"t_da_s16"."Preis_bereinigt" AS "t_da_S16.Preis_bereinigt",
"t_da_s16"."ANG_Name" AS "t_da_S16.ANG_Name",
"t_da_s16"."sk_titel" AS "t_da_S16.sk_titel",

"t_da_s17"."Im-Shop-17" AS "Im-Shop-17",
"t_da_s17"."War-Shop-17" AS "War-Shop-17",
"t_da_s17"."Im-Shop-17-ANG" AS "Im-Shop-17-ANG",
"t_da_s17"."Preis_bereinigt" AS "t_da_S17.Preis_bereinigt",
"t_da_s17"."ANG_Name" AS "t_da_S17.ANG_Name",
"t_da_s17"."sk_titel" AS "t_da_S17.sk_titel",

"t_da_s18"."Im-Shop-18" AS "Im-Shop-18",
"t_da_s18"."War-Shop-18" AS "War-Shop-18",
"t_da_s18"."Im-Shop-18-ANG" AS "Im-Shop-18-ANG",
"t_da_s18"."Preis_bereinigt" AS "t_da_S18.Preis_bereinigt",
"t_da_s18"."ANG_Name" AS "t_da_S18.ANG_Name",
"t_da_s18"."sk_titel" AS "t_da_S18.sk_titel",

"t_da_s19"."Im-Shop-19" AS "Im-Shop-19",
"t_da_s19"."War-Shop-19" AS "War-Shop-19",
"t_da_s19"."Im-Shop-19-ANG" AS "Im-Shop-19-ANG",
"t_da_s19"."Preis_bereinigt" AS "t_da_S19.Preis_bereinigt",
"t_da_s19"."ANG_Name" AS "t_da_S19.ANG_Name",
"t_da_s19"."sk_titel" AS "t_da_S19.sk_titel",

"t_da_s20"."Im-Shop-20" AS "Im-Shop-20",
"t_da_s20"."War-Shop-20" AS "War-Shop-20",
"t_da_s20"."Im-Shop-20-ANG" AS "Im-Shop-20-ANG",
"t_da_s20"."Preis_bereinigt" AS "t_da_S20.Preis_bereinigt",
"t_da_s20"."ANG_Name" AS "t_da_S20.ANG_Name",
"t_da_s20"."sk_titel" AS "t_da_S20.sk_titel"

from (((((((((((((((((((("t_da_sammeln_1"
left join "t_da_s1" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s1"."StabiloNr")))
left join "t_da_s2" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s2"."StabiloNr")))
left join "t_da_s3" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s3"."StabiloNr")))
left join "t_da_s4" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s4"."StabiloNr")))
left join "t_da_s5" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s5"."StabiloNr")))
left join "t_da_s6" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s6"."StabiloNr")))
left join "t_da_s7" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s7"."StabiloNr")))
left join "t_da_s8" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s8"."StabiloNr")))
left join "t_da_s9" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s9"."StabiloNr")))
left join "t_da_s10" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s10"."StabiloNr")))
left join "t_da_s11" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s11"."StabiloNr")))
left join "t_da_s12" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s12"."StabiloNr")))
left join "t_da_s13" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s13"."StabiloNr")))
left join "t_da_s14" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s14"."StabiloNr")))
left join "t_da_s15" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s15"."StabiloNr")))
left join "t_da_s16" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s16"."StabiloNr")))
left join "t_da_s17" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s17"."StabiloNr")))
left join "t_da_s18" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s18"."StabiloNr")))
left join "t_da_s19" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s19"."StabiloNr")))
left join "t_da_s20" on(("t_da_sammeln_1"."StabiloNr" = "t_da_s20"."StabiloNr")));


# ---- t_da_fertig erstellen
DROP TABLE IF EXISTS "jes"."t_da_fertig";

CREATE TABLE `t_da_fertig` (
  "ID_da_fertig" INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  "TIMESTAMP" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "StabiloNr" DOUBLE(13,0) NOT NULL,
  "Lief-Art-Nr" VARCHAR(50) NULL,
  "Bildpfad" LONGTEXT DEFAULT NULL,
  "Download" LONGTEXT DEFAULT NULL,
  "Gewicht" INTEGER(11) UNSIGNED NULL,
  "Brutto_Preis" DOUBLE(15,2) NULL,
  "Sichtbar" INTEGER(2) NULL DEFAULT '0',
  "Kaufen_Zulassen" INTEGER(2) NULL DEFAULT '0',
  "Sonderangebot" INTEGER(2) NULL,
  "Angebotspreis" DOUBLE(15,2) NULL,
  "Info_Text" LONGTEXT DEFAULT NULL,
  "Vorrauskasse" INT(2) DEFAULT '-1',
  "Vorrauskasse_kosten" DOUBLE(3,2),
  "Nachnahme" INT(2) DEFAULT '-1',
  "Nachnahme_kosten" DOUBLE(3,2),
  "Stand_Shops" DATETIME NULL,
  "t_lang_deu_Artikelname" VARCHAR(255) NULL,
  "t_lang_eng_Artikelname" VARCHAR(255) NULL,
  "t_lang_fra_Artikelname" VARCHAR(255) NULL,
  "t_lang_deu_GruppenNr" DOUBLE(15,0) NULL,
  "t_lang_eng_GruppenNr" DOUBLE(15,0) NULL,
  "t_lang_fra_GruppenNr" DOUBLE(15,0) NULL,
  "t__gruppennamen_deu_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_deu_Gruppennameexport" VARCHAR(255) NULL,
  "t__gruppennamen_eng_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_eng_Gruppennameexport" VARCHAR(255) NULL,
  "t__gruppennamen_fra_Gruppenname" VARCHAR(100) NULL,
  "t__gruppennamen_fra_Gruppennameexport" VARCHAR(255) NULL,
  "t_lang_deu_Beschreibung" LONGTEXT NULL,
  "t_lang_eng_Beschreibung" LONGTEXT NULL,
  "t_lang_fra_Beschreibung" LONGTEXT NULL,
  "Im-Shop-1" INT(2) NULL,
  "War-Shop-1" INT(2) NULL,
  "Im-Shop-1-ANG" INT(2) NULL,
  "t_DA_S1_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S1_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S1_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-2" INT(2) NULL,
  "War-Shop-2" INT(2) NULL,
  "Im-Shop-2-ANG" INT(2) NULL,
  "t_DA_S2_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S2_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S2_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-3" INT(2) NULL,
  "War-Shop-3" INT(2) NULL,
  "Im-Shop-3-ANG" INT(2) NULL,
  "t_DA_S3_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S3_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S3_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-4" INT(2) NULL,
  "War-Shop-4" INT(2) NULL,
  "Im-Shop-4-ANG" INT(2) NULL,
  "t_DA_S4_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S4_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S4_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-5" INT(2) NULL,
  "War-Shop-5" INT(2) NULL,
  "Im-Shop-5-ANG" INT(2) NULL,
  "t_DA_S5_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S5_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S5_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-6" INT(2) NULL,
  "War-Shop-6" INT(2) NULL,
  "Im-Shop-6-ANG" INT(2) NULL,
  "t_DA_S6_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S6_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S6_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-7" INT(2) NULL,
  "War-Shop-7" INT(2) NULL,
  "Im-Shop-7-ANG" INT(2) NULL,
  "t_DA_S7_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S7_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S7_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-8" INT(2) NULL,
  "War-Shop-8" INT(2) NULL,
  "Im-Shop-8-ANG" INT(2) NULL,
  "t_DA_S8_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S8_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S8_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-9" INT(2) NULL,
  "War-Shop-9" INT(2) NULL,
  "Im-Shop-9-ANG" INT(2) NULL,
  "t_DA_S9_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S9_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S9_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-10" INT(2) NULL,
  "War-Shop-10" INT(2) NULL,
  "Im-Shop-10-ANG" INT(2) NULL,
  "t_DA_S10_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S10_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S10_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-11" INT(2) NULL,
  "War-Shop-11" INT(2) NULL,
  "Im-Shop-11-ANG" INT(2) NULL,
  "t_DA_S11_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S11_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S11_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-12" INT(2) NULL,
  "War-Shop-12" INT(2) NULL,
  "Im-Shop-12-ANG" INT(2) NULL,
  "t_DA_S12_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S12_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S12_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-13" INT(2) NULL,
  "War-Shop-13" INT(2) NULL,
  "Im-Shop-13-ANG" INT(2) NULL,
  "t_DA_S13_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S13_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S13_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-14" INT(2) NULL,
  "War-Shop-14" INT(2) NULL,
  "Im-Shop-14-ANG" INT(2) NULL,
  "t_DA_S14_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S14_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S14_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-15" INT(2) NULL,
  "War-Shop-15" INT(2) NULL,
  "Im-Shop-15-ANG" INT(2) NULL,
  "t_DA_S15_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S15_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S15_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-16" INT(2) NULL,
  "War-Shop-16" INT(2) NULL,
  "Im-Shop-16-ANG" INT(2) NULL,
  "t_DA_S16_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S16_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S16_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-17" INT(2) NULL,
  "War-Shop-17" INT(2) NULL,
  "Im-Shop-17-ANG" INT(2) NULL,
  "t_DA_S17_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S17_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S17_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-18" INT(2) NULL,
  "War-Shop-18" INT(2) NULL,
  "Im-Shop-18-ANG" INT(2) NULL,
  "t_DA_S18_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S18_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S18_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-19" INT(2) NULL,
  "War-Shop-19" INT(2) NULL,
  "Im-Shop-19-ANG" INT(2) NULL,
  "t_DA_S19_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S19_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S19_sk_titel" VARCHAR(32) NULL,
  "Im-Shop-20" INT(2) NULL,
  "War-Shop-20" INT(2) NULL,
  "Im-Shop-20-ANG" INT(2) NULL,
  "t_DA_S20_Preis_bereinigt" DOUBLE(15,2) NULL,
  "t_DA_S20_ANG_Name" VARCHAR(100) NULL,
  "t_DA_S20_sk_titel" VARCHAR(32) NULL,
      PRIMARY KEY("ID_da_fertig"),
  INDEX "Stabilonr"("StabiloNr")
)
ENGINE=InnoDB  CHARSET=utf8;


# ---- Sammlungen zusammenfassen in t_da_fertig
INSERT INTO t_da_fertig
(
  "StabiloNr", "Lief-Art-Nr", "Bildpfad", "Download", "Gewicht", "Brutto_Preis", "Sichtbar", "Kaufen_Zulassen",  "Sonderangebot", "Angebotspreis",
  "Info_Text", "Vorrauskasse", "Vorrauskasse_kosten", "Nachnahme", "Nachnahme_kosten", "Stand_Shops",
  "t_lang_deu_Artikelname", "t_lang_eng_Artikelname", "t_lang_fra_Artikelname",
  "t_lang_deu_GruppenNr", "t_lang_eng_GruppenNr", "t_lang_fra_GruppenNr",
  "t__gruppennamen_deu_Gruppenname", "t__gruppennamen_deu_Gruppennameexport",
  "t__gruppennamen_eng_Gruppenname", "t__gruppennamen_eng_Gruppennameexport",
  "t__gruppennamen_fra_Gruppenname", "t__gruppennamen_fra_Gruppennameexport",
  "t_lang_deu_Beschreibung", "t_lang_eng_Beschreibung", "t_lang_fra_Beschreibung",
  "Im-Shop-1", "War-Shop-1", "Im-Shop-1-ANG", "t_DA_S1_Preis_bereinigt", "t_DA_S1_ANG_Name", "t_DA_S1_sk_titel",
  "Im-Shop-2", "War-Shop-2", "Im-Shop-2-ANG", "t_DA_S2_Preis_bereinigt", "t_DA_S2_ANG_Name", "t_DA_S2_sk_titel",
  "Im-Shop-3", "War-Shop-3", "Im-Shop-3-ANG", "t_DA_S3_Preis_bereinigt", "t_DA_S3_ANG_Name", "t_DA_S3_sk_titel",
  "Im-Shop-4", "War-Shop-4", "Im-Shop-4-ANG", "t_DA_S4_Preis_bereinigt", "t_DA_S4_ANG_Name", "t_DA_S4_sk_titel",
  "Im-Shop-5", "War-Shop-5", "Im-Shop-5-ANG", "t_DA_S5_Preis_bereinigt", "t_DA_S5_ANG_Name", "t_DA_S5_sk_titel",
  "Im-Shop-6", "War-Shop-6", "Im-Shop-6-ANG", "t_DA_S6_Preis_bereinigt", "t_DA_S6_ANG_Name", "t_DA_S6_sk_titel",
  "Im-Shop-7", "War-Shop-7", "Im-Shop-7-ANG", "t_DA_S7_Preis_bereinigt", "t_DA_S7_ANG_Name", "t_DA_S7_sk_titel",
  "Im-Shop-8", "War-Shop-8", "Im-Shop-8-ANG", "t_DA_S8_Preis_bereinigt", "t_DA_S8_ANG_Name", "t_DA_S8_sk_titel",
  "Im-Shop-9", "War-Shop-9", "Im-Shop-9-ANG", "t_DA_S9_Preis_bereinigt", "t_DA_S9_ANG_Name", "t_DA_S9_sk_titel",
  "Im-Shop-10", "War-Shop-10", "Im-Shop-10-ANG", "t_DA_S10_Preis_bereinigt", "t_DA_S10_ANG_Name", "t_DA_S10_sk_titel",
  "Im-Shop-11", "War-Shop-11", "Im-Shop-11-ANG", "t_DA_S11_Preis_bereinigt", "t_DA_S11_ANG_Name", "t_DA_S11_sk_titel",
  "Im-Shop-12", "War-Shop-12", "Im-Shop-12-ANG", "t_DA_S12_Preis_bereinigt", "t_DA_S12_ANG_Name", "t_DA_S12_sk_titel",
  "Im-Shop-13", "War-Shop-13", "Im-Shop-13-ANG", "t_DA_S13_Preis_bereinigt", "t_DA_S13_ANG_Name", "t_DA_S13_sk_titel",
  "Im-Shop-14", "War-Shop-14", "Im-Shop-14-ANG", "t_DA_S14_Preis_bereinigt", "t_DA_S14_ANG_Name", "t_DA_S14_sk_titel",
  "Im-Shop-15", "War-Shop-15", "Im-Shop-15-ANG", "t_DA_S15_Preis_bereinigt", "t_DA_S15_ANG_Name", "t_DA_S15_sk_titel",
  "Im-Shop-16", "War-Shop-16", "Im-Shop-16-ANG", "t_DA_S16_Preis_bereinigt", "t_DA_S16_ANG_Name", "t_DA_S16_sk_titel",
  "Im-Shop-17", "War-Shop-17", "Im-Shop-17-ANG", "t_DA_S17_Preis_bereinigt", "t_DA_S17_ANG_Name", "t_DA_S17_sk_titel",
  "Im-Shop-18", "War-Shop-18", "Im-Shop-18-ANG", "t_DA_S18_Preis_bereinigt", "t_DA_S18_ANG_Name", "t_DA_S18_sk_titel",
  "Im-Shop-19", "War-Shop-19", "Im-Shop-19-ANG", "t_DA_S19_Preis_bereinigt", "t_DA_S19_ANG_Name", "t_DA_S19_sk_titel",
  "Im-Shop-20", "War-Shop-20", "Im-Shop-20-ANG", "t_DA_S20_Preis_bereinigt", "t_DA_S20_ANG_Name", "t_DA_S20_sk_titel"
)
SELECT
  "t_da_sammeln_1"."StabiloNr", "t_da_sammeln_1"."Lief-Art-Nr", "t_da_sammeln_1"."Bildpfad", "t_da_sammeln_2"."Download", "t_da_sammeln_1"."Gewicht",
  "t_da_sammeln_1"."Brutto_Preis", "t_da_sammeln_1"."Sichtbar", "t_da_sammeln_1"."Kaufen_Zulassen",
  "t_da_sammeln_1"."Sonderangebot", "t_da_sammeln_1"."Angebotspreis", "t_da_sammeln_1"."Info_Text",
  "t_da_sammeln_1"."Vorrauskasse", "t_da_sammeln_1"."Vorrauskasse_kosten",
  "t_da_sammeln_1"."Nachnahme", "t_da_sammeln_1"."Nachnahme_kosten",
  "t_da_sammeln_1"."Stand_Shops",
  "t_da_sammeln_2"."t_lang_deu_Artikelname", "t_da_sammeln_2"."t_lang_eng_Artikelname", "t_da_sammeln_2"."t_lang_fra_Artikelname",
  "t_da_sammeln_2"."t_lang_deu_GruppenNr", "t_da_sammeln_2"."t_lang_eng_GruppenNr", "t_da_sammeln_2"."t_lang_fra_GruppenNr",
  "t_da_sammeln_2"."t__gruppennamen_deu_Gruppenname", "t_da_sammeln_2"."t__gruppennamen_deu_Gruppennameexport",
  "t_da_sammeln_2"."t__gruppennamen_eng_Gruppenname", "t_da_sammeln_2"."t__gruppennamen_eng_Gruppennameexport",
  "t_da_sammeln_2"."t__gruppennamen_fra_Gruppenname", "t_da_sammeln_2"."t__gruppennamen_fra_Gruppennameexport",
  "t_da_sammeln_2"."t_lang_deu_Beschreibung", "t_da_sammeln_2"."t_lang_eng_Beschreibung", "t_da_sammeln_2"."t_lang_fra_Beschreibung",
  "t_da_sammeln_3"."Im-Shop-1", "t_da_sammeln_3"."War-Shop-1", "t_da_sammeln_3"."Im-Shop-1-ANG", "t_da_sammeln_3"."t_DA_S1_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S1_ANG_Name", "t_da_sammeln_3"."t_DA_S1_sk_titel",
  "t_da_sammeln_3"."Im-Shop-2", "t_da_sammeln_3"."War-Shop-2", "t_da_sammeln_3"."Im-Shop-2-ANG", "t_da_sammeln_3"."t_DA_S2_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S2_ANG_Name", "t_da_sammeln_3"."t_DA_S2_sk_titel",
  "t_da_sammeln_3"."Im-Shop-3", "t_da_sammeln_3"."War-Shop-3", "t_da_sammeln_3"."Im-Shop-3-ANG", "t_da_sammeln_3"."t_DA_S3_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S3_ANG_Name", "t_da_sammeln_3"."t_DA_S3_sk_titel",
  "t_da_sammeln_3"."Im-Shop-4", "t_da_sammeln_3"."War-Shop-4", "t_da_sammeln_3"."Im-Shop-4-ANG", "t_da_sammeln_3"."t_DA_S4_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S4_ANG_Name", "t_da_sammeln_3"."t_DA_S4_sk_titel",
  "t_da_sammeln_3"."Im-Shop-5", "t_da_sammeln_3"."War-Shop-5", "t_da_sammeln_3"."Im-Shop-5-ANG", "t_da_sammeln_3"."t_DA_S5_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S5_ANG_Name", "t_da_sammeln_3"."t_DA_S5_sk_titel",
  "t_da_sammeln_3"."Im-Shop-6", "t_da_sammeln_3"."War-Shop-6", "t_da_sammeln_3"."Im-Shop-6-ANG", "t_da_sammeln_3"."t_DA_S6_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S6_ANG_Name", "t_da_sammeln_3"."t_DA_S6_sk_titel",
  "t_da_sammeln_3"."Im-Shop-7", "t_da_sammeln_3"."War-Shop-7", "t_da_sammeln_3"."Im-Shop-7-ANG", "t_da_sammeln_3"."t_DA_S7_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S7_ANG_Name", "t_da_sammeln_3"."t_DA_S7_sk_titel",
  "t_da_sammeln_3"."Im-Shop-8", "t_da_sammeln_3"."War-Shop-8", "t_da_sammeln_3"."Im-Shop-8-ANG", "t_da_sammeln_3"."t_DA_S8_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S8_ANG_Name", "t_da_sammeln_3"."t_DA_S8_sk_titel",
  "t_da_sammeln_3"."Im-Shop-9", "t_da_sammeln_3"."War-Shop-9", "t_da_sammeln_3"."Im-Shop-9-ANG", "t_da_sammeln_3"."t_DA_S9_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S9_ANG_Name", "t_da_sammeln_3"."t_DA_S9_sk_titel",
  "t_da_sammeln_3"."Im-Shop-10", "t_da_sammeln_3"."War-Shop-10", "t_da_sammeln_3"."Im-Shop-10-ANG", "t_da_sammeln_3"."t_DA_S10_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S10_ANG_Name", "t_da_sammeln_3"."t_DA_S10_sk_titel",
  "t_da_sammeln_3"."Im-Shop-11", "t_da_sammeln_3"."War-Shop-11", "t_da_sammeln_3"."Im-Shop-11-ANG", "t_da_sammeln_3"."t_DA_S11_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S11_ANG_Name", "t_da_sammeln_3"."t_DA_S11_sk_titel",
  "t_da_sammeln_3"."Im-Shop-12", "t_da_sammeln_3"."War-Shop-12", "t_da_sammeln_3"."Im-Shop-12-ANG", "t_da_sammeln_3"."t_DA_S12_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S12_ANG_Name", "t_da_sammeln_3"."t_DA_S12_sk_titel",
  "t_da_sammeln_3"."Im-Shop-13", "t_da_sammeln_3"."War-Shop-13", "t_da_sammeln_3"."Im-Shop-13-ANG", "t_da_sammeln_3"."t_DA_S13_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S13_ANG_Name", "t_da_sammeln_3"."t_DA_S13_sk_titel",
  "t_da_sammeln_3"."Im-Shop-14", "t_da_sammeln_3"."War-Shop-14", "t_da_sammeln_3"."Im-Shop-14-ANG", "t_da_sammeln_3"."t_DA_S14_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S14_ANG_Name", "t_da_sammeln_3"."t_DA_S14_sk_titel",
  "t_da_sammeln_3"."Im-Shop-15", "t_da_sammeln_3"."War-Shop-15", "t_da_sammeln_3"."Im-Shop-15-ANG", "t_da_sammeln_3"."t_DA_S15_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S15_ANG_Name", "t_da_sammeln_3"."t_DA_S15_sk_titel",
  "t_da_sammeln_3"."Im-Shop-16", "t_da_sammeln_3"."War-Shop-16", "t_da_sammeln_3"."Im-Shop-16-ANG", "t_da_sammeln_3"."t_DA_S16_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S16_ANG_Name", "t_da_sammeln_3"."t_DA_S16_sk_titel",
  "t_da_sammeln_3"."Im-Shop-17", "t_da_sammeln_3"."War-Shop-17", "t_da_sammeln_3"."Im-Shop-17-ANG", "t_da_sammeln_3"."t_DA_S17_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S17_ANG_Name", "t_da_sammeln_3"."t_DA_S17_sk_titel",
  "t_da_sammeln_3"."Im-Shop-18", "t_da_sammeln_3"."War-Shop-18", "t_da_sammeln_3"."Im-Shop-18-ANG", "t_da_sammeln_3"."t_DA_S18_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S18_ANG_Name", "t_da_sammeln_3"."t_DA_S18_sk_titel",
  "t_da_sammeln_3"."Im-Shop-19", "t_da_sammeln_3"."War-Shop-19", "t_da_sammeln_3"."Im-Shop-19-ANG", "t_da_sammeln_3"."t_DA_S19_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S19_ANG_Name", "t_da_sammeln_3"."t_DA_S19_sk_titel",
  "t_da_sammeln_3"."Im-Shop-20", "t_da_sammeln_3"."War-Shop-20", "t_da_sammeln_3"."Im-Shop-20-ANG", "t_da_sammeln_3"."t_DA_S20_Preis_bereinigt", "t_da_sammeln_3"."t_DA_S20_ANG_Name", "t_da_sammeln_3"."t_DA_S20_sk_titel"

FROM t_da_sammeln_1
left join t_da_sammeln_2 on ("t_da_sammeln_1"."StabiloNr" = "t_da_sammeln_2"."StabiloNr")
left join t_da_sammeln_3 on ("t_da_sammeln_1"."StabiloNr" = "t_da_sammeln_3"."StabiloNr");


END$$

DELIMITER ;