Skip to content

Instantly share code, notes, and snippets.

@tommedema

tommedema/test.sql Secret

Created July 24, 2015 01:52
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/5f5ad310a3f31b1dccaa to your computer and use it in GitHub Desktop.
Save tommedema/5f5ad310a3f31b1dccaa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
test.sql
SELECT `Article`.*, `TranslatedArticles`.`id` AS `TranslatedArticles.id`, `TranslatedArticles`.`PageId` AS `TranslatedArticles.PageId`, `TranslatedArticles`.`body` AS `TranslatedArticles.body`, `TranslatedArticles`.`bodyLength` AS `TranslatedArticles.bodyLength`, `TranslatedArticles`.`title` AS `TranslatedArticles.title`, `TranslatedArticles`.`titleLength` AS `TranslatedArticles.titleLength`, `TranslatedArticles`.`lang` AS `TranslatedArticles.lang`, `TranslatedArticles`.`langProbability` AS `TranslatedArticles.langProbability`, `TranslatedArticles`.`type` AS `TranslatedArticles.type`, `TranslatedArticles`.`sourceArticleId` AS `TranslatedArticles.sourceArticleId`, `TranslatedArticles`.`createdAt` AS `TranslatedArticles.createdAt`, `TranslatedArticles`.`updatedAt` AS `TranslatedArticles.updatedAt`, `TranslatedArticles`.`deletedAt` AS `TranslatedArticles.deletedAt` 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 AND translatedArticles.sourceArticleId 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