USAMS

DEBUG PG = int(1)

DEBUG SQL:

    SELECT
        product.ProductID,
        product.Name,
        product.rating,
        product.stockstatus,
        product.RetailPrice,
        product.freeshipping,
        product.salemode,
        product.beforediscount,
        product.SellingPrice,
        ROUND(
            (product.SellingPrice - (product.SellingPrice * product.Discount / 100)),
            2
        ) AS finalprice,
        product.DateUpdated,
        (
            SELECT pic.picture_name_01
            FROM nice_product_picture pic
            WHERE pic.product_id = product.ProductID
            ORDER BY pic.ordering
            LIMIT 1
        ) AS product_image,


        COALESCE(
            (
                SELECT nc.category_displayname
                FROM nice_category_product ncp
                INNER JOIN nice_category_relation ncr
                    ON ncr.category_child_id = ncp.CategoryID
                AND ncr.category_id = 95
                INNER JOIN nice_category nc
                    ON nc.CategoryID = ncp.CategoryID
                WHERE ncp.ProductID = product.ProductID
                LIMIT 1
            ),
            'Red Design'
        ) AS phonetype

    FROM nice_product product

     inner join nice_category_product category1 on product.ProductID = category1.productID  inner join nice_category_product category2 on product.ProductID = category2.productID 

    WHERE product.makeof = 'genuine'
    AND product.online = 1
    AND product.isfreegift = 0

     and category1.categoryID = 1069 and category2.categoryID = 439

    GROUP BY product.ProductID
      order by FIELD (stockstatus, 'Limited Stock', 'Ready Stock', 'Pre-order','Coming Soon','Check with Us','Sold Out'),Recommend Desc, ordering, DateUpdated desc ,FIELD (importshipment, 'fast', 'slow'),Name limit 0, 30

Sold Out

USAMS Magnetic Car Wireless Charging 15W Max Car Mount Phone Holder for iPhone 13 Pro Max iPhone 12 Pro Max Galaxy S21 Ultra Note 20 Ultra (Air Vent)

Now at MYR 89.00

MYR 99.00

You Save 10%

Smart Voucher : Red Design 10% off