SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
SELECT onleft,name,title FROM gl_blocks
DELETE FROM gl_sessions WHERE remote_ip = '3.137.164.241' AND uid = 1
INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1775902801, 1714011242, '3.137.164.241', 1)
DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714010942
SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 1
SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (2)
SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN (2)
SELECT pi_version FROM gl_plugins WHERE pi_name='forum'
SELECT name,owner_id,group_id,perm_group,perm_members,perm_anon FROM gl_blocks WHERE onleft = 1 AND is_enabled = 1 AND (tid = 'all' AND type <> 'layout') ORDER BY blockorder,title asc
SELECT * FROM gl_forum_settings
SELECT * FROM gl_mg_config
SELECT pi_version FROM gl_plugins WHERE pi_name = 'mediagallery'
SELECT format FROM gl_dateformats WHERE dfid = 0
SELECT * FROM gl_cp_config
SELECT value FROM gl_vars WHERE name='last_scheduled_run'
SELECT * FROM gl_prodirectory WHERE name='山本武範' OR name_en='山本武範' OR oldname LIKE '%山本武範%'
SELECT * FROM gl_prodirectory WHERE name='山本武範'
SELECT * FROM gl_mg_media m,gl_mg_albums a,gl_mg_media_albums ma WHERE m.media_id = ma.media_id AND ma.album_id = a.album_id AND a.album_title='山本武範' ORDER BY media_order limit 1
SELECT * FROM gl_ranking_data_now n LEFT JOIN gl_ranking r ON n.id=r.rankid WHERE proid='1759' ORDER BY r.ordernum
SELECT p.*,s.banner,s.name,s.url AS spurl FROM gl_prosponsor_player p, gl_prosponsor s WHERE p.spid=s.id AND p.display != 0 AND s.display != 0 AND p.proid='1759' AND category = 0 ORDER BY sort DESC
SELECT p.*,s.banner,s.name,s.url AS spurl FROM gl_prosponsor_player p, gl_prosponsor s WHERE p.spid=s.id AND p.display != 0 AND s.display != 0 AND p.proid='1759' AND category != 0 ORDER BY category
SELECT profile,profile_en,retired FROM gl_prodirectory WHERE name='山本武範'
SELECT * FROM gl_autotags_plg WHERE is_enabled = 1
SELECT name,oldname FROM gl_prodirectory WHERE name='山本武範'
SELECT * FROM gl_prodirectory WHERE name='山本武範' OR name_en='山本武範' OR oldname LIKE '%山本武範%'
SELECT TBL2.win AS win,winCountSum, loseCountSum, ( winCountSum / ( loseCountSum + winCountSum ) ) AS winRatio , IFNULL(hillwinCountSum,0),hillwinCountSum, IFNULL(hillloseCountSum,0),hillloseCountSum,( hillwinCountSum / ( hillloseCountSum + hillwinCountSum ) ) AS hillwinRatio FROM ( SELECT c_win AS win, SUM( winCount ) AS winCountSum, SUM( loseCount ) AS loseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS winCount, 0 AS loseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 GROUP BY c_win UNION ALL SELECT c_lose, 0 AS winCount, COUNT( c_lose ) AS loseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 GROUP BY c_lose )TBL GROUP BY c_win )TBL2 LEFT JOIN ( SELECT c_win AS win, SUM( hillwinCount ) AS hillwinCountSum, SUM( hillloseCount ) AS hillloseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS hillwinCount, 0 AS hillloseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_win UNION ALL SELECT c_lose, 0 AS hillwinCount, COUNT( c_lose ) AS hillloseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_lose )TBL4 GROUP BY c_win )TBL5 ON TBL2.win = TBL5.win ORDER BY winCountSum DESC , win
SELECT name,oldname FROM gl_prodirectory WHERE name='山本武範'
SELECT * FROM gl_prodirectory WHERE name='山本武範' OR name_en='山本武範' OR oldname LIKE '%山本武範%'
SELECT TBL2.win AS win,winCountSum, loseCountSum, ( winCountSum / ( loseCountSum + winCountSum ) ) AS winRatio , IFNULL(hillwinCountSum,0),hillwinCountSum, IFNULL(hillloseCountSum,0),hillloseCountSum,( hillwinCountSum / ( hillloseCountSum + hillwinCountSum ) ) AS hillwinRatio FROM ( SELECT c_win AS win, SUM( winCount ) AS winCountSum, SUM( loseCount ) AS loseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS winCount, 0 AS loseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 AND date_start BETWEEN date '2024-01-01' AND date '2024-12-31' GROUP BY c_win UNION ALL SELECT c_lose, 0 AS winCount, COUNT( c_lose ) AS loseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 AND date_start BETWEEN date '2024-01-01' AND date '2024-12-31' GROUP BY c_lose )TBL GROUP BY c_win )TBL2 LEFT JOIN ( SELECT c_win AS win, SUM( hillwinCount ) AS hillwinCountSum, SUM( hillloseCount ) AS hillloseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS hillwinCount, 0 AS hillloseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 AND date_start BETWEEN date '2024-01-01' AND date '2024-12-31' AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_win UNION ALL SELECT c_lose, 0 AS hillwinCount, COUNT( c_lose ) AS hillloseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 AND date_start BETWEEN date '2024-01-01' AND date '2024-12-31' AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_lose )TBL4 GROUP BY c_win )TBL5 ON TBL2.win = TBL5.win ORDER BY winCountSum DESC , win
SELECT name,oldname FROM gl_prodirectory WHERE name='山本武範'
SELECT * FROM gl_prodirectory WHERE name='山本武範' OR name_en='山本武範' OR oldname LIKE '%山本武範%'
SELECT TBL2.win AS win,winCountSum, loseCountSum, ( winCountSum / ( loseCountSum + winCountSum ) ) AS winRatio , IFNULL(hillwinCountSum,0),hillwinCountSum, IFNULL(hillloseCountSum,0),hillloseCountSum,( hillwinCountSum / ( hillloseCountSum + hillwinCountSum ) ) AS hillwinRatio FROM ( SELECT c_win AS win, SUM( winCount ) AS winCountSum, SUM( loseCount ) AS loseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS winCount, 0 AS loseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 AND date_start BETWEEN date '2023-01-01' AND date '2023-12-31' GROUP BY c_win UNION ALL SELECT c_lose, 0 AS winCount, COUNT( c_lose ) AS loseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 AND date_start BETWEEN date '2023-01-01' AND date '2023-12-31' GROUP BY c_lose )TBL GROUP BY c_win )TBL2 LEFT JOIN ( SELECT c_win AS win, SUM( hillwinCount ) AS hillwinCountSum, SUM( hillloseCount ) AS hillloseCountSum FROM ( SELECT c_win, COUNT( c_win ) AS hillwinCount, 0 AS hillloseCount FROM gl_result_score WHERE c_win = '山本武範' AND c_lose != 'BYE' AND c_lose != '' AND active=1 AND date_start BETWEEN date '2023-01-01' AND date '2023-12-31' AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_win UNION ALL SELECT c_lose, 0 AS hillwinCount, COUNT( c_lose ) AS hillloseCount FROM gl_result_score WHERE c_lose = '山本武範' AND c_win != 'BYE' AND active=1 AND date_start BETWEEN date '2023-01-01' AND date '2023-12-31' AND ((winner=1 AND score2 = score1 - 1) OR (winner=0 AND score1= score2 -1)) GROUP BY c_lose )TBL4 GROUP BY c_win )TBL5 ON TBL2.win = TBL5.win ORDER BY winCountSum DESC , win
SELECT c_lose AS oponent, COUNT( c_lose ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_win = '山本武範' AND c_lose != 'BYE' AND lose != '' AND active=1 GROUP BY c_lose ORDER BY Count DESC , max DESC LIMIT 1
SELECT * FROM gl_prodirectory WHERE name='広田大輔' OR name_en='広田大輔' OR oldname LIKE '%広田大輔%'
SELECT c_lose AS oponent, COUNT( c_lose ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_win = '山本武範' AND c_lose != 'BYE' AND lose != '' AND active=1 AND date_end BETWEEN date '2024-01-01' AND date '2024-12-31' GROUP BY c_lose ORDER BY Count DESC , max DESC LIMIT 1
SELECT c_lose AS oponent, COUNT( c_lose ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_win = '山本武範' AND c_lose != 'BYE' AND lose != '' AND active=1 AND date_end BETWEEN date '2023-01-01' AND date '2023-12-31' GROUP BY c_lose ORDER BY Count DESC , max DESC LIMIT 1
SELECT c_win AS oponent, COUNT( c_win ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_lose = '山本武範' AND c_win !='BYE' AND active=1 GROUP BY c_win ORDER BY Count DESC , max DESC LIMIT 1
SELECT * FROM gl_prodirectory WHERE name='飯間智也' OR name_en='飯間智也' OR oldname LIKE '%飯間智也%'
SELECT c_win AS oponent, COUNT( c_win ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_lose = '山本武範' AND c_win !='BYE' AND active=1 AND date_end BETWEEN date '2024-01-01' AND date '2024-12-31' GROUP BY c_win ORDER BY Count DESC , max DESC LIMIT 1
SELECT c_win AS oponent, COUNT( c_win ) AS Count, MAX( date_end ) max FROM `gl_result_score` s WHERE c_lose = '山本武範' AND c_win !='BYE' AND active=1 AND date_end BETWEEN date '2023-01-01' AND date '2023-12-31' GROUP BY c_win ORDER BY Count DESC , max DESC LIMIT 1
SELECT * FROM gl_prosponsor WHERE weight != 0
SELECT * FROM gl_prosponsor_player WHERE player='山本武範' AND spid!='' AND display=1
SELECT * FROM gl_prosponsor_ad WHERE spid='5' AND size='728' AND banner!=''
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('5','/en/prodirectory/ajax.php?name=%E5%B1%B1%E6%9C%AC%E6%AD%A6%E7%AF%84','5-728-5','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','5','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
SELECT year FROM gl_proranking ORDER BY year LIMIT 1
SELECT year FROM gl_proranking WHERE year='2024' LIMIT 1
SELECT * FROM gl_prodirectory WHERE name='山本武範' OR name_en='山本武範' OR oldname LIKE '%山本武範%'
SELECT turned,retired FROM gl_prodirectory WHERE (name = '山本武範' OR name = 'Takenori YAMAMOTO' )
SELECT * FROM gl_proranking WHERE (name = '山本武範' OR name = 'Takenori YAMAMOTO' ) ORDER BY year DESC
SELECT * FROM gl_proranking_desc WHERE year='2023' AND category='0'
SELECT name,name_en,oldname,proid FROM gl_prodirectory WHERE name_en!=''
SELECT * FROM gl_mg_media m,gl_mg_albums a,gl_mg_media_albums ma WHERE m.media_id = ma.media_id AND ma.album_id = a.album_id AND a.album_title='山本武範' ORDER BY media_order

Takenori YAMAMOTOIn Japanese

  • Name: Takenori YAMAMOTO
  • :
  • :
  • :
  • :
  • :
  • :
  • :
JAPAN

JPN

JPBA
RATING(2024-04-14)
  • -
    RATING
  • -
    RANK
  • 1,688

    2017-09-24

    MAX
The win-loss records
  • 11
    WIN
  • 10
    LOSE

Profile

Personal Records*based on the results of the final round
AllYears 2024 2023
Win 11 0 0
Lose 10 0 0
WinRatio 0.5238 - -
WinRatio on HillToHill 0.8000(4/5) -(0/0) -(0/0)
Oponent who was beated by most vs Daisuke HIROTA(1) no data() no data()
Oponent who beated most vs Tomoya IIMA(1) no data() no data()
JPBA rankings from for the past 10 years