SELECT
  % s(t1.price) as price
FROM
  product as t1
  LEFT JOIN productCategory as t2 ON t1.id = t2.productId
WHERE
  t2.categoryId = % d
  and t1.isDelete = 0
  and t1.active = 1