{"count":"798","lists":[],"page":1,"total_page":67,"first":0,"offset":12,"cquery":"\r\n    SELECT\r\n        COUNT(*)\r\n    FROM\r\n        tblproduct a\r\n        JOIN ( SELECT c_productcode FROM tblproductlink WHERE c_category LIKE '%' GROUP BY c_productcode ) b on  a.productcode = b.c_productcode\r\n     WHERE a.approve_status = 'C' AND a.sales_status IN ( 'P', 'M' ) AND a.shop_div_code IN ( 'B', 'O' ) ","query":"\r\n    SELECT\r\n        a.pridx, a.productcode, a.productname, a.mdcomment, NVL(a.sellprice, 0) sellprice, NVL(a.consumerprice, 0) consumerprice, a.production, a.model, NVL(a.quantity, 0) quantity, a.maximage, a.minimage, a.tinyimage, a.icon, a.prodcode, a.colorcode, a.sizecd, a.over_minimage, NVL(a.couponprice,0) couponprice, a.c_season, a.shop_div_code, a.seles_status,\r\n        \r\n        nvl(re.marks,0) as marks, nvl(re.marks_total_cnt,0) as marks_total_cnt\r\n    FROM\r\n        tblproduct a\r\n        JOIN ( SELECT c_productcode FROM tblproductlink WHERE c_category LIKE '%' GROUP BY c_productcode ) b on  a.productcode = b.c_productcode\r\n        LEFT JOIN (SELECT productcode, sum(marks) as marks, count(productcode) as marks_total_cnt FROM tblproductreview group by productcode) re on a.productcode = re.productcode\r\n     WHERE a.approve_status = 'C' AND a.sales_status IN ( 'P', 'M' ) AND a.shop_div_code IN ( 'B', 'O' ) \r\n    ORDER BY\r\n         a.start_no asc, a.pridx desc \r\n    offset 0 rows fetch next 12 rows only\r\n    "}