Caught exception: SELECT SQL_CALC_FOUND_ROWS *
FROM product
INNER JOIN product_price ON product_id = product_price_product_id
INNER JOIN category on category_id = product_category_id
INNER JOIN store on product_price_vendor_id = store_id
WHERE store_active=1 AND product_active = 1 AND product_price_active = 1 AND product_subbrand != ''
AND product_category_id = 174
GROUP BY product_subbrand
ORDER BY product_name ASC
LIMIT 200, 100