Confusion about gcd_creator joins
Will Carlough
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.
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>.