Startseite >> Termine >> Salsa Tanzkurse Liste

Funktionen

Salsa Tanzkurse in Köln

Hier findest Du unsere Salsa Tanzkurse sowie Lindy Hop (all you can dance) und Swing Termine. Sortiert nach
Basisprogramm (8 - 15 Abende), Aufbau-Level, Schnupperkurse (max. 7 Abende), Intensiv (z.B. 3x3 Stunden)

Zu den Workshops









Salsa Puertorican Style - Basisprogramm

Datum Uhrzeit Titel Wochentag Dauer Details  
13.11.2017 20:00 - 22:00 Uhr Lerne Salsa in 10 Stunden Montag 5 Abende Details
27.12.2017 18:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Mittwoch 4x3 Stunden Details
02.01.2018 20:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Dienstag 12 Abende Details
02.01.2018 19:00 - 20:00 Uhr 100% Anfänger mit Vorkenntnissen Dienstag 16 Abende Details
08.01.2018 20:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Montag 12 Stunden Details
08.01.2018 19:00 - 20:00 Uhr Folgekurs zum Weihnachtsspecial Montag 15 Abende Details
18.05.2018 15:00 - 18:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Freitag 4x3 Stunden Details
04.08.2018 19:00 - 22:00 Uhr 5-Tage-Tanzen Anfängerkurs Samstag 5x3 Stunden Details
03.09.2018 20:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Montag 8 Abende Details
 

Salsa Puertorican Style - Aufbau-Level

Datum Uhrzeit Titel Wochentag Dauer Details  
02.01.2018 19:00 - 20:00 Uhr 100% Salsa Aufbaukurs: Easy Moves Dienstag 16 Abende Details
08.05.2018 19:00 - 20:00 Uhr 100% Salsa Aufbaukurs: Hot Moves Dienstag 10 Abende Details
04.09.2018 19:00 - 20:00 Uhr 100% Salsa Aufbaukurs: Cool Moves Dienstag 16 Abende Details
 

Salsa Puertorican Style - Intensiv

Datum Uhrzeit Titel Wochentag Dauer Details  
27.12.2017 18:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Mittwoch 4x3 Stunden Details
10.05.2018 19:00 - 22:00 Uhr Lerne Salsa in 12 Stunden Donnerstag 12 Stunden Details
30.05.2018 19:00 - 22:00 Uhr lerne Salsa in 15 Stunden Mittwoch 5x3 Stunden Details
 
