Skip to content

Instantly share code, notes, and snippets.

@tommedema

tommedema/gist:fa400097df063ddf5d75 Secret

Created July 24, 2015 01:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tommedema/fa400097df063ddf5d75 to your computer and use it in GitHub Desktop.
Save tommedema/fa400097df063ddf5d75 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT `Article`.*, `TranslatedArticles`.`id` AS `TranslatedArticles.id`, COUNT('sourceArticleId') AS `TranslatedArticles.translationCount` FROM (SELECT `Article`.`id`, `Article`.`PageId`, `Article`.`body`, `Article`.`bodyLength`, `Article`.`title`, `Article`.`titleLength`, `Article`.`lang`, `Article`.`langProbability`, `Article`.`type`, `Article`.`sourceArticleId`, `Article`.`createdAt`, `Article`.`updatedAt`, `Article`.`deletedAt` FROM `Articles` AS `Article` WHERE `Article`.`deletedAt` IS NULL LIMIT 1) AS `Article` LEFT OUTER JOIN `Articles` AS `TranslatedArticles` ON `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND `TranslatedArticles`.`deletedAt` IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment