360 Home Decor - Built to Last, Designed to Inspire

L o a d i n g

NULL

string(1772) "
       WITH RankedProducts AS (
           SELECT
               CAST(JSON_UNQUOTE(JSON_EXTRACT(p.product_dims_data, '$[0].standart_price')) AS DECIMAL(10, 2)) AS stander_price,
               p.*,
               pa.attr_name,
               pa.online_category,
               c.catalog_id,
               c.catalog_name,
               ROW_NUMBER() OVER (
                   PARTITION BY pa.attr_name
                   ORDER BY
                       CASE
                           WHEN c.catalog_id = 4 THEN 1
                           WHEN c.catalog_id = 1 THEN 2
                           WHEN c.catalog_id = 2 THEN 3
                           ELSE 4
                       END ASC
               ) AS row_rank
           FROM
               hd_products AS p
           INNER JOIN
               hd_product_attr AS pa
               ON p.attr_id = pa.attr_id
           INNER JOIN
               hd_catalogs AS c
               ON pa.catalog_id = c.catalog_id
           WHERE
               p.product_status = '1'
               AND p.product_web_status = '1'
               AND pa.attr_online_status = 'Online'
               AND CAST(
                   JSON_UNQUOTE(JSON_EXTRACT(p.product_dims_data, '$[0].standart_price'))
                   AS DECIMAL(10, 2)
               ) > 0
                AND pa.online_category = '5'
       )
       SELECT
           rp.catalog_id,
           rp.product_id,
           rp.attr_id,
           rp.attr_name,
           rp.product_img,
           rp.online_img,
           rp.perspective_img,
           rp.online_category
       FROM
           RankedProducts rp
       WHERE
           rp.row_rank = 1
       ORDER BY
           rp.attr_name ASC
       ;
       "