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
deal.dealID,
deal.refdealID,
deal.dealProximity,
deal.dealStartTime,
deal.dealEndTime,
deal.multiOptionsAvailable,
deal.dealImage,
deal.dealOnlineRedemption,
deal.dealCreatedDate,
deal.dealStatus,
deal.dealExclusiveDeal,
dealDet.dealExclusiveText,
deal.InventoryTrackLevel,
deal.dealCreatedDate,
deal.dealDefaultCurrency,
deal.dealTippedDate,
deal.dealMinQntyReqToTipp,
deal.dealTypeID,
urlRew.requestPath,
deal.dealSoldCountManipulate,
( CASE
WHEN deal.InventoryTrackLevel='Deal' THEN
(SELECT
COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0)
FROM
`dp_deal_options`
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active')
WHEN deal.InventoryTrackLevel='Options' THEN
(SELECT
COALESCE(sum(`combinationQty`),0)
FROM
`dp_product_combination` Combo
INNER JOIN
dp_deal_options OPT
ON (OPT.dealOptionID=Combo.dealOptionID)
WHERE
OPT.dealID=deal.dealID
AND
Combo.status='A')
ELSE
1
END
)as dealSoldOut,
dealDet.dealTitle,
dealTyp.dealTypeKey,
busDet.businessName,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionDealPrice,
dealOpt.optionSKU,
timez.timeZoneName,
timez.timeZoneAbbreviation, (SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealOrdersCount , (SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs ,
(
SELECT
GROUP_CONCAT(
DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', '
) AS cityName
FROM
dp_deal_locations AS dealLoc,
dp_cities AS cit
INNER JOIN
dp_city_details AS city_details
ON (city_details.cityID=cit.cityID)
WHERE
dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND
dealLoc.dealID=deal.dealID
AND city_details.languageID='1'
) AS cityNames
FROM
dp_timezones AS timez
LEFT JOIN
dp_deals AS deal
ON (timez.timeZoneID=deal.dealTimeZone)
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID=dealDet.dealID
AND
dealDet.languageID='1'
)
LEFT JOIN
dp_deal_types AS dealTyp
ON (deal.dealTypeID = dealTyp.dealTypeID)
LEFT JOIN
dp_business_details AS busDet
ON (
deal.businessID = busDet.businessID
AND
busDet.languageID='1'
)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
dealOpt.dealID = deal.dealID
AND
dealOpt.dealOptionDefault='Yes'
) LEFT JOIN dp_url_rewrite AS urlRew
ON (
urlRew.objectID = deal.dealID
AND
urlRew.type =
IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal'))
AND parentID=0
AND
isSystem=1
AND
urlRew.languageID = '1'
) WHERE 1
AND (deal.dealID IN
(
SELECT
DISTINCT dealLoc.dealID
FROM
dp_deal_locations AS dealLoc
INNER JOIN
dp_cities AS cit
ON dealLoc.cityID = cit.cityID
WHERE
dealLoc.dealID = deal.dealID
AND cit.cityStatus = 'Active'
AND dealLoc.cityID IN ('1') ) OR
EXISTS(
SELECT
1
FROM
dp_deal_to_country AS dealTC
WHERE
dealTC.dealID = deal.dealID AND
dealTC.countryID IN (161) ))
AND
dealTyp.dealTypeStatus='Active' AND
deal.dealStatus IN ('Active') AND
dealTyp.dealTypeKey = 'deal' AND
deal.businessID = '32' AND
CONVERT_TZ('2021-06-16 00:51:01',@@session.time_zone,timez.timeZoneDiff)
BETWEEN
deal.dealStartTime
AND
deal.dealEndTime
AND deal.businessID IN
(
SELECT
businessID
FROM
dp_business
WHERE
businessID = deal.businessID
AND businessStatus='Active'
)
AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY
deal.dealID
ORDER BY
dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC
MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT
deal.dealID,
deal.refdealID,
deal.dealProximity,
deal.dealStartTime,
deal.dealEndTime,
deal.multiOptionsAvailable,
deal.dealImage,
deal.dealOnlineRedemption,
deal.dealCreatedDate,
deal.dealStatus,
deal.dealExclusiveDeal,
dealDet.dealExclusiveText,
deal.InventoryTrackLevel,
deal.dealCreatedDate,
deal.dealDefaultCurrency,
deal.dealTippedDate,
deal.dealMinQntyReqToTipp,
deal.dealTypeID,
urlRew.requestPath,
deal.dealSoldCountManipulate,
( CASE
WHEN deal.InventoryTrackLevel='Deal' THEN
(SELECT
COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0)
FROM
`dp_deal_options`
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active')
WHEN deal.InventoryTrackLevel='Options' THEN
(SELECT
COALESCE(sum(`combinationQty`),0)
FROM
`dp_product_combination` Combo
INNER JOIN
dp_deal_options OPT
ON (OPT.dealOptionID=Combo.dealOptionID)
WHERE
OPT.dealID=deal.dealID
AND
Combo.status='A')
ELSE
1
END
)as dealSoldOut,
dealDet.dealTitle,
dealTyp.dealTypeKey,
busDet.businessName,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionDealPrice,
dealOpt.optionSKU,
timez.timeZoneName,
timez.timeZoneAbbreviation, (SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealOrdersCount , (SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs ,
(
SELECT
GROUP_CONCAT(
DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', '
) AS cityName
FROM
dp_deal_locations AS dealLoc,
dp_cities AS cit
INNER JOIN
dp_city_details AS city_details
ON (city_details.cityID=cit.cityID)
WHERE
dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND
dealLoc.dealID=deal.dealID
AND city_details.languageID='1'
) AS cityNames
FROM
dp_timezones AS timez
LEFT JOIN
dp_deals AS deal
ON (timez.timeZoneID=deal.dealTimeZone)
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID=dealDet.dealID
AND
dealDet.languageID='1'
)
LEFT JOIN
dp_deal_types AS dealTyp
ON (deal.dealTypeID = dealTyp.dealTypeID)
LEFT JOIN
dp_business_details AS busDet
ON (
deal.businessID = busDet.businessID
AND
busDet.languageID='1'
)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
dealOpt.dealID = deal.dealID
AND
dealOpt.dealOptionDefault='Yes'
) LEFT JOIN dp_url_rewrite AS urlRew
ON (
urlRew.objectID = deal.dealID
AND
urlRew.type =
IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal'))
AND parentID=0
AND
isSystem=1
AND
urlRew.languageID = '1'
) WHERE 1
AND (deal.dealID IN
(
SELECT
DISTINCT dealLoc.dealID
FROM
dp_deal_locations AS dealLoc
INNER JOIN
dp_cities AS cit
ON dealLoc.cityID = cit.cityID
WHERE
dealLoc.dealID = deal.dealID
AND cit.cityStatus = 'Active'
AND dealLoc.cityID IN ('1') ) OR
EXISTS(
SELECT
1
FROM
dp_deal_to_country AS dealTC
WHERE
dealTC.dealID = deal.dealID AND
dealTC.countryID IN (161) ))
AND
dealTyp.dealTypeStatus='Active' AND
deal.dealStatus IN ('Active') AND
dealTyp.dealTypeKey = 'getaway_deal' AND
deal.businessID = '32' AND
CONVERT_TZ('2021-06-16 00:51:01',@@session.time_zone,timez.timeZoneDiff)
BETWEEN
deal.dealStartTime
AND
deal.dealEndTime
AND deal.businessID IN
(
SELECT
businessID
FROM
dp_business
WHERE
businessID = deal.businessID
AND businessStatus='Active'
)
AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY
deal.dealID
ORDER BY
dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC
MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT
deal.dealID,
deal.refdealID,
deal.dealProximity,
deal.dealStartTime,
deal.dealEndTime,
deal.multiOptionsAvailable,
deal.dealImage,
deal.dealOnlineRedemption,
deal.dealCreatedDate,
deal.dealStatus,
deal.dealExclusiveDeal,
dealDet.dealExclusiveText,
deal.InventoryTrackLevel,
deal.dealCreatedDate,
deal.dealDefaultCurrency,
deal.dealTippedDate,
deal.dealMinQntyReqToTipp,
deal.dealTypeID,
urlRew.requestPath,
deal.dealSoldCountManipulate,
( CASE
WHEN deal.InventoryTrackLevel='Deal' THEN
(SELECT
COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0)
FROM
`dp_deal_options`
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active')
WHEN deal.InventoryTrackLevel='Options' THEN
(SELECT
COALESCE(sum(`combinationQty`),0)
FROM
`dp_product_combination` Combo
INNER JOIN
dp_deal_options OPT
ON (OPT.dealOptionID=Combo.dealOptionID)
WHERE
OPT.dealID=deal.dealID
AND
Combo.status='A')
ELSE
1
END
)as dealSoldOut,
dealDet.dealTitle,
dealTyp.dealTypeKey,
busDet.businessName,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionDealPrice,
dealOpt.optionSKU,
timez.timeZoneName,
timez.timeZoneAbbreviation, (SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealOrdersCount , (SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs ,
(
SELECT
GROUP_CONCAT(
DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', '
) AS cityName
FROM
dp_deal_locations AS dealLoc,
dp_cities AS cit
INNER JOIN
dp_city_details AS city_details
ON (city_details.cityID=cit.cityID)
WHERE
dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND
dealLoc.dealID=deal.dealID
AND city_details.languageID='1'
) AS cityNames
FROM
dp_timezones AS timez
LEFT JOIN
dp_deals AS deal
ON (timez.timeZoneID=deal.dealTimeZone)
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID=dealDet.dealID
AND
dealDet.languageID='1'
)
LEFT JOIN
dp_deal_types AS dealTyp
ON (deal.dealTypeID = dealTyp.dealTypeID)
LEFT JOIN
dp_business_details AS busDet
ON (
deal.businessID = busDet.businessID
AND
busDet.languageID='1'
)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
dealOpt.dealID = deal.dealID
AND
dealOpt.dealOptionDefault='Yes'
) LEFT JOIN dp_url_rewrite AS urlRew
ON (
urlRew.objectID = deal.dealID
AND
urlRew.type =
IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal'))
AND parentID=0
AND
isSystem=1
AND
urlRew.languageID = '1'
) WHERE 1
AND (deal.dealID IN
(
SELECT
DISTINCT dealLoc.dealID
FROM
dp_deal_locations AS dealLoc
INNER JOIN
dp_cities AS cit
ON dealLoc.cityID = cit.cityID
WHERE
dealLoc.dealID = deal.dealID
AND cit.cityStatus = 'Active'
AND dealLoc.cityID IN ('1') ) OR
EXISTS(
SELECT
1
FROM
dp_deal_to_country AS dealTC
WHERE
dealTC.dealID = deal.dealID AND
dealTC.countryID IN (161) ))
AND
dealTyp.dealTypeStatus='Active' AND
deal.dealEndTime < IF (
(CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0),
CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff),
NOW()
)
AND deal.dealTippedDate IS NOT NULL
AND
deal.dealStatus IN ('Active') AND
dealTyp.dealTypeKey = 'getaway_deal' AND
deal.businessID = '32'
AND deal.businessID IN
(
SELECT
businessID
FROM
dp_business
WHERE
businessID = deal.businessID
AND businessStatus='Active'
)
AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY
deal.dealID
HAVING
(dealOrdersCount >= deal.dealMinQntyReqToTipp)
ORDER BY
deal.dealID DESC
MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT
deal.dealID,
deal.refdealID,
deal.dealProximity,
deal.dealStartTime,
deal.dealEndTime,
deal.multiOptionsAvailable,
deal.dealImage,
deal.dealOnlineRedemption,
deal.dealCreatedDate,
deal.dealStatus,
deal.dealExclusiveDeal,
dealDet.dealExclusiveText,
deal.InventoryTrackLevel,
deal.dealCreatedDate,
deal.dealDefaultCurrency,
deal.dealTippedDate,
deal.dealMinQntyReqToTipp,
deal.dealTypeID,
urlRew.requestPath,
deal.dealSoldCountManipulate,
( CASE
WHEN deal.InventoryTrackLevel='Deal' THEN
(SELECT
COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0)
FROM
`dp_deal_options`
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active')
WHEN deal.InventoryTrackLevel='Options' THEN
(SELECT
COALESCE(sum(`combinationQty`),0)
FROM
`dp_product_combination` Combo
INNER JOIN
dp_deal_options OPT
ON (OPT.dealOptionID=Combo.dealOptionID)
WHERE
OPT.dealID=deal.dealID
AND
Combo.status='A')
ELSE
1
END
)as dealSoldOut,
dealDet.dealTitle,
dealTyp.dealTypeKey,
busDet.businessName,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionDealPrice,
dealOpt.optionSKU,
timez.timeZoneName,
timez.timeZoneAbbreviation, (SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealOrdersCount , (SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs ,
(
SELECT
GROUP_CONCAT(
DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', '
) AS cityName
FROM
dp_deal_locations AS dealLoc,
dp_cities AS cit
INNER JOIN
dp_city_details AS city_details
ON (city_details.cityID=cit.cityID)
WHERE
dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND
dealLoc.dealID=deal.dealID
AND city_details.languageID='1'
) AS cityNames
FROM
dp_timezones AS timez
LEFT JOIN
dp_deals AS deal
ON (timez.timeZoneID=deal.dealTimeZone)
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID=dealDet.dealID
AND
dealDet.languageID='1'
)
LEFT JOIN
dp_deal_types AS dealTyp
ON (deal.dealTypeID = dealTyp.dealTypeID)
LEFT JOIN
dp_business_details AS busDet
ON (
deal.businessID = busDet.businessID
AND
busDet.languageID='1'
)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
dealOpt.dealID = deal.dealID
AND
dealOpt.dealOptionDefault='Yes'
) LEFT JOIN dp_url_rewrite AS urlRew
ON (
urlRew.objectID = deal.dealID
AND
urlRew.type =
IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal'))
AND parentID=0
AND
isSystem=1
AND
urlRew.languageID = '1'
) WHERE 1
AND
dealTyp.dealTypeStatus='Active' AND
deal.dealStatus IN ('Active') AND
dealTyp.dealTypeKey = 'product_deal' AND
deal.businessID = '32' AND
CONVERT_TZ('2021-06-16 00:51:01',@@session.time_zone,timez.timeZoneDiff)
BETWEEN
deal.dealStartTime
AND
deal.dealEndTime
AND deal.businessID IN
(
SELECT
businessID
FROM
dp_business
WHERE
businessID = deal.businessID
AND businessStatus='Active'
)
AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY
deal.dealID
ORDER BY
dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC
MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT
deal.dealID,
deal.refdealID,
deal.dealProximity,
deal.dealStartTime,
deal.dealEndTime,
deal.multiOptionsAvailable,
deal.dealImage,
deal.dealOnlineRedemption,
deal.dealCreatedDate,
deal.dealStatus,
deal.dealExclusiveDeal,
dealDet.dealExclusiveText,
deal.InventoryTrackLevel,
deal.dealCreatedDate,
deal.dealDefaultCurrency,
deal.dealTippedDate,
deal.dealMinQntyReqToTipp,
deal.dealTypeID,
urlRew.requestPath,
deal.dealSoldCountManipulate,
( CASE
WHEN deal.InventoryTrackLevel='Deal' THEN
(SELECT
COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0)
FROM
`dp_deal_options`
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active')
WHEN deal.InventoryTrackLevel='Options' THEN
(SELECT
COALESCE(sum(`combinationQty`),0)
FROM
`dp_product_combination` Combo
INNER JOIN
dp_deal_options OPT
ON (OPT.dealOptionID=Combo.dealOptionID)
WHERE
OPT.dealID=deal.dealID
AND
Combo.status='A')
ELSE
1
END
)as dealSoldOut,
dealDet.dealTitle,
dealTyp.dealTypeKey,
busDet.businessName,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionDealPrice,
dealOpt.optionSKU,
timez.timeZoneName,
timez.timeZoneAbbreviation, (SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealOrdersCount , (SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs ,
(
SELECT
GROUP_CONCAT(
DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', '
) AS cityName
FROM
dp_deal_locations AS dealLoc,
dp_cities AS cit
INNER JOIN
dp_city_details AS city_details
ON (city_details.cityID=cit.cityID)
WHERE
dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND
dealLoc.dealID=deal.dealID
AND city_details.languageID='1'
) AS cityNames
FROM
dp_timezones AS timez
LEFT JOIN
dp_deals AS deal
ON (timez.timeZoneID=deal.dealTimeZone)
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID=dealDet.dealID
AND
dealDet.languageID='1'
)
LEFT JOIN
dp_deal_types AS dealTyp
ON (deal.dealTypeID = dealTyp.dealTypeID)
LEFT JOIN
dp_business_details AS busDet
ON (
deal.businessID = busDet.businessID
AND
busDet.languageID='1'
)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
dealOpt.dealID = deal.dealID
AND
dealOpt.dealOptionDefault='Yes'
) LEFT JOIN dp_url_rewrite AS urlRew
ON (
urlRew.objectID = deal.dealID
AND
urlRew.type =
IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal'))
AND parentID=0
AND
isSystem=1
AND
urlRew.languageID = '1'
) WHERE 1
AND
dealTyp.dealTypeStatus='Active' AND
deal.dealEndTime < IF (
(CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0),
CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff),
NOW()
)
AND deal.dealTippedDate IS NOT NULL
AND
deal.dealStatus IN ('Active') AND
dealTyp.dealTypeKey = 'product_deal' AND
deal.businessID = '32'
AND deal.businessID IN
(
SELECT
businessID
FROM
dp_business
WHERE
businessID = deal.businessID
AND businessStatus='Active'
)
AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY
deal.dealID
HAVING
(dealOrdersCount >= deal.dealMinQntyReqToTipp)
ORDER BY
deal.dealID DESC