Projekt Adressbücher/Technik

aus GenWiki, dem genealogischen Lexikon zum Mitmachen.
Zur Navigation springen Zur Suche springen
Info
Diese Seite enthält technische Details, die für die Pflege der Datenbank benötigt werden.
SELECT concat('UPDATE entry SET prefix=\'',extensions_elt,'-\' WHERE id=',extensions,'; DELETE FROM entry_extensions WHERE extensions_idx = 46 AND extensions=',extensions,';') FROM entry_extensions WHERE extensions_idx = 46 ;
SELECT concat('UPDATE entry SET page=\'',extensions_elt,'-\' WHERE page IS NULL AND id=',extensions,'; DELETE FROM entry_extensions WHERE extensions_idx = 80 AND extensions=',extensions,';') FROM entry_extensions WHERE extensions_idx = 80 ;
SELECT extensions_idx, translation_elt, count(*) from extension_type_translation JOIN entry_extensions ON extensions_idx=translation WHERE translation_idx='de' GROUP BY extensions_idx ORDER BY translation_elt;