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 ) ) 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] => ) ) #######
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 - 717 cache hits / 788