Count records

$search = $modx->query("SELECT b.form_class, a.system_brand_id, a.system_product_id, b.company, a.system_edition_id, a.brand_name, b.content, c.section1_id, c.section2_id, c.section3_id, c.section4_id,
MATCH (tfv_records)AGAINST ('$xkeywordx' IN BOOLEAN MODE) AS relevance
FROM mod_tfvrecords a, mod_tblcontents b, mod_tblproductcategory c
WHERE MATCH (tfv_records)AGAINST ('$xkeywordx' IN BOOLEAN MODE)
AND a.system_brand_id = b.system_brands_id
AND a.system_product_id = c.system_product_id 
GROUP BY a.system_product_id ORDER BY relevance DESC LIMIT 50
");

$query->stmt->rowCount();