Sumo Reference Updates

[Anjoboshi 2]

Not sure if I am doing something wrong or an error:

When I do a Banzuke Query with 1 Basho, Juryo checkbox activated and 0 wins && 15 losses, Oki's result from last basho (Aki 2020) doesn't show up.

 

[Jakusotsu 5,893]

8 minutes ago, Anjoboshi said:

When I do a Banzuke Query with 1 Basho, Juryo checkbox activated and 0 wins && 15 losses, Oki's result from last basho (Aki 2020) doesn't show up.

Oki appears when you scratch the 0 wins, although it doesn't make sense at all.

[WAKATAKE 2,648]

Hozan's November 2020 record seems to be glitched. The vertical entries to show all seven bouts and results but the horizontal hoshitori only shows him as 3-3 with no day 14 or day 15 results (last match was on day 14)

http://sumodb.sumogames.de/Rikishi_basho.aspx?r=12611&b=202011

[Gurowake 4,031]

50 minutes ago, Anjoboshi said:

Not sure if I am doing something wrong or an error:

When I do a Banzuke Query with 1 Basho, Juryo checkbox activated and 0 wins && 15 losses, Oki's result from last basho (Aki 2020) doesn't show up.

 

It's a very common error that searching for 0 of something happening just doesn't work right.

[Jakusotsu 5,893]

1 hour ago, Gurowake said:

It's a very common error that searching for 0 of something happening just doesn't work right.

Generally true, but not in that case.

[Asashosakari 19,104]

2 hours ago, Jakusotsu said:

Oki appears when you scratch the 0 wins, although it doesn't make sense at all.

It's the long-standing problem where no record with 0 wins or 0 losses in a recent tournament can be queried for (presumably the fields are null/empty, not 0), until Doitsuyama fixes those results manually.

[Asashosakari 19,104]

Both Takakeisho and Terunofuji are currently marked as D = yusho-doten, with only Terunofuji properly given a jun-yusho designation in his profile while Takakeisho's is blank altogether (neither yusho nor jun-yusho), which has led to this confusing display on the yusho page:

Edit: And the Day 15 results currently have the makuuchi session break in a very strange position, after the first match.

Edited November 23, 2020 by Asashosakari

[Atenzan 1,074]

1 hour ago, Asashosakari said:

Both Takakeisho and Terunofuji are currently marked as D = yusho-doten, with only Terunofuji properly given a jun-yusho designation in his profile while Takakeisho's is blank altogether (neither yusho nor jun-yusho), which has led to this confusing display on the yusho page:

Possibly related: Takakeishou's rikishi information page says that he's got 3 makuuchi yusho, 2 at ozeki. 

Edited November 23, 2020 by Atenzan

[yorikiried by fate 2,010]

I have come across Kotozakura's intai basho in VII.74. He is still listed, but didn't compete. In other such cases the result seems to be given as 0-0-0, but he gets only 0-0.

For my research this doesn't matter much, EXCEPT that Kotozakura's result doesn't seem to be searchable by query. So if I look for Makuuchi guys that had 0 wins and 0 losses in the timeframe of interest, he won't turn up. The same is true, if I only search for 0 wins.

This looks like a glitch. I would like to know if there are other such cases, that I cannot find by query.

Help?

[Asashosakari 19,104]

I don't think I've ever seen a pre-basho intai listed as 0-0-0...

Anyway, it doesn't seem to be consistently handled. The banzuke pages and the rikishi profiles will show "0-0" by default, but that can be either actual zeros or simply empty fields (see above discussion). As far as I can tell, the great majority of pre-basho retirements are listed with empty records, not zeros. You can see those e.g. here atop the blocks of Bg 0-0 entries for every basho (for example Yoshimura for 2004.09, Nakabuchi 2004.11, Kotoryu 2005.05, etc)*. If you scroll back through the same query, you can spot some others mingling among actual zero-win records, for instance Kizakiumi here in 2020.09.

IMHO, empty fields is the correct way to handle that, since these rikishi were literally no longer on active status for those respective tournaments and just had a banzuke ranking for clerical reasons.

* Before somebody pulls me up on it, yes, I do realize why two of those three are listed that way, and that "retirement" is a bit of an unfortunate choice of words.

Edited November 29, 2020 by Asashosakari

[yorikiried by fate 2,010]

1. I mistyped. I meant 0-0-15.

2. I apologize for not seeing the comments right above.

3. I see that automation/query will send me nowhere in this case.

Thanks.

[rzombie1988 157]

I'd really love to see a link on each page to the wrestler's stable.

[Jakusotsu 5,893]

5 hours ago, rzombie1988 said:

I'd really love to see a link on each page to the wrestler's stable.

And where exactly do you think it should link to?

[rzombie1988 157]

6 hours ago, Jakusotsu said:

And where exactly do you think it should link to?

When you see the wrestler's stable, you should be able to click it and it should take you to the stable page, as I said.

Edited November 30, 2020 by rzombie1988

[Akinomaki 40,223]

30 minutes ago, rzombie1988 said:

When you see the wrestler's stable, you should be able to click it and it should take you to the stable page, as I said.

of which internet site?

[ryafuji 811]

2 hours ago, rzombie1988 said:

When you see the wrestler's stable, you should be able to click it and it should take you to the stable page, as I said.

