SELECT
								wp_102_posts.*
							FROM
								wp_102_posts
							INNER JOIN
								wp_102_postmeta ON (wp_102_posts.ID = wp_102_postmeta.post_id)
							WHERE
									wp_102_posts.post_type = 'attachment'
								AND
									((wp_102_posts.post_status = 'inherit'))
								AND
									((wp_102_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_102_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_102_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 119
            [post_author] => 1
            [post_date] => 2017-11-29 17:19:25
            [post_date_gmt] => 2017-11-29 15:19:25
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/01_DSCF7116.jpg
            [post_title] => 01_DSCF7116.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 01_dscf7116-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:19:25
            [post_modified_gmt] => 2017-11-29 15:19:25
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/01_DSCF7116.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 120
            [post_author] => 1
            [post_date] => 2017-11-29 17:19:35
            [post_date_gmt] => 2017-11-29 15:19:35
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/02_DSCF7119.jpg
            [post_title] => 02_DSCF7119.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 02_dscf7119-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:19:35
            [post_modified_gmt] => 2017-11-29 15:19:35
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/02_DSCF7119.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 121
            [post_author] => 1
            [post_date] => 2017-11-29 17:19:45
            [post_date_gmt] => 2017-11-29 15:19:45
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/03_DSCF7118.jpg
            [post_title] => 03_DSCF7118.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 03_dscf7118-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:19:45
            [post_modified_gmt] => 2017-11-29 15:19:45
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/03_DSCF7118.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 122
            [post_author] => 1
            [post_date] => 2017-11-29 17:19:55
            [post_date_gmt] => 2017-11-29 15:19:55
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/04_DSCF7129.jpg
            [post_title] => 04_DSCF7129.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 04_dscf7129-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:19:55
            [post_modified_gmt] => 2017-11-29 15:19:55
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/04_DSCF7129.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 123
            [post_author] => 1
            [post_date] => 2017-11-29 17:20:05
            [post_date_gmt] => 2017-11-29 15:20:05
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/05_DSCF7134.jpg
            [post_title] => 05_DSCF7134.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 05_dscf7134-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:20:05
            [post_modified_gmt] => 2017-11-29 15:20:05
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/05_DSCF7134.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 124
            [post_author] => 1
            [post_date] => 2017-11-29 17:20:14
            [post_date_gmt] => 2017-11-29 15:20:14
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/06_DSCF7125.jpg
            [post_title] => 06_DSCF7125.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 06_dscf7125-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:20:14
            [post_modified_gmt] => 2017-11-29 15:20:14
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/06_DSCF7125.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [6] => stdClass Object
        (
            [ID] => 125
            [post_author] => 1
            [post_date] => 2017-11-29 17:20:23
            [post_date_gmt] => 2017-11-29 15:20:23
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/07_DSCF7123.jpg
            [post_title] => 07_DSCF7123.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 07_dscf7123-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:20:23
            [post_modified_gmt] => 2017-11-29 15:20:23
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/07_DSCF7123.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [7] => stdClass Object
        (
            [ID] => 126
            [post_author] => 1
            [post_date] => 2017-11-29 17:20:33
            [post_date_gmt] => 2017-11-29 15:20:33
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/08_DSCF7128.jpg
            [post_title] => 08_DSCF7128.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 08_dscf7128-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:20:33
            [post_modified_gmt] => 2017-11-29 15:20:33
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/08_DSCF7128.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [8] => stdClass Object
        (
            [ID] => 127
            [post_author] => 1
            [post_date] => 2017-11-29 17:20:44
            [post_date_gmt] => 2017-11-29 15:20:44
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/09_DSCF7131.jpg
            [post_title] => 09_DSCF7131.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 09_dscf7131-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:20:44
            [post_modified_gmt] => 2017-11-29 15:20:44
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/09_DSCF7131.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [9] => stdClass Object
        (
            [ID] => 128
            [post_author] => 1
            [post_date] => 2017-11-29 17:21:21
            [post_date_gmt] => 2017-11-29 15:21:21
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/10_IMG_3575.jpg
            [post_title] => 10_IMG_3575.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 10_img_3575-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:21:21
            [post_modified_gmt] => 2017-11-29 15:21:21
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/10_IMG_3575.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [10] => stdClass Object
        (
            [ID] => 129
            [post_author] => 1
            [post_date] => 2017-11-29 17:21:30
            [post_date_gmt] => 2017-11-29 15:21:30
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/11_IMG_3574.jpg
            [post_title] => 11_IMG_3574.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_img_3574-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2017-11-29 17:21:30
            [post_modified_gmt] => 2017-11-29 15:21:30
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/11_IMG_3574.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [11] => stdClass Object
        (
            [ID] => 145
            [post_author] => 1
            [post_date] => 2018-04-16 13:44:12
            [post_date_gmt] => 2018-04-16 11:44:12
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_1.jpg
            [post_title] => 11_IMG_3574_1.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_img_3574_1-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-16 13:44:12
            [post_modified_gmt] => 2018-04-16 11:44:12
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_1.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [12] => stdClass Object
        (
            [ID] => 146
            [post_author] => 1
            [post_date] => 2018-04-16 13:44:21
            [post_date_gmt] => 2018-04-16 11:44:21
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_2.jpg
            [post_title] => 11_IMG_3574_2.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_img_3574_2-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-16 13:44:21
            [post_modified_gmt] => 2018-04-16 11:44:21
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_2.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [13] => stdClass Object
        (
            [ID] => 147
            [post_author] => 1
            [post_date] => 2018-04-16 13:44:30
            [post_date_gmt] => 2018-04-16 11:44:30
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_3.jpg
            [post_title] => 11_IMG_3574_3.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_img_3574_3-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-16 13:44:30
            [post_modified_gmt] => 2018-04-16 11:44:30
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_3.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [14] => stdClass Object
        (
            [ID] => 148
            [post_author] => 1
            [post_date] => 2018-04-16 13:44:39
            [post_date_gmt] => 2018-04-16 11:44:39
            [post_content] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_4.jpg
            [post_title] => 11_IMG_3574_4.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => closed
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_img_3574_4-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-04-16 13:44:39
            [post_modified_gmt] => 2018-04-16 11:44:39
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_4.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [119] => Array
        (
            [attachment_id] => 119
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/01_DSCF7116.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/01_DSCF7116.jpg
            [alt_text] => 
        )

    [120] => Array
        (
            [attachment_id] => 120
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/02_DSCF7119.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/02_DSCF7119.jpg
            [alt_text] => 
        )

    [121] => Array
        (
            [attachment_id] => 121
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/03_DSCF7118.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/03_DSCF7118.jpg
            [alt_text] => 
        )

    [122] => Array
        (
            [attachment_id] => 122
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/04_DSCF7129.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/04_DSCF7129.jpg
            [alt_text] => 
        )

    [123] => Array
        (
            [attachment_id] => 123
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/05_DSCF7134.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/05_DSCF7134.jpg
            [alt_text] => 
        )

    [124] => Array
        (
            [attachment_id] => 124
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/06_DSCF7125.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/06_DSCF7125.jpg
            [alt_text] => 
        )

    [125] => Array
        (
            [attachment_id] => 125
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/07_DSCF7123.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/07_DSCF7123.jpg
            [alt_text] => 
        )

    [126] => Array
        (
            [attachment_id] => 126
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/08_DSCF7128.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/08_DSCF7128.jpg
            [alt_text] => 
        )

    [127] => Array
        (
            [attachment_id] => 127
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/09_DSCF7131.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/09_DSCF7131.jpg
            [alt_text] => 
        )

    [128] => Array
        (
            [attachment_id] => 128
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/10_IMG_3575.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/10_IMG_3575.jpg
            [alt_text] => 
        )

    [129] => Array
        (
            [attachment_id] => 129
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/11_IMG_3574.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2017/11/11_IMG_3574.jpg
            [alt_text] => 
        )

    [145] => Array
        (
            [attachment_id] => 145
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_1.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_1.jpg
            [alt_text] => 
        )

    [146] => Array
        (
            [attachment_id] => 146
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_2.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_2.jpg
            [alt_text] => 
        )

    [147] => Array
        (
            [attachment_id] => 147
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_3.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_3.jpg
            [alt_text] => 
        )

    [148] => Array
        (
            [attachment_id] => 148
            [url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_4.jpg
            [thumbnail_url] => https://infax.org/ristorante-alcastello/wp-content/uploads/sites/102/2018/04/11_IMG_3574_4.jpg
            [alt_text] => 
        )

)
#######

Genießen Sie leckere italienische Köstlichkeiten in mediterraner Atmosphäre.

Herzlich willkommen im Ristorante Al Castello! Lassen Sie
sich in dem gemütlichen Ambiente von unserer herzlichen
Gastfreundlichkeit verwöhnen.

In den mit Liebe zum Detail gestalteten Räumlichkeiten erwarten Sie mit
Hingabe zubereitete, traditionelle und saisonale Speisen. Wählen Sie aus
zahlreichen köstlichen Antipasti & heißen Suppen, verschiedenen Pizzen,
hausgemachten Pastaspezialitäten, frischem Fisch sowie leckeren
Fleischgerichten.

Dazu passend bieten wir Ihnen eine reichhaltige Getränkeauswahl vom Aperitif
bis zum Digestif, sowie zahlreich Weine aus verschiedenen Regionen. Für den
Abschluss empfiehlt sich ein Blick in die Dessertauswahl – unser
hausgemachtes Tiramisu ist einfach verführerisch lecker.

Gerne bieten wir Ihnen für Ihre privaten oder geschäftlichen Anlässe unsere
Räumlichkeiten für bis zu 80 Gäste an. Lassen Sie sich unverbindlich über die
verschiedenen Möglichkeiten beraten, wie Sie Ihre Gäste mit leckeren
italienischen Speisen verwöhnen können. Auch wenn Sie lieber in privater
Atmosphäre zu Hause oder zu Anlässen in Ihrem Unternehmen feiern
möchten – unser individueller Partyservice steht Ihnen gerne zur
Verfügung. Sprechen Sie uns einfach an – wir sind für Sie da.

Für den Genuß draußen lädt unsere schöne, überdachte & beheizte
Aussenterrasse zum Verweilen ein.

Wir freuen uns auf Sie & Ihre Wünsche!

Ihr Al Castello – Team

 

Schreibe einen Kommentar Antworten abbrechen

Du musst angemeldet sein, um einen Kommentar abzugeben.

Ristorante Al Castello · Hauptstr. 155 · 58332 Schwelm · Telefon: 02336 - 15471 · E-Mail: info@ristorante-alcastello.de

Öffnungszeiten

• Montag - Sonntag
• 17:30 bis 22:00 Uhr
• Dienstag Ruhetag