SELECT co.table_name,tb.table_rows FROM information_schema.columns co
LEFT JOIN information_schema.tables tb ON tb.table_name = co.table_name
WHERE co.column_name='openid' and tb.table_rows >0 ORDER BY tb.table_rows DESC
SELECT co.table_name,tb.table_rows FROM information_schema.columns co
LEFT JOIN information_schema.tables tb ON tb.table_name = co.table_name
WHERE co.column_name='openid' and tb.table_rows >0 ORDER BY tb.table_rows DESC