Flash Sale

SELECT
   SQL_NO_CACHE DISTINCT promo.ID AS ID,
   prod_id.VALUE AS LINKED_PROD_ID,
   prod.CODE AS LINKED_PROD_CODE,
   section.CODE AS LINKED_SECTION_CODE,
   promo.NAME AS NAME,
   prod.NAME_AR AS NAME_AR,
   IF( sort_site.DESCRIPTION*1 > 0, sort_site.DESCRIPTION*1, promo.SORT ) AS SORT,
   price_msrp.VALUE AS PRICE_OLD,
   price_current.VALUE AS PRICE_CURRENT,
   CEIL((1 - (price_current.VALUE / price_msrp.VALUE))*100) AS PERCENT_DISCOUNT,
   prod.PREVIEW_PICTURE AS IMAGE_ID,
   REPLACE( CONCAT( image_preview.SUBDIR, '/' , image_preview.FILE_NAME ), '/', '-' ) AS IMAGE_FILE,
   promo.ACTIVE_FROM,
   promo.ACTIVE_TO,
   block_element_video.VALUE as VIDEO_ID,
   UPPER( GROUP_CONCAT(DISTINCT block_element_promo_enum.VALUE SEPARATOR ',') ) AS DISABLED_PROMO_SITES,
   UPPER( GROUP_CONCAT(DISTINCT block_element_prod_enum.VALUE SEPARATOR ',') ) AS DISABLED_PROD_SITES,
   UPPER( block_platform_element_promo_enum.XML_ID ) AS DISABLED_PLATFORM,
   IF(sale_type.VALUE = 2130, 'FLASH_SALE', 'WEB_SALE') AS SALE_TYPE,
   total_orders.VALUE AS TOTAL_ORDERS,
   total_stock.VALUE AS TOTAL_STOCK,
   IF( pre_order.VALUE = 1051 , 'Y' , 'N' ) AS PRE_ORDER
FROM
   b_iblock_element promo
   INNER JOIN
      b_iblock_element_property event
      ON ( event.IBLOCK_ELEMENT_ID = promo.ID
      AND event.IBLOCK_PROPERTY_ID = 464 )
   INNER JOIN
      b_iblock_element_property sale_type
      ON ( sale_type.IBLOCK_ELEMENT_ID = promo.ID
      AND sale_type.IBLOCK_PROPERTY_ID = 468 )
   INNER JOIN
      b_iblock_element_property prod_id
      ON ( prod_id.IBLOCK_ELEMENT_ID = promo.ID
      AND prod_id.IBLOCK_PROPERTY_ID = 460 )
   INNER JOIN
      b_iblock_element prod
      ON prod.ID = prod_id.VALUE
   INNER JOIN
      b_iblock_section section
      ON section.ID = prod.IBLOCK_SECTION_ID
   INNER JOIN
      b_iblock_element_property price_msrp
      ON ( price_msrp.IBLOCK_ELEMENT_ID = prod.ID
      AND price_msrp.IBLOCK_PROPERTY_ID = 298 )
   INNER JOIN
      b_iblock_element_property price_current
      ON ( price_current.IBLOCK_ELEMENT_ID = promo.ID
      AND price_current.IBLOCK_PROPERTY_ID = 461 )
   LEFT JOIN
      b_file image_preview
      ON image_preview.ID = prod.PREVIEW_PICTURE
   LEFT JOIN
      b_file image_detail
      ON image_detail.ID = prod.PREVIEW_PICTURE
   LEFT JOIN
      b_iblock_element_property block_element_promo
      ON ( block_element_promo.IBLOCK_ELEMENT_ID = promo.ID
      AND block_element_promo.IBLOCK_PROPERTY_ID = 514 )
   LEFT JOIN
      b_iblock_element_property block_platform_element_promo
      ON ( block_platform_element_promo.IBLOCK_ELEMENT_ID = promo.ID
      AND block_platform_element_promo.IBLOCK_PROPERTY_ID = 516 )
   LEFT JOIN
      b_iblock_property_enum block_platform_element_promo_enum
      ON ( block_platform_element_promo_enum.ID = block_platform_element_promo.VALUE )
   LEFT JOIN
      b_iblock_element_property block_element_video
      ON ( block_element_video.IBLOCK_ELEMENT_ID = prod.ID
      AND block_element_video.IBLOCK_PROPERTY_ID = 211 )
   LEFT JOIN
      b_iblock_property_enum block_element_promo_enum
      ON ( block_element_promo_enum.ID = block_element_promo.VALUE )
   LEFT JOIN
      b_iblock_element_property block_element_prod
      ON ( block_element_prod.IBLOCK_ELEMENT_ID = prod.ID
      AND block_element_prod.IBLOCK_PROPERTY_ID = 520 )
   LEFT JOIN
      b_iblock_property_enum block_element_prod_enum
      ON ( block_element_prod_enum.ID = block_element_prod.VALUE )
   LEFT JOIN
      b_iblock_element_property total_stock
      ON ( total_stock.IBLOCK_ELEMENT_ID = promo.ID
      AND total_stock.IBLOCK_PROPERTY_ID = 458 )
   LEFT JOIN
      b_iblock_element_property total_orders
      ON ( total_orders.IBLOCK_ELEMENT_ID = promo.ID
      AND total_orders.IBLOCK_PROPERTY_ID = 459 )
   LEFT JOIN
      b_iblock_element_property pre_order
      ON ( pre_order.IBLOCK_ELEMENT_ID = prod_id.VALUE
      AND pre_order.IBLOCK_PROPERTY_ID = 278 )
   LEFT JOIN
      b_iblock_element_property sort_site
      ON ( sort_site.IBLOCK_ELEMENT_ID = promo.ID
      AND sort_site.VALUE = 'SA'
      AND sort_site.IBLOCK_PROPERTY_ID = 521 )
WHERE
   promo.ACTIVE = 'Y'
   AND promo.ACTIVE_TO IS NOT NULL
   AND promo.ACTIVE_FROM IS NOT NULL
   AND promo.IBLOCK_ID = 44
   AND event.VALUE = 2589
GROUP BY
   promo.ID
HAVING
( LOCATE( 'GLOBAL', DISABLED_PROMO_SITES ) IS NULL
   OR LOCATE( 'GLOBAL', DISABLED_PROMO_SITES ) = 0 )
   AND
   (
      LOCATE( 'GLOBAL', DISABLED_PROD_SITES ) IS NULL
      OR LOCATE( 'GLOBAL', DISABLED_PROD_SITES ) = 0
   )
   AND
   (
      LOCATE( 'desktop', DISABLED_PLATFORM ) IS NULL
      OR LOCATE( 'desktop', DISABLED_PLATFORM ) = 0
   )
ORDER BY
   SORT DESC,
   promo.ID DESC