Programm am Freitag, 18. Mai 2012

Die Referentenliste mit Abstracts der Beiträge finden Sie hier.

09:00
bis
09:30

Kongresseröffnung: Dr. Jürgen Smettan
Grußworte: Frau Sabine Siegl (WIPs & BDP), Prof. Dr. Herbert Fitzek (BSP), Prof. Dr. Bruno Klauk, Hochschule Harz (FH)

09:30
bis
10:15

Prof. Dr. Rüdiger Reinhardt, SRH Hochschulen Riedlingen:
„Masterstudium in der Wirtschaftspsychologie: Angebote, Erwartungen und Chancen - eine Marktanalyse”.

10:15
bis
11:00

Erfolg durch Kompetenz: Podiumsdiskussion unter Leitung von Prof. Dr. Gerhard Raab
Teilnehmer: Frau Dr. Eileen Mertens, Frau Sabine Siegl, Herr Prof. Dr. Bruno Klauk,
Herr Prof. Dr. Herbert Fitzek, Herr Prof. Dr. Rüdiger Reinhardt, Herr Prof. Dr. Hans-Willi Schroiff

11:00
-
11:15

Kaffeepause

Block A
Arbeit & Arbeitsschutz
Block B
Personal & Führung
Block C
Coaching & Konfliktlösung
Block D
Organisations- entwicklung
Block E
Personal & Eignung
Block F
Ökonomische Psychologie, Geld und Märkte
11:15
-
12:00
Zander & de Vries
Wenn der Change krank macht
Respondek, Wolff & Kemter-Hofmann
Konzeptionsempfehlungen für einen Talentpool - Was erwarten (Nachwuchs-) Führungskräfte der Konzernleitung der Deutschen Bahn AG?
Kalendruschat
Business-Coaching und Strategisches Management, passt das zusammen?
Ryschka & Solga
Begleitung eines Stellenabbauprojekts
Quandte & Püschel
Eignungsdiagnostik XXL
Müller
Die finanzielle Risikobereitschaft und Risikokompetenz als Erfolgsfaktor für nachhaltige Unternehmensführung
12:05
-
12:50
Kubowitsch & Kubowitsch
Promoting Mental Health: Präventionsprogramm zu Burnout, Depression und psychosomatischen Beschwerden in Organisationen
von Ketteler & Ryschka
Führungsleitlinien bei Mercure entwickeln und etablieren
Wilm
Unternehmenscoaching - Ein ganzheitlich(er) psychologischer Ansatz für kleine und mittlere Organisationen
Geißler
Mit Virtuellem Coaching neue Marktsegmente erschließen
Dogge & Klug
Die ISO-Norm 10667 - der neue internationale Maßstab für die Beurteilung von Menschen in beruflichen Situationen
Walbrühl
Schuldnerberatung in Ghana - Implementierung eines Angebots bei öffentlichen Arbeitgebern
12:50
-
14:00

Mittagspause

Block A
Arbeit & Arbeitsschutz
Block B
Personal & Führung
Block C
Coaching & Konfliktlösung
Block D
Org.- & Personal- entwicklung
Block E
Personal & Eignung
Block F
Ökonomische Psychologie, Geld und Märkte
14:00
-
14:45
Bender & Müller
Psychische Gesundheit - Eine Aufgabe von Unternehmen, Führung und Betriebsrat
Dörr & Schmidt-Huber
Mit LEaD® (Leadership Effectiveness and Development) Führungskompetenzen evidenzbasiert und effektiv erfassen
Schreyögg
Coaching von Doppelkarrierepaaren
Dittmann & Stark
Change-Management-Sounding-Board - eine (ohn-)mächtige Methode in Change-Prozessen?
Dreier & Moldzio
Pimp my Personality Inventory Verbesserte Skaleneigenschaften durch kontextbezogene Items und spezifische Facetten
Wienkamp
Sicher und kompetent in Finanzgeschäften Neue Akzente in der Verbraucherberatung von Privatinvestoren
14:50
-
15:35
Flemming, Gründler & Schulz
MABOSS als Einstieg in betriebliches Gesundheitsmanagement
Sagasser & Stief
Führungskräfteentwicklung durch Kompetenzmanagement in mittelständischen Unternehmen - Interviewstudie und Erfahrungsbericht aus der Praxis bei der GEA Diessel
Schreyögg
Doppelkarrieren in der Wissenschaft
Solga & Ryschka
Change Management im Nearshoring: psychologische Verträge gestalten
Rauthmann & Kolar
Machiavellistische Intelligenz: Ein Best Practice Leitfaden zur multidimensionalen Einordnung von machiavellistischen Tendenzen
Müller & Straatmann
Identitätsbasiertes Employer Branding: Die Gestaltung und Modellierung der Arbeitge-bermarke an der Schnittstelle zwischen Markt- und Organisationspsychologie
15:35
-
16:00

Kaffeepause, Postersession

