Loading...
L
o
a
d
i
n
g
string(2827) "
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,
pa.online_product_img,
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 IN (24)
)
SELECT
rp.catalog_id,
rp.product_id,
rp.attr_id,
rp.attr_name,
CASE
WHEN rp.online_product_img IS NOT NULL AND rp.online_product_img != ''
THEN rp.online_product_img
ELSE rp.product_img
END AS product_img,
CASE
WHEN rp.online_product_img IS NOT NULL AND rp.online_product_img != ''
THEN rp.online_product_img
ELSE rp.online_img
END AS online_img,
CASE
WHEN rp.online_product_img IS NOT NULL AND rp.online_product_img != ''
THEN rp.online_product_img
ELSE rp.perspective_img
END AS perspective_img,
rp.online_product_img,
CASE
WHEN rp.online_product_img IS NOT NULL AND rp.online_product_img != ''
THEN 'product_attr'
ELSE 'product'
END AS image_source,
rp.online_category
FROM
RankedProducts rp
WHERE
rp.row_rank = 1
ORDER BY
rp.attr_name ASC
;
"
_f.jpg)
.png "You can check the serial number of your item")
