ProductionHistory

From Sega Retro

I've got this sorting by the release date, however it's not sorting by the earliest release date of a game - it's the first added to the releases template.

So basically if you define

  • JP: 2005
  • US: 2004

It will take the first result (2005) and use that to help define an order. My SQL skills are not good enough to get this to sort a table before joining. -Black Squirrel (talk) 15:42, 27 August 2018 (CDT)


It seems that some data stored in the cargo table is not displayed. Why? --Akiyama Akane (talk) 21:52, 29 September 2018 (CDT)

For example,

Bugs

Clock.svg
This task is unfinished
This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed.

Some Sonic games are being added twice (e.g. Yuji Naka), except the second (or first?) time there isn't a format specified

https://segaretro.org/index.php?title=Special%3ACargoQuery&tables=credits&fields=_pageName%3DPage%2Crole%3Drole%2Cname%3Dname%2Cgame%3Dgame%2Cconsole%3Dconsole%2Cdate%3Ddate%2Cpdf%3Dpdf%2Cpdfpage%3Dpdfpage&where=game%3D%22Sonic+%26+Knuckles%22&join_on=&group_by=&having=&order_by%5B0%5D=&order_by_options%5B0%5D=ASC&limit=500&offset=0&format=

I'm going to guess it's a caching thing. I'd rather not rebuild the table so let's see if this is an issue next time I see this page -Black Squirrel (talk) 14:57, 27 April 2022 (EDT)