Title: None working SQL syntax that works fine with SQL Executioner plugin
Last modified: August 31, 2016

---

# None working SQL syntax that works fine with SQL Executioner plugin

 *  Anonymous User 12673376
 * (@anonymized-12673376)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/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
 * [https://wordpress.org/plugins/miwosql/](https://wordpress.org/plugins/miwosql/)

The topic ‘None working SQL syntax that works fine with SQL Executioner plugin’ 
is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/miwosql_67b6e4.svg)
 * [MiwoSQL - Database & SQL Manager](https://wordpress.org/plugins/miwosql/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/miwosql/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/miwosql/)
 * [Active Topics](https://wordpress.org/support/plugin/miwosql/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/miwosql/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/miwosql/reviews/)

## Tags

 * [join](https://wordpress.org/support/topic-tag/join/)

 * 0 replies
 * 1 participant
 * Last reply from: Anonymous User 12673376
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/none-working-sql-syntax-that-works-fine-with-sql-executioner-plugin/)
 * Status: not resolved