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