MYSQL ERROR : Variable 'time_zone' can't be set to the value of 'NULL'
Query : SET time_zone = ( SELECT timeZoneDiff FROM dp_timezones WHERE timeZoneID='' )


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT staBlo.blockID ,blockTitle,blockContent FROM dp_static_blocks AS staBlo LEFT JOIN dp_static_blocks_details AS staBloDet ON ( staBlo.blockID = staBloDet.blockID ) WHERE 1 AND staBloDet.languageID = 1 AND staBlo.status <> 'Deleted' AND staBlo.status ='Active' AND (dateTo > NOW() OR dateTo =0) AND (dateFrom < NOW() OR dateFrom =0) AND (dateTo > NOW() OR dateTo =0) GROUP BY staBlo.blockID ORDER BY blockTitle ASC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT SQL_CALC_FOUND_ROWS 'product_deal' AS dealTypeKey, 'product_deal' AS dealType, '' AS dealTypeUrlKey, 'Products' AS dealTypeName, deal.dealID, deal.dealTypeID, deal.InventoryTrackLevel, deal.dealOnlineRedemption, deal.dealStartTime, deal.dealCreatedDate, deal.dealEndTime, deal.dealNoEndDate, deal.dealExpiryDate, deal.dealDefaultCurrency, deal.dealMinBuyLimit, deal.dealMaxBuyLimit, deal.dealMaxGiftBuy, IF((dealMaxGiftBuy>0),'No','Yes') AS giftUnlimited, deal.dealMinQntyReqToTipp, deal.dealImage, deal.dealVideo, deal.dealShowVideo, deal.dealShowDealTipped, deal.dealShowNosBought, deal.dealProximity, deal.dealTippedDate, deal.dealExclusiveDeal, deal.dealHideDiscount, deal.productCollectFromStore, deal.dealSlotAvailable, deal.dealFlightAvailable, deal.dealRoomAvailable, deal.multipleDestination, deal.dealReturnableDays, deal.dealShowReturnable, DATEDIFF(NOW(),deal.dealTippedDate) AS dealTippedDateDifference, dealDet.dealTitle, dealDet.dealShortTitle, dealDet.dealDescription, dealDet.dealUrl as dealKey, deal.dealSoldCountManipulate, deal.businessID, deal.shippingStatus, deal.attributeSetID, deal.dealDestinationUrl, bus.businessKey, bus.businessRedemption, busDet.businessName, dealOptLeast.dealOptionDealPrice as dealOptionLeastDealPrice, dealOptLeast.dealOptionRegularPrice as dealOptionLeastRegularPrice, dealOpt.dealOptionID, dealOpt.optionSKU, dealOpt.dealOptionDealPrice, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionQuantity, dealOpt.dealQuantityUnlimited, dealOpt.soldQuantity AS dealOrderItemsCount, dealOpt.dealOptionAvailAdults, dealOpt.dealOptionAvailChilds, dealOpt.dealOptionMaximumDays, timez.timeZoneDiff, timez.timeZoneName, shiprate.rateNational, TIMESTAMPDIFF(DAY,NOW(),deal.dealEndTime) AS remainingDays, TIMESTAMPDIFF(HOUR,NOW(),deal.dealEndTime)-TIMESTAMPDIFF(DAY,NOW(),deal.dealEndTime)*24 AS remainingHours, TIMESTAMPDIFF(MINUTE,NOW(),deal.dealEndTime)-TIMESTAMPDIFF(HOUR,NOW(),deal.dealEndTime)*60 AS remainingMinutes, IF( (CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0), CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff), NOW() ) AS timeZoneConverted, IF(deal.InventoryTrackLevel ='No', 1, IF(deal.InventoryTrackLevel ='Deal', ( SELECT sum(dealOptionQuantity) FROM dp_deal_options WHERE dealID=deal.dealID AND dealOptionStatus='Active' ), ( SELECT sum(combinationQty) FROM dp_deal_options as dealOpt1 LEFT JOIN dp_product_combination as proCom1 ON(proCom1.dealOptionID=dealOpt1.dealOptionID) WHERE dealOpt1.dealID=deal.dealID AND proCom1.status='A' ) ) ) as dealOptionQuantitySum, ( SELECT COUNT(dealOptionID) FROM dp_deal_options WHERE dealID=deal.dealID AND dealOptionStatus='Active' ) AS dealOptionCount, ( SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount, CASE deal.dealOnlineRedemption WHEN 'No' THEN ( SELECT COUNT(dealBusinessLocID) FROM dp_deal_to_business_locations WHERE dealID = deal.dealID ) ELSE 0 END AS locCount,dealDet.dealExclusiveText,deal.dealHideLimitedQuantity,deal.dealHideBuycount,deal.dealHideRemainingTime, ( SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , dealPri.dealPriority FROM dp_deals AS deal LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID = dealDet.dealID AND dealDet.languageID = 1 ) LEFT JOIN dp_attribute_set AS attrSet ON attrSet.attributeSetID = deal.attributeSetID LEFT JOIN dp_deal_to_category AS dealToCat ON (deal.dealID = dealToCat.dealID) LEFT JOIN dp_deal_categories AS dealCat ON (dealCat.dealCategoryID = dealToCat.dealCategoryID) LEFT JOIN dp_deal_priority AS dealPri ON ( dealPri.cityID = '0' AND deal.dealID = dealPri.dealID AND dealPri.dealDate = '2021-06-16' ) LEFT JOIN dp_business AS bus ON (deal.businessID = bus.businessID) LEFT JOIN dp_business_details AS busDet ON (bus.businessID = busDet.businessID) LEFT JOIN dp_deal_options AS dealOpt ON ( deal.dealID = dealOpt.dealID AND dealOpt.dealOptionStatus = 'Active' AND dealOpt.dealOptionDefault = 'Yes' ) LEFT JOIN dp_deal_options AS dealOptLeast ON ( deal.dealID = dealOptLeast.dealID AND dealOptLeast.dealOptionStatus = 'Active' AND dealOptLeast.dealOptionDealPrice = (SELECT MIN(dealOptionDealPrice) FROM dp_deal_options WHERE dealID = dealOptLeast.dealID AND dealOptionStatus = 'Active' ) ) LEFT JOIN dp_timezones AS timez ON deal.dealTimeZone = timez.timeZoneID LEFT JOIN dp_shipping_rates AS shiprate ON shiprate.dealID = deal.dealID WHERE 1 AND deal.dealTypeID = '4' AND deal.dealStatus = 'Active' AND ( CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff) BETWEEN deal.dealStartTime AND deal.dealEndTime ) AND bus.businessStatus = 'Active' AND dealToCat.dealCategoryID in ('81') AND ( dealCat.dealCategoryStatus = 'Active' AND ( dealCat.dealCategoryParent = '0' OR EXISTS ( SELECT dealCat2.dealCategoryID FROM dp_deal_categories dealCat2 WHERE dealCat2.dealCategoryID = dealCat.dealCategoryParent AND dealCat2.dealCategoryStatus = 'Active' ) ) ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID ORDER BY FIELD(deal.dealID,0) DESC, dealPri.dealPriority, deal.dealCreatedDate DESC LIMIT 0,22