https://bugs.documentfoundation.org/show_bug.cgi?id=138715
--- Comment #35 from Robert Großkopf <[email protected]> --- (In reply to Alex Thurgood from comment #34) > (In reply to Robert Großkopf from comment #33) > > In Thunderbird, my personal addressbook shows something like 857 entries. I > don't know why lists and list_cards would be empty, whereas properties isn't. I have only groups for persons in my addressbook. So query would show all results. Take this with LEFT JOIN: SELECT "a"."card", "a"."value" "DisplayName", ( SELECT "value" FROM "properties" WHERE "card" = "a"."card" AND "name" = 'PrimaryEmail' ) "PrimaryEmail", "lists"."name" "list" FROM "properties" AS "a" LEFT JOIN "list_cards" ON "list_cards"."card" = "a"."card" LEFT JOIN "lists" ON "lists"."uid" = "list_cards"."list" WHERE "a"."name" = 'DisplayName' -- You are receiving this mail because: You are the assignee for the bug.
