Soziales Wohnen in Wohngruppen

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

DataItemList Object ( [arrDataItems:protected] => Array ( [145] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 145 [arrData:protected] => Array ( [dedupe] => 1 [id] => 145 [label] => Kolpinghaus Bern [label_place] => [organisation] => Verein Kolpinghaus Bern [membernumber] => 17500 [address_street] => Mattenhofstr. 32 [address_postcode] => 3007 [address_city] => Bern [address_country] => Schweiz [phone] => +41(31) 3819 870 [fax] => [email] => kolpinghaus-bern@bluewin.ch [website] => www.kolpinghaus-bern.ch [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 46.9438402 [geocode_lon] => 7.4289788 [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] => 1 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 0 [type_congresshotel] => 1 [type_housing] => 0 [type_socialhousing] => 1 [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 ) [55] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 55 [arrData:protected] => Array ( [dedupe] => 1 [id] => 55 [label] => Kolpinghaus Hannover [label_place] => [organisation] => Kolpinghaus Hannover e.V. [membernumber] => 11790 [address_street] => Escherstr. 12 [address_postcode] => 30159 [address_city] => Hannover [address_country] => Deutschland [phone] => (0511)1317636 [fax] => (0511)1319497 [email] => kolpinghaus@kolpinghaus-hannover.de [website] => www.kolpinghaus-hannover.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 52.3763659 [geocode_lon] => 9.727715 [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] => 1 [type_familyhotel] => 0 [type_congresshotel] => 1 [type_housing] => 1 [type_socialhousing] => 1 [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 ) [94] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 94 [arrData:protected] => Array ( [dedupe] => 1 [id] => 94 [label] => Kolpinghaus Neuss [label_place] => [organisation] => Kath. Gesellenhaus GmbH [membernumber] => 13280 [address_street] => Burggraben 1 [address_postcode] => 41460 [address_city] => Neuss [address_country] => Deutschland [phone] => (02131) 225-0 [fax] => (02131) 225-225 [email] => neusskolpinghaus@aol.com [website] => www.kolpinghaus-neuss.de [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 51.2017877 [geocode_lon] => 6.6899052 [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] => 1 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 0 [type_congresshotel] => 1 [type_housing] => 1 [type_socialhousing] => 1 [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 ) [96] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 96 [arrData:protected] => Array ( [dedupe] => 1 [id] => 96 [label] => Kolpinghaus Nordhorn [label_place] => [organisation] => Kolpinghaus Nordhorn e.V. [membernumber] => 13290 [address_street] => Stadtring 34 [address_postcode] => 48527 [address_city] => Nordhorn [address_country] => Deutschland [phone] => (05921) 156 96 [fax] => (05921) 799 61 [email] => kolpinghaus.nordhorn@ewetel.net [website] => [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 52.4376717 [geocode_lon] => 7.0630074 [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] => 1 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 0 [type_congresshotel] => 0 [type_housing] => 1 [type_socialhousing] => 1 [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 ) [141] => VKH_House Object ( [arrStoredData:protected] => Array ( ) [queryString:protected] => [parameterString:protected] => [userAgent:protected] => [referrer:protected] => [arrFieldLabels:protected] => Array ( ) [id:protected] => 141 [arrData:protected] => Array ( [dedupe] => 1 [id] => 141 [label] => Kolpinghaus Wuppertal-Elberfeld [label_place] => [organisation] => Kolpinghaus Wuppertal-Elberfeld e.V. [membernumber] => 15830 [address_street] => Laurentiusstr. 4-6 [address_postcode] => 42103 [address_city] => Wuppertal-Elberfeld [address_country] => Deutschland [phone] => (0202) 300 847 [fax] => (0202) 495 87 44 [email] => grotebeverborg@web.de [website] => http://kolping-wuppertal.de/ [website_house] => [website_restaurant] => [website_hotel] => [website_familyhotel] => [website_congresshotel] => [website_housing] => [website_socialhousing] => [geocode_accuracy] => 0 [geocode_lat] => 51.2565496 [geocode_lon] => 7.1401821 [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] => 1 [type_restaurant] => 0 [type_hotel] => 0 [type_familyhotel] => 0 [type_congresshotel] => 0 [type_housing] => 0 [type_socialhousing] => 1 [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_socialhousing] => 1 ) [startDate:protected] => [endDate:protected] => [year:protected] => )