There is no stable page. There's only kabu, which is linked (if applicable).

[rzombie1988 157]

13 minutes ago, ryafuji said:

There is no stable page. There's only kabu, which is linked (if applicable).

The website already knows which stable each wrestlers is in as their stable is listed.

All I'm asking for is that a page is created for each stable so we can see where each person belongs and who else is in their stable.

If you take some of the replies here at face value, you would think I am talking Chinese and that nobody here has any idea what I'm talking about. If you start considering the events of the last week on this sub involving 2 other users in this thread, it seems like there's a little more to it.

Edited November 30, 2020 by rzombie1988

[themistyseas 239]

1 hour ago, ryafuji said:

There is no stable page. There's only kabu, which is linked (if applicable).

In light of the tr****ng happening on other threads I really don't want to endorse the idea, BUT

For those of us who run a lot of queries just looking for who's in a particular stable, as well as someone with a strong interest in kabu, it might be a cool idea to have the wrestler's heya link to one of three things. I've often wished I could click this as a shortcut to other types of information I frequently search. Using Hakuho as an example:

1) "Miyagino" on Hakuho's page links to a query of all Miyagino rikishi all time
2) "Miyagino" on Hakuho's page links to a query of Miyagino rikishi results during the period of Hakuho's active status (thereby eliminating confusion from - for example - unconnected historic heya which used the same name)
3) "Miyagino" on Hakuho's page links to the Miyagino kabu history

Any of these would be super awesome for the user experience, although I appreciate it would be a bit of work

3 hours ago, Akinomaki said:

of which internet site?

:D

[Asojima 2,873]

13 minutes ago, themistyseas said:

Using Hakuho as an example:

1) "Miyagino" on Hakuho's page links to a query of all Miyagino rikishi all time
2) "Miyagino" on Hakuho's page links to a query of Miyagino rikishi results during the period of Hakuho's active status (thereby eliminating confusion from - for example - unconnected historic heya which used the same name)
3) "Miyagino" on Hakuho's page links to the Miyagino kabu history

If anything is going to be done, I suggest clicking on "Miyagino" on Hakuho's page links to a list of all currently active Miyagino rikishi. Keep it simple.  The others are a variety of specialty searches which are available by other means. Even the one I suggest is easily available on other query forms.  No real need for these unless Doits happens to find time to be bored.

[Kotomaru 32]

Oyama is still listed at Azumazeki on the Kabu list, rather than Hakkaku. It's been a while now, so thought I'd mention it, lest he gets overlooked next update.

Edited November 30, 2020 by Kotomaru

[Jejima 1,363]

There seems to be a glitch with Sumo reference here -->  http://sumodb.sumogames.de/Rikishi.aspx?r=8900

For his day 12 loss to Chiyootori, Akiseyama has a dash (same as for when a Makushita rikishi does not fight that day) instead of a kuroiboshi (black circle).

Chiyootori also has the dash instead of a white circle shiroiboshi here -->  http://sumodb.sumogames.de/Rikishi.aspx?r=6928

 

[themistyseas 239]

15 hours ago, Asojima said:

If anything is going to be done, I suggest clicking on "Miyagino" on Hakuho's page links to a list of all currently active Miyagino rikishi. Keep it simple.  The others are a variety of specialty searches which are available by other means. Even the one I suggest is easily available on other query forms.  No real need for these unless Doits happens to find time to be bored.

A better and potentially less complicated solution than anything I offered, and just as useful. I'd use this! Thank you. I was trying to add some meat to the other character's idea. But I appreciate given the other things that can be done to enhance the DB, it is a long shot. Certainly it would be useful to have a really good overview of "who's in the heya" - not just the rikishi either. Much of that of that information is there, but separately. I know some other sites cover this, but given how all-encompassing the DB is, it would be useful to beef that up as well.

[Seiyashi 4,072]

1 hour ago, themistyseas said:

I know some other sites cover this, but given how all-encompassing the DB is, it would be useful to beef that up as well.

I don't mean to diss the db - it is indeed a indispensable resource for the online sumo community. But sometimes, it can be supremely infuriating to attempt - and fail - to get information out of it. It is a wonderful repository, which is what it was designed for, but it's a bit lacking when it comes to assisting in drawing conclusions. 

Edited December 1, 2020 by Seiyashi

[sahaven111 174]

I noticed that there is a lack of pictures in some rikishi's info in even in the top division like tobizaru, and there is an old banzuke with a british rikishi and if you highlight foreigners he does not get a color. so you should fix that and bring back pictures.

[Randomitsuki 2,813]

35 minutes ago, sahaven111 said:

I noticed that there is a lack of pictures in some rikishi's info in even in the top division like tobizaru, and there is an old banzuke with a british rikishi and if you highlight foreigners he does not get a color. so you should fix that and bring back pictures.

The SumoDB is not a commercial site. Nobody pays for this valuable information, and it is maintained for many years by a devoted sumo fan at zero personal benefit. Against this background, I find it somewhat irritating if people demand that this person should do this or that.

As for the photos: these were all personally taken by another incredibly dedicated sumo fan who unfortunately doesn‘t provide this service any longer. And unless Doitsuyama doesn‘t want to run into copyright issues by using photos from existing Websites, no easy solution is at hand.