駅まで歩いて行ける便利さと、のんびり落ち着いた住環境。公園や学校も近く、子育てにもぴったり。杉並・上井草で、家族みんなが笑顔になれる暮らしをはじめませんか？
土地価格：6,480万円 土地面積：118.99m2
販売条件：一般 土地権利：所有権
現況：更地 地目：
参考延床面積：130.84m2 参考建物価格：3,030万円
土地詳細説明予約受付中
| 価格 | 6,480万円 |
|---|---|
| 種類 | 売地 |
| 所在地 | 杉並区上井草4丁目 |
| 土地権利 | 所有権 |
| 敷地面積 | 118.99㎡ |
| 設備 | |
| 接道状況 | 西側約5.45m公道、北東側約3.8m私道・位置指定 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
| 高度地区 | 第一種高度地区 |
| 防火指定 | 準防火地域 |
| 建ぺい率/ 容積率 |
50％(60%)／100% |
|---|---|
| 総区画数 | 2 |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| ポイント | ●建築条件無し ●角地 ●参考プランあり |
| 指定学校区 | 杉並区立桃井第四小学校 杉並区立井草中学校 |
| 備考 | ※北東側(私道)セットバック前幅員約3.6m |
いなげや練馬上石神井南店 約600m 徒歩8分
西友上石神井店 約800m 徒歩10分
杉並区立桃井第四小学校 約600m 徒歩8分
杉並区立井草中学校 約650m 徒歩9分
八幡幼稚園 約750m 徒歩10分
TAC杉並区上井草スポーツセンター 約850m 徒歩11分
西武新宿線「上石神井」駅 約800m 徒歩10分
西武新宿線「上井草」駅 約1040m 徒歩13分
土地詳細説明予約受付中
土地詳細説明予約受付中
路線検索
会員限定物件
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 = [ 'Onlands' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onlands.id AS `Onlands__id`, Onlands.name AS `Onlands__name`, Onlands.mbAddress AS `Onlands__mbAddress`, Onlands.displayFlg AS `Onlands__displayFlg`, Onlands.statusFlg AS `Onlands__statusFlg`, Onlands.area_id AS `Onlands__area_id`, Onlands.sectionNo AS `Onlands__sectionNo`, Onlands.kind_id AS `Onlands__kind_id`, Onlands.landFlg AS `Onlands__landFlg`, Onlands.lifetownFlg AS `Onlands__lifetownFlg`, Onlands.newoldFlg AS `Onlands__newoldFlg`, Onlands.tour_id AS `Onlands__tour_id`, Onlands.topDispFlg AS `Onlands__topDispFlg`, Onlands.recommFlg AS `Onlands__recommFlg`, Onlands.railway_id1 AS `Onlands__railway_id1`, Onlands.railway_id2 AS `Onlands__railway_id2`, Onlands.railway_id3 AS `Onlands__railway_id3`, Onlands.station_id1 AS `Onlands__station_id1`, Onlands.station_id2 AS `Onlands__station_id2`, Onlands.station_id3 AS `Onlands__station_id3`, Onlands.stwalk1 AS `Onlands__stwalk1`, Onlands.stwalk2 AS `Onlands__stwalk2`, Onlands.stwalk3 AS `Onlands__stwalk3`, Onlands.bswalk1 AS `Onlands__bswalk1`, Onlands.bswalk2 AS `Onlands__bswalk2`, Onlands.bswalk3 AS `Onlands__bswalk3`, Onlands.catchCopy AS `Onlands__catchCopy`, Onlands.stationStart AS `Onlands__stationStart`, Onlands.stationTo1 AS `Onlands__stationTo1`, Onlands.stationTo2 AS `Onlands__stationTo2`, Onlands.stationTo3 AS `Onlands__stationTo3`, Onlands.stationTo4 AS `Onlands__stationTo4`, Onlands.trainTime1 AS `Onlands__trainTime1`, Onlands.trainTime2 AS `Onlands__trainTime2`, Onlands.trainTime3 AS `Onlands__trainTime3`, Onlands.trainTime4 AS `Onlands__trainTime4`, Onlands.trainDirect1 AS `Onlands__trainDirect1`, Onlands.trainDirect2 AS `Onlands__trainDirect2`, Onlands.trainDirect3 AS `Onlands__trainDirect3`, Onlands.trainDirect4 AS `Onlands__trainDirect4`, Onlands.trainVia1 AS `Onlands__trainVia1`, Onlands.trainVia2 AS `Onlands__trainVia2`, Onlands.trainVia3 AS `Onlands__trainVia3`, Onlands.trainVia4 AS `Onlands__trainVia4`, Onlands.locationFlg AS `Onlands__locationFlg`, Onlands.locationTitle1 AS `Onlands__locationTitle1`, Onlands.locationTitle2 AS `Onlands__locationTitle2`, Onlands.locationTxt1 AS `Onlands__locationTxt1`, Onlands.locationTxt2 AS `Onlands__locationTxt2`, Onlands.locationTxt3 AS `Onlands__locationTxt3`, Onlands.locationTxt4 AS `Onlands__locationTxt4`, Onlands.locationTxt5 AS `Onlands__locationTxt5`, Onlands.locationTxt6 AS `Onlands__locationTxt6`, Onlands.locationTxt7 AS `Onlands__locationTxt7`, Onlands.locationTxt8 AS `Onlands__locationTxt8`, Onlands.locationTxt9 AS `Onlands__locationTxt9`, Onlands.locationTxt10 AS `Onlands__locationTxt10`, Onlands.locationTxt11 AS `Onlands__locationTxt11`, Onlands.locationTxt12 AS `Onlands__locationTxt12`, Onlands.locationTxt13 AS `Onlands__locationTxt13`, Onlands.locationTxt14 AS `Onlands__locationTxt14`, Onlands.locationTxt15 AS `Onlands__locationTxt15`, Onlands.locationTxt16 AS `Onlands__locationTxt16`, Onlands.locationTxt17 AS `Onlands__locationTxt17`, Onlands.locationTxt18 AS `Onlands__locationTxt18`, Onlands.galleryTxt1 AS `Onlands__galleryTxt1`, Onlands.galleryTxt2 AS `Onlands__galleryTxt2`, Onlands.galleryTxt3 AS `Onlands__galleryTxt3`, Onlands.galleryTxt4 AS `Onlands__galleryTxt4`, Onlands.galleryTxt5 AS `Onlands__galleryTxt5`, Onlands.galleryTxt6 AS `Onlands__galleryTxt6`, Onlands.galleryTxt7 AS `Onlands__galleryTxt7`, Onlands.galleryTxt8 AS `Onlands__galleryTxt8`, Onlands.galleryTxt9 AS `Onlands__galleryTxt9`, Onlands.galleryTxt10 AS `Onlands__galleryTxt10`, Onlands.galleryTxt11 AS `Onlands__galleryTxt11`, Onlands.galleryTxt12 AS `Onlands__galleryTxt12`, Onlands.galleryTxt13 AS `Onlands__galleryTxt13`, Onlands.galleryTxt14 AS `Onlands__galleryTxt14`, Onlands.galleryTxt15 AS `Onlands__galleryTxt15`, Onlands.galleryTxt16 AS `Onlands__galleryTxt16`, Onlands.galleryTxt17 AS `Onlands__galleryTxt17`, Onlands.galleryTxt18 AS `Onlands__galleryTxt18`, Onlands.locationTraffic AS `Onlands__locationTraffic`, Onlands.locationSchool AS `Onlands__locationSchool`, Onlands.locationLife AS `Onlands__locationLife`, Onlands.locationOther AS `Onlands__locationOther`, Onlands.parthFlg AS `Onlands__parthFlg`, Onlands.parthImgFlg1 AS `Onlands__parthImgFlg1`, Onlands.parthImgFlg2 AS `Onlands__parthImgFlg2`, Onlands.parthImgFlg3 AS `Onlands__parthImgFlg3`, Onlands.parthImgFlg4 AS `Onlands__parthImgFlg4`, Onlands.kuwariFlg AS `Onlands__kuwariFlg`, Onlands.planFlg AS `Onlands__planFlg`, Onlands.outlinePrice AS `Onlands__outlinePrice`, Onlands.outlinePriceNum AS `Onlands__outlinePriceNum`, Onlands.outlineType AS `Onlands__outlineType`, Onlands.outlinePlace AS `Onlands__outlinePlace`, Onlands.outlineTraffic AS `Onlands__outlineTraffic`, Onlands.outlineRight AS `Onlands__outlineRight`, Onlands.outlineSite AS `Onlands__outlineSite`, Onlands.outlineFacility AS `Onlands__outlineFacility`, Onlands.outlineApproach AS `Onlands__outlineApproach`, Onlands.outlineCityplan AS `Onlands__outlineCityplan`, Onlands.outlineUse1 AS `Onlands__outlineUse1`, Onlands.outlineUse2 AS `Onlands__outlineUse2`, Onlands.outlineAltitude1 AS `Onlands__outlineAltitude1`, Onlands.outlineAltitude2 AS `Onlands__outlineAltitude2`, Onlands.outlineFire1 AS `Onlands__outlineFire1`, Onlands.outlineFire2 AS `Onlands__outlineFire2`, Onlands.outlineVolume1 AS `Onlands__outlineVolume1`, Onlands.outlineVolume2 AS `Onlands__outlineVolume2`, Onlands.outlinePlots AS `Onlands__outlinePlots`, Onlands.outlineStatus AS `Onlands__outlineStatus`, Onlands.outlineBuildingArea AS `Onlands__outlineBuildingArea`, Onlands.outlineConstruction AS `Onlands__outlineConstruction`, Onlands.outlineFloorPlan AS `Onlands__outlineFloorPlan`, Onlands.outlineCompTime AS `Onlands__outlineCompTime`, Onlands.outlineDelivTime AS `Onlands__outlineDelivTime`, Onlands.outlineTransForm AS `Onlands__outlineTransForm`, Onlands.outlineEquipment AS `Onlands__outlineEquipment`, Onlands.outlineComment AS `Onlands__outlineComment`, Onlands.outlineSchool AS `Onlands__outlineSchool`, Onlands.googleMap AS `Onlands__googleMap`, Onlands.memo AS `Onlands__memo`, Onlands.priceFlg AS `Onlands__priceFlg`, Onlands.newFlg AS `Onlands__newFlg`, Onlands.lastFlg AS `Onlands__lastFlg`, Onlands.topImgFlg AS `Onlands__topImgFlg`, Onlands.memberFlg AS `Onlands__memberFlg`, Onlands.deleteFlg AS `Onlands__deleteFlg`, Onlands.created AS `Onlands__created`, Onlands.modified AS `Onlands__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 onlands Onlands LEFT JOIN areas Areas ON Areas.id = (Onlands.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onlands.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onlands.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onlands.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onlands.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onlands.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onlands.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onlands.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onlands.station_id3) WHERE Onlands.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\OnlandsTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onlands = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onlands.id AS `Onlands__id`, Onlands.name AS `Onlands__name`, Onlands.mbAddress AS `Onlands__mbAddress`, Onlands.displayFlg AS `Onlands__displayFlg`, Onlands.statusFlg AS `Onlands__statusFlg`, Onlands.area_id AS `Onlands__area_id`, Onlands.sectionNo AS `Onlands__sectionNo`, Onlands.kind_id AS `Onlands__kind_id`, Onlands.landFlg AS `Onlands__landFlg`, Onlands.lifetownFlg AS `Onlands__lifetownFlg`, Onlands.newoldFlg AS `Onlands__newoldFlg`, Onlands.tour_id AS `Onlands__tour_id`, Onlands.topDispFlg AS `Onlands__topDispFlg`, Onlands.recommFlg AS `Onlands__recommFlg`, Onlands.railway_id1 AS `Onlands__railway_id1`, Onlands.railway_id2 AS `Onlands__railway_id2`, Onlands.railway_id3 AS `Onlands__railway_id3`, Onlands.station_id1 AS `Onlands__station_id1`, Onlands.station_id2 AS `Onlands__station_id2`, Onlands.station_id3 AS `Onlands__station_id3`, Onlands.stwalk1 AS `Onlands__stwalk1`, Onlands.stwalk2 AS `Onlands__stwalk2`, Onlands.stwalk3 AS `Onlands__stwalk3`, Onlands.bswalk1 AS `Onlands__bswalk1`, Onlands.bswalk2 AS `Onlands__bswalk2`, Onlands.bswalk3 AS `Onlands__bswalk3`, Onlands.catchCopy AS `Onlands__catchCopy`, Onlands.stationStart AS `Onlands__stationStart`, Onlands.stationTo1 AS `Onlands__stationTo1`, Onlands.stationTo2 AS `Onlands__stationTo2`, Onlands.stationTo3 AS `Onlands__stationTo3`, Onlands.stationTo4 AS `Onlands__stationTo4`, Onlands.trainTime1 AS `Onlands__trainTime1`, Onlands.trainTime2 AS `Onlands__trainTime2`, Onlands.trainTime3 AS `Onlands__trainTime3`, Onlands.trainTime4 AS `Onlands__trainTime4`, Onlands.trainDirect1 AS `Onlands__trainDirect1`, Onlands.trainDirect2 AS `Onlands__trainDirect2`, Onlands.trainDirect3 AS `Onlands__trainDirect3`, Onlands.trainDirect4 AS `Onlands__trainDirect4`, Onlands.trainVia1 AS `Onlands__trainVia1`, Onlands.trainVia2 AS `Onlands__trainVia2`, Onlands.trainVia3 AS `Onlands__trainVia3`, Onlands.trainVia4 AS `Onlands__trainVia4`, Onlands.locationFlg AS `Onlands__locationFlg`, Onlands.locationTitle1 AS `Onlands__locationTitle1`, Onlands.locationTitle2 AS `Onlands__locationTitle2`, Onlands.locationTxt1 AS `Onlands__locationTxt1`, Onlands.locationTxt2 AS `Onlands__locationTxt2`, Onlands.locationTxt3 AS `Onlands__locationTxt3`, Onlands.locationTxt4 AS `Onlands__locationTxt4`, Onlands.locationTxt5 AS `Onlands__locationTxt5`, Onlands.locationTxt6 AS `Onlands__locationTxt6`, Onlands.locationTxt7 AS `Onlands__locationTxt7`, Onlands.locationTxt8 AS `Onlands__locationTxt8`, Onlands.locationTxt9 AS `Onlands__locationTxt9`, Onlands.locationTxt10 AS `Onlands__locationTxt10`, Onlands.locationTxt11 AS `Onlands__locationTxt11`, Onlands.locationTxt12 AS `Onlands__locationTxt12`, Onlands.locationTxt13 AS `Onlands__locationTxt13`, Onlands.locationTxt14 AS `Onlands__locationTxt14`, Onlands.locationTxt15 AS `Onlands__locationTxt15`, Onlands.locationTxt16 AS `Onlands__locationTxt16`, Onlands.locationTxt17 AS `Onlands__locationTxt17`, Onlands.locationTxt18 AS `Onlands__locationTxt18`, Onlands.galleryTxt1 AS `Onlands__galleryTxt1`, Onlands.galleryTxt2 AS `Onlands__galleryTxt2`, Onlands.galleryTxt3 AS `Onlands__galleryTxt3`, Onlands.galleryTxt4 AS `Onlands__galleryTxt4`, Onlands.galleryTxt5 AS `Onlands__galleryTxt5`, Onlands.galleryTxt6 AS `Onlands__galleryTxt6`, Onlands.galleryTxt7 AS `Onlands__galleryTxt7`, Onlands.galleryTxt8 AS `Onlands__galleryTxt8`, Onlands.galleryTxt9 AS `Onlands__galleryTxt9`, Onlands.galleryTxt10 AS `Onlands__galleryTxt10`, Onlands.galleryTxt11 AS `Onlands__galleryTxt11`, Onlands.galleryTxt12 AS `Onlands__galleryTxt12`, Onlands.galleryTxt13 AS `Onlands__galleryTxt13`, Onlands.galleryTxt14 AS `Onlands__galleryTxt14`, Onlands.galleryTxt15 AS `Onlands__galleryTxt15`, Onlands.galleryTxt16 AS `Onlands__galleryTxt16`, Onlands.galleryTxt17 AS `Onlands__galleryTxt17`, Onlands.galleryTxt18 AS `Onlands__galleryTxt18`, Onlands.locationTraffic AS `Onlands__locationTraffic`, Onlands.locationSchool AS `Onlands__locationSchool`, Onlands.locationLife AS `Onlands__locationLife`, Onlands.locationOther AS `Onlands__locationOther`, Onlands.parthFlg AS `Onlands__parthFlg`, Onlands.parthImgFlg1 AS `Onlands__parthImgFlg1`, Onlands.parthImgFlg2 AS `Onlands__parthImgFlg2`, Onlands.parthImgFlg3 AS `Onlands__parthImgFlg3`, Onlands.parthImgFlg4 AS `Onlands__parthImgFlg4`, Onlands.kuwariFlg AS `Onlands__kuwariFlg`, Onlands.planFlg AS `Onlands__planFlg`, Onlands.outlinePrice AS `Onlands__outlinePrice`, Onlands.outlinePriceNum AS `Onlands__outlinePriceNum`, Onlands.outlineType AS `Onlands__outlineType`, Onlands.outlinePlace AS `Onlands__outlinePlace`, Onlands.outlineTraffic AS `Onlands__outlineTraffic`, Onlands.outlineRight AS `Onlands__outlineRight`, Onlands.outlineSite AS `Onlands__outlineSite`, Onlands.outlineFacility AS `Onlands__outlineFacility`, Onlands.outlineApproach AS `Onlands__outlineApproach`, Onlands.outlineCityplan AS `Onlands__outlineCityplan`, Onlands.outlineUse1 AS `Onlands__outlineUse1`, Onlands.outlineUse2 AS `Onlands__outlineUse2`, Onlands.outlineAltitude1 AS `Onlands__outlineAltitude1`, Onlands.outlineAltitude2 AS `Onlands__outlineAltitude2`, Onlands.outlineFire1 AS `Onlands__outlineFire1`, Onlands.outlineFire2 AS `Onlands__outlineFire2`, Onlands.outlineVolume1 AS `Onlands__outlineVolume1`, Onlands.outlineVolume2 AS `Onlands__outlineVolume2`, Onlands.outlinePlots AS `Onlands__outlinePlots`, Onlands.outlineStatus AS `Onlands__outlineStatus`, Onlands.outlineBuildingArea AS `Onlands__outlineBuildingArea`, Onlands.outlineConstruction AS `Onlands__outlineConstruction`, Onlands.outlineFloorPlan AS `Onlands__outlineFloorPlan`, Onlands.outlineCompTime AS `Onlands__outlineCompTime`, Onlands.outlineDelivTime AS `Onlands__outlineDelivTime`, Onlands.outlineTransForm AS `Onlands__outlineTransForm`, Onlands.outlineEquipment AS `Onlands__outlineEquipment`, Onlands.outlineComment AS `Onlands__outlineComment`, Onlands.outlineSchool AS `Onlands__outlineSchool`, Onlands.googleMap AS `Onlands__googleMap`, Onlands.memo AS `Onlands__memo`, Onlands.priceFlg AS `Onlands__priceFlg`, Onlands.newFlg AS `Onlands__newFlg`, Onlands.lastFlg AS `Onlands__lastFlg`, Onlands.topImgFlg AS `Onlands__topImgFlg`, Onlands.memberFlg AS `Onlands__memberFlg`, Onlands.deleteFlg AS `Onlands__deleteFlg`, Onlands.created AS `Onlands__created`, Onlands.modified AS `Onlands__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 onlands Onlands LEFT JOIN areas Areas ON Areas.id = (Onlands.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onlands.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onlands.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onlands.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onlands.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onlands.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onlands.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onlands.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onlands.station_id3) WHERE Onlands.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onlands__id' => 'integer', 'Onlands.id' => 'integer', 'id' => 'integer', 'Onlands__name' => 'string', 'Onlands.name' => 'string', 'name' => 'string', 'Onlands__mbAddress' => 'string', 'Onlands.mbAddress' => 'string', 'mbAddress' => 'string', 'Onlands__displayFlg' => 'tinyinteger', 'Onlands.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onlands__statusFlg' => 'tinyinteger', 'Onlands.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onlands__area_id' => 'integer', 'Onlands.area_id' => 'integer', 'area_id' => 'integer', 'Onlands__sectionNo' => 'tinyinteger', 'Onlands.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onlands__kind_id' => 'integer', 'Onlands.kind_id' => 'integer', 'kind_id' => 'integer', 'Onlands__landFlg' => 'tinyinteger', 'Onlands.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onlands__lifetownFlg' => 'tinyinteger', 'Onlands.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onlands__newoldFlg' => 'tinyinteger', 'Onlands.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onlands__tour_id' => 'integer', 'Onlands.tour_id' => 'integer', 'tour_id' => 'integer', 'Onlands__topDispFlg' => 'tinyinteger', 'Onlands.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onlands__recommFlg' => 'tinyinteger', 'Onlands.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onlands__railway_id1' => 'integer', 'Onlands.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onlands__railway_id2' => 'integer', 'Onlands.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onlands__railway_id3' => 'integer', 'Onlands.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onlands__station_id1' => 'integer', 'Onlands.station_id1' => 'integer', 'station_id1' => 'integer', 'Onlands__station_id2' => 'integer', 'Onlands.station_id2' => 'integer', 'station_id2' => 'integer', 'Onlands__station_id3' => 'integer', 'Onlands.station_id3' => 'integer', 'station_id3' => 'integer', 'Onlands__stwalk1' => 'string', 'Onlands.stwalk1' => 'string', 'stwalk1' => 'string', 'Onlands__stwalk2' => 'string', 'Onlands.stwalk2' => 'string', 'stwalk2' => 'string', 'Onlands__stwalk3' => 'string', 'Onlands.stwalk3' => 'string', 'stwalk3' => 'string', 'Onlands__bswalk1' => 'string', 'Onlands.bswalk1' => 'string', 'bswalk1' => 'string', 'Onlands__bswalk2' => 'string', 'Onlands.bswalk2' => 'string', 'bswalk2' => 'string', 'Onlands__bswalk3' => 'string', 'Onlands.bswalk3' => 'string', 'bswalk3' => 'string', 'Onlands__catchCopy' => 'string', 'Onlands.catchCopy' => 'string', 'catchCopy' => 'string', 'Onlands__stationStart' => 'string', 'Onlands.stationStart' => 'string', 'stationStart' => 'string', 'Onlands__stationTo1' => 'string', 'Onlands.stationTo1' => 'string', 'stationTo1' => 'string', 'Onlands__stationTo2' => 'string', 'Onlands.stationTo2' => 'string', 'stationTo2' => 'string', 'Onlands__stationTo3' => 'string', 'Onlands.stationTo3' => 'string', 'stationTo3' => 'string', 'Onlands__stationTo4' => 'string', 'Onlands.stationTo4' => 'string', 'stationTo4' => 'string', 'Onlands__trainTime1' => 'tinyinteger', 'Onlands.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onlands__trainTime2' => 'tinyinteger', 'Onlands.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onlands__trainTime3' => 'tinyinteger', 'Onlands.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onlands__trainTime4' => 'tinyinteger', 'Onlands.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onlands__trainDirect1' => 'tinyinteger', 'Onlands.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onlands__trainDirect2' => 'tinyinteger', 'Onlands.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onlands__trainDirect3' => 'tinyinteger', 'Onlands.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onlands__trainDirect4' => 'tinyinteger', 'Onlands.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onlands__trainVia1' => 'string', 'Onlands.trainVia1' => 'string', 'trainVia1' => 'string', 'Onlands__trainVia2' => 'string', 'Onlands.trainVia2' => 'string', 'trainVia2' => 'string', 'Onlands__trainVia3' => 'string', 'Onlands.trainVia3' => 'string', 'trainVia3' => 'string', 'Onlands__trainVia4' => 'string', 'Onlands.trainVia4' => 'string', 'trainVia4' => 'string', 'Onlands__locationFlg' => 'tinyinteger', 'Onlands.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onlands__locationTitle1' => 'string', 'Onlands.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onlands__locationTitle2' => 'string', 'Onlands.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onlands__locationTxt1' => 'string', 'Onlands.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onlands__locationTxt2' => 'string', 'Onlands.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onlands__locationTxt3' => 'string', 'Onlands.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onlands__locationTxt4' => 'string', 'Onlands.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onlands__locationTxt5' => 'string', 'Onlands.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onlands__locationTxt6' => 'string', 'Onlands.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onlands__locationTxt7' => 'string', 'Onlands.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onlands__locationTxt8' => 'string', 'Onlands.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onlands__locationTxt9' => 'string', 'Onlands.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onlands__locationTxt10' => 'string', 'Onlands.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onlands__locationTxt11' => 'string', 'Onlands.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onlands__locationTxt12' => 'string', 'Onlands.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onlands__locationTxt13' => 'string', 'Onlands.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onlands__locationTxt14' => 'string', 'Onlands.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onlands__locationTxt15' => 'string', 'Onlands.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onlands__locationTxt16' => 'string', 'Onlands.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onlands__locationTxt17' => 'string', 'Onlands.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onlands__locationTxt18' => 'string', 'Onlands.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onlands__galleryTxt1' => 'string', 'Onlands.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onlands__galleryTxt2' => 'string', 'Onlands.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onlands__galleryTxt3' => 'string', 'Onlands.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onlands__galleryTxt4' => 'string', 'Onlands.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onlands__galleryTxt5' => 'string', 'Onlands.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onlands__galleryTxt6' => 'string', 'Onlands.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onlands__galleryTxt7' => 'string', 'Onlands.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onlands__galleryTxt8' => 'string', 'Onlands.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onlands__galleryTxt9' => 'string', 'Onlands.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onlands__galleryTxt10' => 'string', 'Onlands.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onlands__galleryTxt11' => 'string', 'Onlands.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onlands__galleryTxt12' => 'string', 'Onlands.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onlands__galleryTxt13' => 'string', 'Onlands.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onlands__galleryTxt14' => 'string', 'Onlands.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onlands__galleryTxt15' => 'string', 'Onlands.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onlands__galleryTxt16' => 'string', 'Onlands.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onlands__galleryTxt17' => 'string', 'Onlands.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onlands__galleryTxt18' => 'string', 'Onlands.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onlands__locationTraffic' => 'string', 'Onlands.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onlands__locationSchool' => 'string', 'Onlands.locationSchool' => 'string', 'locationSchool' => 'string', 'Onlands__locationLife' => 'string', 'Onlands.locationLife' => 'string', 'locationLife' => 'string', 'Onlands__locationOther' => 'string', 'Onlands.locationOther' => 'string', 'locationOther' => 'string', 'Onlands__parthFlg' => 'tinyinteger', 'Onlands.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onlands__parthImgFlg1' => 'tinyinteger', 'Onlands.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onlands__parthImgFlg2' => 'tinyinteger', 'Onlands.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onlands__parthImgFlg3' => 'tinyinteger', 'Onlands.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onlands__parthImgFlg4' => 'tinyinteger', 'Onlands.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onlands__kuwariFlg' => 'tinyinteger', 'Onlands.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onlands__planFlg' => 'tinyinteger', 'Onlands.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onlands__outlinePrice' => 'string', 'Onlands.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onlands__outlinePriceNum' => 'integer', 'Onlands.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onlands__outlineType' => 'string', 'Onlands.outlineType' => 'string', 'outlineType' => 'string', 'Onlands__outlinePlace' => 'string', 'Onlands.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onlands__outlineTraffic' => 'string', 'Onlands.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onlands__outlineRight' => 'string', 'Onlands.outlineRight' => 'string', 'outlineRight' => 'string', 'Onlands__outlineSite' => 'string', 'Onlands.outlineSite' => 'string', 'outlineSite' => 'string', 'Onlands__outlineFacility' => 'string', 'Onlands.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onlands__outlineApproach' => 'string', 'Onlands.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onlands__outlineCityplan' => 'string', 'Onlands.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onlands__outlineUse1' => 'string', 'Onlands.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onlands__outlineUse2' => 'string', 'Onlands.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onlands__outlineAltitude1' => 'string', 'Onlands.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onlands__outlineAltitude2' => 'string', 'Onlands.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onlands__outlineFire1' => 'string', 'Onlands.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onlands__outlineFire2' => 'string', 'Onlands.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onlands__outlineVolume1' => 'string', 'Onlands.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onlands__outlineVolume2' => 'string', 'Onlands.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onlands__outlinePlots' => 'string', 'Onlands.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onlands__outlineStatus' => 'string', 'Onlands.outlineStatus' => 'string', 'outlineStatus' => 'string', 'Onlands__outlineBuildingArea' => 'string', 'Onlands.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onlands__outlineConstruction' => 'string', 'Onlands.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onlands__outlineFloorPlan' => 'string', 'Onlands.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onlands__outlineCompTime' => 'string', 'Onlands.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onlands__outlineDelivTime' => 'string', 'Onlands.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onlands__outlineTransForm' => 'string', 'Onlands.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onlands__outlineEquipment' => 'string', 'Onlands.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onlands__outlineComment' => 'string', 'Onlands.outlineComment' => 'string', 'outlineComment' => 'string', 'Onlands__outlineSchool' => 'string', 'Onlands.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onlands__googleMap' => 'string', 'Onlands.googleMap' => 'string', 'googleMap' => 'string', 'Onlands__memo' => 'string', 'Onlands.memo' => 'string', 'memo' => 'string', 'Onlands__priceFlg' => 'tinyinteger', 'Onlands.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onlands__newFlg' => 'tinyinteger', 'Onlands.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onlands__lastFlg' => 'tinyinteger', 'Onlands.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onlands__topImgFlg' => 'tinyinteger', 'Onlands.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onlands__memberFlg' => 'tinyinteger', 'Onlands.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onlands__deleteFlg' => 'tinyinteger', 'Onlands.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onlands__created' => 'datetime', 'Onlands.created' => 'datetime', 'created' => 'datetime', 'Onlands__modified' => 'datetime', 'Onlands.modified' => 'datetime', 'modified' => 'datetime', 'Lands__id' => 'integer', 'Lands.id' => 'integer', 'Lands__onland_id' => 'integer', 'Lands.onland_id' => 'integer', 'onland_id' => 'integer', 'Lands__displayFlg' => 'tinyinteger', 'Lands.displayFlg' => 'tinyinteger', 'Lands__statusFlg' => 'tinyinteger', 'Lands.statusFlg' => 'tinyinteger', 'Lands__name' => 'string', 'Lands.name' => 'string', 'Lands__landFlg' => 'tinyinteger', 'Lands.landFlg' => 'tinyinteger', 'Lands__landRights' => 'string', 'Lands.landRights' => 'string', 'landRights' => 'string', 'Lands__landArea' => 'decimal', 'Lands.landArea' => 'decimal', 'landArea' => 'decimal', 'Lands__pvateArea' => 'decimal', 'Lands.pvateArea' => 'decimal', 'pvateArea' => 'decimal', 'Lands__price' => 'decimal', 'Lands.price' => 'decimal', 'price' => 'decimal', 'Lands__refeArea' => 'decimal', 'Lands.refeArea' => 'decimal', 'refeArea' => 'decimal', 'Lands__refePrice' => 'decimal', 'Lands.refePrice' => 'decimal', 'refePrice' => 'decimal', 'Lands__PlanImgFlg' => 'tinyinteger', 'Lands.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Lands__PlanPdfFlg' => 'tinyinteger', 'Lands.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Lands__ground' => 'string', 'Lands.ground' => 'string', 'ground' => 'string', 'Lands__statusDoc' => 'string', 'Lands.statusDoc' => 'string', 'statusDoc' => 'string', 'Lands__comment' => 'string', 'Lands.comment' => 'string', 'comment' => 'string', 'Lands__memo' => 'string', 'Lands.memo' => 'string', 'Lands__areaCD' => 'integer', 'Lands.areaCD' => 'integer', 'areaCD' => 'integer', 'Lands__created' => 'datetime', 'Lands.created' => 'datetime', 'Lands__modified' => 'datetime', 'Lands.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' => [ 'lands' => [[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\OnlandsTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $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/Onlands/view.ctp, line 901 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 = [ 'Onlands' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onlands.id AS `Onlands__id`, Onlands.name AS `Onlands__name`, Onlands.mbAddress AS `Onlands__mbAddress`, Onlands.displayFlg AS `Onlands__displayFlg`, Onlands.statusFlg AS `Onlands__statusFlg`, Onlands.area_id AS `Onlands__area_id`, Onlands.sectionNo AS `Onlands__sectionNo`, Onlands.kind_id AS `Onlands__kind_id`, Onlands.landFlg AS `Onlands__landFlg`, Onlands.lifetownFlg AS `Onlands__lifetownFlg`, Onlands.newoldFlg AS `Onlands__newoldFlg`, Onlands.tour_id AS `Onlands__tour_id`, Onlands.topDispFlg AS `Onlands__topDispFlg`, Onlands.recommFlg AS `Onlands__recommFlg`, Onlands.railway_id1 AS `Onlands__railway_id1`, Onlands.railway_id2 AS `Onlands__railway_id2`, Onlands.railway_id3 AS `Onlands__railway_id3`, Onlands.station_id1 AS `Onlands__station_id1`, Onlands.station_id2 AS `Onlands__station_id2`, Onlands.station_id3 AS `Onlands__station_id3`, Onlands.stwalk1 AS `Onlands__stwalk1`, Onlands.stwalk2 AS `Onlands__stwalk2`, Onlands.stwalk3 AS `Onlands__stwalk3`, Onlands.bswalk1 AS `Onlands__bswalk1`, Onlands.bswalk2 AS `Onlands__bswalk2`, Onlands.bswalk3 AS `Onlands__bswalk3`, Onlands.catchCopy AS `Onlands__catchCopy`, Onlands.stationStart AS `Onlands__stationStart`, Onlands.stationTo1 AS `Onlands__stationTo1`, Onlands.stationTo2 AS `Onlands__stationTo2`, Onlands.stationTo3 AS `Onlands__stationTo3`, Onlands.stationTo4 AS `Onlands__stationTo4`, Onlands.trainTime1 AS `Onlands__trainTime1`, Onlands.trainTime2 AS `Onlands__trainTime2`, Onlands.trainTime3 AS `Onlands__trainTime3`, Onlands.trainTime4 AS `Onlands__trainTime4`, Onlands.trainDirect1 AS `Onlands__trainDirect1`, Onlands.trainDirect2 AS `Onlands__trainDirect2`, Onlands.trainDirect3 AS `Onlands__trainDirect3`, Onlands.trainDirect4 AS `Onlands__trainDirect4`, Onlands.trainVia1 AS `Onlands__trainVia1`, Onlands.trainVia2 AS `Onlands__trainVia2`, Onlands.trainVia3 AS `Onlands__trainVia3`, Onlands.trainVia4 AS `Onlands__trainVia4`, Onlands.locationFlg AS `Onlands__locationFlg`, Onlands.locationTitle1 AS `Onlands__locationTitle1`, Onlands.locationTitle2 AS `Onlands__locationTitle2`, Onlands.locationTxt1 AS `Onlands__locationTxt1`, Onlands.locationTxt2 AS `Onlands__locationTxt2`, Onlands.locationTxt3 AS `Onlands__locationTxt3`, Onlands.locationTxt4 AS `Onlands__locationTxt4`, Onlands.locationTxt5 AS `Onlands__locationTxt5`, Onlands.locationTxt6 AS `Onlands__locationTxt6`, Onlands.locationTxt7 AS `Onlands__locationTxt7`, Onlands.locationTxt8 AS `Onlands__locationTxt8`, Onlands.locationTxt9 AS `Onlands__locationTxt9`, Onlands.locationTxt10 AS `Onlands__locationTxt10`, Onlands.locationTxt11 AS `Onlands__locationTxt11`, Onlands.locationTxt12 AS `Onlands__locationTxt12`, Onlands.locationTxt13 AS `Onlands__locationTxt13`, Onlands.locationTxt14 AS `Onlands__locationTxt14`, Onlands.locationTxt15 AS `Onlands__locationTxt15`, Onlands.locationTxt16 AS `Onlands__locationTxt16`, Onlands.locationTxt17 AS `Onlands__locationTxt17`, Onlands.locationTxt18 AS `Onlands__locationTxt18`, Onlands.galleryTxt1 AS `Onlands__galleryTxt1`, Onlands.galleryTxt2 AS `Onlands__galleryTxt2`, Onlands.galleryTxt3 AS `Onlands__galleryTxt3`, Onlands.galleryTxt4 AS `Onlands__galleryTxt4`, Onlands.galleryTxt5 AS `Onlands__galleryTxt5`, Onlands.galleryTxt6 AS `Onlands__galleryTxt6`, Onlands.galleryTxt7 AS `Onlands__galleryTxt7`, Onlands.galleryTxt8 AS `Onlands__galleryTxt8`, Onlands.galleryTxt9 AS `Onlands__galleryTxt9`, Onlands.galleryTxt10 AS `Onlands__galleryTxt10`, Onlands.galleryTxt11 AS `Onlands__galleryTxt11`, Onlands.galleryTxt12 AS `Onlands__galleryTxt12`, Onlands.galleryTxt13 AS `Onlands__galleryTxt13`, Onlands.galleryTxt14 AS `Onlands__galleryTxt14`, Onlands.galleryTxt15 AS `Onlands__galleryTxt15`, Onlands.galleryTxt16 AS `Onlands__galleryTxt16`, Onlands.galleryTxt17 AS `Onlands__galleryTxt17`, Onlands.galleryTxt18 AS `Onlands__galleryTxt18`, Onlands.locationTraffic AS `Onlands__locationTraffic`, Onlands.locationSchool AS `Onlands__locationSchool`, Onlands.locationLife AS `Onlands__locationLife`, Onlands.locationOther AS `Onlands__locationOther`, Onlands.parthFlg AS `Onlands__parthFlg`, Onlands.parthImgFlg1 AS `Onlands__parthImgFlg1`, Onlands.parthImgFlg2 AS `Onlands__parthImgFlg2`, Onlands.parthImgFlg3 AS `Onlands__parthImgFlg3`, Onlands.parthImgFlg4 AS `Onlands__parthImgFlg4`, Onlands.kuwariFlg AS `Onlands__kuwariFlg`, Onlands.planFlg AS `Onlands__planFlg`, Onlands.outlinePrice AS `Onlands__outlinePrice`, Onlands.outlinePriceNum AS `Onlands__outlinePriceNum`, Onlands.outlineType AS `Onlands__outlineType`, Onlands.outlinePlace AS `Onlands__outlinePlace`, Onlands.outlineTraffic AS `Onlands__outlineTraffic`, Onlands.outlineRight AS `Onlands__outlineRight`, Onlands.outlineSite AS `Onlands__outlineSite`, Onlands.outlineFacility AS `Onlands__outlineFacility`, Onlands.outlineApproach AS `Onlands__outlineApproach`, Onlands.outlineCityplan AS `Onlands__outlineCityplan`, Onlands.outlineUse1 AS `Onlands__outlineUse1`, Onlands.outlineUse2 AS `Onlands__outlineUse2`, Onlands.outlineAltitude1 AS `Onlands__outlineAltitude1`, Onlands.outlineAltitude2 AS `Onlands__outlineAltitude2`, Onlands.outlineFire1 AS `Onlands__outlineFire1`, Onlands.outlineFire2 AS `Onlands__outlineFire2`, Onlands.outlineVolume1 AS `Onlands__outlineVolume1`, Onlands.outlineVolume2 AS `Onlands__outlineVolume2`, Onlands.outlinePlots AS `Onlands__outlinePlots`, Onlands.outlineStatus AS `Onlands__outlineStatus`, Onlands.outlineBuildingArea AS `Onlands__outlineBuildingArea`, Onlands.outlineConstruction AS `Onlands__outlineConstruction`, Onlands.outlineFloorPlan AS `Onlands__outlineFloorPlan`, Onlands.outlineCompTime AS `Onlands__outlineCompTime`, Onlands.outlineDelivTime AS `Onlands__outlineDelivTime`, Onlands.outlineTransForm AS `Onlands__outlineTransForm`, Onlands.outlineEquipment AS `Onlands__outlineEquipment`, Onlands.outlineComment AS `Onlands__outlineComment`, Onlands.outlineSchool AS `Onlands__outlineSchool`, Onlands.googleMap AS `Onlands__googleMap`, Onlands.memo AS `Onlands__memo`, Onlands.priceFlg AS `Onlands__priceFlg`, Onlands.newFlg AS `Onlands__newFlg`, Onlands.lastFlg AS `Onlands__lastFlg`, Onlands.topImgFlg AS `Onlands__topImgFlg`, Onlands.memberFlg AS `Onlands__memberFlg`, Onlands.deleteFlg AS `Onlands__deleteFlg`, Onlands.created AS `Onlands__created`, Onlands.modified AS `Onlands__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 onlands Onlands LEFT JOIN areas Areas ON Areas.id = (Onlands.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onlands.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onlands.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onlands.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onlands.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onlands.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onlands.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onlands.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onlands.station_id3) WHERE Onlands.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\OnlandsTable) {} }, 'area_results' => [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ], 'railway_results' => [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ], 'OptionCT' => [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ], 'user' => null, 'NoList' => true, 'members_total' => '19' ] $Onlands = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onlands.id AS `Onlands__id`, Onlands.name AS `Onlands__name`, Onlands.mbAddress AS `Onlands__mbAddress`, Onlands.displayFlg AS `Onlands__displayFlg`, Onlands.statusFlg AS `Onlands__statusFlg`, Onlands.area_id AS `Onlands__area_id`, Onlands.sectionNo AS `Onlands__sectionNo`, Onlands.kind_id AS `Onlands__kind_id`, Onlands.landFlg AS `Onlands__landFlg`, Onlands.lifetownFlg AS `Onlands__lifetownFlg`, Onlands.newoldFlg AS `Onlands__newoldFlg`, Onlands.tour_id AS `Onlands__tour_id`, Onlands.topDispFlg AS `Onlands__topDispFlg`, Onlands.recommFlg AS `Onlands__recommFlg`, Onlands.railway_id1 AS `Onlands__railway_id1`, Onlands.railway_id2 AS `Onlands__railway_id2`, Onlands.railway_id3 AS `Onlands__railway_id3`, Onlands.station_id1 AS `Onlands__station_id1`, Onlands.station_id2 AS `Onlands__station_id2`, Onlands.station_id3 AS `Onlands__station_id3`, Onlands.stwalk1 AS `Onlands__stwalk1`, Onlands.stwalk2 AS `Onlands__stwalk2`, Onlands.stwalk3 AS `Onlands__stwalk3`, Onlands.bswalk1 AS `Onlands__bswalk1`, Onlands.bswalk2 AS `Onlands__bswalk2`, Onlands.bswalk3 AS `Onlands__bswalk3`, Onlands.catchCopy AS `Onlands__catchCopy`, Onlands.stationStart AS `Onlands__stationStart`, Onlands.stationTo1 AS `Onlands__stationTo1`, Onlands.stationTo2 AS `Onlands__stationTo2`, Onlands.stationTo3 AS `Onlands__stationTo3`, Onlands.stationTo4 AS `Onlands__stationTo4`, Onlands.trainTime1 AS `Onlands__trainTime1`, Onlands.trainTime2 AS `Onlands__trainTime2`, Onlands.trainTime3 AS `Onlands__trainTime3`, Onlands.trainTime4 AS `Onlands__trainTime4`, Onlands.trainDirect1 AS `Onlands__trainDirect1`, Onlands.trainDirect2 AS `Onlands__trainDirect2`, Onlands.trainDirect3 AS `Onlands__trainDirect3`, Onlands.trainDirect4 AS `Onlands__trainDirect4`, Onlands.trainVia1 AS `Onlands__trainVia1`, Onlands.trainVia2 AS `Onlands__trainVia2`, Onlands.trainVia3 AS `Onlands__trainVia3`, Onlands.trainVia4 AS `Onlands__trainVia4`, Onlands.locationFlg AS `Onlands__locationFlg`, Onlands.locationTitle1 AS `Onlands__locationTitle1`, Onlands.locationTitle2 AS `Onlands__locationTitle2`, Onlands.locationTxt1 AS `Onlands__locationTxt1`, Onlands.locationTxt2 AS `Onlands__locationTxt2`, Onlands.locationTxt3 AS `Onlands__locationTxt3`, Onlands.locationTxt4 AS `Onlands__locationTxt4`, Onlands.locationTxt5 AS `Onlands__locationTxt5`, Onlands.locationTxt6 AS `Onlands__locationTxt6`, Onlands.locationTxt7 AS `Onlands__locationTxt7`, Onlands.locationTxt8 AS `Onlands__locationTxt8`, Onlands.locationTxt9 AS `Onlands__locationTxt9`, Onlands.locationTxt10 AS `Onlands__locationTxt10`, Onlands.locationTxt11 AS `Onlands__locationTxt11`, Onlands.locationTxt12 AS `Onlands__locationTxt12`, Onlands.locationTxt13 AS `Onlands__locationTxt13`, Onlands.locationTxt14 AS `Onlands__locationTxt14`, Onlands.locationTxt15 AS `Onlands__locationTxt15`, Onlands.locationTxt16 AS `Onlands__locationTxt16`, Onlands.locationTxt17 AS `Onlands__locationTxt17`, Onlands.locationTxt18 AS `Onlands__locationTxt18`, Onlands.galleryTxt1 AS `Onlands__galleryTxt1`, Onlands.galleryTxt2 AS `Onlands__galleryTxt2`, Onlands.galleryTxt3 AS `Onlands__galleryTxt3`, Onlands.galleryTxt4 AS `Onlands__galleryTxt4`, Onlands.galleryTxt5 AS `Onlands__galleryTxt5`, Onlands.galleryTxt6 AS `Onlands__galleryTxt6`, Onlands.galleryTxt7 AS `Onlands__galleryTxt7`, Onlands.galleryTxt8 AS `Onlands__galleryTxt8`, Onlands.galleryTxt9 AS `Onlands__galleryTxt9`, Onlands.galleryTxt10 AS `Onlands__galleryTxt10`, Onlands.galleryTxt11 AS `Onlands__galleryTxt11`, Onlands.galleryTxt12 AS `Onlands__galleryTxt12`, Onlands.galleryTxt13 AS `Onlands__galleryTxt13`, Onlands.galleryTxt14 AS `Onlands__galleryTxt14`, Onlands.galleryTxt15 AS `Onlands__galleryTxt15`, Onlands.galleryTxt16 AS `Onlands__galleryTxt16`, Onlands.galleryTxt17 AS `Onlands__galleryTxt17`, Onlands.galleryTxt18 AS `Onlands__galleryTxt18`, Onlands.locationTraffic AS `Onlands__locationTraffic`, Onlands.locationSchool AS `Onlands__locationSchool`, Onlands.locationLife AS `Onlands__locationLife`, Onlands.locationOther AS `Onlands__locationOther`, Onlands.parthFlg AS `Onlands__parthFlg`, Onlands.parthImgFlg1 AS `Onlands__parthImgFlg1`, Onlands.parthImgFlg2 AS `Onlands__parthImgFlg2`, Onlands.parthImgFlg3 AS `Onlands__parthImgFlg3`, Onlands.parthImgFlg4 AS `Onlands__parthImgFlg4`, Onlands.kuwariFlg AS `Onlands__kuwariFlg`, Onlands.planFlg AS `Onlands__planFlg`, Onlands.outlinePrice AS `Onlands__outlinePrice`, Onlands.outlinePriceNum AS `Onlands__outlinePriceNum`, Onlands.outlineType AS `Onlands__outlineType`, Onlands.outlinePlace AS `Onlands__outlinePlace`, Onlands.outlineTraffic AS `Onlands__outlineTraffic`, Onlands.outlineRight AS `Onlands__outlineRight`, Onlands.outlineSite AS `Onlands__outlineSite`, Onlands.outlineFacility AS `Onlands__outlineFacility`, Onlands.outlineApproach AS `Onlands__outlineApproach`, Onlands.outlineCityplan AS `Onlands__outlineCityplan`, Onlands.outlineUse1 AS `Onlands__outlineUse1`, Onlands.outlineUse2 AS `Onlands__outlineUse2`, Onlands.outlineAltitude1 AS `Onlands__outlineAltitude1`, Onlands.outlineAltitude2 AS `Onlands__outlineAltitude2`, Onlands.outlineFire1 AS `Onlands__outlineFire1`, Onlands.outlineFire2 AS `Onlands__outlineFire2`, Onlands.outlineVolume1 AS `Onlands__outlineVolume1`, Onlands.outlineVolume2 AS `Onlands__outlineVolume2`, Onlands.outlinePlots AS `Onlands__outlinePlots`, Onlands.outlineStatus AS `Onlands__outlineStatus`, Onlands.outlineBuildingArea AS `Onlands__outlineBuildingArea`, Onlands.outlineConstruction AS `Onlands__outlineConstruction`, Onlands.outlineFloorPlan AS `Onlands__outlineFloorPlan`, Onlands.outlineCompTime AS `Onlands__outlineCompTime`, Onlands.outlineDelivTime AS `Onlands__outlineDelivTime`, Onlands.outlineTransForm AS `Onlands__outlineTransForm`, Onlands.outlineEquipment AS `Onlands__outlineEquipment`, Onlands.outlineComment AS `Onlands__outlineComment`, Onlands.outlineSchool AS `Onlands__outlineSchool`, Onlands.googleMap AS `Onlands__googleMap`, Onlands.memo AS `Onlands__memo`, Onlands.priceFlg AS `Onlands__priceFlg`, Onlands.newFlg AS `Onlands__newFlg`, Onlands.lastFlg AS `Onlands__lastFlg`, Onlands.topImgFlg AS `Onlands__topImgFlg`, Onlands.memberFlg AS `Onlands__memberFlg`, Onlands.deleteFlg AS `Onlands__deleteFlg`, Onlands.created AS `Onlands__created`, Onlands.modified AS `Onlands__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 onlands Onlands LEFT JOIN areas Areas ON Areas.id = (Onlands.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onlands.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onlands.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onlands.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onlands.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onlands.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onlands.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onlands.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onlands.station_id3) WHERE Onlands.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onlands__id' => 'integer', 'Onlands.id' => 'integer', 'id' => 'integer', 'Onlands__name' => 'string', 'Onlands.name' => 'string', 'name' => 'string', 'Onlands__mbAddress' => 'string', 'Onlands.mbAddress' => 'string', 'mbAddress' => 'string', 'Onlands__displayFlg' => 'tinyinteger', 'Onlands.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onlands__statusFlg' => 'tinyinteger', 'Onlands.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onlands__area_id' => 'integer', 'Onlands.area_id' => 'integer', 'area_id' => 'integer', 'Onlands__sectionNo' => 'tinyinteger', 'Onlands.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onlands__kind_id' => 'integer', 'Onlands.kind_id' => 'integer', 'kind_id' => 'integer', 'Onlands__landFlg' => 'tinyinteger', 'Onlands.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onlands__lifetownFlg' => 'tinyinteger', 'Onlands.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onlands__newoldFlg' => 'tinyinteger', 'Onlands.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onlands__tour_id' => 'integer', 'Onlands.tour_id' => 'integer', 'tour_id' => 'integer', 'Onlands__topDispFlg' => 'tinyinteger', 'Onlands.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onlands__recommFlg' => 'tinyinteger', 'Onlands.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onlands__railway_id1' => 'integer', 'Onlands.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onlands__railway_id2' => 'integer', 'Onlands.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onlands__railway_id3' => 'integer', 'Onlands.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onlands__station_id1' => 'integer', 'Onlands.station_id1' => 'integer', 'station_id1' => 'integer', 'Onlands__station_id2' => 'integer', 'Onlands.station_id2' => 'integer', 'station_id2' => 'integer', 'Onlands__station_id3' => 'integer', 'Onlands.station_id3' => 'integer', 'station_id3' => 'integer', 'Onlands__stwalk1' => 'string', 'Onlands.stwalk1' => 'string', 'stwalk1' => 'string', 'Onlands__stwalk2' => 'string', 'Onlands.stwalk2' => 'string', 'stwalk2' => 'string', 'Onlands__stwalk3' => 'string', 'Onlands.stwalk3' => 'string', 'stwalk3' => 'string', 'Onlands__bswalk1' => 'string', 'Onlands.bswalk1' => 'string', 'bswalk1' => 'string', 'Onlands__bswalk2' => 'string', 'Onlands.bswalk2' => 'string', 'bswalk2' => 'string', 'Onlands__bswalk3' => 'string', 'Onlands.bswalk3' => 'string', 'bswalk3' => 'string', 'Onlands__catchCopy' => 'string', 'Onlands.catchCopy' => 'string', 'catchCopy' => 'string', 'Onlands__stationStart' => 'string', 'Onlands.stationStart' => 'string', 'stationStart' => 'string', 'Onlands__stationTo1' => 'string', 'Onlands.stationTo1' => 'string', 'stationTo1' => 'string', 'Onlands__stationTo2' => 'string', 'Onlands.stationTo2' => 'string', 'stationTo2' => 'string', 'Onlands__stationTo3' => 'string', 'Onlands.stationTo3' => 'string', 'stationTo3' => 'string', 'Onlands__stationTo4' => 'string', 'Onlands.stationTo4' => 'string', 'stationTo4' => 'string', 'Onlands__trainTime1' => 'tinyinteger', 'Onlands.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onlands__trainTime2' => 'tinyinteger', 'Onlands.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onlands__trainTime3' => 'tinyinteger', 'Onlands.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onlands__trainTime4' => 'tinyinteger', 'Onlands.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onlands__trainDirect1' => 'tinyinteger', 'Onlands.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onlands__trainDirect2' => 'tinyinteger', 'Onlands.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onlands__trainDirect3' => 'tinyinteger', 'Onlands.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onlands__trainDirect4' => 'tinyinteger', 'Onlands.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onlands__trainVia1' => 'string', 'Onlands.trainVia1' => 'string', 'trainVia1' => 'string', 'Onlands__trainVia2' => 'string', 'Onlands.trainVia2' => 'string', 'trainVia2' => 'string', 'Onlands__trainVia3' => 'string', 'Onlands.trainVia3' => 'string', 'trainVia3' => 'string', 'Onlands__trainVia4' => 'string', 'Onlands.trainVia4' => 'string', 'trainVia4' => 'string', 'Onlands__locationFlg' => 'tinyinteger', 'Onlands.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onlands__locationTitle1' => 'string', 'Onlands.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onlands__locationTitle2' => 'string', 'Onlands.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onlands__locationTxt1' => 'string', 'Onlands.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onlands__locationTxt2' => 'string', 'Onlands.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onlands__locationTxt3' => 'string', 'Onlands.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onlands__locationTxt4' => 'string', 'Onlands.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onlands__locationTxt5' => 'string', 'Onlands.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onlands__locationTxt6' => 'string', 'Onlands.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onlands__locationTxt7' => 'string', 'Onlands.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onlands__locationTxt8' => 'string', 'Onlands.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onlands__locationTxt9' => 'string', 'Onlands.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onlands__locationTxt10' => 'string', 'Onlands.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onlands__locationTxt11' => 'string', 'Onlands.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onlands__locationTxt12' => 'string', 'Onlands.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onlands__locationTxt13' => 'string', 'Onlands.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onlands__locationTxt14' => 'string', 'Onlands.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onlands__locationTxt15' => 'string', 'Onlands.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onlands__locationTxt16' => 'string', 'Onlands.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onlands__locationTxt17' => 'string', 'Onlands.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onlands__locationTxt18' => 'string', 'Onlands.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onlands__galleryTxt1' => 'string', 'Onlands.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onlands__galleryTxt2' => 'string', 'Onlands.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onlands__galleryTxt3' => 'string', 'Onlands.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onlands__galleryTxt4' => 'string', 'Onlands.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onlands__galleryTxt5' => 'string', 'Onlands.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onlands__galleryTxt6' => 'string', 'Onlands.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onlands__galleryTxt7' => 'string', 'Onlands.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onlands__galleryTxt8' => 'string', 'Onlands.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onlands__galleryTxt9' => 'string', 'Onlands.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onlands__galleryTxt10' => 'string', 'Onlands.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onlands__galleryTxt11' => 'string', 'Onlands.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onlands__galleryTxt12' => 'string', 'Onlands.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onlands__galleryTxt13' => 'string', 'Onlands.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onlands__galleryTxt14' => 'string', 'Onlands.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onlands__galleryTxt15' => 'string', 'Onlands.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onlands__galleryTxt16' => 'string', 'Onlands.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onlands__galleryTxt17' => 'string', 'Onlands.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onlands__galleryTxt18' => 'string', 'Onlands.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onlands__locationTraffic' => 'string', 'Onlands.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onlands__locationSchool' => 'string', 'Onlands.locationSchool' => 'string', 'locationSchool' => 'string', 'Onlands__locationLife' => 'string', 'Onlands.locationLife' => 'string', 'locationLife' => 'string', 'Onlands__locationOther' => 'string', 'Onlands.locationOther' => 'string', 'locationOther' => 'string', 'Onlands__parthFlg' => 'tinyinteger', 'Onlands.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onlands__parthImgFlg1' => 'tinyinteger', 'Onlands.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onlands__parthImgFlg2' => 'tinyinteger', 'Onlands.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onlands__parthImgFlg3' => 'tinyinteger', 'Onlands.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onlands__parthImgFlg4' => 'tinyinteger', 'Onlands.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onlands__kuwariFlg' => 'tinyinteger', 'Onlands.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onlands__planFlg' => 'tinyinteger', 'Onlands.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onlands__outlinePrice' => 'string', 'Onlands.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onlands__outlinePriceNum' => 'integer', 'Onlands.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onlands__outlineType' => 'string', 'Onlands.outlineType' => 'string', 'outlineType' => 'string', 'Onlands__outlinePlace' => 'string', 'Onlands.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onlands__outlineTraffic' => 'string', 'Onlands.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onlands__outlineRight' => 'string', 'Onlands.outlineRight' => 'string', 'outlineRight' => 'string', 'Onlands__outlineSite' => 'string', 'Onlands.outlineSite' => 'string', 'outlineSite' => 'string', 'Onlands__outlineFacility' => 'string', 'Onlands.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onlands__outlineApproach' => 'string', 'Onlands.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onlands__outlineCityplan' => 'string', 'Onlands.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onlands__outlineUse1' => 'string', 'Onlands.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onlands__outlineUse2' => 'string', 'Onlands.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onlands__outlineAltitude1' => 'string', 'Onlands.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onlands__outlineAltitude2' => 'string', 'Onlands.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onlands__outlineFire1' => 'string', 'Onlands.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onlands__outlineFire2' => 'string', 'Onlands.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onlands__outlineVolume1' => 'string', 'Onlands.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onlands__outlineVolume2' => 'string', 'Onlands.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onlands__outlinePlots' => 'string', 'Onlands.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onlands__outlineStatus' => 'string', 'Onlands.outlineStatus' => 'string', 'outlineStatus' => 'string', 'Onlands__outlineBuildingArea' => 'string', 'Onlands.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onlands__outlineConstruction' => 'string', 'Onlands.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onlands__outlineFloorPlan' => 'string', 'Onlands.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onlands__outlineCompTime' => 'string', 'Onlands.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onlands__outlineDelivTime' => 'string', 'Onlands.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onlands__outlineTransForm' => 'string', 'Onlands.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onlands__outlineEquipment' => 'string', 'Onlands.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onlands__outlineComment' => 'string', 'Onlands.outlineComment' => 'string', 'outlineComment' => 'string', 'Onlands__outlineSchool' => 'string', 'Onlands.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onlands__googleMap' => 'string', 'Onlands.googleMap' => 'string', 'googleMap' => 'string', 'Onlands__memo' => 'string', 'Onlands.memo' => 'string', 'memo' => 'string', 'Onlands__priceFlg' => 'tinyinteger', 'Onlands.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onlands__newFlg' => 'tinyinteger', 'Onlands.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onlands__lastFlg' => 'tinyinteger', 'Onlands.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onlands__topImgFlg' => 'tinyinteger', 'Onlands.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onlands__memberFlg' => 'tinyinteger', 'Onlands.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onlands__deleteFlg' => 'tinyinteger', 'Onlands.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onlands__created' => 'datetime', 'Onlands.created' => 'datetime', 'created' => 'datetime', 'Onlands__modified' => 'datetime', 'Onlands.modified' => 'datetime', 'modified' => 'datetime', 'Lands__id' => 'integer', 'Lands.id' => 'integer', 'Lands__onland_id' => 'integer', 'Lands.onland_id' => 'integer', 'onland_id' => 'integer', 'Lands__displayFlg' => 'tinyinteger', 'Lands.displayFlg' => 'tinyinteger', 'Lands__statusFlg' => 'tinyinteger', 'Lands.statusFlg' => 'tinyinteger', 'Lands__name' => 'string', 'Lands.name' => 'string', 'Lands__landFlg' => 'tinyinteger', 'Lands.landFlg' => 'tinyinteger', 'Lands__landRights' => 'string', 'Lands.landRights' => 'string', 'landRights' => 'string', 'Lands__landArea' => 'decimal', 'Lands.landArea' => 'decimal', 'landArea' => 'decimal', 'Lands__pvateArea' => 'decimal', 'Lands.pvateArea' => 'decimal', 'pvateArea' => 'decimal', 'Lands__price' => 'decimal', 'Lands.price' => 'decimal', 'price' => 'decimal', 'Lands__refeArea' => 'decimal', 'Lands.refeArea' => 'decimal', 'refeArea' => 'decimal', 'Lands__refePrice' => 'decimal', 'Lands.refePrice' => 'decimal', 'refePrice' => 'decimal', 'Lands__PlanImgFlg' => 'tinyinteger', 'Lands.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Lands__PlanPdfFlg' => 'tinyinteger', 'Lands.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Lands__ground' => 'string', 'Lands.ground' => 'string', 'ground' => 'string', 'Lands__statusDoc' => 'string', 'Lands.statusDoc' => 'string', 'statusDoc' => 'string', 'Lands__comment' => 'string', 'Lands.comment' => 'string', 'comment' => 'string', 'Lands__memo' => 'string', 'Lands.memo' => 'string', 'Lands__areaCD' => 'integer', 'Lands.areaCD' => 'integer', 'areaCD' => 'integer', 'Lands__created' => 'datetime', 'Lands.created' => 'datetime', 'Lands__modified' => 'datetime', 'Lands.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' => [ 'lands' => [[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\OnlandsTable) {} } $area_results = [ (int) 0 => [ 'area_id' => '1', 'name' => '杉並区', 'Ct' => '44', 'CtM' => '17' ], (int) 1 => [ 'area_id' => '2', 'name' => '練馬区', 'Ct' => '24', 'CtM' => '1' ], (int) 2 => [ 'area_id' => '3', 'name' => '中野区', 'Ct' => '7', 'CtM' => '0' ], (int) 3 => [ 'area_id' => '5', 'name' => '世田谷区', 'Ct' => '2', 'CtM' => '0' ], (int) 4 => [ 'area_id' => '8', 'name' => '新宿区', 'Ct' => '2', 'CtM' => '0' ], (int) 5 => [ 'area_id' => '9', 'name' => '豊島区', 'Ct' => '1', 'CtM' => '0' ], (int) 6 => [ 'area_id' => '10', 'name' => '渋谷区', 'Ct' => '1', 'CtM' => '0' ], (int) 7 => [ 'area_id' => '24', 'name' => '武蔵野市', 'Ct' => '3', 'CtM' => '0' ], (int) 8 => [ 'area_id' => '25', 'name' => '三鷹市', 'Ct' => '0', 'CtM' => '1' ], (int) 9 => [ 'area_id' => '28', 'name' => '西東京市', 'Ct' => '3', 'CtM' => '0' ] ] $railway_results = [ (int) 0 => [ 'rway' => '11302', 'name' => 'JR山手線', 'ct' => '3' ], (int) 1 => [ 'rway' => '11312', 'name' => 'JR中央線(快速)', 'ct' => '58' ], (int) 2 => [ 'rway' => '11313', 'name' => 'JR中央・総武線', 'ct' => '9' ], (int) 3 => [ 'rway' => '21001', 'name' => '東武東上線', 'ct' => '2' ], (int) 4 => [ 'rway' => '22001', 'name' => '西武池袋線', 'ct' => '37' ], (int) 5 => [ 'rway' => '22007', 'name' => '西武新宿線', 'ct' => '64' ], (int) 6 => [ 'rway' => '24001', 'name' => '京王線', 'ct' => '10' ], (int) 7 => [ 'rway' => '24006', 'name' => '京王井の頭線', 'ct' => '30' ], (int) 8 => [ 'rway' => '24007', 'name' => '京王新線', 'ct' => '1' ], (int) 9 => [ 'rway' => '25001', 'name' => '小田急線', 'ct' => '2' ], (int) 10 => [ 'rway' => '26003', 'name' => '東急田園都市線', 'ct' => '1' ], (int) 11 => [ 'rway' => '26007', 'name' => '東急世田谷線', 'ct' => '2' ], (int) 12 => [ 'rway' => '28002', 'name' => '東京メトロ丸ノ内線', 'ct' => '24' ], (int) 13 => [ 'rway' => '28004', 'name' => '東京メトロ東西線', 'ct' => '1' ], (int) 14 => [ 'rway' => '28006', 'name' => '東京メトロ有楽町線', 'ct' => '2' ], (int) 15 => [ 'rway' => '28010', 'name' => '東京メトロ副都心線', 'ct' => '5' ], (int) 16 => [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] ] $OptionCT = [ 'railway' => (int) 19, 'pet' => (int) 9, 'life' => (int) 61, 'space' => (int) 18 ] $user = null $NoList = true $members_total = '19' $dat = [ 'rway' => '99301', 'name' => '都営大江戸線', 'ct' => '10' ] $key = (int) 16 $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/Onlands/view.ctp, line 901 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.
エリア検索