SELECT
								wp_116_posts.*
							FROM
								wp_116_posts
							INNER JOIN
								wp_116_postmeta ON (wp_116_posts.ID = wp_116_postmeta.post_id)
							WHERE
									wp_116_posts.post_type = 'attachment'
								AND
									((wp_116_posts.post_status = 'inherit'))
								AND
									((wp_116_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_116_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_116_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 18
            [post_author] => 1
            [post_date] => 2016-10-19 14:54:19
            [post_date_gmt] => 2016-10-19 12:54:19
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
            [post_title] => 01DSCF5156.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 01dscf5156-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:54:19
            [post_modified_gmt] => 2016-10-19 12:54:19
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 19
            [post_author] => 1
            [post_date] => 2016-10-19 14:54:29
            [post_date_gmt] => 2016-10-19 12:54:29
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
            [post_title] => 02DSC_0018.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 02dsc_0018-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:54:29
            [post_modified_gmt] => 2016-10-19 12:54:29
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 20
            [post_author] => 1
            [post_date] => 2016-10-19 14:54:38
            [post_date_gmt] => 2016-10-19 12:54:38
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
            [post_title] => 03DSC_0011.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 03dsc_0011-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:54:38
            [post_modified_gmt] => 2016-10-19 12:54:38
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 21
            [post_author] => 1
            [post_date] => 2016-10-19 14:54:45
            [post_date_gmt] => 2016-10-19 12:54:45
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
            [post_title] => DSC_0021.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => dsc_0021-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:54:45
            [post_modified_gmt] => 2016-10-19 12:54:45
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 22
            [post_author] => 1
            [post_date] => 2016-10-19 14:54:57
            [post_date_gmt] => 2016-10-19 12:54:57
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
            [post_title] => DSCF5140.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => dscf5140-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:54:57
            [post_modified_gmt] => 2016-10-19 12:54:57
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 23
            [post_author] => 1
            [post_date] => 2016-10-19 14:55:06
            [post_date_gmt] => 2016-10-19 12:55:06
            [post_content] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
            [post_title] => DSCF5155.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => dscf5155-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2016-10-19 14:55:06
            [post_modified_gmt] => 2016-10-19 12:55:06
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [18] => Array
        (
            [attachment_id] => 18
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/01DSCF5156.jpg
            [alt_text] => 
        )

    [19] => Array
        (
            [attachment_id] => 19
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/02DSC_0018.jpg
            [alt_text] => 
        )

    [20] => Array
        (
            [attachment_id] => 20
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/03DSC_0011.jpg
            [alt_text] => 
        )

    [21] => Array
        (
            [attachment_id] => 21
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSC_0021.jpg
            [alt_text] => 
        )

    [22] => Array
        (
            [attachment_id] => 22
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5140.jpg
            [alt_text] => 
        )

    [23] => Array
        (
            [attachment_id] => 23
            [url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
            [thumbnail_url] => https://infax.org/zilleoberkassel/wp-content/uploads/sites/116/2016/10/DSCF5155.jpg
            [alt_text] => 
        )

)
#######

Willkommen in der Zille Oberkassel!

Düsseldorf vertraut – Oberkassel verbunden

Das Kult-Lokal in Oberkassel begrüßt Sie in modernem, stilvollem
Ambiente mit viel Liebe zum Detail. Freuen Sie sich auf die Mischung
aus Restaurant – Bar – Lounge, die zu jeder Tages- und Abendzeit das
Richtige für Ihr Wohlbefinden bietet.

Genießen Sie die zahlreichen internationalen Gerichte, ausgefallene saisonale Kreationen,
sowie die Angebote der wechselnden Mittags- und Wochenkarte. Die Vielfalt und Kreativität
der Speisekarte hält für jeden Geschmack etwas bereit.

Eine Auswahl an ausgesuchten Weinen und diversen Spirituosen rundet das Angebot ab.
Für die Genießer von Altbier zapfen wir frisches Alt der Privatbrauerei Bolten vom Fass.

Für alle Frühstücks-Liebhaber bieten wir eine reichhaltige Frühstücksauswahl mit allem
was dazugehört. Für Langschläfer gilt die Frühstückskarte am Wochenende bis 16.00 Uhr!
An jedem Wochenende genießen Sie bei uns verschiedene frische Kuchen.

Für Konferenzen, Meetings, kleinere Gesellschaften stellen wir einen separaten Raum für bis
zu 25 Personen zu Verfügung. Für größere Veranstaltungen bieten wir unser komplettes Lokal
für bis zu 125 Personen zur Anmietung an.

Sprechen Sie uns einfach an – wir beraten Sie gerne über die
Möglichkeiten wie sich Ihre Gäste bei uns wohl fühlen können.

Wir freuen uns auf Sie!

Ihr Zille Team

Schreibe einen Kommentar Antworten abbrechen

Du musst angemeldet sein, um einen Kommentar abzugeben.

ZILLE OBERKASSEL · Luegallee 1 · 40545 Düsseldorf · Telefon 0211 – 5578219 · E-Mail: info@zilleoberkassel.de

Öffnungszeiten

• Montag bis Donnerstag
• 09.00 - 01.00 Uhr
• Freitag und Samstag
• 09.00 - 03.00 Uhr
• Sonntag und Feiertage
• 09.00 - 01.00 Uhr