Startseite >> Termine >> Salsa Workshops Liste

Funktionen

Salsa Workshops in Köln

Hier findest Du unsere Salsa und Lindy Hop (all you can dance!) Workshops, die kompakt an
einem Wochenende oder jährlich z.B. an Pfingsten, 27.-30. Dezember in Köln stattfinden.

Level Anfänger = ohne Vorkenntnisse und 1. Lernjahr, Anfänger-Aufbau-Level: 2. - 4. Lernjahr
Level Mittelstufe: ab dem 5. Lernjahr, Level Fortgeschrittene: ab dem 10. Lernjahr

Zu den Tanzkursen









Salsa Puertorican Style - Basisprogramm

Datum Uhrzeit Titel Wochentag Dauer Details  
27.12.2017 18:00 - 21:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Mittwoch 4x3 Stunden Details
05.11.2018 20:00 - 21:00 Uhr 100% Anfänger ohne Vorkenntnisse Montag 8 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
18.05.2018 15:00 - 18:00 Uhr 100% Salsa Anfänger ohne Vorkenntnisse Freitag 4x3 Stunden Details
30.05.2018 19:00 - 22:00 Uhr lerne Salsa in 15 Stunden Mittwoch 15 Stunden Details
 
Array ( [Basisprogramm] => Array ( [0] => Array ( [id] => 44 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style Intensiv-Workshop für Anfänger ohne Vorkenntnisse: Grundlagentraining über 4 Tage: 27. + 28. + 29. + 30. Dezember 2016 - 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 ) [1] => Array ( [id] => 130 [title] => 100% Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style Kurs für Anfänger ohne Vorkenntnisse [price] => 120,00 € [date] => 05.11.2018 [time] => 20:00 - 21:00 [day] => Montag [days] => 8 Abende [location] => Südstadt ) ) [Intensiv] => Array ( [0] => Array ( [id] => 46 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => 100% Salsa Puertorican Style - Intensiv-Workshop 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 ) [1] => Array ( [id] => 76 [title] => Lerne Salsa in 12 Stunden [text] => 100% Salsa Puertorican Style Workshop für Anfänger ohne Vorkenntnisse - 19:00 - 22:00 Uhr - Dich erwarten täglich 3 Stunden purer Sport und Gehirnjogging. 10. + 11. + 12. + 13. Mai 2018 viertägig [price] => 180,00 € [date] => 10.05.2018 [time] => 19:00 - 22:00 [day] => Donnerstag [days] => 12 Stunden [location] => Barbarossaplatz, Südstadt ) [2] => Array ( [id] => 153 [title] => 100% Salsa Anfänger ohne Vorkenntnisse [text] => Pfingst-Special: 100% Salsa Puertorican Style Workshop für Anfänger ohne Vorkenntnisse - 18. Mai 2018: 19-22 Uhr und 19. + 20. + 21. Mai: 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 ) [3] => Array ( [id] => 141 [title] => lerne Salsa in 15 Stunden [text] => 100% Salsa Puertorican Style Workshop für Anfänger ohne Vorkenntnisse - 30. Mai bis 3. Juni 5-tägig. Täglich 3 Stunden 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] => 15 Stunden [location] => Südstadt ) ) )
Array
(
    [0] => Array
        (
            [0] => SELECT * FROM tl_page WHERE (id=0 OR alias='salsa-workshops-liste') AND (start='' OR start<1508232878) AND (stop='' OR stop>1508232878) 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='44' 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<1508232878) AND (stop='' OR stop>1508232878) 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<1508232878) AND (stop='' OR stop>1508232878) 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<1508232878) AND (stop='' OR stop>1508232878) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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<1508232879) AND (p2.stop='' OR p2.stop>1508232879) 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<1508232879) AND (p1.stop='' OR p1.stop>1508232879) 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='44' 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='44' AND inColumn='main' AND (start='' OR start<1508232879) AND (stop='' OR stop>1508232879) 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='48' OR alias='48') AND pid='44' 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='48' 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='41' 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='42' 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='43' 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='15' 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='Workshop' AND disable!='1' AND style='Salsa Puertorican Style'  ORDER BY startDate
            [1] => 6 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='16' OR alias='16' 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-workshops-liste/diff/0.html' AND pid='44' 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] => 2
                    [filtered] => 2.50
                    [Extra] => Using where
                )

        )

)