Hello Mekhla

I can't see any tables on the related URL you left, so I can't inspect the page.

The next page in the tables stays on the same page, so I don't know why you see about:blank#blocked, but it could be related to a security setting in a security plugin, or on your server.

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. 

You can write credentials here just check Private Reply so nobody can see them except us.

Hello Mekhla

Thank you for the video.

I haven't seen an error like this before, but since it says "Blocked", there must be something blocking it. Either settings on your server, or some security plugin.

wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. If your front-end table looks and behaves differently than in back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.

Also, I noticed you created a query like:

SELECT table.`column1`,
        table.`column2`,
        table.`column3`
FROM table

You should simplify it like this:

SELECT column1,
       column2,
       column3
FROM table

Or you will face issues with filtering and sorting. Maybe this will resolve the issue you're having now, but I can't say for sure as I've never encountered it.