SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1<br>do<br>SELECT onleft,name,title FROM gl_blocks<br>do<br>DELETE FROM gl_sessions WHERE remote_ip = '3.144.9.141' AND uid = 1<br>do<br>INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1960660792, 1714012060, '3.144.9.141', 1)<br>DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011760<br>do<br>SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 1<br>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)<br>SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN (2)<br>do<br>SELECT pi_version FROM gl_plugins WHERE pi_name='forum'<br>do<br>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<br>do<br>SELECT * FROM gl_forum_settings<br>do<br>SELECT * FROM gl_mg_config<br>SELECT pi_version FROM gl_plugins WHERE pi_name = 'mediagallery'<br>do<br>SELECT format FROM gl_dateformats WHERE dfid = 0<br>do<br>SELECT * FROM gl_cp_config<br>SELECT value FROM gl_vars WHERE name='last_scheduled_run'<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦' OR name_en='趙豊邦' OR oldname LIKE '%趙豊邦%'<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦'<br>do<br>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<br>do<br>SELECT * FROM gl_ranking_data_now n LEFT JOIN gl_ranking r ON n.id=r.rankid WHERE proid='155' ORDER BY r.ordernum<br>do<br>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='155' AND category = 0 ORDER BY sort DESC<br>do<br>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='155' AND category != 0 ORDER BY category<br>do<br>SELECT profile,profile_en,retired FROM gl_prodirectory WHERE name='趙豊邦'<br>do<br>SELECT * FROM gl_autotags_plg WHERE is_enabled = 1<br>do<br>SELECT name,oldname FROM gl_prodirectory WHERE name='趙豊邦'<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦' OR name_en='趙豊邦' OR oldname LIKE '%趙豊邦%'<br>do<br>
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
<br>do<br>SELECT name,oldname FROM gl_prodirectory WHERE name='趙豊邦'<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦' OR name_en='趙豊邦' OR oldname LIKE '%趙豊邦%'<br>do<br>
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
<br>do<br>SELECT name,oldname FROM gl_prodirectory WHERE name='趙豊邦'<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦' OR name_en='趙豊邦' OR oldname LIKE '%趙豊邦%'<br>do<br>
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
<br>do<br>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<br>do<br>SELECT * FROM gl_prodirectory WHERE name='ラミル・ガレゴ' OR name_en='ラミル・ガレゴ' OR oldname LIKE '%ラミル・ガレゴ%'<br>do<br>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<br>do<br>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<br>do<br>SELECT * FROM gl_prodirectory WHERE name='斎藤慎太郎' OR name_en='斎藤慎太郎' OR oldname LIKE '%斎藤慎太郎%'<br>do<br>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<br>do<br>SELECT * FROM gl_prodirectory WHERE name='奥村健' OR name_en='奥村健' OR oldname LIKE '%奥村健%'<br>do<br>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<br>do<br>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<br>do<br>SELECT * FROM gl_prodirectory WHERE name='ウォン・ホジュン' OR name_en='ウォン・ホジュン' OR oldname LIKE '%ウォン・ホジュン%'<br>do<br>
		SELECT * 
			FROM gl_prosponsor
			WHERE  weight !=  0
		<br>do<br>SELECT * FROM gl_prosponsor_player WHERE player='趙豊邦' AND spid!='' AND display=1<br>do<br>SELECT * FROM gl_prosponsor_ad WHERE spid='7' AND size='728' AND banner!=''<br>do<br>INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) 
	VALUES('7','/en/prodirectory/ajax.php?name=%E8%B6%99%E8%B1%8A%E9%82%A6&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)')
	<br>do<br>SELECT year FROM gl_proranking ORDER BY year LIMIT 1<br>do<br>SELECT year FROM gl_proranking WHERE year='2024' LIMIT 1<br>do<br>SELECT * FROM gl_prodirectory WHERE name='趙豊邦' OR name_en='趙豊邦' OR oldname LIKE '%趙豊邦%'<br>do<br>SELECT turned,retired FROM gl_prodirectory WHERE  (name = '趙豊邦'  OR name = 'Chao Fong-Pang' ) <br>do<br>SELECT * FROM gl_proranking WHERE  (name = '趙豊邦'  OR name = 'Chao Fong-Pang' )  ORDER BY year DESC<br>do<br>SELECT * FROM gl_proranking_desc WHERE year='2023' AND category=''<br>do<br>
	SELECT name,name_en,oldname,proid FROM gl_prodirectory WHERE name_en!=''
	<br>do<br>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<br>do<br><div id='procontents' style='text-align:left'><div class="mainContentBox clearfix">
	<div id="ProBio">

			<h2 class="red">Chao Fong-Pang<a class="inEnglishLink" href="https://billi-walker.jp/article.php/20071202015701664">In Japanese</a></h2>
		<div id="ProBioMain">
			<div id="ProBioPhoto" class="player_photobox">
				<p id="ProBioPhotoCopy">&copy; Akira TAKATA</p>
				<a href='https://billi-walker.jp/en/mediagallery/mediaobjects/disp/9/9_chaofp01.jpg' title='2015AJ 趙豊邦 Chao Fong-Pang チャオホンパン<br />' data-lightbox='趙豊邦' class='colorbox-nb'>
	    <img src='https://billi-walker.jp/en/mediagallery/mediaobjects/tn/9/9_chaofp01.jpg' alt='趙豊邦' />
		</a>
							<button class="fan dologin disactive proid_155" data-proid="155">
			<i class="fa fa-heart"></i><span class="num">0</span>
			<span class="message">Favorite</span>
			</button>
			</div>
			<ul id="ProBioInfoList">
			    <li><span>Name:</span> Chao Fong-Pang</li>
			    <li><span>Nickname:</span> COOL FACE KILLER</li>
			    <li><span>Date of Birth:</span> 15.09.1967(56 years old)</li>
			    <li><span>Birthplace:</span> Chinese Taipei</li>
			    <li><span>Plays:</span> Right-handed</li>
			    <li><span>:</span> </li>
			    <li><span>:</span> </li>
			    <li><span>:</span> </li>
				
			</ul>
			<div id="ProBioRight">
				<div id="ProBioFlag"><img src="https://billi-walker.jp/en/images/flags24/tw.png" width="22" height="14" title="TAIWAN, PROVINCE OF CHINA" alt="TAIWAN, PROVINCE OF CHINA" />
					<p>TWN</p>
				</div>
				<div id="ProBioAssociation"><span>APBU</span></div>
			</div>
			<div id="ProBioBottom">
							<div id="ProBioRank" class="clearfix">
					<div class="bwr_wrapper">
						<h5 class="bwr">RATING(2024-04-14)</h5>
						<ul class="bwr_list">
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">-</span></div>
								<div class="bwr_label"><span class="rotate">RATING</span></div>
							</li>			
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">-</span></div>
								<div class="bwr_label"><span class="rotate">RANK</span></div>
							</li>
							<li class="bwr_box half">
								<div class="bwr_content_half"><span class="num">1,827</span><p>2000-11-26</p></div>
								<div class="bwr_label"><span class="rotate">MAX</span></div>
							</li>
						</ul>
					</div>
					<div class="bwr_wrapper">
						<h5>The win-loss records</h5>
						<ul class="bwr_list">
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">60</span></div>
								<div class="bwr_label"><span class="rotate">WIN</span></div>
							</li>
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">43</span></div>
								<div class="bwr_label"><span class="rotate">LOSE</span></div>
							</li>
						<ul>
					</div>
					
				</div>

			
			
			</div>
			<div id="ProProfile">
	<h4 class="red"><span>Profile</span></h4>
	<p></p>
