gistfile1.txt

SELECT n.nid, n.title, fc.count
FROM node n
  INNER JOIN flag_counts fc ON fc.content_id = n.nid
  ORDER BY fc.count DESC
  LIMIT 20;

691078  Field tokens	350
1499460	[meta] New theme system	221
494100	State of the multigroup module	218
1170192	Port Hierarchical Select Taxonomy Views (for exposed filters in Views) to Drupal 7	197
284392	db_rewrite_sql causing issues with DISTINCT	194
990204	The path to Marketplace functionality	187
1054326	Port Open Atrium to Drupal 7	185
1224666	[meta] Unofficial Drupal 8 Framework initiative	177
1171546	AdvAgg - Drupal 7 version	177
297035	HTTP error 0 	177
780712	Port twitter to Drupal 7	167
1276450	Views results empty for unprivileged user when using Relationship: Content: Referenced Product	159
119102	Combo field - group different fields into one	156
818638	Update to use Google maps API V3	155
1510532	[META] Implement the new create content page design	153
942782	Custom menus never receive an active trail	153
434394	'HTTP error 0 occurred' on image upload	151
1033202	[Meta] Generic entity processor	148
7881	Add support to drupal_http_request() for proxy servers	148
1253776	Add views support for providing a list of entities or bundles (views filtering, relationships, etc)	147