SELECT y.name, y.category_id FROM (SELECT A.id
FROM categories AS A
WHERE NOT EXISTS
  (SELECT *
   FROM urls AS B
   WHERE B.object_id = A.id AND B.languages_id = 2)) x, category_translate AS y WHERE y.category_id = x.id AND y.language_id = 1