当使用count(分页)时，两个看似相同的查询返回不同的结果

I am running two queries to my database for pagination reasons. As such, each query is nearly identical. My COUNT(*) query is not returning the number of results that the non-count query is. I'm baffled as to why this is the case. The queries are below.I am running two queries to my database for pag