Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT u.*, p.name as plan, COUNT(m.user_id) as totalprojects
- FROM users u
- LEFT JOIN plans p ON p.id = u.access
- LEFT JOIN members m ON m.user_id = u.id
- WHERE u.email = 'email address';
- set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION, ONLY_FULL_GROUP_BY';
- SELECT @@sql_mode
- +------------------------------------------------------------------------------------------------------------------------+
- | @@sql_mode |
- +------------------------------------------------------------------------------------------------------------------------+
- | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
- +------------------------------------------------------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement