Drupal → Посчитать число покупок товара

$product_id = 123;
 
$query = db_select('field_data_commerce_product', 'fcp');
$query->addExpression('COUNT(*)');
$query->innerJoin('commerce_line_item', 'l', 'l.line_item_id = fcp.entity_id');
$query->innerJoin('commerce_order', 'o', 'o.order_id = l.order_id');
$query->condition('o.status', 'completed');
$query->condition('fcp.commerce_product_product_id', $product_id);
$count = $query->execute()->fetchField();

$product_display_nid = 123;
 
$query = db_select('node', 'n');
$query->addExpression('COUNT(*)');
$query->innerJoin('field_data_field_product', 'ffp', 'ffp.entity_id = n.nid');
$query->innerJoin('field_data_commerce_product', 'fcp', 'fcp.commerce_product_product_id = ffp.field_product_product_id');
$query->innerJoin('commerce_line_item', 'l', 'l.line_item_id = fcp.entity_id');
$query->innerJoin('commerce_order', 'o', 'o.order_id = l.order_id');
$query->condition('o.status', 'completed');
$query->condition('n.nid', $product_display_nid);
$count = $query->execute()->fetchField();