SELECT
								wp_154_posts.*
							FROM
								wp_154_posts
							INNER JOIN
								wp_154_postmeta ON (wp_154_posts.ID = wp_154_postmeta.post_id)
							WHERE
									wp_154_posts.post_type = 'attachment'
								AND
									((wp_154_posts.post_status = 'inherit'))
								AND
									((wp_154_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_154_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_154_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 80
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:28
            [post_date_gmt] => 2019-06-06 15:31:28
            [post_content] => 
            [post_title] => 01_DSCF8669
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 01_dscf8669
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:28
            [post_modified_gmt] => 2019-06-06 15:31:28
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/01_DSCF8669.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 81
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:32
            [post_date_gmt] => 2019-06-06 15:31:32
            [post_content] => 
            [post_title] => 02_DSCF8663
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 02_dscf8663
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:32
            [post_modified_gmt] => 2019-06-06 15:31:32
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/02_DSCF8663.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 82
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:35
            [post_date_gmt] => 2019-06-06 15:31:35
            [post_content] => 
            [post_title] => 03_DSCF8661
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 03_dscf8661
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:35
            [post_modified_gmt] => 2019-06-06 15:31:35
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/03_DSCF8661.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 83
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:39
            [post_date_gmt] => 2019-06-06 15:31:39
            [post_content] => 
            [post_title] => 04_DSCF8671
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 04_dscf8671
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:39
            [post_modified_gmt] => 2019-06-06 15:31:39
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/04_DSCF8671.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 84
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:43
            [post_date_gmt] => 2019-06-06 15:31:43
            [post_content] => 
            [post_title] => 05_DSCF8673
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 05_dscf8673
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:43
            [post_modified_gmt] => 2019-06-06 15:31:43
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/05_DSCF8673.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 85
            [post_author] => 1
            [post_date] => 2019-06-06 17:31:47
            [post_date_gmt] => 2019-06-06 15:31:47
            [post_content] => 
            [post_title] => 06_DSCF8664
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => closed
            [post_password] => 
            [post_name] => 06_dscf8664
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2019-06-06 17:31:47
            [post_modified_gmt] => 2019-06-06 15:31:47
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/06_DSCF8664.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [80] => Array
        (
            [attachment_id] => 80
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/01_DSCF8669.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/01_DSCF8669.jpg
            [alt_text] => 
        )

    [81] => Array
        (
            [attachment_id] => 81
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/02_DSCF8663.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/02_DSCF8663.jpg
            [alt_text] => 
        )

    [82] => Array
        (
            [attachment_id] => 82
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/03_DSCF8661.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/03_DSCF8661.jpg
            [alt_text] => 
        )

    [83] => Array
        (
            [attachment_id] => 83
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/04_DSCF8671.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/04_DSCF8671.jpg
            [alt_text] => 
        )

    [84] => Array
        (
            [attachment_id] => 84
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/05_DSCF8673.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/05_DSCF8673.jpg
            [alt_text] => 
        )

    [85] => Array
        (
            [attachment_id] => 85
            [url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/06_DSCF8664.jpg
            [thumbnail_url] => https://infax.org/iguana-stommeln/wp-content/uploads/sites/154/2019/06/06_DSCF8664.jpg
            [alt_text] => 
        )

)
#######

Herzlich Willkommen im Iguana – BBQ Restaurant & Cocktailbar!

Freuen Sie sich auf das unkomplizierte, typisch mexikanische Ambiente und das Gefühl von südländischer Lebensfreude im Iguana in Pulheim-Stommeln. Hier erwartet Sie eine große Auswahl an leckeren mexikanisch-amerikanischen Spezialitäten und tollen Cocktails in lockerer Atmosphäre.

Genießen Sie unsere Vielfalt an mexikanischen Snacks für den kleinen Hunger, köstlliche Nachos, Quesadillas, American Burger & BBQ Gerichte aus frischen Zutaten. Wählen Sie Ihren Favoriten aus der umfangreichen Speisekarte und lassen Sie sich von unserem freundlichen Personal verwöhnen.

Auf unserer Getränkekarte finden Sie zahlreiche erfrischende Cocktailspezialitäten & Longdrinks oder probieren Sie eines unserer mexikanischen Biere, sowie Tequila und andere Shots. Gerne servieren wir Ihnen auch leckere alkoholfreie Cocktails, Softdrinks oder Heißgetränke.

In der warmen Jahreszeit lädt unser schöner Biergarten zum Genuss unter freiem Himmel ein.

Für Veranstaltungen aller Art bieten wir Ihnen einen separaten Raum inklusive Theke für bis zu 40 Personen an. Gerne beraten wir Sie über die verschiedenen Möglichkeiten wie Ihr Event für Sie & Ihre Gäste ein unvergessliches Erlebnis bleibt – sprechen Sie uns einfach an.

Wir freuen uns auf Sie!
Ihr Iguana-Team

 

 
RESERVIERUNGEN BITTE NUR TELEFONISCH
ODER ÜBER FACEBOOK UND INSTAGRAM

Schreibe einen Kommentar Antworten abbrechen

Du musst angemeldet sein, um einen Kommentar abzugeben.

IGUANA BBQ & COCKTAILBAR · Venloer Str. 579 · 50259 Pulheim - Stommeln · Telefon:02238 - 300360 · E-Mail: info@iguana-stommeln.de

Öffnungszeiten

• DI - DO & SO
• 17:00 - 23:00 Uhr
• FR & SA
• 17:00 Uhr – Open End
• Küche 18:00 - 22:00 Uhr
• Montag Ruhetag