SELECT
wp_59_posts.*
FROM
wp_59_posts
INNER JOIN
wp_59_postmeta ON (wp_59_posts.ID = wp_59_postmeta.post_id)
WHERE
wp_59_posts.post_type = 'attachment'
AND
((wp_59_posts.post_status = 'inherit'))
AND
((wp_59_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_59_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
GROUP BY
wp_59_posts.ID
Array
(
[0] => stdClass Object
(
[ID] => 151
[post_author] => 1
[post_date] => 2017-07-26 19:24:00
[post_date_gmt] => 2017-07-26 17:24:00
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/01_DSCF6320.jpg
[post_title] => 01_DSCF6320.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 01_dscf6320-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:00
[post_modified_gmt] => 2017-07-26 17:24:00
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/01_DSCF6320.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[1] => stdClass Object
(
[ID] => 152
[post_author] => 1
[post_date] => 2017-07-26 19:24:08
[post_date_gmt] => 2017-07-26 17:24:08
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/02_DSCF6325.jpg
[post_title] => 02_DSCF6325.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 02_dscf6325-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:08
[post_modified_gmt] => 2017-07-26 17:24:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/02_DSCF6325.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[2] => stdClass Object
(
[ID] => 153
[post_author] => 1
[post_date] => 2017-07-26 19:24:18
[post_date_gmt] => 2017-07-26 17:24:18
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/03_DSCF6324.jpg
[post_title] => 03_DSCF6324.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 03_dscf6324-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:18
[post_modified_gmt] => 2017-07-26 17:24:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/03_DSCF6324.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[3] => stdClass Object
(
[ID] => 154
[post_author] => 1
[post_date] => 2017-07-26 19:24:26
[post_date_gmt] => 2017-07-26 17:24:26
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/04_2017-07-21-00000057.jpg
[post_title] => 04_2017-07-21-00000057.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 04_2017-07-21-00000057-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:26
[post_modified_gmt] => 2017-07-26 17:24:26
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/04_2017-07-21-00000057.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[4] => stdClass Object
(
[ID] => 155
[post_author] => 1
[post_date] => 2017-07-26 19:24:37
[post_date_gmt] => 2017-07-26 17:24:37
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/05_DSCF6321.jpg
[post_title] => 05_DSCF6321.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 05_dscf6321-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:37
[post_modified_gmt] => 2017-07-26 17:24:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/05_DSCF6321.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[5] => stdClass Object
(
[ID] => 156
[post_author] => 1
[post_date] => 2017-07-26 19:24:47
[post_date_gmt] => 2017-07-26 17:24:47
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/06_DSCF6326.jpg
[post_title] => 06_DSCF6326.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 06_dscf6326-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:47
[post_modified_gmt] => 2017-07-26 17:24:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/06_DSCF6326.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[6] => stdClass Object
(
[ID] => 157
[post_author] => 1
[post_date] => 2017-07-26 19:24:55
[post_date_gmt] => 2017-07-26 17:24:55
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/07_2017-07-21-00000059.jpg
[post_title] => 07_2017-07-21-00000059.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 07_2017-07-21-00000059-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:24:55
[post_modified_gmt] => 2017-07-26 17:24:55
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/07_2017-07-21-00000059.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[7] => stdClass Object
(
[ID] => 158
[post_author] => 1
[post_date] => 2017-07-26 19:25:03
[post_date_gmt] => 2017-07-26 17:25:03
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/08_DSCF6328.jpg
[post_title] => 08_DSCF6328.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 08_dscf6328-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:25:03
[post_modified_gmt] => 2017-07-26 17:25:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/08_DSCF6328.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[8] => stdClass Object
(
[ID] => 159
[post_author] => 1
[post_date] => 2017-07-26 19:25:11
[post_date_gmt] => 2017-07-26 17:25:11
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/09_2017-07-21-00000060.jpg
[post_title] => 09_2017-07-21-00000060.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 09_2017-07-21-00000060-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:25:11
[post_modified_gmt] => 2017-07-26 17:25:11
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/09_2017-07-21-00000060.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[9] => stdClass Object
(
[ID] => 160
[post_author] => 1
[post_date] => 2017-07-26 19:25:20
[post_date_gmt] => 2017-07-26 17:25:20
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/10_DSCF6323.jpg
[post_title] => 10_DSCF6323.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 10_dscf6323-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:25:20
[post_modified_gmt] => 2017-07-26 17:25:20
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/10_DSCF6323.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[10] => stdClass Object
(
[ID] => 161
[post_author] => 1
[post_date] => 2017-07-26 19:25:29
[post_date_gmt] => 2017-07-26 17:25:29
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/11_2017-07-21-00000062.jpg
[post_title] => 11_2017-07-21-00000062.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 11_2017-07-21-00000062-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:25:29
[post_modified_gmt] => 2017-07-26 17:25:29
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/11_2017-07-21-00000062.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[11] => stdClass Object
(
[ID] => 162
[post_author] => 1
[post_date] => 2017-07-26 19:25:36
[post_date_gmt] => 2017-07-26 17:25:36
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/12_DSCF6331.jpg
[post_title] => 12_DSCF6331.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 12_dscf6331-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:25:36
[post_modified_gmt] => 2017-07-26 17:25:36
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/12_DSCF6331.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[12] => stdClass Object
(
[ID] => 163
[post_author] => 1
[post_date] => 2017-07-26 19:26:28
[post_date_gmt] => 2017-07-26 17:26:28
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/13_2017-07-21-00000073.jpg
[post_title] => 13_2017-07-21-00000073.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 13_2017-07-21-00000073-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:26:28
[post_modified_gmt] => 2017-07-26 17:26:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/13_2017-07-21-00000073.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[13] => stdClass Object
(
[ID] => 164
[post_author] => 1
[post_date] => 2017-07-26 19:26:37
[post_date_gmt] => 2017-07-26 17:26:37
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/14_DSCF6332.jpg
[post_title] => 14_DSCF6332.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 14_dscf6332-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:26:37
[post_modified_gmt] => 2017-07-26 17:26:37
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/14_DSCF6332.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
[14] => stdClass Object
(
[ID] => 165
[post_author] => 1
[post_date] => 2017-07-26 19:26:47
[post_date_gmt] => 2017-07-26 17:26:47
[post_content] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/15_DSCF6338.jpg
[post_title] => 15_DSCF6338.jpg
[post_excerpt] =>
[post_status] => inherit
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => 15_dscf6338-jpg
[to_ping] =>
[pinged] =>
[post_modified] => 2017-07-26 19:26:47
[post_modified_gmt] => 2017-07-26 17:26:47
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/15_DSCF6338.jpg
[menu_order] => 0
[post_type] => attachment
[post_mime_type] => image/jpeg
[comment_count] => 0
)
)
Array
(
[151] => Array
(
[attachment_id] => 151
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/01_DSCF6320.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/01_DSCF6320.jpg
[alt_text] =>
)
[152] => Array
(
[attachment_id] => 152
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/02_DSCF6325.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/02_DSCF6325.jpg
[alt_text] =>
)
[153] => Array
(
[attachment_id] => 153
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/03_DSCF6324.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/03_DSCF6324.jpg
[alt_text] =>
)
[154] => Array
(
[attachment_id] => 154
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/04_2017-07-21-00000057.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/04_2017-07-21-00000057.jpg
[alt_text] =>
)
[155] => Array
(
[attachment_id] => 155
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/05_DSCF6321.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/05_DSCF6321.jpg
[alt_text] =>
)
[156] => Array
(
[attachment_id] => 156
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/06_DSCF6326.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/06_DSCF6326.jpg
[alt_text] =>
)
[157] => Array
(
[attachment_id] => 157
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/07_2017-07-21-00000059.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/07_2017-07-21-00000059.jpg
[alt_text] =>
)
[158] => Array
(
[attachment_id] => 158
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/08_DSCF6328.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/08_DSCF6328.jpg
[alt_text] =>
)
[159] => Array
(
[attachment_id] => 159
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/09_2017-07-21-00000060.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/09_2017-07-21-00000060.jpg
[alt_text] =>
)
[160] => Array
(
[attachment_id] => 160
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/10_DSCF6323.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/10_DSCF6323.jpg
[alt_text] =>
)
[161] => Array
(
[attachment_id] => 161
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/11_2017-07-21-00000062.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/11_2017-07-21-00000062.jpg
[alt_text] =>
)
[162] => Array
(
[attachment_id] => 162
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/12_DSCF6331.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/12_DSCF6331.jpg
[alt_text] =>
)
[163] => Array
(
[attachment_id] => 163
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/13_2017-07-21-00000073.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/13_2017-07-21-00000073.jpg
[alt_text] =>
)
[164] => Array
(
[attachment_id] => 164
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/14_DSCF6332.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/14_DSCF6332.jpg
[alt_text] =>
)
[165] => Array
(
[attachment_id] => 165
[url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/15_DSCF6338.jpg
[thumbnail_url] => https://infax.org/gilden-brauhaus/wp-content/uploads/sites/59/2017/07/15_DSCF6338.jpg
[alt_text] =>
)
)
####### 
In Kölner Stadtteil Mülheim eröffnete im Jahr 2000 das Gilden Brauhaus seine Pforten.
Genießen Sie nach Herzenlust die regionale Küche mit saisonalen Spezialitäten und frisches Gilden Kölsch vom Fass in dem gemütlichen Brauhaus Ambiente.
Gerne empfehlen wir Ihnen auch unsere besonderen Aktionstage, die beliebten „Kölsche Jecke Gerichte“ und den wöchentlich wechselnden Mittagstisch.
Freuen Sie sich auf frisch gezapftes Gilden Kölsch oder wählen Sie aus der umfangreichen Getränkekarte mit weiteren Biersorten, Spirituosen und zahlreichen Erfrischungsgetränken.
Für private oder geschäftliche Gesellschaften stehen Ihnen seperate Räumlichkeiten zur Verfügung. Lassen Sie sich unverbindlich beraten mit welchen leckeren Gerichten Sie Ihre Gäste im Gilden Brauhaus verwöhnen können.
An den schönen Tagen begrüßen wir Sie gerne auf der mediterranen Aussenterrasse zum Genuß unter freiem Himmel.
Zu Gast im Gilden Kölsch Brauhaus – wir freuen uns auf Sie!
Ihr Gilden Brauhaus Team
Täglich 11-24 Uhr
Mittagstisch
Aktionstage
Aussenterrasse
Gesellschaftsräume
X