// query to select all article entries that are
// not in translation-system and are only english

SELECT `a`.*
  FROM se_articles AS `a`
  WHERE `a`.`article_id` NOT IN (
    SELECT `at`.`article_id`
      FROM `se_articles_translations` AS `at`
      WHERE `at`.`article_id` = `a`.`article_id`
  )
  AND `a`.`article_id` IN (
    SELECT `ats`.`tag_object_id`
      FROM `se_articletags` AS `ats`
      WHERE `ats`.`tag_name` = "english"
  )


// query to select all article entries that are
// not in translation-system and are only german

SELECT `a`.*
  FROM se_articles AS `a`
  WHERE `a`.`article_id` NOT IN (
    SELECT `at`.`article_id`
      FROM `se_articles_translations` AS `at`
      WHERE `at`.`article_id` = `a`.`article_id`
  )
  AND `a`.`article_id` IN (
    SELECT `ats`.`tag_object_id`
      FROM `se_articletags` AS `ats`
      WHERE `ats`.`tag_name` = "english"
      OR `ats`.`tag_name` = "deutsch"
  )