SELECT
  content.hashId, content.numViews, image.width, image.height
FROM
  content, image
WHERE
  content.id = image.contentid AND
  content.state = 'completed:success'
ORDER BY (image.width * image.height) DESC
LIMIT 10;

SELECT
  ("http://zoomhub.net/" || content.hashId) AS URL,
  content.numViews AS Views,
  ROUND(image.width * image.height / 1e6, 1) AS Megapixels
FROM
  content, image
WHERE
  content.id = image.contentid AND
  content.state = 'completed:success'
ORDER BY (image.width * image.height) DESC
LIMIT 10;

Make query for largest images more friendly
Make query for largest images more friendly
