After I run in SQL toolbox (v4.6.11) a simple query like this:

SELECT email FROM core_members where allow_admin_mails = 1 AND temp_ban <> -1 AND joined > 1618596660 AND MEMBER_GROUP_ID = 3;

I get correct results in the first page, but when I click Next or 2 or 3 for other pages of the results I get a blank page.

Is this a known issue?

Is there a command that I could add to my SELECT statement that will not force pagination so that I can see all the results on the 1st page?

Edited March 22, 20223 yr by Jeffrey Roberts

There is no command that will allow lack of pagination. I would suggest if you are running queries like that, you use something like phpMyAdmin which is more built for that purpose. 

That said, I am not able to replicate any issue at all on my end here with mysql toolbox. 

Thanks. This must be an issue with our server provider.

I did use my phpMyAdmin as my workaround. It has always been so convenient for years to generate this list from SQL toolbox.

Most likely it is a limitation of the server. SQL Toolbox is a great tool but please be aware that we may discontinue it at any time and it may have limitations either imposed by your hosting provider or otherwise.