Hello everyone and thank you in advance,

This is been driving me crazy, in running the following query, I get the error 1064, below please find the full query and the error message.
There must be errors everywhere becuase I tried removing one line at a time to pinpoint the error, and the error comes up the same on the lines I did not remove.

Note: the syntax error is in the:
Tabellenstruktu r für Tabelle...