Array ( [Basisprogramm] => Array ( [0] => Array ( [id] => 208 [title] => Lerne Salsa in 10 Stunden [text] => 100% Salsa Puertorican Style Kurs für Anfänger ohne Vorkenntnisse - es gibt noch freie Plätze für 2 Solo-Männer und 2 Paare. [price] => 150,00 € [date] => 13.11.2017 [time] => 20:00 - 22:00 [day] => Montag [days] => 5 Abende [location] => Südstadt ) [1] => Array ( [id] => 171 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style Intensivkurs für Anfänger ohne Vorkenntnisse: zwischen den Tagen 27. + 28. + 29. + 30. Dezember 2017 - Dich erwarten täglich 3 Stunden purer Sport und Gehirnjogging. [price] => 180,00 € [date] => 27.12.2017 [time] => 18:00 - 21:00 [day] => Mittwoch [days] => 4x3 Stunden [location] => Südstadt ) [2] => Array ( [id] => 51 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style für Anfänger ohne Vorkenntnisse- unterrichtsfrei: 13.02.18/Karneval [price] => 180,00 € [date] => 02.01.2018 [time] => 20:00 - 21:00 [day] => Dienstag [days] => 12 Abende [location] => Südstadt ) [3] => Array ( [id] => 101 [title] => 100% Anfänger mit Vorkenntnissen [text] => Folgekurs zu Dienstag 19 Uhr in 2017. Unterrichtsfrei: 12.02.18/Karneval [price] => 240,00 € [date] => 02.01.2018 [time] => 19:00 - 20:00 [day] => Dienstag [days] => 16 Abende [location] => Südstadt ) [4] => Array ( [id] => 57 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style Kurs für Anfänger ohne Vorkenntnisse - unterrichtsfrei: 12.02.18/Rosenmontag und 02.04.18/Ostermontag [price] => 180,00 € [date] => 08.01.2018 [time] => 20:00 - 21:00 [day] => Montag [days] => 12 Stunden [location] => Südstadt ) [5] => Array ( [id] => 168 [title] => Folgekurs zum Weihnachtsspecial [text] => 100% Salsa Puertorican Style Kurs für Anfänger mit Vorkenntnissen - Anmeldeschluss ist der 2. Januar 2018 (Anmeldung über die Homepage und Zahlungseingang). Unterrichtsfrei: 12.02.18/Rosenmontag und 2. April 2018/Ostermontag [price] => 225,00 € [date] => 08.01.2018 [time] => 19:00 - 20:00 [day] => Montag [days] => 15 Abende [location] => Südstadt ) [6] => Array ( [id] => 74 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => Pfingst-Special: 100% Salsa Puertorican Style Intensivkurs für Anfänger ohne Vorkenntnisse - 18. Mai 2018: 19-22 Uhr und 19.+ 20. + 21. Mai 2018: 15-18 Uhr - Dich erwarten 3 Stunden täglich purer Sport und Gehirnjogging! [price] => 180,00 € [date] => 18.05.2018 [time] => 15:00 - 18:00 [day] => Freitag [days] => 4x3 Stunden [location] => Südstadt ) [7] => Array ( [id] => 58 [title] => 5-Tage-Tanzen Anfängerkurs [text] => Anfänger ohne Vorkenntnisse. 5 Tage tanzen tanzen tanzen vom 4.-8. August 2018 täglich! Ein kompletter Anfängerkurs für die Salsa Puertorican Style. Wir starten aber auch mit Bachata und Merengue, den beiden Salsatänzen aus der Dom. Rep., die auf jeder Latino Party der wichtigste Bestandteil sind. ¡Caliente! [price] => 225,00 € [date] => 04.08.2018 [time] => 19:00 - 22:00 [day] => Samstag [days] => 5x3 Stunden [location] => Südstadt ) [8] => Array ( [id] => 96 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100 % Salsa Puertorican Style für Anfänger ohne Vorkenntnisse [price] => 120,00 € [date] => 03.09.2018 [time] => 20:00 - 21:00 [day] => Montag [days] => 8 Abende [location] => Südstadt ) ) [Aufbau-Level] => Array ( [0] => Array ( [id] => 88 [title] => 100% Salsa Aufbaukurs: Easy Moves [text] => Easy Moves: Salsa Puertorican Style Aufbaukurs für die Dienstagsteilnehmer aus 2017 - unterrichtsfrei: 13. Februar/Karneval
[price] => 240,00 € [date] => 02.01.2018 [time] => 19:00 - 20:00 [day] => Dienstag [days] => 16 Abende [location] => Südstadt ) [1] => Array ( [id] => 140 [title] => 100% Salsa Aufbaukurs: Hot Moves [text] => 100% Salsa Puertorican Style Aufbaukurs - Folgekurs zu den easy moves im Januar [price] => 150,00 € [date] => 08.05.2018 [time] => 19:00 - 20:00 [day] => Dienstag [days] => 10 Abende [location] => Südstadt ) [2] => Array ( [id] => 103 [title] => 100% Salsa Aufbaukurs: Cool Moves [text] => 100% Salsa Puertorican Style Aufbaukurs - Folgekurs zum Hot Moves Sommerkurs [price] => 240,00 € [date] => 04.09.2018 [time] => 19:00 - 20:00 [day] => Dienstag [days] => 16 Abende [location] => Südstadt ) ) [Intensiv] => Array ( [0] => Array ( [id] => 172 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style für Anfänger ohne Vorkenntnisse - Intensivkurs zwischen den Tagen: 27. + 28. + 29. + 30. Dezember 2017. Dich erwarten täglich 3 Stunden purer Sport und Gehirnjogging. [price] => 180,- € [date] => 27.12.2017 [time] => 18:00 - 21:00 [day] => Mittwoch [days] => 4x3 Stunden [location] => Südstadt ) [1] => Array ( [id] => 11 [title] => Lerne Salsa in 12 Stunden [text] => 100% Salsa Puertorican Style Kurs für Anfänger ohne Vorkenntnisse - 10. - 13. Mai 2018 viertägig - 19:00 - 22:00 Uhr - lerne Salsa in 12 Stunden - Dich erwarten täglich 3 Stunden purer Sport und Gehirnjogging [price] => 180,00 € [date] => 10.05.2018 [time] => 19:00 - 22:00 [day] => Donnerstag [days] => 12 Stunden [location] => Barbarossaplatz, Südstadt ) [2] => Array ( [id] => 128 [title] => lerne Salsa in 15 Stunden [text] => Salsa Puertorican Style Intensivkurs für Anfänger ohne Vorkenntnisse - 20. Mai bis 3. Jui 5-tägig - 3 Stunden täglich purer Sport und Gehirnjogging - wir machen Dich fit für die Tanzfläche [price] => 225,00 € [date] => 30.05.2018 [time] => 19:00 - 22:00 [day] => Mittwoch [days] => 5x3 Stunden [location] => Südstadt ) ) )
Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='salsa-tanzkurse-liste') AND (start='' OR start<1508197785) AND (stop='' OR stop>1508197785) AND published=1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [1] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [2] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='69' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [3] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='1' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [4] => Array
        (
            [0] => SELECT l.*, t.templates FROM tl_layout l LEFT JOIN tl_theme t ON l.pid=t.id WHERE l.id='2' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => l
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [5] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='2' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [6] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='7' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1508197785) AND (stop='' OR stop>1508197785) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [7] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='8' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1508197785) AND (stop='' OR stop>1508197785) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [8] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='9' AND type!='root' AND type!='error_403' AND type!='error_404' AND (start='' OR start<1508197785) AND (stop='' OR stop>1508197785) AND published=1 LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [9] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='50' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [10] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='5' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [11] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='3' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [12] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='1' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [13] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='1' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 8 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 13
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [14] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='69' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 5
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [15] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='11' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [16] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='3' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 9 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 10
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [17] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='17' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [18] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='4' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [19] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='28' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 8 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 14
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [20] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='27' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [21] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='5' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 5 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 6
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [22] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='49' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [23] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='6' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 5.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [24] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='65' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [25] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='14' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 2 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 1.67
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [26] => Array
        (
            [0] => SELECT id, alias FROM tl_page WHERE id='72' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [27] => Array
        (
            [0] => SELECT p1.*, (SELECT COUNT(*) FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide!=1 AND (p2.start='' OR p2.start<1508197785) AND (p2.stop='' OR p2.stop>1508197785) AND p2.published=1) AS subpages FROM tl_page p1 WHERE p1.pid='7' AND p1.type!='root' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide!=1 AND (p1.start='' OR p1.start<1508197785) AND (p1.stop='' OR p1.stop>1508197785) AND p1.published=1 ORDER BY p1.sorting
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => p1
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 5
                    [filtered] => 1.43
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [28] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='6' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [29] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [30] => Array
        (
            [0] => SELECT id FROM tl_article WHERE pid='16' AND inColumn='main' AND (start='' OR start<1508197785) AND (stop='' OR stop>1508197785) AND published=1 ORDER BY sorting
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 5.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [31] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='20' OR alias='20') AND pid='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => PRIMARY,pid,alias
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 10.94
                    [Extra] => Using where
                )

        )

    [32] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='20' AND invisible='' ORDER BY sorting
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 10.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [33] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='24' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [34] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='11' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [35] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='25' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [36] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='34' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [37] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='8' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [38] => Array
        (
            [0] => SELECT * FROM tl_event WHERE type='Tanzkurs' AND disable!='1' AND style='Salsa Puertorican Style'  ORDER BY startDate
            [1] => 15 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_event
                    [partitions] => 
                    [type] => ALL
                    [possible_keys] => 
                    [key] => 
                    [key_len] => 
                    [ref] => 
                    [rows] => 161
                    [filtered] => 0.90
                    [Extra] => Using where; Using filesort
                )

        )

    [39] => Array
        (
            [0] => SELECT * FROM tl_module WHERE id='10' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_module
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [40] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='44' OR alias='44' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [41] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='72' OR alias='72' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [42] => Array
        (
            [0] => SELECT *, author AS authorId, (SELECT name FROM tl_user WHERE id=author) AS author FROM tl_article WHERE (id='14' OR alias='14') LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => PRIMARY
                    [table] => tl_article
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [43] => Array
        (
            [0] => SELECT id FROM tl_content WHERE pid='14' AND invisible='' ORDER BY sorting
            [1] => 3 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid
                    [key] => pid
                    [key_len] => 4
                    [ref] => const
                    [rows] => 3
                    [filtered] => 10.00
                    [Extra] => Using index condition; Using where; Using filesort
                )

        )

    [44] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='5' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [45] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='6' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [46] => Array
        (
            [0] => SELECT * FROM tl_content WHERE id='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_content
                    [partitions] => 
                    [type] => const
                    [possible_keys] => PRIMARY
                    [key] => PRIMARY
                    [key_len] => 4
                    [ref] => const
                    [rows] => 1
                    [filtered] => 100.00
                    [Extra] => 
                )

        )

    [47] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='27' OR alias='27' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [48] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='28' OR alias='28' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [49] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='11' OR alias='11' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [50] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='7' OR alias='7' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [51] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='8' OR alias='8' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [52] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='3' OR alias='3' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [53] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='5' OR alias='5' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [54] => Array
        (
            [0] => SELECT * FROM tl_page WHERE id='6' OR alias='6' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_page
                    [partitions] => 
                    [type] => index_merge
                    [possible_keys] => PRIMARY,alias
                    [key] => PRIMARY,alias
                    [key_len] => 4,130
                    [ref] => 
                    [rows] => 2
                    [filtered] => 100.00
                    [Extra] => Using union(PRIMARY,alias); Using where
                )

        )

    [55] => Array
        (
            [0] => SELECT id, checksum FROM tl_search WHERE url='salsa-tanzkurse-liste/diff/0.html' AND pid='16' LIMIT 0,1
            [1] => 1 rows returned
            [2] => Array
                (
                    [id] => 1
                    [select_type] => SIMPLE
                    [table] => tl_search
                    [partitions] => 
                    [type] => ref
                    [possible_keys] => pid,url
                    [key] => url
                    [key_len] => 767
                    [ref] => const
                    [rows] => 1
                    [filtered] => 5.00
                    [Extra] => Using where
                )

        )

)