WordPress database error: [MySQL server has gone away]
SELECT usr.ID, usr.user_email, fnametab.meta_value AS fname, lnametab.meta_value as lname, cnt.post_count FROM wp_users usr JOIN wp_usermeta capa ON usr.ID = capa.user_id AND capa.meta_key LIKE '%capabilities' LEFT OUTER JOIN wp_usermeta fnametab ON usr.ID = fnametab.user_id AND fnametab.meta_key = 'first_name' LEFT OUTER JOIN wp_usermeta lnametab ON usr.ID = lnametab.user_id AND lnametab.meta_key = 'last_name' LEFT OUTER JOIN ( SELECT post_author, COUNT(1) post_count FROM wp_posts WHERE post_type='post' AND post_status='publish' GROUP BY post_author ) cnt ON usr.ID = cnt.post_author WHERE capa.meta_value LIKE '%author%' OR capa.meta_value LIKE '%contrib%' OR capa.meta_value LIKE '%admin%' ORDER BY post_count DESC