SELECT MIN(p.price) AS precio_minimo, MAX(p.price) AS precio_maximo FROM `category_group` cg INNER JOIN `category_product` cp ON cp.`id_category` = cg.`id_category` INNER JOIN `category` c ON cp.`id_category` = c.`id_category` INNER JOIN `product` p ON cp.`id_product` = p.`id_product` INNER JOIN `product_lang` pl ON p.`id_product` = pl.`id_product` WHERE p.`active` = 1 AND neumatico = 1 AND quantity > 0 AND cp.id_category= AND p.carga =0 AND p.velocidad like '0' LIMIT 1