JR荻窪駅より徒歩12分。静寂さのある清水エリアに南道路に面する高級感を醸し出す2邸が誕生。外構エントランスから間接照明やアプローチライトがお出迎えを演出。魅せる拘りは妥協がなく、至る所に石やタイルが惜しみなく施されている。ラグジュアリーホテルを彷彿とさせるファシリティとデザインで造られた建築物は、優雅な暮らしのステージへと完成を迎えた。
4LDK+カースペース2台
敷地面積：112.48m2 建物延床面積：114.43m2
15,350万円
4LDK+カースペース2台
敷地面積：112.22m2 建物延床面積：114.43m2
15,550万円
現地イベント開催中
| 価格 | 15,350万円～15,550万円 |
|---|---|
| 種類 | 新築戸建 |
| 所在地 | 杉並区清水1丁目 |
| 土地権利 | 所有権 |
| 敷地面積 | 112.22㎡～112.48㎡ |
| 設備 | 公営水道・本下水・東京ガス・東京電力 |
| 接道状況 | 南側 約8.1m公道 |
| 都市計画 | 市街化区域 |
| 用途地域 | 第一種低層住居専用地域 |
| 高度地区 | |
| 防火指定 | 準防火地域 |
| 建ぺい率/ 容積率 |
50％／100％ |
| 総区画数 | 2 |
| 建築確認番号 | 第24UDI1T建01526号他 |
| 建物面積 | 114.43㎡ |
| 建物構造 | 木造2階建 |
| 間取り | 4LDK+カースペース2台 |
| 完成時期 | 2025年4月中旬予定 |
| 引渡時期 | 相談 |
| 取引態様 | 媒介 |
| 建物仕様 | ◆床暖房 ◆エアコン(LDK) ◆食洗機(深型) ◆カップボード ◆タッチレス水栓 ◆高級人造石フィオレストーン ◆浴室1618サイズ ◆浴室換気乾燥機 ◆ガス乾燥機「乾太くん」 ◆2ボウル洗面台 ◆五面鏡 ◆リネン庫 ◆TVモニター付インターフォン ◆電気錠ピタットキー ◆宅配ボックス ◆屋外カメラ |
|---|---|
| ポイント | ●制震ダンパー ●耐震等級3 ●断熱等性能等級4 ●一次エネルギー消費量等級5 |
| 指定学校区 | 杉並区立沓掛小学校 杉並区立井荻中学校 |
| 備考 | ●地盤保証20年 ●JIOわが家の保険 |
杉並区立沓掛小学校 約850m 徒歩11分
杉並区立井荻中学校 約1200m 徒歩15分
桃井幼稚園 約500m 徒歩7分
ローソンストア100 杉並桃井店 約250m 徒歩4分
セブンイレブン 杉並天沼通り店 約500m 徒歩7分
まいばすけっと 荻窪四面道店 約500m 徒歩7分
荻窪タウンセブン 約1000m 徒歩13分
杉並四面道郵便局 約450m 徒歩6分
東京衛生アドベンチスト病院 約650m 徒歩9分
杉並区立妙正寺公園 約800m 徒歩10分
JR中央線/総武線・東京メトロ丸ノ内線「荻窪」駅 約960m 徒歩12分
西武新宿線「井荻」駅 約1760m 徒歩22分
外観
カースペース2台
外観
外観
前面道路
現地イベント開催中
現地イベント開催中
路線検索
会員限定物件
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 = [ 'Onsites' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__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 onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.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\OnsitesTable) {} }, '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' ] $Onsites = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__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 onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onsites__id' => 'integer', 'Onsites.id' => 'integer', 'id' => 'integer', 'Onsites__name' => 'string', 'Onsites.name' => 'string', 'name' => 'string', 'Onsites__mbAddress' => 'string', 'Onsites.mbAddress' => 'string', 'mbAddress' => 'string', 'Onsites__displayFlg' => 'tinyinteger', 'Onsites.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onsites__statusFlg' => 'tinyinteger', 'Onsites.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onsites__area_id' => 'integer', 'Onsites.area_id' => 'integer', 'area_id' => 'integer', 'Onsites__sectionNo' => 'tinyinteger', 'Onsites.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onsites__kind_id' => 'integer', 'Onsites.kind_id' => 'integer', 'kind_id' => 'integer', 'Onsites__landFlg' => 'tinyinteger', 'Onsites.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onsites__lifetownFlg' => 'tinyinteger', 'Onsites.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onsites__newoldFlg' => 'tinyinteger', 'Onsites.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onsites__tour_id' => 'integer', 'Onsites.tour_id' => 'integer', 'tour_id' => 'integer', 'Onsites__topDispFlg' => 'tinyinteger', 'Onsites.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onsites__recommFlg' => 'tinyinteger', 'Onsites.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onsites__railway_id1' => 'integer', 'Onsites.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onsites__railway_id2' => 'integer', 'Onsites.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onsites__railway_id3' => 'integer', 'Onsites.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onsites__station_id1' => 'integer', 'Onsites.station_id1' => 'integer', 'station_id1' => 'integer', 'Onsites__station_id2' => 'integer', 'Onsites.station_id2' => 'integer', 'station_id2' => 'integer', 'Onsites__station_id3' => 'integer', 'Onsites.station_id3' => 'integer', 'station_id3' => 'integer', 'Onsites__stwalk1' => 'string', 'Onsites.stwalk1' => 'string', 'stwalk1' => 'string', 'Onsites__stwalk2' => 'string', 'Onsites.stwalk2' => 'string', 'stwalk2' => 'string', 'Onsites__stwalk3' => 'string', 'Onsites.stwalk3' => 'string', 'stwalk3' => 'string', 'Onsites__bswalk1' => 'string', 'Onsites.bswalk1' => 'string', 'bswalk1' => 'string', 'Onsites__bswalk2' => 'string', 'Onsites.bswalk2' => 'string', 'bswalk2' => 'string', 'Onsites__bswalk3' => 'string', 'Onsites.bswalk3' => 'string', 'bswalk3' => 'string', 'Onsites__catchCopy' => 'string', 'Onsites.catchCopy' => 'string', 'catchCopy' => 'string', 'Onsites__stationStart' => 'string', 'Onsites.stationStart' => 'string', 'stationStart' => 'string', 'Onsites__stationTo1' => 'string', 'Onsites.stationTo1' => 'string', 'stationTo1' => 'string', 'Onsites__stationTo2' => 'string', 'Onsites.stationTo2' => 'string', 'stationTo2' => 'string', 'Onsites__stationTo3' => 'string', 'Onsites.stationTo3' => 'string', 'stationTo3' => 'string', 'Onsites__stationTo4' => 'string', 'Onsites.stationTo4' => 'string', 'stationTo4' => 'string', 'Onsites__trainTime1' => 'tinyinteger', 'Onsites.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onsites__trainTime2' => 'tinyinteger', 'Onsites.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onsites__trainTime3' => 'tinyinteger', 'Onsites.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onsites__trainTime4' => 'tinyinteger', 'Onsites.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onsites__trainDirect1' => 'tinyinteger', 'Onsites.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onsites__trainDirect2' => 'tinyinteger', 'Onsites.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onsites__trainDirect3' => 'tinyinteger', 'Onsites.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onsites__trainDirect4' => 'tinyinteger', 'Onsites.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onsites__trainVia1' => 'string', 'Onsites.trainVia1' => 'string', 'trainVia1' => 'string', 'Onsites__trainVia2' => 'string', 'Onsites.trainVia2' => 'string', 'trainVia2' => 'string', 'Onsites__trainVia3' => 'string', 'Onsites.trainVia3' => 'string', 'trainVia3' => 'string', 'Onsites__trainVia4' => 'string', 'Onsites.trainVia4' => 'string', 'trainVia4' => 'string', 'Onsites__locationFlg' => 'tinyinteger', 'Onsites.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onsites__locationTitle1' => 'string', 'Onsites.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onsites__locationTitle2' => 'string', 'Onsites.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onsites__locationTxt1' => 'string', 'Onsites.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onsites__locationTxt2' => 'string', 'Onsites.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onsites__locationTxt3' => 'string', 'Onsites.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onsites__locationTxt4' => 'string', 'Onsites.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onsites__locationTxt5' => 'string', 'Onsites.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onsites__locationTxt6' => 'string', 'Onsites.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onsites__locationTxt7' => 'string', 'Onsites.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onsites__locationTxt8' => 'string', 'Onsites.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onsites__locationTxt9' => 'string', 'Onsites.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onsites__locationTxt10' => 'string', 'Onsites.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onsites__locationTxt11' => 'string', 'Onsites.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onsites__locationTxt12' => 'string', 'Onsites.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onsites__locationTxt13' => 'string', 'Onsites.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onsites__locationTxt14' => 'string', 'Onsites.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onsites__locationTxt15' => 'string', 'Onsites.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onsites__locationTxt16' => 'string', 'Onsites.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onsites__locationTxt17' => 'string', 'Onsites.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onsites__locationTxt18' => 'string', 'Onsites.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onsites__galleryTxt1' => 'string', 'Onsites.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onsites__galleryTxt2' => 'string', 'Onsites.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onsites__galleryTxt3' => 'string', 'Onsites.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onsites__galleryTxt4' => 'string', 'Onsites.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onsites__galleryTxt5' => 'string', 'Onsites.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onsites__galleryTxt6' => 'string', 'Onsites.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onsites__galleryTxt7' => 'string', 'Onsites.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onsites__galleryTxt8' => 'string', 'Onsites.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onsites__galleryTxt9' => 'string', 'Onsites.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onsites__galleryTxt10' => 'string', 'Onsites.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onsites__galleryTxt11' => 'string', 'Onsites.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onsites__galleryTxt12' => 'string', 'Onsites.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onsites__galleryTxt13' => 'string', 'Onsites.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onsites__galleryTxt14' => 'string', 'Onsites.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onsites__galleryTxt15' => 'string', 'Onsites.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onsites__galleryTxt16' => 'string', 'Onsites.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onsites__galleryTxt17' => 'string', 'Onsites.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onsites__galleryTxt18' => 'string', 'Onsites.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onsites__locationTraffic' => 'string', 'Onsites.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onsites__locationSchool' => 'string', 'Onsites.locationSchool' => 'string', 'locationSchool' => 'string', 'Onsites__locationLife' => 'string', 'Onsites.locationLife' => 'string', 'locationLife' => 'string', 'Onsites__locationOther' => 'string', 'Onsites.locationOther' => 'string', 'locationOther' => 'string', 'Onsites__parthFlg' => 'tinyinteger', 'Onsites.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onsites__parthImgFlg1' => 'tinyinteger', 'Onsites.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onsites__parthImgFlg2' => 'tinyinteger', 'Onsites.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onsites__parthImgFlg3' => 'tinyinteger', 'Onsites.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onsites__parthImgFlg4' => 'tinyinteger', 'Onsites.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onsites__kuwariFlg' => 'tinyinteger', 'Onsites.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onsites__planFlg' => 'tinyinteger', 'Onsites.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onsites__outlinePrice' => 'string', 'Onsites.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onsites__outlinePriceNum' => 'integer', 'Onsites.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onsites__outlineType' => 'string', 'Onsites.outlineType' => 'string', 'outlineType' => 'string', 'Onsites__outlinePlace' => 'string', 'Onsites.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onsites__outlineTraffic' => 'string', 'Onsites.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onsites__outlineRight' => 'string', 'Onsites.outlineRight' => 'string', 'outlineRight' => 'string', 'Onsites__outlineSite' => 'string', 'Onsites.outlineSite' => 'string', 'outlineSite' => 'string', 'Onsites__outlineFacility' => 'string', 'Onsites.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onsites__outlineApproach' => 'string', 'Onsites.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onsites__outlineCityplan' => 'string', 'Onsites.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onsites__outlineUse1' => 'string', 'Onsites.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onsites__outlineUse2' => 'string', 'Onsites.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onsites__outlineAltitude1' => 'string', 'Onsites.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onsites__outlineAltitude2' => 'string', 'Onsites.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onsites__outlineFire1' => 'string', 'Onsites.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onsites__outlineFire2' => 'string', 'Onsites.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onsites__outlineVolume1' => 'string', 'Onsites.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onsites__outlineVolume2' => 'string', 'Onsites.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onsites__outlinePlots' => 'string', 'Onsites.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onsites__outlineBuldingNo' => 'string', 'Onsites.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onsites__outlineBuildingArea' => 'string', 'Onsites.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onsites__outlineConstruction' => 'string', 'Onsites.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onsites__outlineFloorPlan' => 'string', 'Onsites.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onsites__outlineCompTime' => 'string', 'Onsites.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onsites__outlineDelivTime' => 'string', 'Onsites.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onsites__outlineTransForm' => 'string', 'Onsites.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onsites__outlineEquipment' => 'string', 'Onsites.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onsites__outlineComment' => 'string', 'Onsites.outlineComment' => 'string', 'outlineComment' => 'string', 'Onsites__outlineSchool' => 'string', 'Onsites.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onsites__googleMap' => 'string', 'Onsites.googleMap' => 'string', 'googleMap' => 'string', 'Onsites__memo' => 'string', 'Onsites.memo' => 'string', 'memo' => 'string', 'Onsites__priceFlg' => 'tinyinteger', 'Onsites.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onsites__newFlg' => 'tinyinteger', 'Onsites.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onsites__lastFlg' => 'tinyinteger', 'Onsites.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onsites__topImgFlg' => 'tinyinteger', 'Onsites.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onsites__memberFlg' => 'tinyinteger', 'Onsites.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onsites__deleteFlg' => 'tinyinteger', 'Onsites.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onsites__created' => 'datetime', 'Onsites.created' => 'datetime', 'created' => 'datetime', 'Onsites__modified' => 'datetime', 'Onsites.modified' => 'datetime', 'modified' => 'datetime', 'Sites__id' => 'integer', 'Sites.id' => 'integer', 'Sites__onsite_id' => 'integer', 'Sites.onsite_id' => 'integer', 'onsite_id' => 'integer', 'Sites__displayFlg' => 'tinyinteger', 'Sites.displayFlg' => 'tinyinteger', 'Sites__statusFlg' => 'tinyinteger', 'Sites.statusFlg' => 'tinyinteger', 'Sites__name' => 'string', 'Sites.name' => 'string', 'Sites__floor' => 'string', 'Sites.floor' => 'string', 'floor' => 'string', 'Sites__landRights' => 'string', 'Sites.landRights' => 'string', 'landRights' => 'string', 'Sites__landArea' => 'decimal', 'Sites.landArea' => 'decimal', 'landArea' => 'decimal', 'Sites__buildArea' => 'decimal', 'Sites.buildArea' => 'decimal', 'buildArea' => 'decimal', 'Sites__price' => 'decimal', 'Sites.price' => 'decimal', 'price' => 'decimal', 'Sites__PlanImgFlg' => 'tinyinteger', 'Sites.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Sites__PlanPdfFlg' => 'tinyinteger', 'Sites.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Sites__comment' => 'string', 'Sites.comment' => 'string', 'comment' => 'string', 'Sites__memo' => 'string', 'Sites.memo' => 'string', 'Sites__areaCD' => 'integer', 'Sites.areaCD' => 'integer', 'areaCD' => 'integer', 'Sites__lifetownFlg' => 'tinyinteger', 'Sites.lifetownFlg' => 'tinyinteger', 'Sites__created' => 'datetime', 'Sites.created' => 'datetime', 'Sites__modified' => 'datetime', 'Sites.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' => [ 'sites' => [[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\OnsitesTable) {} } $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/Onsites/view.ctp, line 933 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 = [ 'Onsites' => object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__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 onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.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\OnsitesTable) {} }, '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' ] $Onsites = object(Cake\ORM\Query) { '(help)' => 'This is a Query object, to get the results execute or iterate it.', 'sql' => 'SELECT Onsites.id AS `Onsites__id`, Onsites.name AS `Onsites__name`, Onsites.mbAddress AS `Onsites__mbAddress`, Onsites.displayFlg AS `Onsites__displayFlg`, Onsites.statusFlg AS `Onsites__statusFlg`, Onsites.area_id AS `Onsites__area_id`, Onsites.sectionNo AS `Onsites__sectionNo`, Onsites.kind_id AS `Onsites__kind_id`, Onsites.landFlg AS `Onsites__landFlg`, Onsites.lifetownFlg AS `Onsites__lifetownFlg`, Onsites.newoldFlg AS `Onsites__newoldFlg`, Onsites.tour_id AS `Onsites__tour_id`, Onsites.topDispFlg AS `Onsites__topDispFlg`, Onsites.recommFlg AS `Onsites__recommFlg`, Onsites.railway_id1 AS `Onsites__railway_id1`, Onsites.railway_id2 AS `Onsites__railway_id2`, Onsites.railway_id3 AS `Onsites__railway_id3`, Onsites.station_id1 AS `Onsites__station_id1`, Onsites.station_id2 AS `Onsites__station_id2`, Onsites.station_id3 AS `Onsites__station_id3`, Onsites.stwalk1 AS `Onsites__stwalk1`, Onsites.stwalk2 AS `Onsites__stwalk2`, Onsites.stwalk3 AS `Onsites__stwalk3`, Onsites.bswalk1 AS `Onsites__bswalk1`, Onsites.bswalk2 AS `Onsites__bswalk2`, Onsites.bswalk3 AS `Onsites__bswalk3`, Onsites.catchCopy AS `Onsites__catchCopy`, Onsites.stationStart AS `Onsites__stationStart`, Onsites.stationTo1 AS `Onsites__stationTo1`, Onsites.stationTo2 AS `Onsites__stationTo2`, Onsites.stationTo3 AS `Onsites__stationTo3`, Onsites.stationTo4 AS `Onsites__stationTo4`, Onsites.trainTime1 AS `Onsites__trainTime1`, Onsites.trainTime2 AS `Onsites__trainTime2`, Onsites.trainTime3 AS `Onsites__trainTime3`, Onsites.trainTime4 AS `Onsites__trainTime4`, Onsites.trainDirect1 AS `Onsites__trainDirect1`, Onsites.trainDirect2 AS `Onsites__trainDirect2`, Onsites.trainDirect3 AS `Onsites__trainDirect3`, Onsites.trainDirect4 AS `Onsites__trainDirect4`, Onsites.trainVia1 AS `Onsites__trainVia1`, Onsites.trainVia2 AS `Onsites__trainVia2`, Onsites.trainVia3 AS `Onsites__trainVia3`, Onsites.trainVia4 AS `Onsites__trainVia4`, Onsites.locationFlg AS `Onsites__locationFlg`, Onsites.locationTitle1 AS `Onsites__locationTitle1`, Onsites.locationTitle2 AS `Onsites__locationTitle2`, Onsites.locationTxt1 AS `Onsites__locationTxt1`, Onsites.locationTxt2 AS `Onsites__locationTxt2`, Onsites.locationTxt3 AS `Onsites__locationTxt3`, Onsites.locationTxt4 AS `Onsites__locationTxt4`, Onsites.locationTxt5 AS `Onsites__locationTxt5`, Onsites.locationTxt6 AS `Onsites__locationTxt6`, Onsites.locationTxt7 AS `Onsites__locationTxt7`, Onsites.locationTxt8 AS `Onsites__locationTxt8`, Onsites.locationTxt9 AS `Onsites__locationTxt9`, Onsites.locationTxt10 AS `Onsites__locationTxt10`, Onsites.locationTxt11 AS `Onsites__locationTxt11`, Onsites.locationTxt12 AS `Onsites__locationTxt12`, Onsites.locationTxt13 AS `Onsites__locationTxt13`, Onsites.locationTxt14 AS `Onsites__locationTxt14`, Onsites.locationTxt15 AS `Onsites__locationTxt15`, Onsites.locationTxt16 AS `Onsites__locationTxt16`, Onsites.locationTxt17 AS `Onsites__locationTxt17`, Onsites.locationTxt18 AS `Onsites__locationTxt18`, Onsites.galleryTxt1 AS `Onsites__galleryTxt1`, Onsites.galleryTxt2 AS `Onsites__galleryTxt2`, Onsites.galleryTxt3 AS `Onsites__galleryTxt3`, Onsites.galleryTxt4 AS `Onsites__galleryTxt4`, Onsites.galleryTxt5 AS `Onsites__galleryTxt5`, Onsites.galleryTxt6 AS `Onsites__galleryTxt6`, Onsites.galleryTxt7 AS `Onsites__galleryTxt7`, Onsites.galleryTxt8 AS `Onsites__galleryTxt8`, Onsites.galleryTxt9 AS `Onsites__galleryTxt9`, Onsites.galleryTxt10 AS `Onsites__galleryTxt10`, Onsites.galleryTxt11 AS `Onsites__galleryTxt11`, Onsites.galleryTxt12 AS `Onsites__galleryTxt12`, Onsites.galleryTxt13 AS `Onsites__galleryTxt13`, Onsites.galleryTxt14 AS `Onsites__galleryTxt14`, Onsites.galleryTxt15 AS `Onsites__galleryTxt15`, Onsites.galleryTxt16 AS `Onsites__galleryTxt16`, Onsites.galleryTxt17 AS `Onsites__galleryTxt17`, Onsites.galleryTxt18 AS `Onsites__galleryTxt18`, Onsites.locationTraffic AS `Onsites__locationTraffic`, Onsites.locationSchool AS `Onsites__locationSchool`, Onsites.locationLife AS `Onsites__locationLife`, Onsites.locationOther AS `Onsites__locationOther`, Onsites.parthFlg AS `Onsites__parthFlg`, Onsites.parthImgFlg1 AS `Onsites__parthImgFlg1`, Onsites.parthImgFlg2 AS `Onsites__parthImgFlg2`, Onsites.parthImgFlg3 AS `Onsites__parthImgFlg3`, Onsites.parthImgFlg4 AS `Onsites__parthImgFlg4`, Onsites.kuwariFlg AS `Onsites__kuwariFlg`, Onsites.planFlg AS `Onsites__planFlg`, Onsites.outlinePrice AS `Onsites__outlinePrice`, Onsites.outlinePriceNum AS `Onsites__outlinePriceNum`, Onsites.outlineType AS `Onsites__outlineType`, Onsites.outlinePlace AS `Onsites__outlinePlace`, Onsites.outlineTraffic AS `Onsites__outlineTraffic`, Onsites.outlineRight AS `Onsites__outlineRight`, Onsites.outlineSite AS `Onsites__outlineSite`, Onsites.outlineFacility AS `Onsites__outlineFacility`, Onsites.outlineApproach AS `Onsites__outlineApproach`, Onsites.outlineCityplan AS `Onsites__outlineCityplan`, Onsites.outlineUse1 AS `Onsites__outlineUse1`, Onsites.outlineUse2 AS `Onsites__outlineUse2`, Onsites.outlineAltitude1 AS `Onsites__outlineAltitude1`, Onsites.outlineAltitude2 AS `Onsites__outlineAltitude2`, Onsites.outlineFire1 AS `Onsites__outlineFire1`, Onsites.outlineFire2 AS `Onsites__outlineFire2`, Onsites.outlineVolume1 AS `Onsites__outlineVolume1`, Onsites.outlineVolume2 AS `Onsites__outlineVolume2`, Onsites.outlinePlots AS `Onsites__outlinePlots`, Onsites.outlineBuldingNo AS `Onsites__outlineBuldingNo`, Onsites.outlineBuildingArea AS `Onsites__outlineBuildingArea`, Onsites.outlineConstruction AS `Onsites__outlineConstruction`, Onsites.outlineFloorPlan AS `Onsites__outlineFloorPlan`, Onsites.outlineCompTime AS `Onsites__outlineCompTime`, Onsites.outlineDelivTime AS `Onsites__outlineDelivTime`, Onsites.outlineTransForm AS `Onsites__outlineTransForm`, Onsites.outlineEquipment AS `Onsites__outlineEquipment`, Onsites.outlineComment AS `Onsites__outlineComment`, Onsites.outlineSchool AS `Onsites__outlineSchool`, Onsites.googleMap AS `Onsites__googleMap`, Onsites.memo AS `Onsites__memo`, Onsites.priceFlg AS `Onsites__priceFlg`, Onsites.newFlg AS `Onsites__newFlg`, Onsites.lastFlg AS `Onsites__lastFlg`, Onsites.topImgFlg AS `Onsites__topImgFlg`, Onsites.memberFlg AS `Onsites__memberFlg`, Onsites.deleteFlg AS `Onsites__deleteFlg`, Onsites.created AS `Onsites__created`, Onsites.modified AS `Onsites__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 onsites Onsites LEFT JOIN areas Areas ON Areas.id = (Onsites.area_id) LEFT JOIN kinds Kinds ON Kinds.id = (Onsites.kind_id) LEFT JOIN tours Tours ON Tours.id = (Onsites.tour_id) LEFT JOIN railways Railways1 ON Railways1.id = (Onsites.railway_id1) LEFT JOIN railways Railways2 ON Railways2.id = (Onsites.railway_id2) LEFT JOIN railways Railways3 ON Railways3.id = (Onsites.railway_id3) LEFT JOIN stations Stations1 ON Stations1.id = (Onsites.station_id1) LEFT JOIN stations Stations2 ON Stations2.id = (Onsites.station_id2) LEFT JOIN stations Stations3 ON Stations3.id = (Onsites.station_id3) WHERE Onsites.id = :c0', 'params' => [ ':c0' => [ [maximum depth reached] ] ], 'defaultTypes' => [ 'Onsites__id' => 'integer', 'Onsites.id' => 'integer', 'id' => 'integer', 'Onsites__name' => 'string', 'Onsites.name' => 'string', 'name' => 'string', 'Onsites__mbAddress' => 'string', 'Onsites.mbAddress' => 'string', 'mbAddress' => 'string', 'Onsites__displayFlg' => 'tinyinteger', 'Onsites.displayFlg' => 'tinyinteger', 'displayFlg' => 'tinyinteger', 'Onsites__statusFlg' => 'tinyinteger', 'Onsites.statusFlg' => 'tinyinteger', 'statusFlg' => 'tinyinteger', 'Onsites__area_id' => 'integer', 'Onsites.area_id' => 'integer', 'area_id' => 'integer', 'Onsites__sectionNo' => 'tinyinteger', 'Onsites.sectionNo' => 'tinyinteger', 'sectionNo' => 'tinyinteger', 'Onsites__kind_id' => 'integer', 'Onsites.kind_id' => 'integer', 'kind_id' => 'integer', 'Onsites__landFlg' => 'tinyinteger', 'Onsites.landFlg' => 'tinyinteger', 'landFlg' => 'tinyinteger', 'Onsites__lifetownFlg' => 'tinyinteger', 'Onsites.lifetownFlg' => 'tinyinteger', 'lifetownFlg' => 'tinyinteger', 'Onsites__newoldFlg' => 'tinyinteger', 'Onsites.newoldFlg' => 'tinyinteger', 'newoldFlg' => 'tinyinteger', 'Onsites__tour_id' => 'integer', 'Onsites.tour_id' => 'integer', 'tour_id' => 'integer', 'Onsites__topDispFlg' => 'tinyinteger', 'Onsites.topDispFlg' => 'tinyinteger', 'topDispFlg' => 'tinyinteger', 'Onsites__recommFlg' => 'tinyinteger', 'Onsites.recommFlg' => 'tinyinteger', 'recommFlg' => 'tinyinteger', 'Onsites__railway_id1' => 'integer', 'Onsites.railway_id1' => 'integer', 'railway_id1' => 'integer', 'Onsites__railway_id2' => 'integer', 'Onsites.railway_id2' => 'integer', 'railway_id2' => 'integer', 'Onsites__railway_id3' => 'integer', 'Onsites.railway_id3' => 'integer', 'railway_id3' => 'integer', 'Onsites__station_id1' => 'integer', 'Onsites.station_id1' => 'integer', 'station_id1' => 'integer', 'Onsites__station_id2' => 'integer', 'Onsites.station_id2' => 'integer', 'station_id2' => 'integer', 'Onsites__station_id3' => 'integer', 'Onsites.station_id3' => 'integer', 'station_id3' => 'integer', 'Onsites__stwalk1' => 'string', 'Onsites.stwalk1' => 'string', 'stwalk1' => 'string', 'Onsites__stwalk2' => 'string', 'Onsites.stwalk2' => 'string', 'stwalk2' => 'string', 'Onsites__stwalk3' => 'string', 'Onsites.stwalk3' => 'string', 'stwalk3' => 'string', 'Onsites__bswalk1' => 'string', 'Onsites.bswalk1' => 'string', 'bswalk1' => 'string', 'Onsites__bswalk2' => 'string', 'Onsites.bswalk2' => 'string', 'bswalk2' => 'string', 'Onsites__bswalk3' => 'string', 'Onsites.bswalk3' => 'string', 'bswalk3' => 'string', 'Onsites__catchCopy' => 'string', 'Onsites.catchCopy' => 'string', 'catchCopy' => 'string', 'Onsites__stationStart' => 'string', 'Onsites.stationStart' => 'string', 'stationStart' => 'string', 'Onsites__stationTo1' => 'string', 'Onsites.stationTo1' => 'string', 'stationTo1' => 'string', 'Onsites__stationTo2' => 'string', 'Onsites.stationTo2' => 'string', 'stationTo2' => 'string', 'Onsites__stationTo3' => 'string', 'Onsites.stationTo3' => 'string', 'stationTo3' => 'string', 'Onsites__stationTo4' => 'string', 'Onsites.stationTo4' => 'string', 'stationTo4' => 'string', 'Onsites__trainTime1' => 'tinyinteger', 'Onsites.trainTime1' => 'tinyinteger', 'trainTime1' => 'tinyinteger', 'Onsites__trainTime2' => 'tinyinteger', 'Onsites.trainTime2' => 'tinyinteger', 'trainTime2' => 'tinyinteger', 'Onsites__trainTime3' => 'tinyinteger', 'Onsites.trainTime3' => 'tinyinteger', 'trainTime3' => 'tinyinteger', 'Onsites__trainTime4' => 'tinyinteger', 'Onsites.trainTime4' => 'tinyinteger', 'trainTime4' => 'tinyinteger', 'Onsites__trainDirect1' => 'tinyinteger', 'Onsites.trainDirect1' => 'tinyinteger', 'trainDirect1' => 'tinyinteger', 'Onsites__trainDirect2' => 'tinyinteger', 'Onsites.trainDirect2' => 'tinyinteger', 'trainDirect2' => 'tinyinteger', 'Onsites__trainDirect3' => 'tinyinteger', 'Onsites.trainDirect3' => 'tinyinteger', 'trainDirect3' => 'tinyinteger', 'Onsites__trainDirect4' => 'tinyinteger', 'Onsites.trainDirect4' => 'tinyinteger', 'trainDirect4' => 'tinyinteger', 'Onsites__trainVia1' => 'string', 'Onsites.trainVia1' => 'string', 'trainVia1' => 'string', 'Onsites__trainVia2' => 'string', 'Onsites.trainVia2' => 'string', 'trainVia2' => 'string', 'Onsites__trainVia3' => 'string', 'Onsites.trainVia3' => 'string', 'trainVia3' => 'string', 'Onsites__trainVia4' => 'string', 'Onsites.trainVia4' => 'string', 'trainVia4' => 'string', 'Onsites__locationFlg' => 'tinyinteger', 'Onsites.locationFlg' => 'tinyinteger', 'locationFlg' => 'tinyinteger', 'Onsites__locationTitle1' => 'string', 'Onsites.locationTitle1' => 'string', 'locationTitle1' => 'string', 'Onsites__locationTitle2' => 'string', 'Onsites.locationTitle2' => 'string', 'locationTitle2' => 'string', 'Onsites__locationTxt1' => 'string', 'Onsites.locationTxt1' => 'string', 'locationTxt1' => 'string', 'Onsites__locationTxt2' => 'string', 'Onsites.locationTxt2' => 'string', 'locationTxt2' => 'string', 'Onsites__locationTxt3' => 'string', 'Onsites.locationTxt3' => 'string', 'locationTxt3' => 'string', 'Onsites__locationTxt4' => 'string', 'Onsites.locationTxt4' => 'string', 'locationTxt4' => 'string', 'Onsites__locationTxt5' => 'string', 'Onsites.locationTxt5' => 'string', 'locationTxt5' => 'string', 'Onsites__locationTxt6' => 'string', 'Onsites.locationTxt6' => 'string', 'locationTxt6' => 'string', 'Onsites__locationTxt7' => 'string', 'Onsites.locationTxt7' => 'string', 'locationTxt7' => 'string', 'Onsites__locationTxt8' => 'string', 'Onsites.locationTxt8' => 'string', 'locationTxt8' => 'string', 'Onsites__locationTxt9' => 'string', 'Onsites.locationTxt9' => 'string', 'locationTxt9' => 'string', 'Onsites__locationTxt10' => 'string', 'Onsites.locationTxt10' => 'string', 'locationTxt10' => 'string', 'Onsites__locationTxt11' => 'string', 'Onsites.locationTxt11' => 'string', 'locationTxt11' => 'string', 'Onsites__locationTxt12' => 'string', 'Onsites.locationTxt12' => 'string', 'locationTxt12' => 'string', 'Onsites__locationTxt13' => 'string', 'Onsites.locationTxt13' => 'string', 'locationTxt13' => 'string', 'Onsites__locationTxt14' => 'string', 'Onsites.locationTxt14' => 'string', 'locationTxt14' => 'string', 'Onsites__locationTxt15' => 'string', 'Onsites.locationTxt15' => 'string', 'locationTxt15' => 'string', 'Onsites__locationTxt16' => 'string', 'Onsites.locationTxt16' => 'string', 'locationTxt16' => 'string', 'Onsites__locationTxt17' => 'string', 'Onsites.locationTxt17' => 'string', 'locationTxt17' => 'string', 'Onsites__locationTxt18' => 'string', 'Onsites.locationTxt18' => 'string', 'locationTxt18' => 'string', 'Onsites__galleryTxt1' => 'string', 'Onsites.galleryTxt1' => 'string', 'galleryTxt1' => 'string', 'Onsites__galleryTxt2' => 'string', 'Onsites.galleryTxt2' => 'string', 'galleryTxt2' => 'string', 'Onsites__galleryTxt3' => 'string', 'Onsites.galleryTxt3' => 'string', 'galleryTxt3' => 'string', 'Onsites__galleryTxt4' => 'string', 'Onsites.galleryTxt4' => 'string', 'galleryTxt4' => 'string', 'Onsites__galleryTxt5' => 'string', 'Onsites.galleryTxt5' => 'string', 'galleryTxt5' => 'string', 'Onsites__galleryTxt6' => 'string', 'Onsites.galleryTxt6' => 'string', 'galleryTxt6' => 'string', 'Onsites__galleryTxt7' => 'string', 'Onsites.galleryTxt7' => 'string', 'galleryTxt7' => 'string', 'Onsites__galleryTxt8' => 'string', 'Onsites.galleryTxt8' => 'string', 'galleryTxt8' => 'string', 'Onsites__galleryTxt9' => 'string', 'Onsites.galleryTxt9' => 'string', 'galleryTxt9' => 'string', 'Onsites__galleryTxt10' => 'string', 'Onsites.galleryTxt10' => 'string', 'galleryTxt10' => 'string', 'Onsites__galleryTxt11' => 'string', 'Onsites.galleryTxt11' => 'string', 'galleryTxt11' => 'string', 'Onsites__galleryTxt12' => 'string', 'Onsites.galleryTxt12' => 'string', 'galleryTxt12' => 'string', 'Onsites__galleryTxt13' => 'string', 'Onsites.galleryTxt13' => 'string', 'galleryTxt13' => 'string', 'Onsites__galleryTxt14' => 'string', 'Onsites.galleryTxt14' => 'string', 'galleryTxt14' => 'string', 'Onsites__galleryTxt15' => 'string', 'Onsites.galleryTxt15' => 'string', 'galleryTxt15' => 'string', 'Onsites__galleryTxt16' => 'string', 'Onsites.galleryTxt16' => 'string', 'galleryTxt16' => 'string', 'Onsites__galleryTxt17' => 'string', 'Onsites.galleryTxt17' => 'string', 'galleryTxt17' => 'string', 'Onsites__galleryTxt18' => 'string', 'Onsites.galleryTxt18' => 'string', 'galleryTxt18' => 'string', 'Onsites__locationTraffic' => 'string', 'Onsites.locationTraffic' => 'string', 'locationTraffic' => 'string', 'Onsites__locationSchool' => 'string', 'Onsites.locationSchool' => 'string', 'locationSchool' => 'string', 'Onsites__locationLife' => 'string', 'Onsites.locationLife' => 'string', 'locationLife' => 'string', 'Onsites__locationOther' => 'string', 'Onsites.locationOther' => 'string', 'locationOther' => 'string', 'Onsites__parthFlg' => 'tinyinteger', 'Onsites.parthFlg' => 'tinyinteger', 'parthFlg' => 'tinyinteger', 'Onsites__parthImgFlg1' => 'tinyinteger', 'Onsites.parthImgFlg1' => 'tinyinteger', 'parthImgFlg1' => 'tinyinteger', 'Onsites__parthImgFlg2' => 'tinyinteger', 'Onsites.parthImgFlg2' => 'tinyinteger', 'parthImgFlg2' => 'tinyinteger', 'Onsites__parthImgFlg3' => 'tinyinteger', 'Onsites.parthImgFlg3' => 'tinyinteger', 'parthImgFlg3' => 'tinyinteger', 'Onsites__parthImgFlg4' => 'tinyinteger', 'Onsites.parthImgFlg4' => 'tinyinteger', 'parthImgFlg4' => 'tinyinteger', 'Onsites__kuwariFlg' => 'tinyinteger', 'Onsites.kuwariFlg' => 'tinyinteger', 'kuwariFlg' => 'tinyinteger', 'Onsites__planFlg' => 'tinyinteger', 'Onsites.planFlg' => 'tinyinteger', 'planFlg' => 'tinyinteger', 'Onsites__outlinePrice' => 'string', 'Onsites.outlinePrice' => 'string', 'outlinePrice' => 'string', 'Onsites__outlinePriceNum' => 'integer', 'Onsites.outlinePriceNum' => 'integer', 'outlinePriceNum' => 'integer', 'Onsites__outlineType' => 'string', 'Onsites.outlineType' => 'string', 'outlineType' => 'string', 'Onsites__outlinePlace' => 'string', 'Onsites.outlinePlace' => 'string', 'outlinePlace' => 'string', 'Onsites__outlineTraffic' => 'string', 'Onsites.outlineTraffic' => 'string', 'outlineTraffic' => 'string', 'Onsites__outlineRight' => 'string', 'Onsites.outlineRight' => 'string', 'outlineRight' => 'string', 'Onsites__outlineSite' => 'string', 'Onsites.outlineSite' => 'string', 'outlineSite' => 'string', 'Onsites__outlineFacility' => 'string', 'Onsites.outlineFacility' => 'string', 'outlineFacility' => 'string', 'Onsites__outlineApproach' => 'string', 'Onsites.outlineApproach' => 'string', 'outlineApproach' => 'string', 'Onsites__outlineCityplan' => 'string', 'Onsites.outlineCityplan' => 'string', 'outlineCityplan' => 'string', 'Onsites__outlineUse1' => 'string', 'Onsites.outlineUse1' => 'string', 'outlineUse1' => 'string', 'Onsites__outlineUse2' => 'string', 'Onsites.outlineUse2' => 'string', 'outlineUse2' => 'string', 'Onsites__outlineAltitude1' => 'string', 'Onsites.outlineAltitude1' => 'string', 'outlineAltitude1' => 'string', 'Onsites__outlineAltitude2' => 'string', 'Onsites.outlineAltitude2' => 'string', 'outlineAltitude2' => 'string', 'Onsites__outlineFire1' => 'string', 'Onsites.outlineFire1' => 'string', 'outlineFire1' => 'string', 'Onsites__outlineFire2' => 'string', 'Onsites.outlineFire2' => 'string', 'outlineFire2' => 'string', 'Onsites__outlineVolume1' => 'string', 'Onsites.outlineVolume1' => 'string', 'outlineVolume1' => 'string', 'Onsites__outlineVolume2' => 'string', 'Onsites.outlineVolume2' => 'string', 'outlineVolume2' => 'string', 'Onsites__outlinePlots' => 'string', 'Onsites.outlinePlots' => 'string', 'outlinePlots' => 'string', 'Onsites__outlineBuldingNo' => 'string', 'Onsites.outlineBuldingNo' => 'string', 'outlineBuldingNo' => 'string', 'Onsites__outlineBuildingArea' => 'string', 'Onsites.outlineBuildingArea' => 'string', 'outlineBuildingArea' => 'string', 'Onsites__outlineConstruction' => 'string', 'Onsites.outlineConstruction' => 'string', 'outlineConstruction' => 'string', 'Onsites__outlineFloorPlan' => 'string', 'Onsites.outlineFloorPlan' => 'string', 'outlineFloorPlan' => 'string', 'Onsites__outlineCompTime' => 'string', 'Onsites.outlineCompTime' => 'string', 'outlineCompTime' => 'string', 'Onsites__outlineDelivTime' => 'string', 'Onsites.outlineDelivTime' => 'string', 'outlineDelivTime' => 'string', 'Onsites__outlineTransForm' => 'string', 'Onsites.outlineTransForm' => 'string', 'outlineTransForm' => 'string', 'Onsites__outlineEquipment' => 'string', 'Onsites.outlineEquipment' => 'string', 'outlineEquipment' => 'string', 'Onsites__outlineComment' => 'string', 'Onsites.outlineComment' => 'string', 'outlineComment' => 'string', 'Onsites__outlineSchool' => 'string', 'Onsites.outlineSchool' => 'string', 'outlineSchool' => 'string', 'Onsites__googleMap' => 'string', 'Onsites.googleMap' => 'string', 'googleMap' => 'string', 'Onsites__memo' => 'string', 'Onsites.memo' => 'string', 'memo' => 'string', 'Onsites__priceFlg' => 'tinyinteger', 'Onsites.priceFlg' => 'tinyinteger', 'priceFlg' => 'tinyinteger', 'Onsites__newFlg' => 'tinyinteger', 'Onsites.newFlg' => 'tinyinteger', 'newFlg' => 'tinyinteger', 'Onsites__lastFlg' => 'tinyinteger', 'Onsites.lastFlg' => 'tinyinteger', 'lastFlg' => 'tinyinteger', 'Onsites__topImgFlg' => 'tinyinteger', 'Onsites.topImgFlg' => 'tinyinteger', 'topImgFlg' => 'tinyinteger', 'Onsites__memberFlg' => 'tinyinteger', 'Onsites.memberFlg' => 'tinyinteger', 'memberFlg' => 'tinyinteger', 'Onsites__deleteFlg' => 'tinyinteger', 'Onsites.deleteFlg' => 'tinyinteger', 'deleteFlg' => 'tinyinteger', 'Onsites__created' => 'datetime', 'Onsites.created' => 'datetime', 'created' => 'datetime', 'Onsites__modified' => 'datetime', 'Onsites.modified' => 'datetime', 'modified' => 'datetime', 'Sites__id' => 'integer', 'Sites.id' => 'integer', 'Sites__onsite_id' => 'integer', 'Sites.onsite_id' => 'integer', 'onsite_id' => 'integer', 'Sites__displayFlg' => 'tinyinteger', 'Sites.displayFlg' => 'tinyinteger', 'Sites__statusFlg' => 'tinyinteger', 'Sites.statusFlg' => 'tinyinteger', 'Sites__name' => 'string', 'Sites.name' => 'string', 'Sites__floor' => 'string', 'Sites.floor' => 'string', 'floor' => 'string', 'Sites__landRights' => 'string', 'Sites.landRights' => 'string', 'landRights' => 'string', 'Sites__landArea' => 'decimal', 'Sites.landArea' => 'decimal', 'landArea' => 'decimal', 'Sites__buildArea' => 'decimal', 'Sites.buildArea' => 'decimal', 'buildArea' => 'decimal', 'Sites__price' => 'decimal', 'Sites.price' => 'decimal', 'price' => 'decimal', 'Sites__PlanImgFlg' => 'tinyinteger', 'Sites.PlanImgFlg' => 'tinyinteger', 'PlanImgFlg' => 'tinyinteger', 'Sites__PlanPdfFlg' => 'tinyinteger', 'Sites.PlanPdfFlg' => 'tinyinteger', 'PlanPdfFlg' => 'tinyinteger', 'Sites__comment' => 'string', 'Sites.comment' => 'string', 'comment' => 'string', 'Sites__memo' => 'string', 'Sites.memo' => 'string', 'Sites__areaCD' => 'integer', 'Sites.areaCD' => 'integer', 'areaCD' => 'integer', 'Sites__lifetownFlg' => 'tinyinteger', 'Sites.lifetownFlg' => 'tinyinteger', 'Sites__created' => 'datetime', 'Sites.created' => 'datetime', 'Sites__modified' => 'datetime', 'Sites.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' => [ 'sites' => [[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\OnsitesTable) {} } $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/Onsites/view.ctp, line 933 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.
エリア検索