array(5) {
["Select"]=>
string(105) "MIN(tr.nPlanRate) AS MinPlanRate1, CASE WHEN th.nYadoNo > 0 THEN 1 ELSE 0 END as preHoliday, tr.dPlanDate"
["From"]=>
string(114) "FROM tPlanRateTbl AS tr LEFT JOIN tPreHoliday AS th ON (tr.dPlanDate = th.dPreHoliday) AND tr.nYadoNo = th.nYadoNo"
["Where"]=>
string(253) "WHERE tr.nYadoNo = :YadoNo AND tr.nPlanNo = :PlanNo AND tr.nAgentNo = 1 AND tr.nPlanRate > 0 AND tr.dPlanDate >= :ymd AND tr.nStockNo IN ( SELECT nStockNo FROM tPlanSale WHERE nYadoNo = :YadoNo AND nPlanNo = :PlanNo AND nAgentNo = 1 AND bPlanSleep = 0) "
["OrderBy"]=>
string(39) "GROUP BY preHoliday ORDER BY preHoliday"
["Params"]=>
array(3) {
["YadoNo"]=>
string(3) "112"
["PlanNo"]=>
string(1) "2"
["ymd"]=>
string(19) "2025-06-12 00:00:00"
}
}
array(1) {
[0]=>
array(3) {
["MinPlanRate1"]=>
string(4) "8000"
["preHoliday"]=>
string(1) "0"
["dPlanDate"]=>
string(19) "2025-06-12 00:00:00"
}
}
string(4) "8000"
int(-1)
あさぎり荘の宿泊プラン一覧｜あさぎり荘の宿泊プランは城崎温泉 お宿とれとれ
お宿とれとれ（城崎温泉）の「あさぎり荘」宿泊プラン一覧のページです。
宿泊条件で検索
城崎温泉旅館予約トップ
> あさぎり荘
> プラン一覧
¥8,000～