SQLSTATE[HY000]: General error: 1041 Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap spaceSELECT plan.nPlanNo,sPlanName,nPlanRateType,nPlanSort,bSaleTypeFlg,Rate FROM tPlan AS plan INNER JOIN tPlanSale AS plansale ON plan.nYadono = plansale.nYadoNo AND plan.nPlanNo = plansale.nPlanNo AND plansale.nAgentNo = :AgentNo AND plansale.bPlanSleep = 0  AND plansale.dPlanSDate <= :CheckIn INNER JOIN (SELECT nYadoNo,nStockNo FROM tStockTbl WHERE (nStockInputNum - nStockResvNum) >= :StayRooms AND nYadono = :YadoNo  AND dStockDate >= :CheckIn GROUP BY nYadoNo,nStockNo HAVING COUNT(*) >= :StayNights ) AS stocktbl ON stocktbl.nYadoNo = plansale.nYadoNo AND stocktbl.nStockNo = plansale.nStockNo INNER JOIN (SELECT nYadoNo,nPlanNo,nStockNo,SUM(nPlanRate) AS Rate FROM tPlanRateTbl WHERE bPlanExclude = 0 AND nPlanRate > 0 AND nYadono = :YadoNo AND nAgentNo = :AgentNo  AND nPlanRoomNinzu = :StayNinzu  AND dPlanDate >= :CheckIn GROUP BY nYadoNo,nPlanNo,nStockNo HAVING COUNT(*) >= :StayNights ) AS ratetbl ON ratetbl.nYadoNo = plansale.nYadoNo AND ratetbl.nPlanNo = plansale.nPlanNo AND ratetbl.nStockNo = plansale.nStockNo WHERE plan.nYadono = :YadoNo  AND plan.nPlanRateType = :PlanRateType GROUP BY plan.nPlanNo,sPlanName,nPlanRateType,nPlanSort,bSaleTypeFlg ORDER BY plan.nPlanSort  limit :LimitCnt array(8) {
  ["YadoNo"]=>
  string(3) "259"
  ["AgentNo"]=>
  int(5)
  ["PlanRateType"]=>
  string(1) "1"
  ["CheckIn"]=>
  string(10) "2025-08-11"
  ["StayRooms"]=>
  int(1)
  ["StayNights"]=>
  int(1)
  ["StayNinzu"]=>
  string(1) "2"
  ["LimitCnt"]=>
  int(100)
}