SELECT wp_72_posts.* FROM wp_72_posts INNER JOIN wp_72_postmeta ON (wp_72_posts.ID = wp_72_postmeta.post_id) WHERE wp_72_posts.post_type = 'attachment' AND ((wp_72_posts.post_status = 'inherit')) AND ((wp_72_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_72_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap')) GROUP BY wp_72_posts.ID Array ( [0] => stdClass Object ( [ID] => 84 [post_author] => 1 [post_date] => 2018-04-27 14:17:55 [post_date_gmt] => 2018-04-27 12:17:55 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg [post_title] => DSCF7703.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => dscf7703-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:17:55 [post_modified_gmt] => 2018-04-27 12:17:55 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [1] => stdClass Object ( [ID] => 85 [post_author] => 1 [post_date] => 2018-04-27 14:22:41 [post_date_gmt] => 2018-04-27 12:22:41 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg [post_title] => 02_2221.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 02_2221-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:22:41 [post_modified_gmt] => 2018-04-27 12:22:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [2] => stdClass Object ( [ID] => 86 [post_author] => 1 [post_date] => 2018-04-27 14:22:50 [post_date_gmt] => 2018-04-27 12:22:50 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg [post_title] => 03_2018-04-18-PHOTO-00000003.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 03_2018-04-18-photo-00000003-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:22:50 [post_modified_gmt] => 2018-04-27 12:22:50 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [3] => stdClass Object ( [ID] => 87 [post_author] => 1 [post_date] => 2018-04-27 14:23:01 [post_date_gmt] => 2018-04-27 12:23:01 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg [post_title] => 04_sli05.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 04_sli05-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:01 [post_modified_gmt] => 2018-04-27 12:23:01 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [4] => stdClass Object ( [ID] => 88 [post_author] => 1 [post_date] => 2018-04-27 14:23:11 [post_date_gmt] => 2018-04-27 12:23:11 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg [post_title] => 05_2018-04-18_004.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 05_2018-04-18_004-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:11 [post_modified_gmt] => 2018-04-27 12:23:11 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [5] => stdClass Object ( [ID] => 89 [post_author] => 1 [post_date] => 2018-04-27 14:23:23 [post_date_gmt] => 2018-04-27 12:23:23 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg [post_title] => 06_DSCF7708.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 06_dscf7708-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:23 [post_modified_gmt] => 2018-04-27 12:23:23 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [6] => stdClass Object ( [ID] => 90 [post_author] => 1 [post_date] => 2018-04-27 14:23:36 [post_date_gmt] => 2018-04-27 12:23:36 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg [post_title] => 07_2018-04-18-0005.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 07_2018-04-18-0005-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:36 [post_modified_gmt] => 2018-04-27 12:23:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [7] => stdClass Object ( [ID] => 91 [post_author] => 1 [post_date] => 2018-04-27 14:23:48 [post_date_gmt] => 2018-04-27 12:23:48 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg [post_title] => 08_DSCF7706.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 08_dscf7706-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:48 [post_modified_gmt] => 2018-04-27 12:23:48 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [8] => stdClass Object ( [ID] => 92 [post_author] => 1 [post_date] => 2018-04-27 14:23:59 [post_date_gmt] => 2018-04-27 12:23:59 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg [post_title] => 09_2018-04-18-07.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 09_2018-04-18-07-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:23:59 [post_modified_gmt] => 2018-04-27 12:23:59 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [9] => stdClass Object ( [ID] => 93 [post_author] => 1 [post_date] => 2018-04-27 14:24:13 [post_date_gmt] => 2018-04-27 12:24:13 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg [post_title] => 10_sli09.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 10_sli09-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:24:13 [post_modified_gmt] => 2018-04-27 12:24:13 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [10] => stdClass Object ( [ID] => 94 [post_author] => 1 [post_date] => 2018-04-27 14:24:22 [post_date_gmt] => 2018-04-27 12:24:22 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg [post_title] => 11_2018-04-18-009.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 11_2018-04-18-009-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-27 14:24:22 [post_modified_gmt] => 2018-04-27 12:24:22 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [11] => stdClass Object ( [ID] => 101 [post_author] => 1 [post_date] => 2018-04-30 12:55:01 [post_date_gmt] => 2018-04-30 10:55:01 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160303_205045.jpg [post_title] => 20160303_205045.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 20160303_205045-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-30 12:55:01 [post_modified_gmt] => 2018-04-30 10:55:01 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160303_205045.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [12] => stdClass Object ( [ID] => 102 [post_author] => 1 [post_date] => 2018-04-30 12:55:16 [post_date_gmt] => 2018-04-30 10:55:16 [post_content] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160115_132117.jpg [post_title] => 20160115_132117.jpg [post_excerpt] => [post_status] => inherit [comment_status] => closed [ping_status] => open [post_password] => [post_name] => 20160115_132117-jpg [to_ping] => [pinged] => [post_modified] => 2018-04-30 12:55:16 [post_modified_gmt] => 2018-04-30 10:55:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160115_132117.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) ) Array ( [84] => Array ( [attachment_id] => 84 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/DSCF7703.jpg [alt_text] => ) [85] => Array ( [attachment_id] => 85 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/02_2221.jpg [alt_text] => ) [86] => Array ( [attachment_id] => 86 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/03_2018-04-18-PHOTO-00000003.jpg [alt_text] => ) [87] => Array ( [attachment_id] => 87 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/04_sli05.jpg [alt_text] => ) [88] => Array ( [attachment_id] => 88 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/05_2018-04-18_004.jpg [alt_text] => ) [89] => Array ( [attachment_id] => 89 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/06_DSCF7708.jpg [alt_text] => ) [90] => Array ( [attachment_id] => 90 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/07_2018-04-18-0005.jpg [alt_text] => ) [91] => Array ( [attachment_id] => 91 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/08_DSCF7706.jpg [alt_text] => ) [92] => Array ( [attachment_id] => 92 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/09_2018-04-18-07.jpg [alt_text] => ) [93] => Array ( [attachment_id] => 93 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/10_sli09.jpg [alt_text] => ) [94] => Array ( [attachment_id] => 94 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/11_2018-04-18-009.jpg [alt_text] => ) [101] => Array ( [attachment_id] => 101 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160303_205045.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160303_205045.jpg [alt_text] => ) [102] => Array ( [attachment_id] => 102 [url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160115_132117.jpg [thumbnail_url] => https://infax.org/haus-heidgen-lev/wp-content/uploads/sites/72/2018/04/20160115_132117.jpg [alt_text] => ) ) #######
Ein Kölsch unter Freunden oder ein genussvolles Essen – hier kocht der Chef noch selbst und verwöhnt Sie mit internationalen Spezialitäten und leckeren Gerichten vom Grill.Freuen Sie sich auf eine unkomplizierte Atmosphäre und den freundlichen Service. Wählen Sie aus verschiedenen Vorspeisen, Salaten und frischen Fleisch & Fischgerichten, die wir sorgfältig für Sie zubereiten.
Dazu passend bieten wir Ihnen eine Auswahl an Weinen, sowie zahlreiche weitere Erfrischungs- oder Heißgetränke an.
Für private oder geschäftliche Veranstaltungen bieten wir Ihnen Platz für bis zu 50 Personen. Lassen Sie sich durch unsere Menüvorschläge inspirieren und unverbindlich beraten, mit welchen leckeren Gerichten Sie Ihre Gäste bei uns verwöhnen können. Gerne verleihen wir Ihrer Feier einen festlichen Rahmen und kümmern uns auf Wunsch um die Dekoration. Wir freuen uns auf Ihre Anfrage – sprechen Sie uns einfach an.
Während der Sommermonate genießen Sie die warmen Tage auf unserer Aussenterrasse unter freiem Himmel.
Parkplätze finden Sie vor dem Haus.
Wir freuen uns auf Ihren Besuch!
Ihr Team von Haus Heidgen
Load: 18 queries - 0ms - 4.0MB - 145 cache hits / 177 Query: 21 queries - 0ms - 4.2MB - 177 cache hits / 211 Display: 41 queries - 0ms - 4.9MB - 741 cache hits / 814