Trying to create a table from a MySQL query but am getting the following error. 

 info unknown [expr_type] = user_variable in "expression subtree" [0]

I know my query works as I can run it directly from the mysql database and return the information I want. It also displays the info I want in your preview, but when I go to click on create the table that is the error I receive.

I have attached a screenshot to this ticket, any help would be appreciated as I have 5 more tables like this to create and have a deadline to meet which is in 4 days.

Hi Bogdan,

  Yes I also tried creating it via Add from data source and selected MySQL Query as the type. It gives me the exact same error.

Select @ranknum := @ranknum + 1 AS Rank, T1.*
FROM
(
   SELECT a.meta_value AS Resort, TRIM(TRAILING ' in.' FROM b.meta_value) AS Snowfall
   FROM wpu1_postmeta a
   LEFT OUTER JOIN wpu1_postmeta b ON b.post_id = a.post_id
   AND b.meta_key =  '_job_annualsnow'
   WHERE a.meta_key =  '_company_name'
   
) AS T1, (Select @ranknum := 0) AS r
ORDER BY CONVERT(Snowfall, SIGNED INTEGER) DESC

Was just trying to make table from it. 

The issue isn't the query at least not in mysql itself. All I am doing is generating a table column in a select statement and populating that column with number representing a ranking system based upon sorting. If you look in the 1st picture I attached you will see how by using @ranknum which is a variable it is creating a column called Rank and populating it with a number starting at 1. If you would like I can screen shot this inside of phpmyadmin as well. The problem appears to be that your plugin does not accept user assigned vars.