Hello Marco

If you're creating SQL query-based tables, you would be able to select only certain columns through the query, or add some condition for a column, like:

WHERE product = 'monitor'

For example.

I'm not sure if there's anything else I could help you with, but creating SQL query-based tables requires some SQL skills, and included support doesn't cover that.

I see, Marco.

Go to the Editing tab, and copy the value from the "MySQL table name for editing". Then create a new SQL query based table with a simple query, like:

SELECT * FROM the_mysql_table_name_you_copied

Hi again Marco

Something's not right here. What's the MySQL table name for editing?

Try:

SELECT COUNT(*) FROM Test

If "Test" is the MySQL table name for editing, it should work like this. If you still can't get it to work, please tell me which table you're trying to pull the data from, and provide me a temporary WP-admin (administrator) user 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 parties. 

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