SELECT
wp_117_posts.*
FROM
wp_117_posts
INNER JOIN
wp_117_postmeta ON (wp_117_posts.ID = wp_117_postmeta.post_id)
WHERE
wp_117_posts.post_type = 'attachment'
AND
((wp_117_posts.post_status = 'inherit'))
AND
((wp_117_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_117_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
GROUP BY
wp_117_posts.ID
Array
(
[0] => stdClass Object
(
[ID] => 12
[post_author] => 1
[post_date] => 2016-10-26 14:06:36
[post_date_gmt] => 2016-10-26 12:06:36
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/01IMG_20160606_220740.jpg
[post_title] => 01IMG_20160606_220740.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 01img_20160606_220740-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:06:36
[post_modified_gmt] => 2016-10-26 12:06:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/01IMG_20160606_220740.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[1] => stdClass Object
(
[ID] => 13
[post_author] => 1
[post_date] => 2016-10-26 14:06:45
[post_date_gmt] => 2016-10-26 12:06:45
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/02DSCF5338.jpg
[post_title] => 02DSCF5338.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 02dscf5338-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:06:45
[post_modified_gmt] => 2016-10-26 12:06:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/02DSCF5338.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[2] => stdClass Object
(
[ID] => 14
[post_author] => 1
[post_date] => 2016-10-26 14:06:54
[post_date_gmt] => 2016-10-26 12:06:54
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/03DSCF5333.jpg
[post_title] => 03DSCF5333.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 03dscf5333-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:06:54
[post_modified_gmt] => 2016-10-26 12:06:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/03DSCF5333.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[3] => stdClass Object
(
[ID] => 15
[post_author] => 1
[post_date] => 2016-10-26 14:07:04
[post_date_gmt] => 2016-10-26 12:07:04
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/04DSCF5337.jpg
[post_title] => 04DSCF5337.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 04dscf5337-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:07:04
[post_modified_gmt] => 2016-10-26 12:07:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/04DSCF5337.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[4] => stdClass Object
(
[ID] => 16
[post_author] => 1
[post_date] => 2016-10-26 14:07:13
[post_date_gmt] => 2016-10-26 12:07:13
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/05DSCF5345.jpg
[post_title] => 05DSCF5345.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 05dscf5345-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:07:13
[post_modified_gmt] => 2016-10-26 12:07:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/05DSCF5345.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[5] => stdClass Object
(
[ID] => 17
[post_author] => 1
[post_date] => 2016-10-26 14:07:34
[post_date_gmt] => 2016-10-26 12:07:34
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/06DSCF5348.jpg
[post_title] => 06DSCF5348.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 06dscf5348-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:07:34
[post_modified_gmt] => 2016-10-26 12:07:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/06DSCF5348.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[6] => stdClass Object
(
[ID] => 18
[post_author] => 1
[post_date] => 2016-10-26 14:07:54
[post_date_gmt] => 2016-10-26 12:07:54
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/cropped-08IMG_20150608_192023.jpg
[post_title] => cropped-08IMG_20150608_192023.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => closed
[ping_status] => open
[post_password] =>
[post_name] => cropped-08img_20150608_192023-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:07:54
[post_modified_gmt] => 2016-10-26 12:07:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/08IMG_20150608_192023.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[7] => stdClass Object
(
[ID] => 19
[post_author] => 1
[post_date] => 2016-10-26 14:08:03
[post_date_gmt] => 2016-10-26 12:08:03
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09IMG_20150608_194418.jpg
[post_title] => 09IMG_20150608_194418.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 09img_20150608_194418-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:08:03
[post_modified_gmt] => 2016-10-26 12:08:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09IMG_20150608_194418.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[8] => stdClass Object
(
[ID] => 20
[post_author] => 1
[post_date] => 2016-10-26 14:08:13
[post_date_gmt] => 2016-10-26 12:08:13
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09zIMG_20150905_165258.jpg
[post_title] => 09zIMG_20150905_165258.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 09zimg_20150905_165258-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:08:13
[post_modified_gmt] => 2016-10-26 12:08:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09zIMG_20150905_165258.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[9] => stdClass Object
(
[ID] => 21
[post_author] => 1
[post_date] => 2016-10-26 14:08:22
[post_date_gmt] => 2016-10-26 12:08:22
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/10IMG_20160417_110639.jpg
[post_title] => 10IMG_20160417_110639.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 10img_20160417_110639-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:08:22
[post_modified_gmt] => 2016-10-26 12:08:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/10IMG_20160417_110639.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[10] => stdClass Object
(
[ID] => 22
[post_author] => 1
[post_date] => 2016-10-26 14:08:30
[post_date_gmt] => 2016-10-26 12:08:30
[post_content] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/11DSCF5326.jpg
[post_title] => 11DSCF5326.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 11dscf5326-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2016-10-26 14:08:30
[post_modified_gmt] => 2016-10-26 12:08:30
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/11DSCF5326.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
)
Array
(
[12] => Array
(
[attachment_id] => 12
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/01IMG_20160606_220740.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/01IMG_20160606_220740.jpg
[alt_text] =>
)
[13] => Array
(
[attachment_id] => 13
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/02DSCF5338.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/02DSCF5338.jpg
[alt_text] =>
)
[14] => Array
(
[attachment_id] => 14
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/03DSCF5333.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/03DSCF5333.jpg
[alt_text] =>
)
[15] => Array
(
[attachment_id] => 15
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/04DSCF5337.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/04DSCF5337.jpg
[alt_text] =>
)
[16] => Array
(
[attachment_id] => 16
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/05DSCF5345.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/05DSCF5345.jpg
[alt_text] =>
)
[17] => Array
(
[attachment_id] => 17
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/06DSCF5348.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/06DSCF5348.jpg
[alt_text] =>
)
[18] => Array
(
[attachment_id] => 18
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/cropped-08IMG_20150608_192023.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/cropped-08IMG_20150608_192023.jpg
[alt_text] =>
)
[19] => Array
(
[attachment_id] => 19
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09IMG_20150608_194418.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09IMG_20150608_194418.jpg
[alt_text] =>
)
[20] => Array
(
[attachment_id] => 20
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09zIMG_20150905_165258.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/09zIMG_20150905_165258.jpg
[alt_text] =>
)
[21] => Array
(
[attachment_id] => 21
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/10IMG_20160417_110639.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/10IMG_20160417_110639.jpg
[alt_text] =>
)
[22] => Array
(
[attachment_id] => 22
[url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/11DSCF5326.jpg
[thumbnail_url] => https://infax.org/friedrichstuben-beisofie/wp-content/uploads/sites/117/2016/10/11DSCF5326.jpg
[alt_text] =>
)
)
####### 
Herzlich willkommen in den Friedrichstuben bei Sofie!
Im Zentrum von Haan verwöhnen Sie in unserem Traditionsrestaurant seit 1999 mit griechischer und internationaler Küche.
Nehmen Sie Platz und genießen das unkomplizierte Ambiente in den gemütlich, mit viel Liebe zum Detail eingerichteten Räumlichkeiten.
Internationale & Griechische Vorspeisen, Omelettes, Fleischgerichte, Pasta sowie Fischgerichte. Finden Sie Ihr Lieblingsgericht – hier ist für jeden etwas dabei!
Für private oder geschäftliche Veranstaltungen bieten wir einen separaten Raum mit Bar für bis zu 100 Personen zur Verfügung. Hier können Sie richtig feiern und haben viel Zeit für Ihre Gäste. Sprechen Sie uns einfach an – wir beraten Sie gerne wie Sie Ihre Gäste in unseren Räumlichkeiten mit leckeren Gerichten verwöhnen können.
Für private oder geschäftliche Veranstaltungen bieten wir einen separaten Raum mit Bar für bis zu 100 Personen zur Verfügung. Hier können Sie richtig feiern und haben viel Zeit für Ihre Gäste. Sprechen Sie uns einfach an – wir beraten Sie gerne wie Sie Ihre Gäste in unseren Räumlichkeiten mit leckeren Gerichten verwöhnen können.
Lust auf sportliche Betätigung?
Wir bieten noch freie Plätze auf unseren Kegelbahnen. Hier können Sie auch Ihren Kindergeburtstag oder sonstige Events verbringen.
Lust auf etwas Besonderes?
Sie möchten lieber in privater Umgebung feiern? Wir bieten einen individuellen Partyservice, mit kaltem oder warmem Buffet. Fragen Sie nach unseren Empfehlungen damit Ihr Event für zu Hause etwas „Besonderes“ wird.
Jetzt neu für unsere Gäste: Genießen Sie den neuen „Wintergarten“!
Aus unserem Biergarten wurde im Handumdrehen ein wunderschöner, angenehm temperierter Wintergarten! Wenn Sie im Winter eine gemütliche, unkomplizierte Atmosphäre genießen möchten werden Sie sich hier wohl fühlen.
In den Sommermonaten steht Ihnen unser schöner, idyllisch angelegter Biergarten zur Verfügung.
Wir freuen uns auf Sie!
Ioannis Papapetrou & Team
Schreibe einen Kommentar
Du musst angemeldet sein, um einen Kommentar abzugeben.