SELECT DISTINCT(p_id) idp,p_nmb nmb,MIN(ep_precio) precio,p_sku sku,p_departamento dpto,p_concepto conecpto,p_categoria categoria,p_inventariado FROM productos INNER JOIN esquema_precio ON p_id = ep_producto WHERE p_estatus = "A" AND p_tienda IN ("0","2") AND (p_nmb LIKE "%kit%" OR p_id LIKE "%kit%" ) GROUP BY p_id ORDER BY idp ASC LIMIT 0,12