gistfile1.txt

{ [SequelizeDatabaseError: ER_BAD_FIELD_ERROR: Unknown column 'TranslatedArticles.translationCount' in 'where clause']
  name: 'SequelizeDatabaseError',
  message: 'ER_BAD_FIELD_ERROR: Unknown column \'TranslatedArticles.translationCount\' in \'where clause\'',
  parent: 
   { [Error: ER_BAD_FIELD_ERROR: Unknown column 'TranslatedArticles.translationCount' in 'where clause']
     code: 'ER_BAD_FIELD_ERROR',
     errno: 1054,
     sqlState: '42S22',
     index: 0,
     sql: '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 AND ( SELECT `sourceArticleId` FROM `Articles` AS `TranslatedArticles` WHERE `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0) LIMIT 1 ) IS NOT NULL LIMIT 1) AS `Article` INNER JOIN `Articles` AS `TranslatedArticles` ON `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0);' },
  original: 
   { [Error: ER_BAD_FIELD_ERROR: Unknown column 'TranslatedArticles.translationCount' in 'where clause']
     code: 'ER_BAD_FIELD_ERROR',
     errno: 1054,
     sqlState: '42S22',
     index: 0,
     sql: '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 AND ( SELECT `sourceArticleId` FROM `Articles` AS `TranslatedArticles` WHERE `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0) LIMIT 1 ) IS NOT NULL LIMIT 1) AS `Article` INNER JOIN `Articles` AS `TranslatedArticles` ON `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0);' },
  sql: '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 AND ( SELECT `sourceArticleId` FROM `Articles` AS `TranslatedArticles` WHERE `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0) LIMIT 1 ) IS NOT NULL LIMIT 1) AS `Article` INNER JOIN `Articles` AS `TranslatedArticles` ON `Article`.`id` = `TranslatedArticles`.`sourceArticleId` AND (`TranslatedArticles`.`deletedAt` IS NULL AND `TranslatedArticles`.`translationCount` = 0);' }