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
Diese Website verwendet Cookies – nähere Informationen dazu und zu Ihren Rechten als Benutzer finden Sie in unserer Datenschutzerklärung. Klicken Sie auf „Ich stimme zu“, um Cookies zu akzeptieren und direkt unsere Website besuchen zu können.OK, ich stimme zu.Nein
Load: 15 queries - 0ms - 5.8MB - 53 cache hits / 118
Query: 18 queries - 0ms - 5.9MB - 68 cache hits / 150
Display: 40 queries - 0ms - 6.9MB - 588 cache hits / 750
Schreibe einen Kommentar
Du musst angemeldet sein, um einen Kommentar abzugeben.