Block A
Arbeit & Arbeitsschutz
Block B
Personal & Führung
Block C
Coaching & Konfliktlösung
Block D
Org.- & Personal- entwicklung
Block E
Personal & Eignung
Block F
Ökonomische Psychologie, Geld und Märkte
16:00
-
16:45
Giesers & Tangen-Petraitis
Werde, der Du bist... Die Überwindung des ""falschen Selbst"" als hilfreiches Konzept zur Burn-out-Behandlung
Furtner & Riedmüller
SuperLeadership: Stufen zur erfolgreichen Selbst-und Mitarbeiterführung in der Organisation des 21. Jahrhunderts
Waibel
Stimme und Stimmpsychologie im Führungskräftecoaching und in der Wirtschaftsmediation Ein stimmiger Monolog
Weissenborn
Profiler in der Personalentwicklung Hintergründe, Anwendungsbeispiele und Erfahrungen mit dem GPOP (Golden Profiler of Personality)
Ringelband
Validität und Best-Practice des Einzel-Assessments
Müller & Straatmann
Ökonomische Psychologie für alle Marktteilnehmer: Transformative Konsumentenforschung am Beispiel des Präventionsprogrammes für Jugendüberschuldung ""Start Frei!
16:50
-
17:35
Bender
Tandemgespräche - Prozessberatung bei der AOK Rheinland/Hamburg in der Regionaldirektion Köln
Giesers & Tangen-Petraitis
Das Führungs-Hexagon - die sechs paradoxen Wirkfaktoren der Führungspsychologie
Dehner
Psychologische Spiele im Büro
Prinz & Voigt
Nachhaltige Business Transformation: Psychologisches Knowhow statt Prozessoptimierungen - ein neuer Markt für wirtschaftspsychologische Dienstleistungen
Sauer & Jandeisek
Personalauswahl im Wandel globaler Vernetzung Untertitel: Management-Audits als interkultureller Brückenschlag zwischen West- und Osteuropa
Marten
Das a-k-g-Syndrom und seine Überwindung
17:00
-
18:00

Mitgliederversammlung des WiPs (Verband zur Förderung der Wirtschaftspsychologie)

18:00
-
19:30

Mitgliederversammlung der Sektion Wirtschaftspsychologie

20:00
-
24:00

Abendveranstaltung – Tanz und Buffet mit DJ Städler





---------------
INSERT()
INSERT INTO tracking (ip, referer, sessionid, date, page, schritt, query, agent) VALUES ('', '', 'e7c322fc063a40c8e80e2398046c2ab8', '2016-05-27 14:09:13', 'freitag', '1', '', '')

id: 262098

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=0
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 7

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=1
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=5
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=2
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 2

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=34
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=35
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=8
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=4
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=28
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
bereiche

   SELECT bereiche.label, bereiche.id,bereiche.parentid, bereiche_detl.headline, bereiche_detl.id AS detlid
     FROM bereiche
LEFT JOIN bereiche_detl
       ON (bereiche.id=bereiche_detl.bereichid )
    WHERE parentid=33
      AND bereiche_detl.lang='de'
 ORDER BY sortid
Zeilen: 0

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='11:15:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=25
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=40
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=16
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=11
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=70
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=19
Zeilen: 1

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='12:05:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=10
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=23
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=55
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=69
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=26
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=63
Zeilen: 1

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='14:00:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=21
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=27
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=2
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=17
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=8
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=54
Zeilen: 1

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='14:50:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=28
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=43
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=68
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=44
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=39
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=13
Zeilen: 1

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='16:00:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=5
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=29
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=60
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=52
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=41
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=14
Zeilen: 1

---------------
Programm

   SELECT referate.id, blockid, startzeit, endzeit
     FROM block
LEFT JOIN referate
       ON referate.blockid = block.id
      AND datum='2012-05-18'
      AND startzeit='16:50:00'
    WHERE block.id>=1
      AND block.id<=6
 ORDER BY block.id, startzeit
Zeilen: 6

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=22
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=6
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=62
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=38
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=12
Zeilen: 1

---------------
Namensliste

   SELECT referenten.name AS referent, referentid, thema1 AS thema, coid1, coid2, coid3, coid4, co1.name AS coname1, co2.name AS coname2, co3.name AS coname3, co4.name AS coname4
     FROM referate
LEFT JOIN referenten
       ON referate.referentid=referenten.id
LEFT JOIN referenten AS co1
       ON referate.coid1=co1.id
LEFT JOIN referenten AS co2
       ON referate.coid2=co2.id
LEFT JOIN referenten AS co3
       ON referate.coid3=co3.id
LEFT JOIN referenten AS co4
       ON referate.coid4=co4.id
    WHERE referate.id=32
Zeilen: 1

lang: de

bereichAr

kongresseinladung

id: 1

detlid: 2

parentid: 0

headline: Kongresseinladung

veranstalter

id: 5

detlid: 9

parentid: 0

headline: Veranstalter

programm

id: 2

detlid: 3

parentid: 0

headline: Programm

sub

freitag

id: 34

detlid: 35

parentid: 2

headline: Freitag

samstag

id: 35

detlid: 36

parentid: 2

headline: Samstag

referenten

id: 8

detlid: 7

parentid: 0

headline: Referenten

veranstaltungsort

id: 4

detlid: 8

parentid: 0

headline: Tagungshotel

ansprechpartner

id: 28

detlid: 30

parentid: 0

headline: Ansprechpartner

impressum

id: 33

detlid: 34

parentid: 0

headline: Impressum