SELECT wp_156_posts.* FROM wp_156_posts INNER JOIN wp_156_postmeta ON (wp_156_posts.ID = wp_156_postmeta.post_id) WHERE wp_156_posts.post_type = 'attachment' AND ((wp_156_posts.post_status = 'inherit')) AND ((wp_156_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_156_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap')) GROUP BY wp_156_posts.ID Array ( [0] => stdClass Object ( [ID] => 30 [post_author] => 1 [post_date] => 2018-07-06 17:02:29 [post_date_gmt] => 2018-07-06 15:02:29 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/01_DSCF80901.jpg [post_title] => 01_DSCF80901.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 01_dscf80901-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:02:29 [post_modified_gmt] => 2018-07-06 15:02:29 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/01_DSCF80901.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [1] => stdClass Object ( [ID] => 31 [post_author] => 1 [post_date] => 2018-07-06 17:02:43 [post_date_gmt] => 2018-07-06 15:02:43 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/02_DSCF81011.jpg [post_title] => 02_DSCF81011.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 02_dscf81011-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:02:43 [post_modified_gmt] => 2018-07-06 15:02:43 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/02_DSCF81011.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [2] => stdClass Object ( [ID] => 32 [post_author] => 1 [post_date] => 2018-07-06 17:02:49 [post_date_gmt] => 2018-07-06 15:02:49 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/03_DSCF81051.jpg [post_title] => 03_DSCF81051.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 03_dscf81051-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:02:49 [post_modified_gmt] => 2018-07-06 15:02:49 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/03_DSCF81051.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [3] => stdClass Object ( [ID] => 33 [post_author] => 1 [post_date] => 2018-07-06 17:03:02 [post_date_gmt] => 2018-07-06 15:03:02 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/04_DSCF80921.jpg [post_title] => 04_DSCF80921.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 04_dscf80921-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:02 [post_modified_gmt] => 2018-07-06 15:03:02 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/04_DSCF80921.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [4] => stdClass Object ( [ID] => 34 [post_author] => 1 [post_date] => 2018-07-06 17:03:09 [post_date_gmt] => 2018-07-06 15:03:09 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/05_DSCF80911.jpg [post_title] => 05_DSCF80911.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 05_dscf80911-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:09 [post_modified_gmt] => 2018-07-06 15:03:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/05_DSCF80911.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [5] => stdClass Object ( [ID] => 35 [post_author] => 1 [post_date] => 2018-07-06 17:03:16 [post_date_gmt] => 2018-07-06 15:03:16 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/06_DSCF81141.jpg [post_title] => 06_DSCF81141.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 06_dscf81141-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:16 [post_modified_gmt] => 2018-07-06 15:03:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/06_DSCF81141.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [6] => stdClass Object ( [ID] => 36 [post_author] => 1 [post_date] => 2018-07-06 17:03:25 [post_date_gmt] => 2018-07-06 15:03:25 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/07_DSCF81191.jpg [post_title] => 07_DSCF81191.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 07_dscf81191-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:25 [post_modified_gmt] => 2018-07-06 15:03:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/07_DSCF81191.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [7] => stdClass Object ( [ID] => 37 [post_author] => 1 [post_date] => 2018-07-06 17:03:37 [post_date_gmt] => 2018-07-06 15:03:37 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/08_DSCF81411.jpg [post_title] => 08_DSCF81411.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 08_dscf81411-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:37 [post_modified_gmt] => 2018-07-06 15:03:37 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/08_DSCF81411.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [8] => stdClass Object ( [ID] => 38 [post_author] => 1 [post_date] => 2018-07-06 17:03:45 [post_date_gmt] => 2018-07-06 15:03:45 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/09_DSCF81211.jpg [post_title] => 09_DSCF81211.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 09_dscf81211-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:45 [post_modified_gmt] => 2018-07-06 15:03:45 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/09_DSCF81211.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [9] => stdClass Object ( [ID] => 39 [post_author] => 1 [post_date] => 2018-07-06 17:03:52 [post_date_gmt] => 2018-07-06 15:03:52 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/11_DSCF81281.jpg [post_title] => 11_DSCF81281.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 11_dscf81281-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:52 [post_modified_gmt] => 2018-07-06 15:03:52 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/11_DSCF81281.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [10] => stdClass Object ( [ID] => 40 [post_author] => 1 [post_date] => 2018-07-06 17:03:58 [post_date_gmt] => 2018-07-06 15:03:58 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/12_DSCF81361.jpg [post_title] => 12_DSCF81361.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 12_dscf81361-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:03:58 [post_modified_gmt] => 2018-07-06 15:03:58 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/12_DSCF81361.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [11] => stdClass Object ( [ID] => 41 [post_author] => 1 [post_date] => 2018-07-06 17:04:03 [post_date_gmt] => 2018-07-06 15:04:03 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/13_DSCF81351.jpg [post_title] => 13_DSCF81351.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 13_dscf81351-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:04:03 [post_modified_gmt] => 2018-07-06 15:04:03 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/13_DSCF81351.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) [12] => stdClass Object ( [ID] => 42 [post_author] => 1 [post_date] => 2018-07-06 17:04:09 [post_date_gmt] => 2018-07-06 15:04:09 [post_content] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/14_DSCF81421.jpg [post_title] => 14_DSCF81421.jpg [post_excerpt] => [post_status] => inherit [comment_status] => open [ping_status] => open [post_password] => [post_name] => 14_dscf81421-jpg [to_ping] => [pinged] => [post_modified] => 2018-07-06 17:04:09 [post_modified_gmt] => 2018-07-06 15:04:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/14_DSCF81421.jpg [menu_order] => 0 [post_type] => attachment [post_mime_type] => image/jpeg [comment_count] => 0 ) ) Array ( [30] => Array ( [attachment_id] => 30 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/01_DSCF80901.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/01_DSCF80901.jpg [alt_text] => ) [31] => Array ( [attachment_id] => 31 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/02_DSCF81011.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/02_DSCF81011.jpg [alt_text] => ) [32] => Array ( [attachment_id] => 32 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/03_DSCF81051.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/03_DSCF81051.jpg [alt_text] => ) [33] => Array ( [attachment_id] => 33 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/04_DSCF80921.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/04_DSCF80921.jpg [alt_text] => ) [34] => Array ( [attachment_id] => 34 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/05_DSCF80911.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/05_DSCF80911.jpg [alt_text] => ) [35] => Array ( [attachment_id] => 35 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/06_DSCF81141.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/06_DSCF81141.jpg [alt_text] => ) [36] => Array ( [attachment_id] => 36 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/07_DSCF81191.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/07_DSCF81191.jpg [alt_text] => ) [37] => Array ( [attachment_id] => 37 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/08_DSCF81411.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/08_DSCF81411.jpg [alt_text] => ) [38] => Array ( [attachment_id] => 38 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/09_DSCF81211.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/09_DSCF81211.jpg [alt_text] => ) [39] => Array ( [attachment_id] => 39 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/11_DSCF81281.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/11_DSCF81281.jpg [alt_text] => ) [40] => Array ( [attachment_id] => 40 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/12_DSCF81361.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/12_DSCF81361.jpg [alt_text] => ) [41] => Array ( [attachment_id] => 41 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/13_DSCF81351.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/13_DSCF81351.jpg [alt_text] => ) [42] => Array ( [attachment_id] => 42 [url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/14_DSCF81421.jpg [thumbnail_url] => https://infax.org/brandsjupp/wp-content/uploads/sites/156/2018/07/14_DSCF81421.jpg [alt_text] => ) ) #######
In diesem herrlichen Ambiente verwöhnt Sie unsere Küche modern aber bodenständig mit deutschen, internationalen & saisonalen Köstlichkeiten.
An warmen Sommertagen lädt unser lauschiger Biergarten im Grünen mit schattenspendenden Bäumen und Blick auf den Rhein zum Genuss unter freiem Himmel ein. Hier finden bis zu 120 Personen Platz zur Entspannung in ländlicher Umgebung.
Unsere Location eignet sich hervorragend für private und geschäftliche Veranstaltungen jeglicher Art. Gerne stellen wir Ihnen unseren Gesellschaftsraum für bis zu 60 Personen oder unser ganzes Restaurant mit Biergarten zur Verfügung. Sprechen Sie uns einfach an – wir beraten Sie ausführlich über die Möglichkeiten, wie Sie Ihre Gäste in diesem stilvollen Ambiente mit unseren leckeren Köstlichkeiten verwöhnen können.
Ihr Brands Jupp – Team
Load: 19 queries - 0ms - 4.1MB - 148 cache hits / 182 Query: 22 queries - 0ms - 4.3MB - 180 cache hits / 216 Display: 42 queries - 0ms - 5.0MB - 841 cache hits / 922