fix: use total_count CTE and return it with the parsed results

fix: use total_count CTE and return it with the parsed results #1763