Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE3Mjg4NTY1NzQsImlzcyI6ImVLYXJ0IiwiZXhwIjoxNzI4ODU4Mzc0LCJzdWIiOiJlS2FydCBBdXRoZW50aWNhdGlvbiJ9._tXpak1jznMGWKz2Sw3crYMhDTdU14vbLgcS8-x5Xho
API URL : shop.php
Params :
array(12) { ["limit"]=> int(12) ["offset"]=> int(0) ["s"]=> string(0) "" ["category"]=> string(2) "20" ["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(20) AND p.status = 1 AND c.status = 1