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] =>
)
)
####### 
APP 1 (25qm)
Neu renoviertes Appartement 25qm mit separatem Eingang und kleiner Terrasse.
Exklusives, modernes & helles Appartement mit allem was Ihr Herz begehrt.
- separater Schlafbereich mit Boxspringbett 140cm
- 2 TV-Flachbildschirme
- kleine Terrasse
- elegantes Duschbad
- komplett eingerichtete Küchenzeile mit Geschirrspüler, Backofen und Interieur
- kleine Sitzecke
Das Appartement wird mit Bettwäsche, Handtüchern und Geschirrtüchern übergeben.
Preis pro Tag 50,- Euro (buchbar ab 3 Tage)
Endreinigung 30,- Euro
APP 2 (34qm)
Neu renoviertes Appartement 34qm mit separatem Eingang und kleiner Terrasse.
Exklusives, modernes & helles Appartement mit allem was Ihr Herz begehrt.
- separater Schlafbereich mit Boxspringbett 180cm
- 1 TV-Flachbild
- kleine Terrasse
- elegantes Duschbad
- komplett eingerichtete Küchenzeile mit Geschirrspüler, Backofen und Interieur
- kleine Sitzecke
Das Appartement wird mit Bettwäsche, Handtüchern und Geschirrtüchern übergeben.
Preis pro Tag 60,- Euro (buchbar ab 3 Tage)
Endreinigung 30,- Euro
APP 3 (38qm)
Neu renoviertes Appartement 38qm mit separatem Eingang und kleiner Terrasse.
Exklusives, modernes & helles Appartement mit allem was Ihr Herz begehrt.
- separater Schlafbereich mit Boxspringbett 180cm
- 1 TV-Flachbild
- kleine Terrasse
- elegantes Duschbad
- komplett eingerichtete Küchenzeile mit Geschirrspüler, Backofen und Interieur
- kleine Sitzecke
Das Appartement wird mit Bettwäsche, Handtüchern und Geschirrtüchern übergeben.
Preis pro Tag 60,- Euro (buchbar ab 3 Tage)
Endreinigung 30,- Euro
HOTEL SCHÜTZENHOF · Kirchlinder Str. 21 · 44379 Dortmund · Telefon: 0231 - 671368 · E-Mail: info@hotel-schuetzenhof.de
Schreibe einen Kommentar
Du musst angemeldet sein, um einen Kommentar abzugeben.