some gcd_issue.brand_id missing from sqlite exports

[Mike O'Regan]

There appears to be data missing from the biweekly sqlite exports.

Every issue in this series has a brand_id: https://www.comics.org/series/3406/details/?sort=issue

However, in the sqlite dumps from 2026-01-15, 2026-01-01, and 2025-12-01, two of the issues have NULL for brand_id:

sqlite> select number, variant_name, no_brand, brand_id from gcd_issue where series_id = 3406 order by sort_code;
number  variant_name    no_brand  brand_id
------  --------------  --------  --------
1       Direct          0         2654
1       Newsstand       0
2                       0         2654
2       Third Printing  0         2654
3       Direct          0         2654
3       Newsstand       0
4       Direct          0         2654
4       Newsstand       0         2654

(Perhaps a red herring, but brand_id in those two issues was set to 2654 via bulk edit on 2025-11-18: https://www.comics.org/changeset/7959637/compare/?collapse=1 )

Mike

[Jochen G.]

Since brand_emblems are now m2m, the dump script needed to be updated
with the intermediate table.

Fresh dump is available.

The brand_id will be removed, likely in the next db maintenance.

Am 15.01.26 um 09:57 schrieb Mike O'Regan:

> --
> You received this message because you are subscribed to the Google
> Groups "gcd-tech" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to gcd-tech+u...@googlegroups.com <mailto:gcd-
> tech+uns...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/gcd-
> tech/2a376779-fe92-41d7-b699-077e36754f21n%40googlegroups.com <https://
> groups.google.com/d/msgid/gcd-tech/2a376779-fe92-41d7-
> b699-077e36754f21n%40googlegroups.com?utm_medium=email&utm_source=footer>.