SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
do
SELECT onleft,name,title FROM gl_blocks
do
DELETE FROM gl_sessions WHERE remote_ip = '3.138.118.250' AND uid = 1
do
INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (584524429, 1714011957, '3.138.118.250', 1)
DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011657
do
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)
do
SELECT pi_version FROM gl_plugins WHERE pi_name='forum'
do
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
do
SELECT * FROM gl_forum_settings
do
SELECT * FROM gl_mg_config
SELECT pi_version FROM gl_plugins WHERE pi_name = 'mediagallery'
do
SELECT format FROM gl_dateformats WHERE dfid = 0
do
SELECT * FROM gl_cp_config
SELECT value FROM gl_vars WHERE name='last_scheduled_run'
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子' OR name_en='元廣麗子' OR oldname LIKE '%元廣麗子%'
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子'
do
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
do
SELECT * FROM gl_ranking_data_now n LEFT JOIN gl_ranking r ON n.id=r.rankid WHERE proid='249' ORDER BY r.ordernum
do
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='249' AND category = 0 ORDER BY sort DESC
do
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('2','/en/prodirectory/ajax.php?name=%E5%85%83%E5%BB%A3%E9%BA%97%E5%AD%90','0','150','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
do
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('12','/en/prodirectory/ajax.php?name=%E5%85%83%E5%BB%A3%E9%BA%97%E5%AD%90','0','150','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
do
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='249' AND category != 0 ORDER BY category
do
SELECT profile,profile_en,retired FROM gl_prodirectory WHERE name='元廣麗子'
do
SELECT * FROM gl_autotags_plg WHERE is_enabled = 1
do
SELECT name,oldname FROM gl_prodirectory WHERE name='元廣麗子'
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子' OR name_en='元廣麗子' OR oldname LIKE '%元廣麗子%'
do
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
do
SELECT name,oldname FROM gl_prodirectory WHERE name='元廣麗子'
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子' OR name_en='元廣麗子' OR oldname LIKE '%元廣麗子%'
do
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
do
SELECT name,oldname FROM gl_prodirectory WHERE name='元廣麗子'
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子' OR name_en='元廣麗子' OR oldname LIKE '%元廣麗子%'
do
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
do
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
do
SELECT * FROM gl_prodirectory WHERE name='溝口清美' OR name_en='溝口清美' OR oldname LIKE '%溝口清美%'
do
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
do
SELECT * FROM gl_prodirectory WHERE name='石井利江' OR name_en='石井利江' OR oldname LIKE '%石井利江%'
do
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
do
SELECT * FROM gl_prodirectory WHERE name='宮本理香' OR name_en='宮本理香' OR oldname LIKE '%宮本理香%'
do
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
do
SELECT * FROM gl_prodirectory WHERE name='夕川景子' OR name_en='夕川景子' OR oldname LIKE '%夕川景子%'
do
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
do
SELECT * FROM gl_prodirectory WHERE name='新谷通子' OR name_en='新谷通子' OR oldname LIKE '%新谷通子%'
do
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
do
SELECT * FROM gl_prodirectory WHERE name='丸岡文子' OR name_en='丸岡文子' OR oldname LIKE '%丸岡文子%'
do
SELECT * FROM gl_prosponsor WHERE weight != 0
do
SELECT * FROM gl_prosponsor_player WHERE player='元廣麗子' AND spid!='' AND display=1
do
SELECT * FROM gl_prosponsor_ad WHERE spid='2' AND size='728' AND banner!=''
do
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('2','/en/prodirectory/ajax.php?name=%E5%85%83%E5%BB%A3%E9%BA%97%E5%AD%90','2-728-3','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','3','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
do
SELECT year FROM gl_proranking ORDER BY year LIMIT 1
do
SELECT year FROM gl_proranking WHERE year='2024' LIMIT 1
do
SELECT * FROM gl_prodirectory WHERE name='元廣麗子' OR name_en='元廣麗子' OR oldname LIKE '%元廣麗子%'
do
SELECT turned,retired FROM gl_prodirectory WHERE (name = '元廣麗子' OR name = 'Reiko MOTOHIRO' )
do
SELECT * FROM gl_proranking WHERE (name = '元廣麗子' OR name = 'Reiko MOTOHIRO' ) ORDER BY year DESC
do
SELECT * FROM gl_proranking_desc WHERE year='2023' AND category='1'
do
SELECT name,name_en,oldname,proid FROM gl_prodirectory WHERE name_en!=''
do
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
do

Reiko MOTOHIROIn Japanese

© Akira TAKATA

元廣麗子
JAPAN

JPN

JPBA
RATING(2024-04-14)
  • 1,488
    RATING
  • 87
    RANK
  • 1,553

    2023-05-27

    MAX
The win-loss records
  • 181
    WIN
  • 176
    LOSE
JPBA Rank
  • 20

    2024-03-31

    RANK
Sponsor

Profile

editing

Personal Records*based on the results of the final round
AllYears 2024 2023
Win 184 9 27
Lose 179 7 22
WinRatio 0.5069 0.5625 0.5510
WinRatio on HillToHill 0.5106(24/47) 0.0000(0/1) 0.6667(4/6)
Oponent who was beated by most vs Kiyomi MIZOGUCHI(7) vs Rie ISHII(1) vs Rika MIYAMOTO(3)
Oponent who beated most vs Keiko YUKAWA(16) vs Michiko SHINYA(1) vs Ayako MARUOKA(3)
JPBA rankings from for the past 10 years
元廣麗子