【リノベーション完了！即日ご見学できます】最上階、三方角に佇むChambers。2LDK＋DENに加え、27㎡を超えるルーフバルコニーを持つ。ご家族、ご友人さま達と「自宅でビアガーデン」。乾杯。
2LDK+DEN+ルーフバルコニー
専有面積：53.64m2 バルコニー面積：10.36m2
2,999万円
見学予約受付中
| マンション名 | ライオンズマンション井荻 |
|---|---|
| 価格 | 2,999万円 |
| 所在地 | 杉並区井草3丁目 |
| 専有面積 | 53.64㎡ |
| バルコニー面積 | 10.36㎡ |
| 間取タイプ | 2LDK+DEN+ルーフバルコニー |
| 所在階 | 4階 |
| 向き | 向き |
| 権利形態 | 所有権 |
| 用途地域1 | |
| 構造 | RC造4階建 |
| 総戸数 | 14(戸) |
| 築年月 | 1981年4月 |
| 分譲会社 | |
| 施工会社 | |
| 管理会社 | (株)大京アステージ |
| 管理形態 | 全部委託 |
| 管理方式 | 巡回 | 駐車場 | --- |
| ガス | 都市ガス |
| リフォーム歴 | 有 |
|---|---|
| リフォーム履歴内容 | ■床、クロス ■洗面、トイレ ■キッチン(食洗器) ■ユニットバス ■建具 ■新規エアコン設置(1台) |
| エレベーター | --- |
| ペット飼育可否 | 不可 |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| 管理費(月額) | 15,930円 |
| 修繕積立金(月額) | 19,950円 |
| その他費用(月額) | --- |
| 合計額(月額) | 35,880円 |
| ポイント | ●リノベーション住戸 ●低層マンション |
| 指定学校区 | 杉並区立八成小学校 杉並区立中瀬中学校 |
| 備考 | ●2018年大規模修繕工事実施済み （ルーフバルコニー防水、屋上防水、鉄部塗装） ●長期修繕計画あり ●フラット35適合 ●アフターサービス保証付 |
杉並区立八成小学校 約240m 徒歩3分
杉並区立中瀬中学校 約1200m 徒歩15分
ひこばえ幼稚園 約750m 徒歩10分
ウエルシア杉並井草３丁目店 約160m 徒歩2分
コープみらい コープ杉並井草店 約170m 徒歩3分
まいばすけっと南田中1丁目店 約400m 徒歩5分
サミットストア 井荻駅前店 約750m 徒歩10分
杉並区立井草森公園 約500m 徒歩7分
杉並区立井草森公園 約500m 徒歩7分
見学予約受付中
見学予約受付中
路線検索
会員限定物件
Notice (8): Undefined variable: area_results_member [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onmanshons' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onmanshons.id AS `Onmanshons__id`, Onmanshons.name AS `Onmanshons__name`, Onmanshons.mbAddress AS `Onmanshons__mbAddress`, Onmanshons.displayFlg AS `Onmanshons__displayFlg`, Onmanshons.statusFlg AS `Onmanshons__statusFlg`, Onmanshons.area_id AS `Onmanshons__area_id`, Onmanshons.kind_id AS `Onmanshons__kind_id`, Onmanshons.newoldFlg AS `Onmanshons__newoldFlg`, Onmanshons.tour_id AS `Onmanshons__tour_id`, Onmanshons.topDispFlg AS `Onmanshons__topDispFlg`, Onmanshons.recommFlg AS `Onmanshons__recommFlg`, Onmanshons.railway_id1 AS `Onmanshons__railway_id1`, Onmanshons.railway_id2 AS `Onmanshons__railway_id2`, Onmanshons.railway_id3 AS `Onmanshons__railway_id3`, Onmanshons.station_id1 AS `Onmanshons__station_id1`, Onmanshons.station_id2 AS `Onmanshons__station_id2`, Onmanshons.station_id3 AS `Onmanshons__station_id3`, Onmanshons.stwalk1 AS `Onmanshons__stwalk1`, Onmanshons.stwalk2 AS `Onmanshons__stwalk2`, Onmanshons.stwalk3 AS `Onmanshons__stwalk3`, Onmanshons.bswalk1 AS `Onmanshons__bswalk1`, Onmanshons.bswalk2 AS `Onmanshons__bswalk2`, Onmanshons.bswalk3 AS `Onmanshons__bswalk3`, Onmanshons.catchCopy AS `Onmanshons__catchCopy`, Onmanshons.stationStart AS `Onmanshons__stationStart`, Onmanshons.stationTo1 AS `Onmanshons__stationTo1`, Onmanshons.stationTo2 AS `Onmanshons__stationTo2`, Onmanshons.stationTo3 AS `Onmanshons__stationTo3`, Onmanshons.stationTo4 AS `Onmanshons__stationTo4`, Onmanshons.trainTime1 AS `Onmanshons__trainTime1`, Onmanshons.trainTime2 AS `Onmanshons__trainTime2`, Onmanshons.trainTime3 AS `Onmanshons__trainTime3`, Onmanshons.trainTime4 AS `Onmanshons__trainTime4`, Onmanshons.trainDirect1 AS `Onmanshons__trainDirect1`, Onmanshons.trainDirect2 AS `Onmanshons__trainDirect2`, Onmanshons.trainDirect3 AS `Onmanshons__trainDirect3`, Onmanshons.trainDirect4 AS `Onmanshons__trainDirect4`, Onmanshons.trainVia1 AS `Onmanshons__trainVia1`, Onmanshons.trainVia2 AS `Onmanshons__trainVia2`, Onmanshons.trainVia3 AS `Onmanshons__trainVia3`, Onmanshons.trainVia4 AS `Onmanshons__trainVia4`, Onmanshons.locationFlg AS `Onmanshons__locationFlg`, Onmanshons.locationTitle1 AS `Onmanshons__locationTitle1`, Onmanshons.locationTitle2 AS `Onmanshons__locationTitle2`, Onmanshons.locationTxt1 AS `Onmanshons__locationTxt1`, Onmanshons.locationTxt2 AS `Onmanshons__locationTxt2`, Onmanshons.locationTxt3 AS `Onmanshons__locationTxt3`, Onmanshons.locationTxt4 AS `Onmanshons__locationTxt4`, Onmanshons.locationTxt5 AS `Onmanshons__locationTxt5`, Onmanshons.locationTxt6 AS `Onmanshons__locationTxt6`, Onmanshons.locationTxt7 AS `Onmanshons__locationTxt7`, Onmanshons.locationTxt8 AS `Onmanshons__locationTxt8`, Onmanshons.locationTxt9 AS `Onmanshons__locationTxt9`, Onmanshons.locationTxt10 AS `Onmanshons__locationTxt10`, Onmanshons.locationTxt11 AS `Onmanshons__locationTxt11`, Onmanshons.locationTxt12 AS `Onmanshons__locationTxt12`, Onmanshons.locationTxt13 AS `Onmanshons__locationTxt13`, Onmanshons.locationTxt14 AS `Onmanshons__locationTxt14`, Onmanshons.locationTxt15 AS `Onmanshons__locationTxt15`, Onmanshons.locationTxt16 AS `Onmanshons__locationTxt16`, Onmanshons.locationTxt17 AS `Onmanshons__locationTxt17`, Onmanshons.locationTxt18 AS `Onmanshons__locationTxt18`, Onmanshons.galleryTxt1 AS `Onmanshons__galleryTxt1`, Onmanshons.galleryTxt2 AS `Onmanshons__galleryTxt2`, Onmanshons.galleryTxt3 AS `Onmanshons__galleryTxt3`, Onmanshons.galleryTxt4 AS `Onmanshons__galleryTxt4`, Onmanshons.galleryTxt5 AS `Onmanshons__galleryTxt5`, Onmanshons.galleryTxt6 AS `Onmanshons__galleryTxt6`, Onmanshons.galleryTxt7 AS `Onmanshons__galleryTxt7`, Onmanshons.galleryTxt8 AS `Onmanshons__galleryTxt8`, Onmanshons.galleryTxt9 AS `Onmanshons__galleryTxt9`, Onmanshons.galleryTxt10 AS `Onmanshons__galleryTxt10`, Onmanshons.galleryTxt11 AS `Onmanshons__galleryTxt11`, Onmanshons.galleryTxt12 AS `Onmanshons__galleryTxt12`, Onmanshons.galleryTxt13 AS `Onmanshons__galleryTxt13`, Onmanshons.galleryTxt14 AS `Onmanshons__galleryTxt14`, Onmanshons.galleryTxt15 AS `Onmanshons__galleryTxt15`, Onmanshons.galleryTxt16 AS `Onmanshons__galleryTxt16`, Onmanshons.galleryTxt17 AS `Onmanshons__galleryTxt17`, Onmanshons.galleryTxt18 AS `Onmanshons__galleryTxt18`, Onmanshons.locationTraffic AS `Onmanshons__locationTraffic`, Onmanshons.locationSchool AS `Onmanshons__locationSchool`, Onmanshons.locationLife AS `Onmanshons__locationLife`, Onmanshons.locationOther AS `Onmanshons__locationOther`, Onmanshons.planFlg AS `Onmanshons__planFlg`, Onmanshons.outlinePrice AS `Onmanshons__outlinePrice`, Onmanshons.outlinePriceNum AS `Onmanshons__outlinePriceNum`, Onmanshons.outlinePlace AS `Onmanshons__outlinePlace`, Onmanshons.outlineTraffic AS `Onmanshons__outlineTraffic`, Onmanshons.outlineChiken AS `Onmanshons__outlineChiken`, Onmanshons.outlineSite AS `Onmanshons__outlineSite`, Onmanshons.outlineRoomSite AS `Onmanshons__outlineRoomSite`, Onmanshons.outlineUse1 AS `Onmanshons__outlineUse1`, Onmanshons.outlineUse2 AS `Onmanshons__outlineUse2`, Onmanshons.outlinePlots AS `Onmanshons__outlinePlots`, Onmanshons.outlineConstruction AS `Onmanshons__outlineConstruction`, Onmanshons.outlineFloorPlan AS `Onmanshons__outlineFloorPlan`, Onmanshons.outlineCompTime AS `Onmanshons__outlineCompTime`, Onmanshons.outlineSaleCo AS `Onmanshons__outlineSaleCo`, Onmanshons.outlineSekoCo AS `Onmanshons__outlineSekoCo`, Onmanshons.outlineManaCo AS `Onmanshons__outlineManaCo`, Onmanshons.outlineManeForm AS `Onmanshons__outlineManeForm`, Onmanshons.outlineManaMeth AS `Onmanshons__outlineManaMeth`, Onmanshons.outlineParkYesNo AS `Onmanshons__outlineParkYesNo`, Onmanshons.outlineParkAkiYesNo AS `Onmanshons__outlineParkAkiYesNo`, Onmanshons.outlineParkPrice AS `Onmanshons__outlineParkPrice`, Onmanshons.outlineParkPrice2 AS `Onmanshons__outlineParkPrice2`, Onmanshons.outlineTrunkYesNo AS `Onmanshons__outlineTrunkYesNo`, Onmanshons.outlineHotWater AS `Onmanshons__outlineHotWater`, Onmanshons.outlineGas AS `Onmanshons__outlineGas`, Onmanshons.outlineElevatorYesNo AS `Onmanshons__outlineElevatorYesNo`, Onmanshons.outlineDeliBoxYesNo AS `Onmanshons__outlineDeliBoxYesNo`, Onmanshons.outlinePetYesNo AS `Onmanshons__outlinePetYesNo`, Onmanshons.outlinePetRoules AS `Onmanshons__outlinePetRoules`, Onmanshons.outlineDelivTime AS `Onmanshons__outlineDelivTime`, Onmanshons.outlineTransForm AS `Onmanshons__outlineTransForm`, Onmanshons.outlineEquipment AS `Onmanshons__outlineEquipment`, Onmanshons.outlineComment AS `Onmanshons__outlineComment`, Onmanshons.outlineSchool AS `Onmanshons__outlineSchool`, Onmanshons.googleMap AS `Onmanshons__googleMap`, Onmanshons.memo AS `Onmanshons__memo`, Onmanshons.priceFlg AS `Onmanshons__priceFlg`, Onmanshons.newFlg AS `Onmanshons__newFlg`, Onmanshons.lastFlg AS `Onmanshons__lastFlg`, Onmanshons.topImgFlg AS `Onmanshons__topImgFlg`, Onmanshons.memberFlg AS `Onmanshons__memberFlg`, Onmanshons.deleteFlg AS `Onmanshons__deleteFlg`, Onmanshons.created AS `Onmanshons__created`, Onmanshons.modified AS `Onmanshons__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onmanshons Onmanshons INNER JOIN areas Areas ON Areas.id = (Onmanshons.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onmanshons.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onmanshons.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onmanshons.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onmanshons.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onmanshons.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onmanshons.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onmanshons.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onmanshons.station_id3) WHERE Onmanshons.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnmanshonsTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '37', 'CtM' => '13' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '20', 'CtM' => '3' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '9', 'CtM' => '1' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '1', 'CtM' => '1' ], (int) 4 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '4', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 8 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '2' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '56' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '1' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '56' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '24' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '1' ], (int) 10 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '1' ], (int) 11 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '20' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '4' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 15, 'pet' => (int) 8, 'life' => (int) 57, 'space' => (int) 16 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onmanshons = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onmanshons.id AS `Onmanshons__id`, Onmanshons.name AS `Onmanshons__name`, Onmanshons.mbAddress AS `Onmanshons__mbAddress`, Onmanshons.displayFlg AS `Onmanshons__displayFlg`, Onmanshons.statusFlg AS `Onmanshons__statusFlg`, Onmanshons.area_id AS `Onmanshons__area_id`, Onmanshons.kind_id AS `Onmanshons__kind_id`, Onmanshons.newoldFlg AS `Onmanshons__newoldFlg`, Onmanshons.tour_id AS `Onmanshons__tour_id`, Onmanshons.topDispFlg AS `Onmanshons__topDispFlg`, Onmanshons.recommFlg AS `Onmanshons__recommFlg`, Onmanshons.railway_id1 AS `Onmanshons__railway_id1`, Onmanshons.railway_id2 AS `Onmanshons__railway_id2`, Onmanshons.railway_id3 AS `Onmanshons__railway_id3`, Onmanshons.station_id1 AS `Onmanshons__station_id1`, Onmanshons.station_id2 AS `Onmanshons__station_id2`, Onmanshons.station_id3 AS `Onmanshons__station_id3`, Onmanshons.stwalk1 AS `Onmanshons__stwalk1`, Onmanshons.stwalk2 AS `Onmanshons__stwalk2`, Onmanshons.stwalk3 AS `Onmanshons__stwalk3`, Onmanshons.bswalk1 AS `Onmanshons__bswalk1`, Onmanshons.bswalk2 AS `Onmanshons__bswalk2`, Onmanshons.bswalk3 AS `Onmanshons__bswalk3`, Onmanshons.catchCopy AS `Onmanshons__catchCopy`, Onmanshons.stationStart AS `Onmanshons__stationStart`, Onmanshons.stationTo1 AS `Onmanshons__stationTo1`, Onmanshons.stationTo2 AS `Onmanshons__stationTo2`, Onmanshons.stationTo3 AS `Onmanshons__stationTo3`, Onmanshons.stationTo4 AS `Onmanshons__stationTo4`, Onmanshons.trainTime1 AS `Onmanshons__trainTime1`, Onmanshons.trainTime2 AS `Onmanshons__trainTime2`, Onmanshons.trainTime3 AS `Onmanshons__trainTime3`, Onmanshons.trainTime4 AS `Onmanshons__trainTime4`, Onmanshons.trainDirect1 AS `Onmanshons__trainDirect1`, Onmanshons.trainDirect2 AS `Onmanshons__trainDirect2`, Onmanshons.trainDirect3 AS `Onmanshons__trainDirect3`, Onmanshons.trainDirect4 AS `Onmanshons__trainDirect4`, Onmanshons.trainVia1 AS `Onmanshons__trainVia1`, Onmanshons.trainVia2 AS `Onmanshons__trainVia2`, Onmanshons.trainVia3 AS `Onmanshons__trainVia3`, Onmanshons.trainVia4 AS `Onmanshons__trainVia4`, Onmanshons.locationFlg AS `Onmanshons__locationFlg`, Onmanshons.locationTitle1 AS `Onmanshons__locationTitle1`, Onmanshons.locationTitle2 AS `Onmanshons__locationTitle2`, Onmanshons.locationTxt1 AS `Onmanshons__locationTxt1`, Onmanshons.locationTxt2 AS `Onmanshons__locationTxt2`, Onmanshons.locationTxt3 AS `Onmanshons__locationTxt3`, Onmanshons.locationTxt4 AS `Onmanshons__locationTxt4`, Onmanshons.locationTxt5 AS `Onmanshons__locationTxt5`, Onmanshons.locationTxt6 AS `Onmanshons__locationTxt6`, Onmanshons.locationTxt7 AS `Onmanshons__locationTxt7`, Onmanshons.locationTxt8 AS `Onmanshons__locationTxt8`, Onmanshons.locationTxt9 AS `Onmanshons__locationTxt9`, Onmanshons.locationTxt10 AS `Onmanshons__locationTxt10`, Onmanshons.locationTxt11 AS `Onmanshons__locationTxt11`, Onmanshons.locationTxt12 AS `Onmanshons__locationTxt12`, Onmanshons.locationTxt13 AS `Onmanshons__locationTxt13`, Onmanshons.locationTxt14 AS `Onmanshons__locationTxt14`, Onmanshons.locationTxt15 AS `Onmanshons__locationTxt15`, Onmanshons.locationTxt16 AS `Onmanshons__locationTxt16`, Onmanshons.locationTxt17 AS `Onmanshons__locationTxt17`, Onmanshons.locationTxt18 AS `Onmanshons__locationTxt18`, Onmanshons.galleryTxt1 AS `Onmanshons__galleryTxt1`, Onmanshons.galleryTxt2 AS `Onmanshons__galleryTxt2`, Onmanshons.galleryTxt3 AS `Onmanshons__galleryTxt3`, Onmanshons.galleryTxt4 AS `Onmanshons__galleryTxt4`, Onmanshons.galleryTxt5 AS `Onmanshons__galleryTxt5`, Onmanshons.galleryTxt6 AS `Onmanshons__galleryTxt6`, Onmanshons.galleryTxt7 AS `Onmanshons__galleryTxt7`, Onmanshons.galleryTxt8 AS `Onmanshons__galleryTxt8`, Onmanshons.galleryTxt9 AS `Onmanshons__galleryTxt9`, Onmanshons.galleryTxt10 AS `Onmanshons__galleryTxt10`, Onmanshons.galleryTxt11 AS `Onmanshons__galleryTxt11`, Onmanshons.galleryTxt12 AS `Onmanshons__galleryTxt12`, Onmanshons.galleryTxt13 AS `Onmanshons__galleryTxt13`, Onmanshons.galleryTxt14 AS `Onmanshons__galleryTxt14`, Onmanshons.galleryTxt15 AS `Onmanshons__galleryTxt15`, Onmanshons.galleryTxt16 AS `Onmanshons__galleryTxt16`, Onmanshons.galleryTxt17 AS `Onmanshons__galleryTxt17`, Onmanshons.galleryTxt18 AS `Onmanshons__galleryTxt18`, Onmanshons.locationTraffic AS `Onmanshons__locationTraffic`, Onmanshons.locationSchool AS `Onmanshons__locationSchool`, Onmanshons.locationLife AS `Onmanshons__locationLife`, Onmanshons.locationOther AS `Onmanshons__locationOther`, Onmanshons.planFlg AS `Onmanshons__planFlg`, Onmanshons.outlinePrice AS `Onmanshons__outlinePrice`, Onmanshons.outlinePriceNum AS `Onmanshons__outlinePriceNum`, Onmanshons.outlinePlace AS `Onmanshons__outlinePlace`, Onmanshons.outlineTraffic AS `Onmanshons__outlineTraffic`, Onmanshons.outlineChiken AS `Onmanshons__outlineChiken`, Onmanshons.outlineSite AS `Onmanshons__outlineSite`, Onmanshons.outlineRoomSite AS `Onmanshons__outlineRoomSite`, Onmanshons.outlineUse1 AS `Onmanshons__outlineUse1`, Onmanshons.outlineUse2 AS `Onmanshons__outlineUse2`, Onmanshons.outlinePlots AS `Onmanshons__outlinePlots`, Onmanshons.outlineConstruction AS `Onmanshons__outlineConstruction`, Onmanshons.outlineFloorPlan AS `Onmanshons__outlineFloorPlan`, Onmanshons.outlineCompTime AS `Onmanshons__outlineCompTime`, Onmanshons.outlineSaleCo AS `Onmanshons__outlineSaleCo`, Onmanshons.outlineSekoCo AS `Onmanshons__outlineSekoCo`, Onmanshons.outlineManaCo AS `Onmanshons__outlineManaCo`, Onmanshons.outlineManeForm AS `Onmanshons__outlineManeForm`, Onmanshons.outlineManaMeth AS `Onmanshons__outlineManaMeth`, Onmanshons.outlineParkYesNo AS `Onmanshons__outlineParkYesNo`, Onmanshons.outlineParkAkiYesNo AS `Onmanshons__outlineParkAkiYesNo`, Onmanshons.outlineParkPrice AS `Onmanshons__outlineParkPrice`, Onmanshons.outlineParkPrice2 AS `Onmanshons__outlineParkPrice2`, Onmanshons.outlineTrunkYesNo AS `Onmanshons__outlineTrunkYesNo`, Onmanshons.outlineHotWater AS `Onmanshons__outlineHotWater`, Onmanshons.outlineGas AS `Onmanshons__outlineGas`, Onmanshons.outlineElevatorYesNo AS `Onmanshons__outlineElevatorYesNo`, Onmanshons.outlineDeliBoxYesNo AS `Onmanshons__outlineDeliBoxYesNo`, Onmanshons.outlinePetYesNo AS `Onmanshons__outlinePetYesNo`, Onmanshons.outlinePetRoules AS `Onmanshons__outlinePetRoules`, Onmanshons.outlineDelivTime AS `Onmanshons__outlineDelivTime`, Onmanshons.outlineTransForm AS `Onmanshons__outlineTransForm`, Onmanshons.outlineEquipment AS `Onmanshons__outlineEquipment`, Onmanshons.outlineComment AS `Onmanshons__outlineComment`, Onmanshons.outlineSchool AS `Onmanshons__outlineSchool`, Onmanshons.googleMap AS `Onmanshons__googleMap`, Onmanshons.memo AS `Onmanshons__memo`, Onmanshons.priceFlg AS `Onmanshons__priceFlg`, Onmanshons.newFlg AS `Onmanshons__newFlg`, Onmanshons.lastFlg AS `Onmanshons__lastFlg`, Onmanshons.topImgFlg AS `Onmanshons__topImgFlg`, Onmanshons.memberFlg AS `Onmanshons__memberFlg`, Onmanshons.deleteFlg AS `Onmanshons__deleteFlg`, Onmanshons.created AS `Onmanshons__created`, Onmanshons.modified AS `Onmanshons__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onmanshons Onmanshons INNER JOIN areas Areas ON Areas.id = (Onmanshons.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onmanshons.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onmanshons.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onmanshons.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onmanshons.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onmanshons.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onmanshons.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onmanshons.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onmanshons.station_id3) WHERE Onmanshons.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onmanshons__id' => 'integer', 'Onmanshons.id' => 'integer', 'id' => 'integer', 'Onmanshons__name' => 'string', 'Onmanshons.name' => 'string', 'name' => 'string', 'Onmanshons__mbAddress' => 'string', 'Onmanshons.mbAddress' => 'string', 'mbAddress' => 'string', 'Onmanshons__displayFlg' => 'tinyinteger', 'Onmanshons.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onmanshons__statusFlg' => 'tinyinteger', 'Onmanshons.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onmanshons__area_id' => 'integer', 'Onmanshons.area_id' => 'integer', 'area_id' => 'integer', 'Onmanshons__kind_id' => 'integer', 'Onmanshons.kind_id' => 'integer', 'kind_id' => 'integer', 'Onmanshons__newoldFlg' => 'tinyinteger', 'Onmanshons.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onmanshons__tour_id' => 'integer', 'Onmanshons.tour_id' => 'integer', 'tour_id' => 'integer', 'Onmanshons__topDispFlg' => 'tinyinteger', 'Onmanshons.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onmanshons__recommFlg' => 'tinyinteger', 'Onmanshons.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onmanshons__railway_id1' => 'integer', 'Onmanshons.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onmanshons__railway_id2' => 'integer', 'Onmanshons.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onmanshons__railway_id3' => 'integer', 'Onmanshons.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onmanshons__station_id1' => 'integer', 'Onmanshons.station_id1' => 'integer', 'station_id1' => 'integer', 'Onmanshons__station_id2' => 'integer', 'Onmanshons.station_id2' => 'integer', 'station_id2' => 'integer', 'Onmanshons__station_id3' => 'integer', 'Onmanshons.station_id3' => 'integer', 'station_id3' => 'integer', 'Onmanshons__stwalk1' => 'string', 'Onmanshons.stwalk1' => 'string', 'stwalk1' => 'string', 'Onmanshons__stwalk2' => 'string', 'Onmanshons.stwalk2' => 'string', 'stwalk2' => 'string', 'Onmanshons__stwalk3' => 'string', 'Onmanshons.stwalk3' => 'string', 'stwalk3' => 'string', 'Onmanshons__bswalk1' => 'string', 'Onmanshons.bswalk1' => 'string', 'bswalk1' => 'string', 'Onmanshons__bswalk2' => 'string', 'Onmanshons.bswalk2' => 'string', 'bswalk2' => 'string', 'Onmanshons__bswalk3' => 'string', 'Onmanshons.bswalk3' => 'string', 'bswalk3' => 'string', 'Onmanshons__catchCopy' => 'string', 'Onmanshons.catchCopy' => 'string', 'catchCopy' => 'string', 'Onmanshons__stationStart' => 'string', 'Onmanshons.stationStart' => 'string', 'stationStart' => 'string', 'Onmanshons__stationTo1' => 'string', 'Onmanshons.stationTo1' => 'string', 'stationTo1' => 'string', 'Onmanshons__stationTo2' => 'string', 'Onmanshons.stationTo2' => 'string', 'stationTo2' => 'string', 'Onmanshons__stationTo3' => 'string', 'Onmanshons.stationTo3' => 'string', 'stationTo3' => 'string', 'Onmanshons__stationTo4' => 'string', 'Onmanshons.stationTo4' => 'string', 'stationTo4' => 'string', 'Onmanshons__trainTime1' => 'tinyinteger', 'Onmanshons.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onmanshons__trainTime2' => 'tinyinteger', 'Onmanshons.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onmanshons__trainTime3' => 'tinyinteger', 'Onmanshons.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onmanshons__trainTime4' => 'tinyinteger', 'Onmanshons.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onmanshons__trainDirect1' => 'tinyinteger', 'Onmanshons.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onmanshons__trainDirect2' => 'tinyinteger', 'Onmanshons.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onmanshons__trainDirect3' => 'tinyinteger', 'Onmanshons.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onmanshons__trainDirect4' => 'tinyinteger', 'Onmanshons.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onmanshons__trainVia1' => 'string', 'Onmanshons.trainVia1' => 'string', 'trainVia1' => 'string', 'Onmanshons__trainVia2' => 'string', 'Onmanshons.trainVia2' => 'string', 'trainVia2' => 'string', 'Onmanshons__trainVia3' => 'string', 'Onmanshons.trainVia3' => 'string', 'trainVia3' => 'string', 'Onmanshons__trainVia4' => 'string', 'Onmanshons.trainVia4' => 'string', 'trainVia4' => 'string', 'Onmanshons__locationFlg' => 'tinyinteger', 'Onmanshons.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onmanshons__locationTitle1' => 'string', 'Onmanshons.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onmanshons__locationTitle2' => 'string', 'Onmanshons.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onmanshons__locationTxt1' => 'string', 'Onmanshons.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onmanshons__locationTxt2' => 'string', 'Onmanshons.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onmanshons__locationTxt3' => 'string', 'Onmanshons.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onmanshons__locationTxt4' => 'string', 'Onmanshons.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onmanshons__locationTxt5' => 'string', 'Onmanshons.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onmanshons__locationTxt6' => 'string', 'Onmanshons.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onmanshons__locationTxt7' => 'string', 'Onmanshons.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onmanshons__locationTxt8' => 'string', 'Onmanshons.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onmanshons__locationTxt9' => 'string', 'Onmanshons.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onmanshons__locationTxt10' => 'string', 'Onmanshons.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onmanshons__locationTxt11' => 'string', 'Onmanshons.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onmanshons__locationTxt12' => 'string', 'Onmanshons.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onmanshons__locationTxt13' => 'string', 'Onmanshons.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onmanshons__locationTxt14' => 'string', 'Onmanshons.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onmanshons__locationTxt15' => 'string', 'Onmanshons.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onmanshons__locationTxt16' => 'string', 'Onmanshons.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onmanshons__locationTxt17' => 'string', 'Onmanshons.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onmanshons__locationTxt18' => 'string', 'Onmanshons.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onmanshons__galleryTxt1' => 'string', 'Onmanshons.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onmanshons__galleryTxt2' => 'string', 'Onmanshons.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onmanshons__galleryTxt3' => 'string', 'Onmanshons.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onmanshons__galleryTxt4' => 'string', 'Onmanshons.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onmanshons__galleryTxt5' => 'string', 'Onmanshons.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onmanshons__galleryTxt6' => 'string', 'Onmanshons.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onmanshons__galleryTxt7' => 'string', 'Onmanshons.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onmanshons__galleryTxt8' => 'string', 'Onmanshons.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onmanshons__galleryTxt9' => 'string', 'Onmanshons.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onmanshons__galleryTxt10' => 'string', 'Onmanshons.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onmanshons__galleryTxt11' => 'string', 'Onmanshons.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onmanshons__galleryTxt12' => 'string', 'Onmanshons.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onmanshons__galleryTxt13' => 'string', 'Onmanshons.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onmanshons__galleryTxt14' => 'string', 'Onmanshons.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onmanshons__galleryTxt15' => 'string', 'Onmanshons.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onmanshons__galleryTxt16' => 'string', 'Onmanshons.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onmanshons__galleryTxt17' => 'string', 'Onmanshons.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onmanshons__galleryTxt18' => 'string', 'Onmanshons.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onmanshons__locationTraffic' => 'string', 'Onmanshons.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onmanshons__locationSchool' => 'string', 'Onmanshons.locationSchool' => 'string', 'locationSchool' => 'string', 'Onmanshons__locationLife' => 'string', 'Onmanshons.locationLife' => 'string', 'locationLife' => 'string', 'Onmanshons__locationOther' => 'string', 'Onmanshons.locationOther' => 'string', 'locationOther' => 'string', 'Onmanshons__planFlg' => 'tinyinteger', 'Onmanshons.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onmanshons__outlinePrice' => 'string', 'Onmanshons.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onmanshons__outlinePriceNum' => 'integer', 'Onmanshons.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onmanshons__outlinePlace' => 'string', 'Onmanshons.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onmanshons__outlineTraffic' => 'string', 'Onmanshons.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onmanshons__outlineChiken' => 'tinyinteger', 'Onmanshons.outlineChiken' => 'tinyinteger', 'outlineChiken' => 'tinyinteger', 'Onmanshons__outlineSite' => 'string', 'Onmanshons.outlineSite' => 'string', 'outlineSite' => 'string', 'Onmanshons__outlineRoomSite' => 'string', 'Onmanshons.outlineRoomSite' => 'string', 'outlineRoomSite' => 'string', 'Onmanshons__outlineUse1' => 'string', 'Onmanshons.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onmanshons__outlineUse2' => 'string', 'Onmanshons.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onmanshons__outlinePlots' => 'integer', 'Onmanshons.outlinePlots' => 'integer', 'outlinePlots' => 'integer', 'Onmanshons__outlineConstruction' => 'string', 'Onmanshons.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onmanshons__outlineFloorPlan' => 'string', 'Onmanshons.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onmanshons__outlineCompTime' => 'string', 'Onmanshons.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onmanshons__outlineSaleCo' => 'string', 'Onmanshons.outlineSaleCo' => 'string', 'outlineSaleCo' => 'string', 'Onmanshons__outlineSekoCo' => 'string', 'Onmanshons.outlineSekoCo' => 'string', 'outlineSekoCo' => 'string', 'Onmanshons__outlineManaCo' => 'string', 'Onmanshons.outlineManaCo' => 'string', 'outlineManaCo' => 'string', 'Onmanshons__outlineManeForm' => 'string', 'Onmanshons.outlineManeForm' => 'string', 'outlineManeForm' => 'string', 'Onmanshons__outlineManaMeth' => 'string', 'Onmanshons.outlineManaMeth' => 'string', 'outlineManaMeth' => 'string', 'Onmanshons__outlineParkYesNo' => 'tinyinteger', 'Onmanshons.outlineParkYesNo' => 'tinyinteger', 'outlineParkYesNo' => 'tinyinteger', 'Onmanshons__outlineParkAkiYesNo' => 'tinyinteger', 'Onmanshons.outlineParkAkiYesNo' => 'tinyinteger', 'outlineParkAkiYesNo' => 'tinyinteger', 'Onmanshons__outlineParkPrice' => 'decimal', 'Onmanshons.outlineParkPrice' => 'decimal', 'outlineParkPrice' => 'decimal', 'Onmanshons__outlineParkPrice2' => 'decimal', 'Onmanshons.outlineParkPrice2' => 'decimal', 'outlineParkPrice2' => 'decimal', 'Onmanshons__outlineTrunkYesNo' => 'tinyinteger', 'Onmanshons.outlineTrunkYesNo' => 'tinyinteger', 'outlineTrunkYesNo' => 'tinyinteger', 'Onmanshons__outlineHotWater' => 'string', 'Onmanshons.outlineHotWater' => 'string', 'outlineHotWater' => 'string', 'Onmanshons__outlineGas' => 'string', 'Onmanshons.outlineGas' => 'string', 'outlineGas' => 'string', 'Onmanshons__outlineElevatorYesNo' => 'tinyinteger', 'Onmanshons.outlineElevatorYesNo' => 'tinyinteger', 'outlineElevatorYesNo' => 'tinyinteger', 'Onmanshons__outlineDeliBoxYesNo' => 'tinyinteger', 'Onmanshons.outlineDeliBoxYesNo' => 'tinyinteger', 'outlineDeliBoxYesNo' => 'tinyinteger', 'Onmanshons__outlinePetYesNo' => 'tinyinteger', 'Onmanshons.outlinePetYesNo' => 'tinyinteger', 'outlinePetYesNo' => 'tinyinteger', 'Onmanshons__outlinePetRoules' => 'string', 'Onmanshons.outlinePetRoules' => 'string', 'outlinePetRoules' => 'string', 'Onmanshons__outlineDelivTime' => 'string', 'Onmanshons.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onmanshons__outlineTransForm' => 'string', 'Onmanshons.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onmanshons__outlineEquipment' => 'string', 'Onmanshons.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onmanshons__outlineComment' => 'string', 'Onmanshons.outlineComment' => 'string', 'outlineComment' => 'string', 'Onmanshons__outlineSchool' => 'string', 'Onmanshons.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onmanshons__googleMap' => 'string', 'Onmanshons.googleMap' => 'string', 'googleMap' => 'string', 'Onmanshons__memo' => 'string', 'Onmanshons.memo' => 'string', 'memo' => 'string', 'Onmanshons__priceFlg' => 'tinyinteger', 'Onmanshons.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onmanshons__newFlg' => 'tinyinteger', 'Onmanshons.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onmanshons__lastFlg' => 'tinyinteger', 'Onmanshons.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onmanshons__topImgFlg' => 'tinyinteger', 'Onmanshons.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onmanshons__memberFlg' => 'tinyinteger', 'Onmanshons.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onmanshons__deleteFlg' => 'tinyinteger', 'Onmanshons.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onmanshons__created' => 'datetime', 'Onmanshons.created' => 'datetime', 'created' => 'datetime', 'Onmanshons__modified' => 'datetime', 'Onmanshons.modified' => 'datetime', 'modified' => 'datetime', 'Manshons__id' => 'integer', 'Manshons.id' => 'integer', 'Manshons__onmanshon_id' => 'integer', 'Manshons.onmanshon_id' => 'integer', 'onmanshon_id' => 'integer', 'Manshons__displayFlg' => 'tinyinteger', 'Manshons.displayFlg' => 'tinyinteger', 'Manshons__statusFlg' => 'tinyinteger', 'Manshons.statusFlg' => 'tinyinteger', 'Manshons__nowStatus' => 'string', 'Manshons.nowStatus' => 'string', 'nowStatus' => 'string', 'Manshons__name' => 'string', 'Manshons.name' => 'string', 'Manshons__floor' => 'string', 'Manshons.floor' => 'string', 'floor' => 'string', 'Manshons__roomFloor' => 'string', 'Manshons.roomFloor' => 'string', 'roomFloor' => 'string', 'Manshons__shareArea' => 'string', 'Manshons.shareArea' => 'string', 'shareArea' => 'string', 'Manshons__roomArea' => 'decimal', 'Manshons.roomArea' => 'decimal', 'roomArea' => 'decimal', 'Manshons__valconyArea' => 'decimal', 'Manshons.valconyArea' => 'decimal', 'valconyArea' => 'decimal', 'Manshons__valconyFor' => 'string', 'Manshons.valconyFor' => 'string', 'valconyFor' => 'string', 'Manshons__reformYesNo' => 'tinyinteger', 'Manshons.reformYesNo' => 'tinyinteger', 'reformYesNo' => 'tinyinteger', 'Manshons__reformContents' => 'string', 'Manshons.reformContents' => 'string', 'reformContents' => 'string', 'Manshons__price' => 'decimal', 'Manshons.price' => 'decimal', 'price' => 'decimal', 'Manshons__PlanImgFlg' => 'tinyinteger', 'Manshons.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Manshons__manageCost' => 'decimal', 'Manshons.manageCost' => 'decimal', 'manageCost' => 'decimal', 'Manshons__repairCost' => 'decimal', 'Manshons.repairCost' => 'decimal', 'repairCost' => 'decimal', 'Manshons__otherCost' => 'decimal', 'Manshons.otherCost' => 'decimal', 'otherCost' => 'decimal', 'Manshons__totalCost' => 'decimal', 'Manshons.totalCost' => 'decimal', 'totalCost' => 'decimal', 'Manshons__comment' => 'string', 'Manshons.comment' => 'string', 'comment' => 'string', 'Manshons__memo' => 'string', 'Manshons.memo' => 'string', 'Manshons__areaCD' => 'integer', 'Manshons.areaCD' => 'integer', 'areaCD' => 'integer', 'Manshons__created' => 'datetime', 'Manshons.created' => 'datetime', 'Manshons__modified' => 'datetime', 'Manshons.modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'manshons' => [[maximum depth reached]], 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnmanshonsTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '37', 'CtM' => '13' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '20', 'CtM' => '3' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '9', 'CtM' => '1' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '1', 'CtM' => '1' ], (int) 4 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '4', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 8 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '2' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '56' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '1' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '56' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '24' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '1' ], (int) 10 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '1' ], (int) 11 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '20' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '4' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 15, 'pet' => (int) 8, 'life' => (int) 57, 'space' => (int) 16 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onmanshons/view.ctp, line 915 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Warning (2): Invalid argument supplied for foreach() [APP/Template/Element/search_Area_Railway.ctp, line 89]Code Context<?phpforeach($area_results_member as $key => $dat){?>$viewFile = '/data/WWW/rainbow/test.life-hf.co.jp/htdocs/src/Template/Element/search_Area_Railway.ctp' $dataForView = [ 'Onmanshons' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onmanshons.id AS `Onmanshons__id`, Onmanshons.name AS `Onmanshons__name`, Onmanshons.mbAddress AS `Onmanshons__mbAddress`, Onmanshons.displayFlg AS `Onmanshons__displayFlg`, Onmanshons.statusFlg AS `Onmanshons__statusFlg`, Onmanshons.area_id AS `Onmanshons__area_id`, Onmanshons.kind_id AS `Onmanshons__kind_id`, Onmanshons.newoldFlg AS `Onmanshons__newoldFlg`, Onmanshons.tour_id AS `Onmanshons__tour_id`, Onmanshons.topDispFlg AS `Onmanshons__topDispFlg`, Onmanshons.recommFlg AS `Onmanshons__recommFlg`, Onmanshons.railway_id1 AS `Onmanshons__railway_id1`, Onmanshons.railway_id2 AS `Onmanshons__railway_id2`, Onmanshons.railway_id3 AS `Onmanshons__railway_id3`, Onmanshons.station_id1 AS `Onmanshons__station_id1`, Onmanshons.station_id2 AS `Onmanshons__station_id2`, Onmanshons.station_id3 AS `Onmanshons__station_id3`, Onmanshons.stwalk1 AS `Onmanshons__stwalk1`, Onmanshons.stwalk2 AS `Onmanshons__stwalk2`, Onmanshons.stwalk3 AS `Onmanshons__stwalk3`, Onmanshons.bswalk1 AS `Onmanshons__bswalk1`, Onmanshons.bswalk2 AS `Onmanshons__bswalk2`, Onmanshons.bswalk3 AS `Onmanshons__bswalk3`, Onmanshons.catchCopy AS `Onmanshons__catchCopy`, Onmanshons.stationStart AS `Onmanshons__stationStart`, Onmanshons.stationTo1 AS `Onmanshons__stationTo1`, Onmanshons.stationTo2 AS `Onmanshons__stationTo2`, Onmanshons.stationTo3 AS `Onmanshons__stationTo3`, Onmanshons.stationTo4 AS `Onmanshons__stationTo4`, Onmanshons.trainTime1 AS `Onmanshons__trainTime1`, Onmanshons.trainTime2 AS `Onmanshons__trainTime2`, Onmanshons.trainTime3 AS `Onmanshons__trainTime3`, Onmanshons.trainTime4 AS `Onmanshons__trainTime4`, Onmanshons.trainDirect1 AS `Onmanshons__trainDirect1`, Onmanshons.trainDirect2 AS `Onmanshons__trainDirect2`, Onmanshons.trainDirect3 AS `Onmanshons__trainDirect3`, Onmanshons.trainDirect4 AS `Onmanshons__trainDirect4`, Onmanshons.trainVia1 AS `Onmanshons__trainVia1`, Onmanshons.trainVia2 AS `Onmanshons__trainVia2`, Onmanshons.trainVia3 AS `Onmanshons__trainVia3`, Onmanshons.trainVia4 AS `Onmanshons__trainVia4`, Onmanshons.locationFlg AS `Onmanshons__locationFlg`, Onmanshons.locationTitle1 AS `Onmanshons__locationTitle1`, Onmanshons.locationTitle2 AS `Onmanshons__locationTitle2`, Onmanshons.locationTxt1 AS `Onmanshons__locationTxt1`, Onmanshons.locationTxt2 AS `Onmanshons__locationTxt2`, Onmanshons.locationTxt3 AS `Onmanshons__locationTxt3`, Onmanshons.locationTxt4 AS `Onmanshons__locationTxt4`, Onmanshons.locationTxt5 AS `Onmanshons__locationTxt5`, Onmanshons.locationTxt6 AS `Onmanshons__locationTxt6`, Onmanshons.locationTxt7 AS `Onmanshons__locationTxt7`, Onmanshons.locationTxt8 AS `Onmanshons__locationTxt8`, Onmanshons.locationTxt9 AS `Onmanshons__locationTxt9`, Onmanshons.locationTxt10 AS `Onmanshons__locationTxt10`, Onmanshons.locationTxt11 AS `Onmanshons__locationTxt11`, Onmanshons.locationTxt12 AS `Onmanshons__locationTxt12`, Onmanshons.locationTxt13 AS `Onmanshons__locationTxt13`, Onmanshons.locationTxt14 AS `Onmanshons__locationTxt14`, Onmanshons.locationTxt15 AS `Onmanshons__locationTxt15`, Onmanshons.locationTxt16 AS `Onmanshons__locationTxt16`, Onmanshons.locationTxt17 AS `Onmanshons__locationTxt17`, Onmanshons.locationTxt18 AS `Onmanshons__locationTxt18`, Onmanshons.galleryTxt1 AS `Onmanshons__galleryTxt1`, Onmanshons.galleryTxt2 AS `Onmanshons__galleryTxt2`, Onmanshons.galleryTxt3 AS `Onmanshons__galleryTxt3`, Onmanshons.galleryTxt4 AS `Onmanshons__galleryTxt4`, Onmanshons.galleryTxt5 AS `Onmanshons__galleryTxt5`, Onmanshons.galleryTxt6 AS `Onmanshons__galleryTxt6`, Onmanshons.galleryTxt7 AS `Onmanshons__galleryTxt7`, Onmanshons.galleryTxt8 AS `Onmanshons__galleryTxt8`, Onmanshons.galleryTxt9 AS `Onmanshons__galleryTxt9`, Onmanshons.galleryTxt10 AS `Onmanshons__galleryTxt10`, Onmanshons.galleryTxt11 AS `Onmanshons__galleryTxt11`, Onmanshons.galleryTxt12 AS `Onmanshons__galleryTxt12`, Onmanshons.galleryTxt13 AS `Onmanshons__galleryTxt13`, Onmanshons.galleryTxt14 AS `Onmanshons__galleryTxt14`, Onmanshons.galleryTxt15 AS `Onmanshons__galleryTxt15`, Onmanshons.galleryTxt16 AS `Onmanshons__galleryTxt16`, Onmanshons.galleryTxt17 AS `Onmanshons__galleryTxt17`, Onmanshons.galleryTxt18 AS `Onmanshons__galleryTxt18`, Onmanshons.locationTraffic AS `Onmanshons__locationTraffic`, Onmanshons.locationSchool AS `Onmanshons__locationSchool`, Onmanshons.locationLife AS `Onmanshons__locationLife`, Onmanshons.locationOther AS `Onmanshons__locationOther`, Onmanshons.planFlg AS `Onmanshons__planFlg`, Onmanshons.outlinePrice AS `Onmanshons__outlinePrice`, Onmanshons.outlinePriceNum AS `Onmanshons__outlinePriceNum`, Onmanshons.outlinePlace AS `Onmanshons__outlinePlace`, Onmanshons.outlineTraffic AS `Onmanshons__outlineTraffic`, Onmanshons.outlineChiken AS `Onmanshons__outlineChiken`, Onmanshons.outlineSite AS `Onmanshons__outlineSite`, Onmanshons.outlineRoomSite AS `Onmanshons__outlineRoomSite`, Onmanshons.outlineUse1 AS `Onmanshons__outlineUse1`, Onmanshons.outlineUse2 AS `Onmanshons__outlineUse2`, Onmanshons.outlinePlots AS `Onmanshons__outlinePlots`, Onmanshons.outlineConstruction AS `Onmanshons__outlineConstruction`, Onmanshons.outlineFloorPlan AS `Onmanshons__outlineFloorPlan`, Onmanshons.outlineCompTime AS `Onmanshons__outlineCompTime`, Onmanshons.outlineSaleCo AS `Onmanshons__outlineSaleCo`, Onmanshons.outlineSekoCo AS `Onmanshons__outlineSekoCo`, Onmanshons.outlineManaCo AS `Onmanshons__outlineManaCo`, Onmanshons.outlineManeForm AS `Onmanshons__outlineManeForm`, Onmanshons.outlineManaMeth AS `Onmanshons__outlineManaMeth`, Onmanshons.outlineParkYesNo AS `Onmanshons__outlineParkYesNo`, Onmanshons.outlineParkAkiYesNo AS `Onmanshons__outlineParkAkiYesNo`, Onmanshons.outlineParkPrice AS `Onmanshons__outlineParkPrice`, Onmanshons.outlineParkPrice2 AS `Onmanshons__outlineParkPrice2`, Onmanshons.outlineTrunkYesNo AS `Onmanshons__outlineTrunkYesNo`, Onmanshons.outlineHotWater AS `Onmanshons__outlineHotWater`, Onmanshons.outlineGas AS `Onmanshons__outlineGas`, Onmanshons.outlineElevatorYesNo AS `Onmanshons__outlineElevatorYesNo`, Onmanshons.outlineDeliBoxYesNo AS `Onmanshons__outlineDeliBoxYesNo`, Onmanshons.outlinePetYesNo AS `Onmanshons__outlinePetYesNo`, Onmanshons.outlinePetRoules AS `Onmanshons__outlinePetRoules`, Onmanshons.outlineDelivTime AS `Onmanshons__outlineDelivTime`, Onmanshons.outlineTransForm AS `Onmanshons__outlineTransForm`, Onmanshons.outlineEquipment AS `Onmanshons__outlineEquipment`, Onmanshons.outlineComment AS `Onmanshons__outlineComment`, Onmanshons.outlineSchool AS `Onmanshons__outlineSchool`, Onmanshons.googleMap AS `Onmanshons__googleMap`, Onmanshons.memo AS `Onmanshons__memo`, Onmanshons.priceFlg AS `Onmanshons__priceFlg`, Onmanshons.newFlg AS `Onmanshons__newFlg`, Onmanshons.lastFlg AS `Onmanshons__lastFlg`, Onmanshons.topImgFlg AS `Onmanshons__topImgFlg`, Onmanshons.memberFlg AS `Onmanshons__memberFlg`, Onmanshons.deleteFlg AS `Onmanshons__deleteFlg`, Onmanshons.created AS `Onmanshons__created`, Onmanshons.modified AS `Onmanshons__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onmanshons Onmanshons INNER JOIN areas Areas ON Areas.id = (Onmanshons.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onmanshons.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onmanshons.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onmanshons.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onmanshons.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onmanshons.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onmanshons.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onmanshons.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onmanshons.station_id3) WHERE Onmanshons.id = :c0', 'params' => [ [maximum depth reached] ], 'defaultTypes' => [ [maximum depth reached] ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ [maximum depth reached] ], 'matching' => [[maximum depth reached]], 'extraOptions' => [[maximum depth reached]], 'repository' => object(App\Model\Table\OnmanshonsTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '37', 'CtM' => '13' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '20', 'CtM' => '3' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '9', 'CtM' => '1' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '1', 'CtM' => '1' ], (int) 4 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '4', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 8 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '2' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '56' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '1' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '56' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '24' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '1' ], (int) 10 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '1' ], (int) 11 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '20' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '4' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 15, 'pet' => (int) 8, 'life' => (int) 57, 'space' => (int) 16 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onmanshons = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onmanshons.id AS `Onmanshons__id`, Onmanshons.name AS `Onmanshons__name`, Onmanshons.mbAddress AS `Onmanshons__mbAddress`, Onmanshons.displayFlg AS `Onmanshons__displayFlg`, Onmanshons.statusFlg AS `Onmanshons__statusFlg`, Onmanshons.area_id AS `Onmanshons__area_id`, Onmanshons.kind_id AS `Onmanshons__kind_id`, Onmanshons.newoldFlg AS `Onmanshons__newoldFlg`, Onmanshons.tour_id AS `Onmanshons__tour_id`, Onmanshons.topDispFlg AS `Onmanshons__topDispFlg`, Onmanshons.recommFlg AS `Onmanshons__recommFlg`, Onmanshons.railway_id1 AS `Onmanshons__railway_id1`, Onmanshons.railway_id2 AS `Onmanshons__railway_id2`, Onmanshons.railway_id3 AS `Onmanshons__railway_id3`, Onmanshons.station_id1 AS `Onmanshons__station_id1`, Onmanshons.station_id2 AS `Onmanshons__station_id2`, Onmanshons.station_id3 AS `Onmanshons__station_id3`, Onmanshons.stwalk1 AS `Onmanshons__stwalk1`, Onmanshons.stwalk2 AS `Onmanshons__stwalk2`, Onmanshons.stwalk3 AS `Onmanshons__stwalk3`, Onmanshons.bswalk1 AS `Onmanshons__bswalk1`, Onmanshons.bswalk2 AS `Onmanshons__bswalk2`, Onmanshons.bswalk3 AS `Onmanshons__bswalk3`, Onmanshons.catchCopy AS `Onmanshons__catchCopy`, Onmanshons.stationStart AS `Onmanshons__stationStart`, Onmanshons.stationTo1 AS `Onmanshons__stationTo1`, Onmanshons.stationTo2 AS `Onmanshons__stationTo2`, Onmanshons.stationTo3 AS `Onmanshons__stationTo3`, Onmanshons.stationTo4 AS `Onmanshons__stationTo4`, Onmanshons.trainTime1 AS `Onmanshons__trainTime1`, Onmanshons.trainTime2 AS `Onmanshons__trainTime2`, Onmanshons.trainTime3 AS `Onmanshons__trainTime3`, Onmanshons.trainTime4 AS `Onmanshons__trainTime4`, Onmanshons.trainDirect1 AS `Onmanshons__trainDirect1`, Onmanshons.trainDirect2 AS `Onmanshons__trainDirect2`, Onmanshons.trainDirect3 AS `Onmanshons__trainDirect3`, Onmanshons.trainDirect4 AS `Onmanshons__trainDirect4`, Onmanshons.trainVia1 AS `Onmanshons__trainVia1`, Onmanshons.trainVia2 AS `Onmanshons__trainVia2`, Onmanshons.trainVia3 AS `Onmanshons__trainVia3`, Onmanshons.trainVia4 AS `Onmanshons__trainVia4`, Onmanshons.locationFlg AS `Onmanshons__locationFlg`, Onmanshons.locationTitle1 AS `Onmanshons__locationTitle1`, Onmanshons.locationTitle2 AS `Onmanshons__locationTitle2`, Onmanshons.locationTxt1 AS `Onmanshons__locationTxt1`, Onmanshons.locationTxt2 AS `Onmanshons__locationTxt2`, Onmanshons.locationTxt3 AS `Onmanshons__locationTxt3`, Onmanshons.locationTxt4 AS `Onmanshons__locationTxt4`, Onmanshons.locationTxt5 AS `Onmanshons__locationTxt5`, Onmanshons.locationTxt6 AS `Onmanshons__locationTxt6`, Onmanshons.locationTxt7 AS `Onmanshons__locationTxt7`, Onmanshons.locationTxt8 AS `Onmanshons__locationTxt8`, Onmanshons.locationTxt9 AS `Onmanshons__locationTxt9`, Onmanshons.locationTxt10 AS `Onmanshons__locationTxt10`, Onmanshons.locationTxt11 AS `Onmanshons__locationTxt11`, Onmanshons.locationTxt12 AS `Onmanshons__locationTxt12`, Onmanshons.locationTxt13 AS `Onmanshons__locationTxt13`, Onmanshons.locationTxt14 AS `Onmanshons__locationTxt14`, Onmanshons.locationTxt15 AS `Onmanshons__locationTxt15`, Onmanshons.locationTxt16 AS `Onmanshons__locationTxt16`, Onmanshons.locationTxt17 AS `Onmanshons__locationTxt17`, Onmanshons.locationTxt18 AS `Onmanshons__locationTxt18`, Onmanshons.galleryTxt1 AS `Onmanshons__galleryTxt1`, Onmanshons.galleryTxt2 AS `Onmanshons__galleryTxt2`, Onmanshons.galleryTxt3 AS `Onmanshons__galleryTxt3`, Onmanshons.galleryTxt4 AS `Onmanshons__galleryTxt4`, Onmanshons.galleryTxt5 AS `Onmanshons__galleryTxt5`, Onmanshons.galleryTxt6 AS `Onmanshons__galleryTxt6`, Onmanshons.galleryTxt7 AS `Onmanshons__galleryTxt7`, Onmanshons.galleryTxt8 AS `Onmanshons__galleryTxt8`, Onmanshons.galleryTxt9 AS `Onmanshons__galleryTxt9`, Onmanshons.galleryTxt10 AS `Onmanshons__galleryTxt10`, Onmanshons.galleryTxt11 AS `Onmanshons__galleryTxt11`, Onmanshons.galleryTxt12 AS `Onmanshons__galleryTxt12`, Onmanshons.galleryTxt13 AS `Onmanshons__galleryTxt13`, Onmanshons.galleryTxt14 AS `Onmanshons__galleryTxt14`, Onmanshons.galleryTxt15 AS `Onmanshons__galleryTxt15`, Onmanshons.galleryTxt16 AS `Onmanshons__galleryTxt16`, Onmanshons.galleryTxt17 AS `Onmanshons__galleryTxt17`, Onmanshons.galleryTxt18 AS `Onmanshons__galleryTxt18`, Onmanshons.locationTraffic AS `Onmanshons__locationTraffic`, Onmanshons.locationSchool AS `Onmanshons__locationSchool`, Onmanshons.locationLife AS `Onmanshons__locationLife`, Onmanshons.locationOther AS `Onmanshons__locationOther`, Onmanshons.planFlg AS `Onmanshons__planFlg`, Onmanshons.outlinePrice AS `Onmanshons__outlinePrice`, Onmanshons.outlinePriceNum AS `Onmanshons__outlinePriceNum`, Onmanshons.outlinePlace AS `Onmanshons__outlinePlace`, Onmanshons.outlineTraffic AS `Onmanshons__outlineTraffic`, Onmanshons.outlineChiken AS `Onmanshons__outlineChiken`, Onmanshons.outlineSite AS `Onmanshons__outlineSite`, Onmanshons.outlineRoomSite AS `Onmanshons__outlineRoomSite`, Onmanshons.outlineUse1 AS `Onmanshons__outlineUse1`, Onmanshons.outlineUse2 AS `Onmanshons__outlineUse2`, Onmanshons.outlinePlots AS `Onmanshons__outlinePlots`, Onmanshons.outlineConstruction AS `Onmanshons__outlineConstruction`, Onmanshons.outlineFloorPlan AS `Onmanshons__outlineFloorPlan`, Onmanshons.outlineCompTime AS `Onmanshons__outlineCompTime`, Onmanshons.outlineSaleCo AS `Onmanshons__outlineSaleCo`, Onmanshons.outlineSekoCo AS `Onmanshons__outlineSekoCo`, Onmanshons.outlineManaCo AS `Onmanshons__outlineManaCo`, Onmanshons.outlineManeForm AS `Onmanshons__outlineManeForm`, Onmanshons.outlineManaMeth AS `Onmanshons__outlineManaMeth`, Onmanshons.outlineParkYesNo AS `Onmanshons__outlineParkYesNo`, Onmanshons.outlineParkAkiYesNo AS `Onmanshons__outlineParkAkiYesNo`, Onmanshons.outlineParkPrice AS `Onmanshons__outlineParkPrice`, Onmanshons.outlineParkPrice2 AS `Onmanshons__outlineParkPrice2`, Onmanshons.outlineTrunkYesNo AS `Onmanshons__outlineTrunkYesNo`, Onmanshons.outlineHotWater AS `Onmanshons__outlineHotWater`, Onmanshons.outlineGas AS `Onmanshons__outlineGas`, Onmanshons.outlineElevatorYesNo AS `Onmanshons__outlineElevatorYesNo`, Onmanshons.outlineDeliBoxYesNo AS `Onmanshons__outlineDeliBoxYesNo`, Onmanshons.outlinePetYesNo AS `Onmanshons__outlinePetYesNo`, Onmanshons.outlinePetRoules AS `Onmanshons__outlinePetRoules`, Onmanshons.outlineDelivTime AS `Onmanshons__outlineDelivTime`, Onmanshons.outlineTransForm AS `Onmanshons__outlineTransForm`, Onmanshons.outlineEquipment AS `Onmanshons__outlineEquipment`, Onmanshons.outlineComment AS `Onmanshons__outlineComment`, Onmanshons.outlineSchool AS `Onmanshons__outlineSchool`, Onmanshons.googleMap AS `Onmanshons__googleMap`, Onmanshons.memo AS `Onmanshons__memo`, Onmanshons.priceFlg AS `Onmanshons__priceFlg`, Onmanshons.newFlg AS `Onmanshons__newFlg`, Onmanshons.lastFlg AS `Onmanshons__lastFlg`, Onmanshons.topImgFlg AS `Onmanshons__topImgFlg`, Onmanshons.memberFlg AS `Onmanshons__memberFlg`, Onmanshons.deleteFlg AS `Onmanshons__deleteFlg`, Onmanshons.created AS `Onmanshons__created`, Onmanshons.modified AS `Onmanshons__modified`, Areas.id AS `Areas__id`, Areas.areaClass_cd AS `Areas__areaClass_cd`, Areas.name AS `Areas__name`, Areas.sortPt AS `Areas__sortPt`, Areas.editDate AS `Areas__editDate`, Kinds.id AS `Kinds__id`, Kinds.name AS `Kinds__name`, Kinds.sortPt AS `Kinds__sortPt`, Kinds.editDate AS `Kinds__editDate`, Tours.id AS `Tours__id`, Tours.name AS `Tours__name`, Tours.sortPt AS `Tours__sortPt`, Tours.category AS `Tours__category`, Tours.editDate AS `Tours__editDate`, Railways1.id AS `Railways1__id`, Railways1.name AS `Railways1__name`, Railways1.sortPt AS `Railways1__sortPt`, Railways1.editDate AS `Railways1__editDate`, Railways2.id AS `Railways2__id`, Railways2.name AS `Railways2__name`, Railways2.sortPt AS `Railways2__sortPt`, Railways2.editDate AS `Railways2__editDate`, Railways3.id AS `Railways3__id`, Railways3.name AS `Railways3__name`, Railways3.sortPt AS `Railways3__sortPt`, Railways3.editDate AS `Railways3__editDate`, Stations1.id AS `Stations1__id`, Stations1.name AS `Stations1__name`, Stations1.railway_id AS `Stations1__railway_id`, Stations1.pref_cd AS `Stations1__pref_cd`, Stations1.sortPt AS `Stations1__sortPt`, Stations1.editDate AS `Stations1__editDate`, Stations2.id AS `Stations2__id`, Stations2.name AS `Stations2__name`, Stations2.railway_id AS `Stations2__railway_id`, Stations2.pref_cd AS `Stations2__pref_cd`, Stations2.sortPt AS `Stations2__sortPt`, Stations2.editDate AS `Stations2__editDate`, Stations3.id AS `Stations3__id`, Stations3.name AS `Stations3__name`, Stations3.railway_id AS `Stations3__railway_id`, Stations3.pref_cd AS `Stations3__pref_cd`, Stations3.sortPt AS `Stations3__sortPt`, Stations3.editDate AS `Stations3__editDate` FROM onmanshons Onmanshons INNER JOIN areas Areas ON Areas.id = (Onmanshons.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onmanshons.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onmanshons.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onmanshons.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onmanshons.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onmanshons.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onmanshons.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onmanshons.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onmanshons.station_id3) WHERE Onmanshons.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onmanshons__id' => 'integer', 'Onmanshons.id' => 'integer', 'id' => 'integer', 'Onmanshons__name' => 'string', 'Onmanshons.name' => 'string', 'name' => 'string', 'Onmanshons__mbAddress' => 'string', 'Onmanshons.mbAddress' => 'string', 'mbAddress' => 'string', 'Onmanshons__displayFlg' => 'tinyinteger', 'Onmanshons.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onmanshons__statusFlg' => 'tinyinteger', 'Onmanshons.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onmanshons__area_id' => 'integer', 'Onmanshons.area_id' => 'integer', 'area_id' => 'integer', 'Onmanshons__kind_id' => 'integer', 'Onmanshons.kind_id' => 'integer', 'kind_id' => 'integer', 'Onmanshons__newoldFlg' => 'tinyinteger', 'Onmanshons.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onmanshons__tour_id' => 'integer', 'Onmanshons.tour_id' => 'integer', 'tour_id' => 'integer', 'Onmanshons__topDispFlg' => 'tinyinteger', 'Onmanshons.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onmanshons__recommFlg' => 'tinyinteger', 'Onmanshons.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onmanshons__railway_id1' => 'integer', 'Onmanshons.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onmanshons__railway_id2' => 'integer', 'Onmanshons.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onmanshons__railway_id3' => 'integer', 'Onmanshons.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onmanshons__station_id1' => 'integer', 'Onmanshons.station_id1' => 'integer', 'station_id1' => 'integer', 'Onmanshons__station_id2' => 'integer', 'Onmanshons.station_id2' => 'integer', 'station_id2' => 'integer', 'Onmanshons__station_id3' => 'integer', 'Onmanshons.station_id3' => 'integer', 'station_id3' => 'integer', 'Onmanshons__stwalk1' => 'string', 'Onmanshons.stwalk1' => 'string', 'stwalk1' => 'string', 'Onmanshons__stwalk2' => 'string', 'Onmanshons.stwalk2' => 'string', 'stwalk2' => 'string', 'Onmanshons__stwalk3' => 'string', 'Onmanshons.stwalk3' => 'string', 'stwalk3' => 'string', 'Onmanshons__bswalk1' => 'string', 'Onmanshons.bswalk1' => 'string', 'bswalk1' => 'string', 'Onmanshons__bswalk2' => 'string', 'Onmanshons.bswalk2' => 'string', 'bswalk2' => 'string', 'Onmanshons__bswalk3' => 'string', 'Onmanshons.bswalk3' => 'string', 'bswalk3' => 'string', 'Onmanshons__catchCopy' => 'string', 'Onmanshons.catchCopy' => 'string', 'catchCopy' => 'string', 'Onmanshons__stationStart' => 'string', 'Onmanshons.stationStart' => 'string', 'stationStart' => 'string', 'Onmanshons__stationTo1' => 'string', 'Onmanshons.stationTo1' => 'string', 'stationTo1' => 'string', 'Onmanshons__stationTo2' => 'string', 'Onmanshons.stationTo2' => 'string', 'stationTo2' => 'string', 'Onmanshons__stationTo3' => 'string', 'Onmanshons.stationTo3' => 'string', 'stationTo3' => 'string', 'Onmanshons__stationTo4' => 'string', 'Onmanshons.stationTo4' => 'string', 'stationTo4' => 'string', 'Onmanshons__trainTime1' => 'tinyinteger', 'Onmanshons.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onmanshons__trainTime2' => 'tinyinteger', 'Onmanshons.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onmanshons__trainTime3' => 'tinyinteger', 'Onmanshons.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onmanshons__trainTime4' => 'tinyinteger', 'Onmanshons.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onmanshons__trainDirect1' => 'tinyinteger', 'Onmanshons.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onmanshons__trainDirect2' => 'tinyinteger', 'Onmanshons.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onmanshons__trainDirect3' => 'tinyinteger', 'Onmanshons.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onmanshons__trainDirect4' => 'tinyinteger', 'Onmanshons.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onmanshons__trainVia1' => 'string', 'Onmanshons.trainVia1' => 'string', 'trainVia1' => 'string', 'Onmanshons__trainVia2' => 'string', 'Onmanshons.trainVia2' => 'string', 'trainVia2' => 'string', 'Onmanshons__trainVia3' => 'string', 'Onmanshons.trainVia3' => 'string', 'trainVia3' => 'string', 'Onmanshons__trainVia4' => 'string', 'Onmanshons.trainVia4' => 'string', 'trainVia4' => 'string', 'Onmanshons__locationFlg' => 'tinyinteger', 'Onmanshons.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onmanshons__locationTitle1' => 'string', 'Onmanshons.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onmanshons__locationTitle2' => 'string', 'Onmanshons.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onmanshons__locationTxt1' => 'string', 'Onmanshons.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onmanshons__locationTxt2' => 'string', 'Onmanshons.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onmanshons__locationTxt3' => 'string', 'Onmanshons.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onmanshons__locationTxt4' => 'string', 'Onmanshons.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onmanshons__locationTxt5' => 'string', 'Onmanshons.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onmanshons__locationTxt6' => 'string', 'Onmanshons.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onmanshons__locationTxt7' => 'string', 'Onmanshons.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onmanshons__locationTxt8' => 'string', 'Onmanshons.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onmanshons__locationTxt9' => 'string', 'Onmanshons.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onmanshons__locationTxt10' => 'string', 'Onmanshons.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onmanshons__locationTxt11' => 'string', 'Onmanshons.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onmanshons__locationTxt12' => 'string', 'Onmanshons.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onmanshons__locationTxt13' => 'string', 'Onmanshons.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onmanshons__locationTxt14' => 'string', 'Onmanshons.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onmanshons__locationTxt15' => 'string', 'Onmanshons.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onmanshons__locationTxt16' => 'string', 'Onmanshons.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onmanshons__locationTxt17' => 'string', 'Onmanshons.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onmanshons__locationTxt18' => 'string', 'Onmanshons.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onmanshons__galleryTxt1' => 'string', 'Onmanshons.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onmanshons__galleryTxt2' => 'string', 'Onmanshons.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onmanshons__galleryTxt3' => 'string', 'Onmanshons.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onmanshons__galleryTxt4' => 'string', 'Onmanshons.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onmanshons__galleryTxt5' => 'string', 'Onmanshons.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onmanshons__galleryTxt6' => 'string', 'Onmanshons.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onmanshons__galleryTxt7' => 'string', 'Onmanshons.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onmanshons__galleryTxt8' => 'string', 'Onmanshons.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onmanshons__galleryTxt9' => 'string', 'Onmanshons.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onmanshons__galleryTxt10' => 'string', 'Onmanshons.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onmanshons__galleryTxt11' => 'string', 'Onmanshons.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onmanshons__galleryTxt12' => 'string', 'Onmanshons.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onmanshons__galleryTxt13' => 'string', 'Onmanshons.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onmanshons__galleryTxt14' => 'string', 'Onmanshons.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onmanshons__galleryTxt15' => 'string', 'Onmanshons.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onmanshons__galleryTxt16' => 'string', 'Onmanshons.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onmanshons__galleryTxt17' => 'string', 'Onmanshons.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onmanshons__galleryTxt18' => 'string', 'Onmanshons.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onmanshons__locationTraffic' => 'string', 'Onmanshons.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onmanshons__locationSchool' => 'string', 'Onmanshons.locationSchool' => 'string', 'locationSchool' => 'string', 'Onmanshons__locationLife' => 'string', 'Onmanshons.locationLife' => 'string', 'locationLife' => 'string', 'Onmanshons__locationOther' => 'string', 'Onmanshons.locationOther' => 'string', 'locationOther' => 'string', 'Onmanshons__planFlg' => 'tinyinteger', 'Onmanshons.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onmanshons__outlinePrice' => 'string', 'Onmanshons.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onmanshons__outlinePriceNum' => 'integer', 'Onmanshons.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onmanshons__outlinePlace' => 'string', 'Onmanshons.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onmanshons__outlineTraffic' => 'string', 'Onmanshons.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onmanshons__outlineChiken' => 'tinyinteger', 'Onmanshons.outlineChiken' => 'tinyinteger', 'outlineChiken' => 'tinyinteger', 'Onmanshons__outlineSite' => 'string', 'Onmanshons.outlineSite' => 'string', 'outlineSite' => 'string', 'Onmanshons__outlineRoomSite' => 'string', 'Onmanshons.outlineRoomSite' => 'string', 'outlineRoomSite' => 'string', 'Onmanshons__outlineUse1' => 'string', 'Onmanshons.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onmanshons__outlineUse2' => 'string', 'Onmanshons.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onmanshons__outlinePlots' => 'integer', 'Onmanshons.outlinePlots' => 'integer', 'outlinePlots' => 'integer', 'Onmanshons__outlineConstruction' => 'string', 'Onmanshons.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onmanshons__outlineFloorPlan' => 'string', 'Onmanshons.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onmanshons__outlineCompTime' => 'string', 'Onmanshons.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onmanshons__outlineSaleCo' => 'string', 'Onmanshons.outlineSaleCo' => 'string', 'outlineSaleCo' => 'string', 'Onmanshons__outlineSekoCo' => 'string', 'Onmanshons.outlineSekoCo' => 'string', 'outlineSekoCo' => 'string', 'Onmanshons__outlineManaCo' => 'string', 'Onmanshons.outlineManaCo' => 'string', 'outlineManaCo' => 'string', 'Onmanshons__outlineManeForm' => 'string', 'Onmanshons.outlineManeForm' => 'string', 'outlineManeForm' => 'string', 'Onmanshons__outlineManaMeth' => 'string', 'Onmanshons.outlineManaMeth' => 'string', 'outlineManaMeth' => 'string', 'Onmanshons__outlineParkYesNo' => 'tinyinteger', 'Onmanshons.outlineParkYesNo' => 'tinyinteger', 'outlineParkYesNo' => 'tinyinteger', 'Onmanshons__outlineParkAkiYesNo' => 'tinyinteger', 'Onmanshons.outlineParkAkiYesNo' => 'tinyinteger', 'outlineParkAkiYesNo' => 'tinyinteger', 'Onmanshons__outlineParkPrice' => 'decimal', 'Onmanshons.outlineParkPrice' => 'decimal', 'outlineParkPrice' => 'decimal', 'Onmanshons__outlineParkPrice2' => 'decimal', 'Onmanshons.outlineParkPrice2' => 'decimal', 'outlineParkPrice2' => 'decimal', 'Onmanshons__outlineTrunkYesNo' => 'tinyinteger', 'Onmanshons.outlineTrunkYesNo' => 'tinyinteger', 'outlineTrunkYesNo' => 'tinyinteger', 'Onmanshons__outlineHotWater' => 'string', 'Onmanshons.outlineHotWater' => 'string', 'outlineHotWater' => 'string', 'Onmanshons__outlineGas' => 'string', 'Onmanshons.outlineGas' => 'string', 'outlineGas' => 'string', 'Onmanshons__outlineElevatorYesNo' => 'tinyinteger', 'Onmanshons.outlineElevatorYesNo' => 'tinyinteger', 'outlineElevatorYesNo' => 'tinyinteger', 'Onmanshons__outlineDeliBoxYesNo' => 'tinyinteger', 'Onmanshons.outlineDeliBoxYesNo' => 'tinyinteger', 'outlineDeliBoxYesNo' => 'tinyinteger', 'Onmanshons__outlinePetYesNo' => 'tinyinteger', 'Onmanshons.outlinePetYesNo' => 'tinyinteger', 'outlinePetYesNo' => 'tinyinteger', 'Onmanshons__outlinePetRoules' => 'string', 'Onmanshons.outlinePetRoules' => 'string', 'outlinePetRoules' => 'string', 'Onmanshons__outlineDelivTime' => 'string', 'Onmanshons.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onmanshons__outlineTransForm' => 'string', 'Onmanshons.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onmanshons__outlineEquipment' => 'string', 'Onmanshons.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onmanshons__outlineComment' => 'string', 'Onmanshons.outlineComment' => 'string', 'outlineComment' => 'string', 'Onmanshons__outlineSchool' => 'string', 'Onmanshons.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onmanshons__googleMap' => 'string', 'Onmanshons.googleMap' => 'string', 'googleMap' => 'string', 'Onmanshons__memo' => 'string', 'Onmanshons.memo' => 'string', 'memo' => 'string', 'Onmanshons__priceFlg' => 'tinyinteger', 'Onmanshons.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onmanshons__newFlg' => 'tinyinteger', 'Onmanshons.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onmanshons__lastFlg' => 'tinyinteger', 'Onmanshons.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onmanshons__topImgFlg' => 'tinyinteger', 'Onmanshons.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onmanshons__memberFlg' => 'tinyinteger', 'Onmanshons.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onmanshons__deleteFlg' => 'tinyinteger', 'Onmanshons.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onmanshons__created' => 'datetime', 'Onmanshons.created' => 'datetime', 'created' => 'datetime', 'Onmanshons__modified' => 'datetime', 'Onmanshons.modified' => 'datetime', 'modified' => 'datetime', 'Manshons__id' => 'integer', 'Manshons.id' => 'integer', 'Manshons__onmanshon_id' => 'integer', 'Manshons.onmanshon_id' => 'integer', 'onmanshon_id' => 'integer', 'Manshons__displayFlg' => 'tinyinteger', 'Manshons.displayFlg' => 'tinyinteger', 'Manshons__statusFlg' => 'tinyinteger', 'Manshons.statusFlg' => 'tinyinteger', 'Manshons__nowStatus' => 'string', 'Manshons.nowStatus' => 'string', 'nowStatus' => 'string', 'Manshons__name' => 'string', 'Manshons.name' => 'string', 'Manshons__floor' => 'string', 'Manshons.floor' => 'string', 'floor' => 'string', 'Manshons__roomFloor' => 'string', 'Manshons.roomFloor' => 'string', 'roomFloor' => 'string', 'Manshons__shareArea' => 'string', 'Manshons.shareArea' => 'string', 'shareArea' => 'string', 'Manshons__roomArea' => 'decimal', 'Manshons.roomArea' => 'decimal', 'roomArea' => 'decimal', 'Manshons__valconyArea' => 'decimal', 'Manshons.valconyArea' => 'decimal', 'valconyArea' => 'decimal', 'Manshons__valconyFor' => 'string', 'Manshons.valconyFor' => 'string', 'valconyFor' => 'string', 'Manshons__reformYesNo' => 'tinyinteger', 'Manshons.reformYesNo' => 'tinyinteger', 'reformYesNo' => 'tinyinteger', 'Manshons__reformContents' => 'string', 'Manshons.reformContents' => 'string', 'reformContents' => 'string', 'Manshons__price' => 'decimal', 'Manshons.price' => 'decimal', 'price' => 'decimal', 'Manshons__PlanImgFlg' => 'tinyinteger', 'Manshons.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Manshons__manageCost' => 'decimal', 'Manshons.manageCost' => 'decimal', 'manageCost' => 'decimal', 'Manshons__repairCost' => 'decimal', 'Manshons.repairCost' => 'decimal', 'repairCost' => 'decimal', 'Manshons__otherCost' => 'decimal', 'Manshons.otherCost' => 'decimal', 'otherCost' => 'decimal', 'Manshons__totalCost' => 'decimal', 'Manshons.totalCost' => 'decimal', 'totalCost' => 'decimal', 'Manshons__comment' => 'string', 'Manshons.comment' => 'string', 'comment' => 'string', 'Manshons__memo' => 'string', 'Manshons.memo' => 'string', 'Manshons__areaCD' => 'integer', 'Manshons.areaCD' => 'integer', 'areaCD' => 'integer', 'Manshons__created' => 'datetime', 'Manshons.created' => 'datetime', 'Manshons__modified' => 'datetime', 'Manshons.modified' => 'datetime', 'Areas__id' => 'integer', 'Areas.id' => 'integer', 'Areas__areaClass_cd' => 'tinyinteger', 'Areas.areaClass_cd' => 'tinyinteger', 'areaClass_cd' => 'tinyinteger', 'Areas__name' => 'string', 'Areas.name' => 'string', 'Areas__sortPt' => 'smallinteger', 'Areas.sortPt' => 'smallinteger', 'sortPt' => 'smallinteger', 'Areas__editDate' => 'timestamp', 'Areas.editDate' => 'timestamp', 'editDate' => 'timestamp', 'Kinds__id' => 'integer', 'Kinds.id' => 'integer', 'Kinds__name' => 'string', 'Kinds.name' => 'string', 'Kinds__sortPt' => 'smallinteger', 'Kinds.sortPt' => 'smallinteger', 'Kinds__editDate' => 'timestamp', 'Kinds.editDate' => 'timestamp', 'Tours__id' => 'integer', 'Tours.id' => 'integer', 'Tours__name' => 'string', 'Tours.name' => 'string', 'Tours__sortPt' => 'smallinteger', 'Tours.sortPt' => 'smallinteger', 'Tours__category' => 'tinyinteger', 'Tours.category' => 'tinyinteger', 'category' => 'tinyinteger', 'Tours__editDate' => 'timestamp', 'Tours.editDate' => 'timestamp', 'Railways1__id' => 'integer', 'Railways1.id' => 'integer', 'Railways1__name' => 'string', 'Railways1.name' => 'string', 'Railways1__sortPt' => 'integer', 'Railways1.sortPt' => 'integer', 'Railways1__editDate' => 'timestamp', 'Railways1.editDate' => 'timestamp', 'Railways2__id' => 'integer', 'Railways2.id' => 'integer', 'Railways2__name' => 'string', 'Railways2.name' => 'string', 'Railways2__sortPt' => 'integer', 'Railways2.sortPt' => 'integer', 'Railways2__editDate' => 'timestamp', 'Railways2.editDate' => 'timestamp', 'Railways3__id' => 'integer', 'Railways3.id' => 'integer', 'Railways3__name' => 'string', 'Railways3.name' => 'string', 'Railways3__sortPt' => 'integer', 'Railways3.sortPt' => 'integer', 'Railways3__editDate' => 'timestamp', 'Railways3.editDate' => 'timestamp', 'Stations1__id' => 'integer', 'Stations1.id' => 'integer', 'Stations1__name' => 'string', 'Stations1.name' => 'string', 'Stations1__railway_id' => 'integer', 'Stations1.railway_id' => 'integer', 'railway_id' => 'integer', 'Stations1__pref_cd' => 'tinyinteger', 'Stations1.pref_cd' => 'tinyinteger', 'pref_cd' => 'tinyinteger', 'Stations1__sortPt' => 'smallinteger', 'Stations1.sortPt' => 'smallinteger', 'Stations1__editDate' => 'timestamp', 'Stations1.editDate' => 'timestamp', 'Stations2__id' => 'integer', 'Stations2.id' => 'integer', 'Stations2__name' => 'string', 'Stations2.name' => 'string', 'Stations2__railway_id' => 'integer', 'Stations2.railway_id' => 'integer', 'Stations2__pref_cd' => 'tinyinteger', 'Stations2.pref_cd' => 'tinyinteger', 'Stations2__sortPt' => 'smallinteger', 'Stations2.sortPt' => 'smallinteger', 'Stations2__editDate' => 'timestamp', 'Stations2.editDate' => 'timestamp', 'Stations3__id' => 'integer', 'Stations3.id' => 'integer', 'Stations3__name' => 'string', 'Stations3.name' => 'string', 'Stations3__railway_id' => 'integer', 'Stations3.railway_id' => 'integer', 'Stations3__pref_cd' => 'tinyinteger', 'Stations3.pref_cd' => 'tinyinteger', 'Stations3__sortPt' => 'smallinteger', 'Stations3.sortPt' => 'smallinteger', 'Stations3__editDate' => 'timestamp', 'Stations3.editDate' => 'timestamp' ], 'decorators' => (int) 0, 'executed' => true, 'hydrate' => true, 'buffered' => true, 'formatters' => (int) 0, 'mapReducers' => (int) 0, 'contain' => [ 'manshons' => [[maximum depth reached]], 'Areas' => [[maximum depth reached]], 'Kinds' => [[maximum depth reached]], 'Tours' => [[maximum depth reached]], 'Railways1' => [[maximum depth reached]], 'Railways2' => [[maximum depth reached]], 'Railways3' => [[maximum depth reached]], 'Stations1' => [[maximum depth reached]], 'Stations2' => [[maximum depth reached]], 'Stations3' => [[maximum depth reached]] ], 'matching' => [], 'extraOptions' => [], 'repository' => object(App\Model\Table\OnmanshonsTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '37', 'CtM' => '13' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '20', 'CtM' => '3' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '9', 'CtM' => '1' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '1', 'CtM' => '1' ], (int) 4 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '4', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 8 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '2' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '56' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '1' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '31' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '56' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '24' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '1' ], (int) 10 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '1' ], (int) 11 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '20' ], (int) 12 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 13 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '4' ], (int) 14 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 15, 'pet' => (int) 8, 'life' => (int) 57, 'space' => (int) 16 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 14 $CtMember = ''include - APP/Template/Element/search_Area_Railway.ctp, line 89 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::_renderElement() - CORE/src/View/View.php, line 1857 Cake\View\View::element() - CORE/src/View/View.php, line 782 include - APP/Template/Onmanshons/view.ctp, line 915 Cake\View\View::_evaluate() - CORE/src/View/View.php, line 1420 Cake\View\View::_render() - CORE/src/View/View.php, line 1381 Cake\View\View::render() - CORE/src/View/View.php, line 879 Cake\Controller\Controller::render() - CORE/src/Controller/Controller.php, line 795 Cake\Http\ActionDispatcher::_invoke() - CORE/src/Http/ActionDispatcher.php, line 126 Cake\Http\ActionDispatcher::dispatch() - CORE/src/Http/ActionDispatcher.php, line 94 Cake\Http\BaseApplication::__invoke() - CORE/src/Http/BaseApplication.php, line 234 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Runner::__invoke() - CORE/src/Http/Runner.php, line 65 Cake\Http\Middleware\CsrfProtectionMiddleware::__invoke() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 120
Copyright©2021-2025 LHF co.,ltd.
エリア検索