UAG Cases & Mobile Accessories Malaysia

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 = 1319 and category2.categoryID = 678

    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