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] => 
        )

)
#######

Erlesene Weine, herzhafte Speisen und hausgemachter Kuchen im romantischen Fachwerkambiente von 1874.

In einem kleinen historischen Fachwerkhaus, nahe am Rhein in Düsseldorf-Wittlaer befindet sich das urige Restaurant ,,Brands Jupp“.

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.

Wir freuen uns auf Sie!

Ihr Brands Jupp – Team

X

Brands Jupp • Kalkstr. 49 • 40489 Düsseldorf • Telefon: 0211-404040 • Mail: info@brandsjupp.de