decoration wallpaper

array(1) {
  [0]=>
  object(stdClass)#6 (5) {
    ["id"]=>
    int(35)
    ["date_time"]=>
    string(19) "2024-08-24 03:20:27"
    ["base_category"]=>
    string(1) "4"
    ["category"]=>
    string(9) "Wallpaper"
    ["deleted"]=>
    int(0)
  }
}

category idint(35)

L o a d i n g

0

Enhance Your Space with Elegance

string(1743) "
       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
               
       )
       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
       ;
       "