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.144.96.159' AND uid = 1
INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1894872779, 1714011403, '3.144.96.159', 1)
DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011103
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='18' 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='18' AND category = 0 ORDER BY sort DESC
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('24','/en/prodirectory/ajax.php?name=%E7%BE%85%E7%AB%8B%E6%96%87&eng=1','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)')
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='18' 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 * 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 '2023-01-01' AND date '2023-12-31' 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_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 * 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 '2023-01-01' AND date '2023-12-31' 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 * 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='24' AND size='728' AND banner!=''
INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) VALUES('24','/en/prodirectory/ajax.php?name=%E7%BE%85%E7%AB%8B%E6%96%87&eng=1','0','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','0','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 = 'Lo Li-Wen' OR name = 'Lo Li Wen' )
SELECT * FROM gl_proranking WHERE (name = '羅立文' OR name = 'Lo Li-Wen' OR name = 'Lo Li Wen' ) 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

Lo Li-WenIn Japanese

© Akira TAKATA

羅立文
  • Name: Lo Li-Wen
  • Nickname: ROLEX
  • Date of Birth: 10.07.1978(45 years old)
  • Turned pro: 2009
  • Birthplace: Taiwan
  • Bloodtype: B
  • Website: lo-liwen.com/
  • Plays: Right-handed
TAIWAN, PROVINCE OF CHINA

TWN

JPBA
RATING(2024-04-14)
  • 2,089
    RATING
  • 4
    RANK
  • 2,126

    2022-08-21

    MAX
The win-loss records
  • 723
    WIN
  • 199
    LOSE

JPBA Rank
  • 2

    2024-03-31

    RANK
JPBA-EAST
  • 3

    2021-11-30

    RANK
GPE Rank
  • 2

    2019-12-12

    RANK
WPA Rank
  • 367

    2023-11-11

    RANK
Sponsor

Profile

2010 & 2023 JPBA Ranking No.1 player.
editing

Personal Records*based on the results of the final round
AllYears 2024 2023
Win 768 19 61
Lose 207 2 13
WinRatio 0.7877 0.9048 0.8243
WinRatio on HillToHill 0.5780(63/109) 0.5000(1/2) 0.7143(5/7)
Oponent who was beated by most vs Kiyoshi SUZUKI(19) vs Kouki SUGIYAMA(2) vs Katsuji TERUYA(3)
Oponent who beated most vs Hayato HIJIKATA(17) vs Keisuke HANAWA(1) vs Hayato HIJIKATA(3)
JPBA rankings from for the past 10 years