IHRE URLAUBSZIELE IN DEUTSCHLAND

SELECT *, label AS label, ctrl_show = true AS is_active FROM house h WHERE 1 AND ( true AND ctrl_show = true AND ( `type_familyhotel` = 1 ) ) ORDER BY address_city

DataItemList Object ( [arrDataItems:protected] => Array ( [153] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 153 [arrData:protected] => Array ( [dedupe] => 1 [id] => 153 [label] => Ferienparadies Pferdeberg [label_place] => [organisation] => [membernumber] => [address_street] => Bischof-Janssen-Straße 1 [address_postcode] => 37115 [address_city] => Duderstadt [address_country] => Deutschland [phone] => 05527 - 5733 [fax] => 05527 - 71665 [email] => info@kolping-duderstadt.de [website] => http://www.kolping-duderstadt.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 51.4949846 [geocode_lon] => 10.2510814 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [167] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 167 [arrData:protected] => Array ( [dedupe] => 1 [id] => 167 [label] => Vogelsbergdorf [label_place] => [organisation] => [membernumber] => [address_street] => Adolph-Kolping-Str. 22 [address_postcode] => 36358 [address_city] => Herbstein [address_country] => Deutschland [phone] => 06643-70 20 [fax] => 06643-70 21 41 [email] => info@vogelsbergdorf.de [website] => https://www.vogelsbergdorf.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 50.5706329 [geocode_lon] => 9.3367918 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [158] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 158 [arrData:protected] => Array ( [dedupe] => 1 [id] => 158 [label] => Kolping Haus Bayerischer Wald [label_place] => [organisation] => [membernumber] => [address_street] => Lambach 1 [address_postcode] => 93462 [address_city] => Lam [address_country] => Deutschland [phone] => 09943 - 94070 [fax] => 0941 - 5972219 [email] => info@haus-bayerischer-wald.de [website] => https://www.haus-bayerischer-wald.de/ [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 49.2168911 [geocode_lon] => 13.0660678 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [152] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 152 [arrData:protected] => Array ( [dedupe] => 1 [id] => 152 [label] => Ferienland Salem [label_place] => [organisation] => [membernumber] => [address_street] => Am Hafen 1 [address_postcode] => 17139 [address_city] => Malchin OT Salem [address_country] => Deutschland [phone] => 03994-2340 [fax] => 03994-234400 [email] => info@kolpingurlaub-mv.de [website] => http://www.kolpingurlaub-mv.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 53.79452 [geocode_lon] => 12.8125 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [161] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 161 [arrData:protected] => Array ( [dedupe] => 1 [id] => 161 [label] => Haus Zauberberg [label_place] => [organisation] => [membernumber] => [address_street] => Kolpingstraße 23 [address_postcode] => 87459 [address_city] => Pfronten [address_country] => Deutschland [phone] => 08363-91260 [fax] => 08363-912656 [email] => info@haus-zauberberg.de [website] => http://www.haus-zauberberg.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 47.60590535 [geocode_lon] => 10.5621879342301 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [179] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 179 [arrData:protected] => Array ( [dedupe] => 1 [id] => 179 [label] => Kolping-Bildungshaus-Salzbergen [label_place] => [organisation] => [membernumber] => [address_street] => Kolpingstraße 4 [address_postcode] => 48499 [address_city] => Salzbergen [address_country] => Deutschland [phone] => 05976 /94 94-20 [fax] => [email] => info@kbs-salzbergen.de [website] => http://www.kbs-salzbergen.de/ [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 52.3252379 [geocode_lon] => 7.3427462 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 1 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [160] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 160 [arrData:protected] => Array ( [dedupe] => 1 [id] => 160 [label] => Haus Chiemgau [label_place] => [organisation] => [membernumber] => [address_street] => Dechantshof 3 [address_postcode] => 83317 [address_city] => Teisendorf [address_country] => Deutschland [phone] => +49 (0) 8666 98590 [fax] => +49 (0) 8666 487 [email] => info@haus-chiemgau.de [website] => http://www.haus-chiemgau.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 47.8454381 [geocode_lon] => 12.836459704873 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) [162] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 162 [arrData:protected] => Array ( [dedupe] => 1 [id] => 162 [label] => Allgäuhaus [label_place] => [organisation] => [membernumber] => [address_street] => Kolpingstraße 1-7 [address_postcode] => 87497 [address_city] => Wertach [address_country] => Deutschland [phone] => 08365-7900 [fax] => 08365-790190 [email] => info@allgaeuhaus-wertach.de [website] => http://www.allgaeuhaus-wertach.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 47.6161945 [geocode_lon] => 10.4331384 [geocode_zoom] => 0 [content_title] => [content_intro] => [content_lage] => [image_overview] => [image_detailmain] => [image_hotel] => [image_logo] => [image_house] => img_house.jpg [text_beschreibung] => [ctrl_position] => 0 [ctrl_show] => 1 [type_house] => 0 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 1 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 0 [is_active] => 1 ) [arrTableFields:protected] => Array ( ) [arrActionHandler:protected] => Array ( ) [arrRelations:protected] => Array ( ) [arrSavedData:protected] => Array ( ) [files] => DataItemFiles Object ( [website:protected] => [baseFilesDir:protected] => house [dataItem:protected] => VKH_House Object *RECURSION* [storagemode:protected] => 1 ) [format] => json ) ) ) DataItemFilter Object ( [mode:protected] => 1 [showAll:protected] => [sqlLabel:protected] => [sqlWhere:protected] => [sqlOrder:protected] => address_city [arrFilterParams:protected] => Array ( [type_familyhotel] => 1 ) [startDate:protected] => [endDate:protected] => [year:protected] => )