SELECT
								wp_149_posts.*
							FROM
								wp_149_posts
							INNER JOIN
								wp_149_postmeta ON (wp_149_posts.ID = wp_149_postmeta.post_id)
							WHERE
									wp_149_posts.post_type = 'attachment'
								AND
									((wp_149_posts.post_status = 'inherit'))
								AND
									((wp_149_postmeta.meta_key = '_wp_attachment_is_custom_header' AND CAST(wp_149_postmeta.meta_value AS CHAR) = 'infax_2016_bootstrap'))
							GROUP BY
								wp_149_posts.ID
							Array
(
    [0] => stdClass Object
        (
            [ID] => 58
            [post_author] => 1
            [post_date] => 2018-03-28 11:05:27
            [post_date_gmt] => 2018-03-28 09:05:27
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [post_title] => 01_Hotel-Intro.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 01_hotel-intro-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:05:27
            [post_modified_gmt] => 2018-03-28 09:05:27
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [1] => stdClass Object
        (
            [ID] => 59
            [post_author] => 1
            [post_date] => 2018-03-28 11:05:50
            [post_date_gmt] => 2018-03-28 09:05:50
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [post_title] => 02_SAM_4711.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 02_sam_4711-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:05:50
            [post_modified_gmt] => 2018-03-28 09:05:50
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [2] => stdClass Object
        (
            [ID] => 60
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:01
            [post_date_gmt] => 2018-03-28 09:06:01
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [post_title] => 03_SAM_4718.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 03_sam_4718-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:01
            [post_modified_gmt] => 2018-03-28 09:06:01
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [3] => stdClass Object
        (
            [ID] => 61
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:09
            [post_date_gmt] => 2018-03-28 09:06:09
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [post_title] => 04_SAM_4414.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 04_sam_4414-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:09
            [post_modified_gmt] => 2018-03-28 09:06:09
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [4] => stdClass Object
        (
            [ID] => 62
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:17
            [post_date_gmt] => 2018-03-28 09:06:17
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [post_title] => 05_SAM_4421.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 05_sam_4421-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:17
            [post_modified_gmt] => 2018-03-28 09:06:17
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [5] => stdClass Object
        (
            [ID] => 63
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:28
            [post_date_gmt] => 2018-03-28 09:06:28
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [post_title] => 06_SAM_4443.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 06_sam_4443-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:28
            [post_modified_gmt] => 2018-03-28 09:06:28
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [6] => stdClass Object
        (
            [ID] => 64
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:40
            [post_date_gmt] => 2018-03-28 09:06:40
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [post_title] => 07_SAM_4471.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 07_sam_4471-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:40
            [post_modified_gmt] => 2018-03-28 09:06:40
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [7] => stdClass Object
        (
            [ID] => 65
            [post_author] => 1
            [post_date] => 2018-03-28 11:06:52
            [post_date_gmt] => 2018-03-28 09:06:52
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [post_title] => 08_IMG_20180320_171327.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 08_img_20180320_171327-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:06:52
            [post_modified_gmt] => 2018-03-28 09:06:52
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [8] => stdClass Object
        (
            [ID] => 66
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:00
            [post_date_gmt] => 2018-03-28 09:07:00
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [post_title] => 09_IMG_20180320_171610.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 09_img_20180320_171610-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:00
            [post_modified_gmt] => 2018-03-28 09:07:00
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [9] => stdClass Object
        (
            [ID] => 67
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:09
            [post_date_gmt] => 2018-03-28 09:07:09
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [post_title] => 10_SAM_8220.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 10_sam_8220-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:09
            [post_modified_gmt] => 2018-03-28 09:07:09
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

    [10] => stdClass Object
        (
            [ID] => 68
            [post_author] => 1
            [post_date] => 2018-03-28 11:07:17
            [post_date_gmt] => 2018-03-28 09:07:17
            [post_content] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [post_title] => 11_SAM_8222.jpg
            [post_excerpt] => 
            [post_status] => inherit
            [comment_status] => open
            [ping_status] => open
            [post_password] => 
            [post_name] => 11_sam_8222-jpg
            [to_ping] => 
            [pinged] => 
            [post_modified] => 2018-03-28 11:07:17
            [post_modified_gmt] => 2018-03-28 09:07:17
            [post_content_filtered] => 
            [post_parent] => 0
            [guid] => http://infax.org/hotel-schuetzenhaus/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [menu_order] => 0
            [post_type] => attachment
            [post_mime_type] => image/jpeg
            [comment_count] => 0
        )

)
Array
(
    [58] => Array
        (
            [attachment_id] => 58
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/01_Hotel-Intro.jpg
            [alt_text] => 
        )

    [59] => Array
        (
            [attachment_id] => 59
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/02_SAM_4711.jpg
            [alt_text] => 
        )

    [60] => Array
        (
            [attachment_id] => 60
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/03_SAM_4718.jpg
            [alt_text] => 
        )

    [61] => Array
        (
            [attachment_id] => 61
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/04_SAM_4414.jpg
            [alt_text] => 
        )

    [62] => Array
        (
            [attachment_id] => 62
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/05_SAM_4421.jpg
            [alt_text] => 
        )

    [63] => Array
        (
            [attachment_id] => 63
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/06_SAM_4443.jpg
            [alt_text] => 
        )

    [64] => Array
        (
            [attachment_id] => 64
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/07_SAM_4471.jpg
            [alt_text] => 
        )

    [65] => Array
        (
            [attachment_id] => 65
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/08_IMG_20180320_171327.jpg
            [alt_text] => 
        )

    [66] => Array
        (
            [attachment_id] => 66
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/09_IMG_20180320_171610.jpg
            [alt_text] => 
        )

    [67] => Array
        (
            [attachment_id] => 67
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/10_SAM_8220.jpg
            [alt_text] => 
        )

    [68] => Array
        (
            [attachment_id] => 68
            [url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [thumbnail_url] => https://infax.org/hotel-schuetzenhof/wp-content/uploads/sites/149/2018/03/11_SAM_8222.jpg
            [alt_text] => 
        )

)
#######

Zimmerpreise

	Zimmer	1 Nacht	ab 2 Nächte p.N.
1	DZ / Dusche – WC	75,00 €	65,00 €/Nacht
2	EZ / Dusche – WC	51,00 €	46,00 €/Nacht
	Preise incl. TV, Telefon u. 7% MwSt. zzgl. 7,5% Bettensteuer

Frühstück

Frühstück 7,- € p. Person

Wir bieten ein Frühstückssystem an, dass in der Zeit von 6.30 – 11.00 Uhr auf dem Zimmer eingenommen werden kann. Wir stellen die Brötchen sowie die Kühlbox mit Wurst & Käse vor die Tür, damit Sie selber bestimmen können, wann Sie Ihr Frühstück einnehmen möchten.

Wir würden uns freuen Sie im Hotel Schützenhof begrüßen zu dürfen.

Schreibe einen Kommentar Antworten abbrechen

Du musst angemeldet sein, um einen Kommentar abzugeben.

HOTEL SCHÜTZENHOF · Kirchlinder Str. 21 · 44379 Dortmund · Telefon: 0231 - 671368 · E-Mail: info@hotel-schuetzenhof.de