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 INNER JOIN (SELECT nYadoNo,nStockNo FROM tStockTbl WHERE (nStockInputNum - nStockResvNum) >= :StayRooms AND nYadono = :YadoNo 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 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 GROUP BY plan.nPlanNo,sPlanName,nPlanRateType,nPlanSort,bSaleTypeFlg ORDER BY plan.nPlanSort  limit :LimitCnt array(5) {
  ["YadoNo"]=>
  string(3) "277"
  ["AgentNo"]=>
  int(5)
  ["StayRooms"]=>
  int(1)
  ["StayNights"]=>
  int(1)
  ["LimitCnt"]=>
  int(100)
}