Bug in pagination does not apply where clause

[jpmateo022]

Hi,

It seems the pagination doesn't apply the where clause wherein it returns the total items in the database.

The total field value should only be 9.

The validation I made via manual SQL query

The total items I have in the database without filtering.

[josephmancuso]

Yup issue is right here on line 1322:

orm/src/masoniteorm/query/QueryBuilder.py

Lines 1322 to 1325 in ca84859

	total = self.new().count()
	paginator = LengthAwarePaginator(result, per_page, page, total)
	return paginator