Creating a view for wp_usermeta to return data as one row
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `active_users_view` AS SELECT `u1`.`ID` AS `ID`, `u1`.`user_login` AS `user_login`, `u1`.`display_name` AS `display_name`, `m1`.`meta_value` AS `email_enable`, `m2`.`meta_value` AS `expired`, `m3`.`meta_value` AS `user_cron_job`, `m5`.`meta_value` AS `_save_notification` FROM (((((`wp_users` `u1` join `wp_usermeta` `m1` on(((`m1`.`user_id` = `u1`.`ID`) and (`m1`.`meta_key` = '_email_enable')))) join `wp_usermeta` `m2` on(((`m2`.`user_id` = `u1`.`ID`) and (`m2`.`meta_key` = 'expired')))) join `wp_usermeta` `m3` on(((`m3`.`user_id` = `u1`.`ID`) and (`m3`.`meta_key` = 'user_cron_job')))) join `wp_usermeta` `m4` on(((`m4`.`user_id` = `u1`.`ID`) and (`m4`.`meta_key` = 'wp_capabilities')))) join `wp_usermeta` `m5` on(((`m5`.`user_id` = `u1`.`ID`) and (`m5`.`meta_key` = '_save_notification')))) where ((`m4`.`meta_val...