Data from the counter column is not being displayed by the plug-in.
In the attachments you can see it when I run it straight against the DB but not when the plug-in parses it.
I didn't put the URL in because it is secured. If you have to have access I can set something up.
Here is the query source.
SELECT (@RankNum := @RankNum+1) AS Ranking ,wp_usermeta.meta_value AS MOCID ,MOCData.post_title AS MOCTitle ,fn.meta_value AS FirstName ,ln.meta_value AS LastName ,COUNT(wp_usermeta.meta_value) AS VoteCount FROM wp_usermeta LEFT JOIN wp_posts AS MOCData ON wp_usermeta.meta_value = MOCData.id LEFT JOIN wp_usermeta AS fn ON MOCData.post_author = fn.user_id LEFT JOIN wp_usermeta AS ln ON MOCData.post_author = ln.user_id WHERE wp_usermeta.meta_key = 'best_in_show_vote' AND MOCData.post_type='moc' AND fn.meta_key='first_name' AND ln.meta_key='last_name' GROUP BY wp_usermeta.meta_value ORDER BY Ranking
This is probably caused by using variables in your query. Using AS could be a problem to because we are using it for built in plugin settings so please try to use "Displayed header" option instead.
If that doesn't help please create MySQL VIEW from your query and use that as data source
Data from the counter column is not being displayed by the plug-in.
In the attachments you can see it when I run it straight against the DB but not when the plug-in parses it.
I didn't put the URL in because it is secured. If you have to have access I can set something up.
Here is the query source.
SELECT (@RankNum := @RankNum+1) AS Ranking ,wp_usermeta.meta_value AS MOCID ,MOCData.post_title AS MOCTitle ,fn.meta_value AS FirstName ,ln.meta_value AS LastName ,COUNT(wp_usermeta.meta_value) AS VoteCount FROM wp_usermeta LEFT JOIN wp_posts AS MOCData ON wp_usermeta.meta_value = MOCData.id LEFT JOIN wp_usermeta AS fn ON MOCData.post_author = fn.user_id LEFT JOIN wp_usermeta AS ln ON MOCData.post_author = ln.user_id WHERE wp_usermeta.meta_key = 'best_in_show_vote' AND MOCData.post_type='moc' AND fn.meta_key='first_name' AND ln.meta_key='last_name' GROUP BY wp_usermeta.meta_value ORDER BY Ranking
Hi MyWifesGeek,
This is probably caused by using variables in your query. Using AS could be a problem to because we are using it for built in plugin settings so please try to use "Displayed header" option instead.
If that doesn't help please create MySQL VIEW from your query and use that as data source