From Sega Retro
|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.
The join/group by is incorrect, which is why the dates are wrong.
|Virtua Striker||1995-05||Sega AM2||PlayStation 3||MOD2||Developer||Yes|
|Virtua Fighter 5||2005-11-26||Sega AM2||PlayStation 3||LINDBERGH||Developer||Yes|
|Hatsune Miku: Project DIVA Dreamy Theater||2010-06-24||Sega AM2||PlayStation 3||PS3||Developer||Yes|
|Virtua Fighter 5: Final Showdown||2010-07-29||Sega AM2||PlayStation 3||LINDBERGH||Developer||Yes|
|Virtua Tennis 4||2011||Sega AM2||PlayStation 3||RE||Developer||Yes|
|Hatsune Miku: Project DIVA Dreamy Theater 2nd||2011-08-04||Sega AM2||PlayStation 3||PS3||Developer||Yes|
|Hatsune Miku: Project DIVA Dreamy Theater extend||2012-09-13||Sega AM2||PlayStation 3||PS3||Developer||Yes|
|Dead or Alive 5||2012-09-27||Sega AM2||PlayStation 3||360||Developer||Yes|
|Hatsune Miku: Project DIVA F||2013-03-07||Sega AM2||PlayStation 3||PS3||Developer||Yes|
|Dead or Alive 5+ & Dead or Alive 5||2013-03-20||Sega AM2||PlayStation 3||PS3||Developer||Yes|
|Dead or Alive 5 Ultimate||2013-12-24||Sega AM2||PlayStation 3||RE2||Developer||Yes|
|Dead or Alive 5 Last Round||2015-02-17||Sega AM2||PlayStation 3||RE2||Developer||Yes|
This could be solved if I could join "PS3" onto "PlayStation 3". I don't know how to do that without making another table (to replicate template:Code2Format). Is there another way?
- So the problem is that "companies" uses the full console names and "releases" uses codes? I don't really understand the cargo syntax you've used here, so all I can suggest is creating an additional template that fetches the date, instead of trying to get the date in CompanyHistory. The template would be called from Template:CompanyHistory/Cargo and would need to contain a reverse Template:Code2Format. - Hivebrain (talk) 15:02, 5 January 2020 (EST)
- Alright no worries - I thought there might have been a shortcut.
- I've cheated and made Special:CargoTables/codeformat, which means we can join the tables in a better way. I think the results are correct now - missing games are hopefully the fault of individual pages. -Black Squirrel (talk) 16:07, 5 January 2020 (EST)