: select * from yp_product inner join yp_product_cat on yp_product.product_id = yp_product_cat.product_id inner join yp_category on yp_category.category_id = yp_product_cat.category_id where yp_product.product_status='Active' group by yp_product.product_id order by yp_product.product_sale_price 1_100 limit 0, 27