WordPress SQL queries I use a lot

wp-common-queries.sql

-- Life is better when you can cut and paste

-- Post meta

-------------
-- Site Options
-------------

select distinct option_name from wp_options;

-------------
-- User data
-------------

-- Get the user meta names.

select distinct meta_key from wp_usermeta;

-- Get user capabilities.  This will tell you if they are, say, 
-- an admin, a subscriber, or have some custom capability assigned.

select distinct meta_key, meta_value from wp_usermeta where meta_key like '%capabilities%';

select distinct meta_key, meta_value from wp_usermeta where meta_key like '%capabilities%' && meta_value like '%espresso%';