Confusion about gcd_creator joins

7 views
Skip to first unread message

Will Carlough

unread,
Sep 21, 2022, 12:01:28 PMSep 21
to gcd-tech
Hi, I'm new to the gcd, and I'm confused about how joins to the creator table work. Take for example this story: https://www.comics.org/issue/2302812/#3376348

First I select the story from the story_id, looks good:

mysql> select * from gcd_story where id = 3376348;

+---------+-----------------------+----------------+---------+-----------------+------------+----------+--------+---------+------+--------+---------+---------+-----------+------------+----------+---------------+---------------------+---------------------+-------+-----------+------------+---------+-----------+------------+------------+----------------------+---------+------------+---------+------------+

| id      | title                 | title_inferred | feature | sequence_number | page_count | issue_id | script | pencils | inks | colors | letters | editing | genre     | characters | synopsis | reprint_notes | created             | modified            | notes | no_script | no_pencils | no_inks | no_colors | no_letters | no_editing | page_count_uncertain | type_id | job_number | deleted | first_line |

+---------+-----------------------+----------------+---------+-----------------+------------+----------+--------+---------+------+--------+---------+---------+-----------+------------+----------+---------------+---------------------+---------------------+-------+-----------+------------+---------+-----------+------------+------------+----------------------+---------+------------+---------+------------+

| 3376348 | Beyond Chapter Twelve |              0 |         |               1 |     20.000 |  2302812 |        |         |      |        |         |         | superhero | Hellbomb   |          |               | 2022-01-23 22:27:35 | 2022-05-25 02:02:45 |       |         0 |          0 |       0 |         0 |          0 |          1 |                    0 |      19 |            |       0 | So...      |

+---------+-----------------------+----------------+---------+-----------------+------------+----------+--------+---------+------+--------+---------+---------+-----------+------------+----------+---------------+---------------------+---------------------+-------+-----------+------------+---------+-----------+------------+------------+----------------------+---------+------------+---------+------------+

Then I look at the gcd_story_credit table to get the creator_ids:

mysql> select * from gcd_story_credit where story_id = 3376348;

+---------+----------------------------+----------------------------+---------+-------------+-----------+-----------+-----------+-------------+-------------+------------+----------------+----------+--------------+------------+------------+

| id      | created                    | modified                   | deleted | is_credited | is_signed | uncertain | signed_as | credited_as | credit_name | creator_id | credit_type_id | story_id | signature_id | is_sourced | sourced_by |

+---------+----------------------------+----------------------------+---------+-------------+-----------+-----------+-----------+-------------+-------------+------------+----------------+----------+--------------+------------+------------+

| 3292270 | 2022-01-23 22:27:35.061829 | 2022-05-25 02:02:45.208080 |       0 |           1 |         0 |         0 |           |             |             |      42410 |              1 |  3376348 |         NULL |          0 |            |

| 3292272 | 2022-01-23 22:27:35.083057 | 2022-05-25 02:02:45.224162 |       0 |           1 |         0 |         0 |           |             |             |      60966 |              2 |  3376348 |         NULL |          0 |            |

| 3292274 | 2022-01-23 22:27:35.103611 | 2022-05-25 02:02:45.240394 |       0 |           1 |         0 |         0 |           |             |             |      60966 |              3 |  3376348 |         NULL |          0 |            |

| 3292276 | 2022-01-23 22:27:35.123899 | 2022-05-25 02:02:45.256465 |       0 |           1 |         0 |         0 |           |             |             |      18171 |              4 |  3376348 |         NULL |          0 |            |

| 3292277 | 2022-01-23 22:27:35.133899 | 2022-05-25 02:02:45.264296 |       0 |           1 |         0 |         0 |           |             |             |      42038 |              5 |  3376348 |         NULL |          0 |            |

+---------+----------------------------+----------------------------+---------+-------------+-----------+-----------+-----------+-------------+-------------+------------+----------------+----------+--------------+------------+------------+

Then I go to the gcd_creator table with those creator_ids: 

mysql> select * from gcd_creator where id in (42410, 60966, 18171, 42038);

+-------+-------------------+----------+-------------------------+----------------+--------------------------+------------+----------------------+-------------------------+----------------+--------------------------+------------+----------------------+-----+-------+---------------------+---------------------+---------+------------------+---------------+------------------+---------------+------------------+----------------+

| id    | gcd_official_name | whos_who | birth_country_uncertain | birth_province | birth_province_uncertain | birth_city | birth_city_uncertain | death_country_uncertain | death_province | death_province_uncertain | death_city | death_city_uncertain | bio | notes | created             | modified            | deleted | birth_country_id | birth_date_id | death_country_id | death_date_id | sort_name        | disambiguation |

+-------+-------------------+----------+-------------------------+----------------+--------------------------+------------+----------------------+-------------------------+----------------+--------------------------+------------+----------------------+-----+-------+---------------------+---------------------+---------+------------------+---------------+------------------+---------------+------------------+----------------+

| 18171 | Lejon De Borger   |          |                       0 |                |                        0 | Heffen     |                    0 |                       0 |                |                        0 |            |                    0 |     |       | 2018-03-24 22:10:01 | 2020-12-13 01:13:20 |       0 |               20 |        309651 |             NULL |        309652 | De Borger, Lejon |                |

| 42038 | Brent Wood        |          |                       0 |                |                        0 |            |                    0 |                       0 |                |                        0 |            |                    0 |     |       | 2020-12-16 14:08:59 | 2020-12-16 14:08:59 |       0 |              225 |        310632 |             NULL |        310633 | Wood, Brent      |                |

| 42410 | Cindy Chapman     |          |                       0 |                |                        0 |            |                    0 |                       0 |                |                        0 |            |                    0 |     |       | 2020-12-22 09:04:09 | 2020-12-22 09:04:09 |       0 |             NULL |        312701 |             NULL |        312702 | Chapman, Cindy   |                |

+-------+-------------------+----------+-------------------------+----------------+--------------------------+------------+----------------------+-------------------------+----------------+--------------------------+------------+----------------------+-----+-------+---------------------+---------------------+---------+------------------+---------------+------------------+---------------+------------------+----------------+

Which gives me Lejon De Borger, Brent Wood, and Cindy Chapman, who are not the artists on the page. I've seen other stories where the credits behave like I expect them to, so what am I doing wrong on this one? Thank you for any help, sorry if the formatting of this is bad. 

Jochen G.

unread,
Sep 21, 2022, 3:58:49 PMSep 21
to gcd-...@googlegroups.com
The stories point the creator_name_ids, not creator_ids.

The creator_names than point to creators.

This is to record the specific name used in a story for the creator.

Jochen

Am 21.09.22 um 18:01 schrieb Will Carlough:
> --
> 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+u...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/gcd-tech/7c0f2412-7102-403d-bec8-161b2bd17844n%40googlegroups.com
> <https://groups.google.com/d/msgid/gcd-tech/7c0f2412-7102-403d-bec8-161b2bd17844n%40googlegroups.com?utm_medium=email&utm_source=footer>.

Will Carlough

unread,
Sep 21, 2022, 4:40:46 PMSep 21
to gcd-tech
I see, that makes sense. Thank you!
Reply all
Reply to author
Forward
0 new messages