Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE3Mjg4NjI4NTUsImlzcyI6ImVLYXJ0IiwiZXhwIjoxNzI4ODY0NjU1LCJzdWIiOiJlS2FydCBBdXRoZW50aWNhdGlvbiJ9.x9icxxFwkgMcSAkqwBN7taRUcDYHLkc2Vl_FxFWrG1s
API URL : shop.php
Params :
array(12) { ["limit"]=> int(12) ["offset"]=> int(0) ["s"]=> string(0) "" ["category"]=> string(2) "22" ["sub-category"]=> string(0) "" ["sub-sub-category"]=> string(0) "" ["sort"]=> string(0) "" ["out_of_stock"]=> int(0) ["min_price"]=> int(0) ["max_price"]=> int(0) ["pincode"]=> string(0) "" ["accesskey"]=> string(5) "90336" }
SELECT count(p.id) as total,MIN(if(pv.discounted_price > 0, pv.discounted_price, pv.price)) as min_price, MAX(if(pv.discounted_price > 0, pv.discounted_price, pv.price)) as max_price FROM products p INNER JOIN category c on c.id=p.category_id INNER JOIN product_variant pv on p.id=pv.product_id WHERE p.category_id IN(22) AND p.status = 1 AND c.status = 1