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.138.33.178' AND uid = 1<br>do<br>INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1650356836, 1714012262, '3.138.33.178', 1)<br>DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011962<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='76' 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='76' 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='76' 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 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 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 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_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='2' AND size='728' AND banner!=''<br>do<br>INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) 
	VALUES('2','/prodirectory/ajax.php?name=%E3%83%AF%E3%83%AC%E3%83%B3%E3%83%BB%E3%82%AD%E3%82%A2%E3%83%A0%E3%82%B3','2-728-4','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','4','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 = 'Warren Kiamco'  OR name = 'ワレン・キアムコ'  OR name = 'ウォーレン･キアムコ' ) <br>do<br>SELECT * FROM gl_proranking WHERE  (name = 'ウォーレン・キアムコ'  OR name = 'Warren Kiamco'  OR name = 'ワレン・キアムコ'  OR name = 'ウォーレン･キアムコ' )  ORDER BY year DESC<br>do<br>SELECT * FROM gl_proranking_desc WHERE year='2023' AND category=''<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">ウォーレン・キアムコ <span>Warren Kiamco</span><a class="inEnglishLink" href="https://billi-walker.jp/en/article.php/20130302165233673">In English</a></h2>
		<div id="ProBioMain">
			<div id="ProBioPhoto" class="player_photobox">
				<p id="ProBioPhotoCopy">&copy; Akira TAKATA</p>
				<a href='https://billi-walker.jp/mediagallery/mediaobjects/disp/f/f_warrenk01.jpg' title='2009AJC ウォーレン・キアムコ Warren Kiamco<br />' data-lightbox='ウォーレン・キアムコ' class='colorbox-nb'>
	    <img src='https://billi-walker.jp/mediagallery/mediaobjects/tn/f/f_warrenk01.jpg' alt='ウォーレン・キアムコ' />
		</a>
							<button class="fan dologin disactive proid_76" data-proid="76">
			<i class="fa fa-heart"></i><span class="num">0</span>
			<span class="message">ファンになる</span>
			</button>
			</div>
			<ul id="ProBioInfoList">
			    <li><span>なまえ:</span> ウォーレンキアムコ</li>
			    <li><span>生年月日:</span> 1970年02月05日(54歳)</li>
			    <li><span>出身:</span> フィリピン</li>
			    <li><span>利き腕:</span> 右利き</li>
			    <li><span>:</span> </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/images/flags24/ph.png" width="22" height="14" title="PHILIPPINES" alt="PHILIPPINES" />
					<p>PHL</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">ビリヲカレーティング(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,872</span><p>2012-06-03</p></div>
								<div class="bwr_label"><span class="rotate">MAX</span></div>
							</li>
						</ul>
					</div>
					<div class="bwr_wrapper">
						<h5>勝敗（公式戦のみ）</h5>
						<ul class="bwr_list">
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">112</span>勝</div>
								<div class="bwr_label"><span class="rotate">WIN</span></div>
							</li>
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">79</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_76" data-proid="76">
			<i class="fa fa-heart"></i><span class="num">0</span>
			<span class="message">ファンになる</span>
			</button>
			</div>
      
		</div>
	</div>
</div>
<div class="sponsor_ad size_728"><a href="http://mezzcue.com/jp/products_pool/accessories/cueaccessories/chalkset" target="_blank" class="noListLink clearfix" rel="nofollow"><img src="https://billi-walker.jp/mediagallery/mediaobjects/orig/8/8_smart_chalk_z--728x-90.jpg" alt="Mezz" data-size="728" data-spid="2" data-num="4" /></a><p><a href="http://mezzcue.com/jp/products_pool/accessories/cueaccessories/chalkset" target="_blank" class="noListLink clearfix" rel="nofollow">MEZZ SMART CHALK</a></p></div><div class="mainContentBox clearfix">
<div class="commonProfileContainer">
<h5 class="profileSecondaryTitleAlt3">個人成績<span class="wisp">＊本選以降の結果を基にしています。</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>すべて</td>
            <td>2024</td>
            <td>2023</td>
        </tr>
        <tr>
            <td><strong>勝数</strong></td>
            <td>112</td>
            <td>0</td>
            <td>0</td>
        </tr>
        <tr class="oddRow">
            <td><strong>負数</strong></td>
            <td>79</td>
            <td>0</td>
            <td>0</td>
        </tr>
        <tr>
            <td><strong>勝率</strong></td>
            <td>0.5864</td>
            <td>-</td>
            <td>-</td>
        </tr>
        <tr class="oddRow">
            <td><strong>ヒルヒル勝率</strong></td>
            <td>0.4583(11/24)</td>
            <td>-(0/0)</td>
            <td>-(0/0)</td>
        </tr>
        <tr>
            <td><strong>最も勝っている相手</strong></td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E3%82%A6%E3%82%A9%E3%83%BC%E3%83%AC%E3%83%B3%E3%83%BB%E3%82%AD%E3%82%A2%E3%83%A0%E3%82%B3&p2=%E3%83%87%E3%83%8B%E3%82%B9%E3%83%BB%E3%82%AA%E3%83%AB%E3%82%B3%E3%83%AD'>vs デニス・オルコロ</a>(3)</td>
            <td>no data()</td>
            <td>no data()</td>
        </tr>
        <tr class="oddRow">
            <td><strong>最も負けている相手</strong></td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E3%82%A6%E3%82%A9%E3%83%BC%E3%83%AC%E3%83%B3%E3%83%BB%E3%82%AD%E3%82%A2%E3%83%A0%E3%82%B3&p2=%E3%83%87%E3%83%8B%E3%82%B9%E3%83%BB%E3%82%AA%E3%83%AB%E3%82%B3%E3%83%AD'>vs デニス・オルコロ</a>(4)</td>
            <td>no data()</td>
            <td>no data()</td>
        </tr>
    </tbody>
</table>
</div>
</div>
</div>
	<div class="mainContentBox">
		<div class="commonProfileContainer clearfix">
      <h5 class="featured_title">ウォーレン・キアムコの最新の動画</h5>
      <div class='pro_video_wrap ajaxbox' data-url='https://billi-walker.jp/prodirectory/ajaxmode.php?mode=pro_video&name=ウォーレン・キアムコ'></div>
    </div>
  </div>	<div class="mainContentBox">
		<div class="commonProfileContainer clearfix">
      <h5 class="featured_title">主な戦績<span class="wisp">＊本選以降の結果を基にしています。</span></h5>
      <div class='pro_records_wrap ajaxbox' data-url='https://billi-walker.jp/prodirectory/ajaxmode.php?mode=pro_records&name=ウォーレン・キアムコ&lang=jp&jpba='></div>
    </div>
  </div>	<div class="media_photos">
	
	</div>
	<br style="clear:both" />
	</div>