</div>

			<div class="fan_button_big">
						<button class="fan dologin disactive proid_155" data-proid="155">
			<i class="fa fa-heart"></i><span class="num">0</span>
			<span class="message">Favorite</span>
			</button>
			</div>
      
		</div>
	</div>
</div>
<div class="sponsor_ad size_728"><a href="https://www.zantip.com/" target="_blank" class="noListLink clearfix" rel="nofollow"><img src="https://billi-walker.jp/mediagallery/mediaobjects/orig/6/6_zantip170227.jpg" alt="ZAN TIP" data-size="728" data-spid="7" data-num="0" /></a></div><div class="mainContentBox clearfix">
<div class="commonProfileContainer">
<h5 class="profileSecondaryTitleAlt3">Personal Records<span class="wisp">*based on the results of the final round</span></h5>
<div class="bioTableWrap bioTableWrapAlt">
<table cellspacing="0" cellpadding="0" class="bioTableAlt stripeMe pro_stats" border="0">
    <tbody>
        <tr class="bioTableHead oddRow">
            <td></td>
            <td>AllYears</td>
            <td>2024</td>
            <td>2023</td>
        </tr>
        <tr>
            <td><strong>Win</strong></td>
            <td>60</td>
            <td>0</td>
            <td>2</td>
        </tr>
        <tr class="oddRow">
            <td><strong>Lose</strong></td>
            <td>43</td>
            <td>0</td>
            <td>3</td>
        </tr>
        <tr>
            <td><strong>WinRatio</strong></td>
            <td>0.5825</td>
            <td>-</td>
            <td>0.4000</td>
        </tr>
        <tr class="oddRow">
            <td><strong>WinRatio on HillToHill</strong></td>
            <td>0.3333(4/12)</td>
            <td>-(0/0)</td>
            <td>(/0)</td>
        </tr>
        <tr>
            <td><strong>Oponent who was beated by most</strong></td>
            <td><a href='https://billi-walker.jp/en/prodirectory/versus.php?p1=%E8%B6%99%E8%B1%8A%E9%82%A6&p2=Ramil+Gallego'>vs Ramil Gallego</a>(4)</td>
            <td>no data()</td>
            <td><a href='https://billi-walker.jp/en/prodirectory/versus.php?p1=%E8%B6%99%E8%B1%8A%E9%82%A6&p2=Shintarou+SAITOU'>vs Shintarou SAITOU</a>(1)</td>
        </tr>
        <tr class="oddRow">
            <td><strong>Oponent who beated most</strong></td>
            <td><a href='https://billi-walker.jp/en/prodirectory/versus.php?p1=%E8%B6%99%E8%B1%8A%E9%82%A6&p2=Takeshi+OKUMURA'>vs Takeshi OKUMURA</a>(3)</td>
            <td>no data()</td>
            <td><a href='https://billi-walker.jp/en/prodirectory/versus.php?p1=%E8%B6%99%E8%B1%8A%E9%82%A6&p2=Kwon+Ho-Jun'>vs Kwon Ho-Jun</a>(1)</td>
        </tr>
    </tbody>
</table>
</div>
</div>
</div>
	<div class="mainContentBox">
		<div class="commonProfileContainer clearfix">
      <h5 class="featured_title">Recent videos of Chao Fong-Pang</h5>
      <div class='pro_video_wrap ajaxbox' data-url='https://billi-walker.jp/en/prodirectory/ajaxmode.php?mode=pro_video&name=趙豊邦'></div>
    </div>
  </div>	<div class="mainContentBox">
		<div class="commonProfileContainer clearfix">
      <h5 class="featured_title">Records<span class="wisp">*based on the results of the final round</span></h5>
      <div class='pro_records_wrap ajaxbox' data-url='https://billi-walker.jp/en/prodirectory/ajaxmode.php?mode=pro_records&name=趙豊邦&lang=en&jpba='></div>
    </div>
  </div>	<div class="media_photos">
	
	</div>
	<br style="clear:both" />
	</div>