https://bugs.documentfoundation.org/show_bug.cgi?id=138715
--- Comment #33 from Robert Großkopf <[email protected]> --- (In reply to Alex Thurgood from comment #32) There a 2 different addressbooks in Thunderbird, which will show the content most people needed: abook.sqlite → will show the current created data of addressbook. All other of this called abook.v2.sqlite, abook.v3.sqlite should be old data backups and not current created books. history.sqlite → will show all addresses available in Thunderbird, not added to your personal addressbook. The following code will help for a query, which could be used to work with addresses in abook.sqlite. It will only show "name", "mail" and "group": SELECT "a"."card", "a"."value" "DisplayName", ( SELECT "value" FROM "properties" WHERE "card" = "a"."card" AND "name" = 'PrimaryEmail' ) "PrimaryEmail", "lists"."name" "list" FROM "list_cards", "properties" AS "a", "lists" WHERE "list_cards"."card" = "a"."card" AND "lists"."uid" = "list_cards"."list" AND "a"."name" = 'DisplayName' -- You are receiving this mail because: You are the assignee for the bug.
