None working SQL syntax that works fine with SQL Executioner plugin
-
HI !
I’m trying to use your very nice WordPress plugin for one of the pro project I’m working on but unfortunately the following SQL request returns a 500 error.—
SELECT display_name, user_email, DateNaissance, TelMobile FROM wp_users INNER JOIN ( SELECT T.user_id, DateNaissance, TelMobile FROM ( SELECT user_id, value AS TelMobile FROM wp_bp_xprofile_fields AS F INNER JOIN wp_bp_xprofile_data AS D WHERE field_id = F.id AND name = ‘Tel Mobile’ ) AS T INNER JOIN ( SELECT user_id, value AS DateNaissance FROM wp_bp_xprofile_fields AS F INNER JOIN wp_bp_xprofile_data AS D WHERE field_id = F.id AND name = ‘Date de naissance’ AND SUBSTRING(value, 6,5) = SUBSTRING(CAST(CURDATE() AS CHAR),6,5) ) AS Target WHERE Target.user_id = T.user_id ) AS Coordonnes WHERE ID = user_id ORDER BY display_name LIMIT 100 ;
—I know that request works fine because I already tried it with another WordPress plugin : SQL Executioner
But I would need to use that complexe request with your plugin that provides much more capabilities like the “save” function, the “RUN button” and the CSV export.
Please, tell me what I’m doing wrong or if your plugin does’nt handle that kind of SQL syntax.
Many thanks in advance,
Regards,
Jean David
- The topic ‘None working SQL syntax that works fine with SQL Executioner plugin’ is closed to new replies.
