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(1) "7"
["PlanNo"]=>
string(3) "184"
["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)
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(1) "7"
["PlanNo"]=>
string(2) "38"
["ymd"]=>
string(19) "2025-06-12 00:00:00"
}
}
array(0) {
}
int(-1)
int(-1)
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(1) "7"
["PlanNo"]=>
string(2) "39"
["ymd"]=>
string(19) "2025-06-12 00:00:00"
}
}
array(1) {
[0]=>
array(3) {
["MinPlanRate1"]=>
string(5) "10000"
["preHoliday"]=>
string(1) "0"
["dPlanDate"]=>
string(19) "2025-06-12 00:00:00"
}
}
string(5) "10000"
int(-1)
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(1) "7"
["PlanNo"]=>
string(2) "13"
["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)
千葉をまるごと楽しむ贅を尽くしたグランピングBBQ。「千葉県しあわせ絆牛と房総自慢の海の幸」との共演をご堪能ください。
「夕・朝食付 /BBQスタイル◎天然温泉利用付◎【GoToトラベルキャンペーン割引対象】(?2025年12月31日まで)」プラン詳細を見る
昨年、ブルードーム京都天橋立で大変ご好評いただいた「薪グランピングプラン」を今年も提供します! 暖をとりながら、薪焼き・藁焼きの香ばしい料理を堪能できる秋冬ならではのプランをお楽しみください。
¥10,001~