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.145.60.29' AND uid = 1<br>do<br>INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (653645332, 1714012245, '3.145.60.29', 1)<br>DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011945<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='286' 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='286' 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='286' 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 * 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 '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 * 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 '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='5' AND size='728' AND banner!=''<br>do<br>INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) 
	VALUES('5','/prodirectory/ajax.php?name=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&eng=1','5-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)')
	<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 = 'Kouichi Sakamoto' ) <br>do<br>SELECT * FROM gl_proranking WHERE  (name = '坂本晃一'  OR name = 'Kouichi Sakamoto' )  ORDER BY year DESC<br>do<br>SELECT * FROM gl_proranking_desc WHERE year='2023' AND category='0'<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">Kouichi Sakamoto<a class="inEnglishLink" href="https://billi-walker.jp/article.php/20160203140618832">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/mediagallery/mediaobjects/disp/a/a_sakamotok01.jpg' title='2015AJC 坂本晃一 Kouichi Sakamoto<br />' data-lightbox='坂本晃一' class='colorbox-nb'>
	    <img src='https://billi-walker.jp/mediagallery/mediaobjects/tn/a/a_sakamotok01.jpg' alt='坂本晃一' />
		</a>
							<button class="fan dologin disactive proid_286" data-proid="286">
			<i class="fa fa-heart"></i><span class="num">0</span>
			<span class="message">ファンになる</span>
			</button>
			</div>
			<ul id="ProBioInfoList">
			    <li><span>Name:</span> Kouichi Sakamoto</li>
			    <li><span>Date of Birth:</span> 13.09.1976(47 years old)</li>
			    <li><span>Turned pro:</span> 2015</li>
			    <li><span>Birthplace:</span> Tochigi, Japan</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/images/flags24/jp.png" width="22" height="14" title="JAPAN" alt="JAPAN" />
					<p>JPN</p>
				</div>
				<div id="ProBioAssociation"><span>JPBA</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,498</span><p>2017-07-16</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">13</span></div>
								<div class="bwr_label"><span class="rotate">WIN</span></div>
							</li>
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">17</span></div>
								<div class="bwr_label"><span class="rotate">LOSE</span></div>
							</li>
						<ul>
					</div>
					<br />					<div class="bwr_wrapper">
						<h5 class="jpbar">JPBA Rank</h5>
						<ul class="bwr_list">
							<li class="bwr_box half">
								<div class="bwr_content_half"><span class="num">145</span><p>2024-03-31</p></div>
								<div class="bwr_label"><span class="rotate">RANK</span></div>
							</li>
						<ul>
						
					</div>
					<div class="bwr_wrapper">
						<h5 class="jpbar">JPBA-EAST</h5>
						<ul class="bwr_list">
							<li class="bwr_box half">
								<div class="bwr_content_half"><span class="num">68</span><p>2021-11-30</p></div>
								<div class="bwr_label"><span class="rotate">RANK</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_286" data-proid="286">
			<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="https://www.newart.co.jp/beginners?bw" target="_blank" class="noListLink clearfix" rel="nofollow"><img src="https://billi-walker.jp/mediagallery/mediaobjects/orig/3/3_bw_newart_03.jpg" alt="NEW ART" data-size="728" data-spid="5" data-num="3" /></a><p><a href="https://www.newart.co.jp/beginners?bw" target="_blank" class="noListLink clearfix" rel="nofollow">ニューアート式初心者応援サイト</a></p></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>13</td>
            <td>2</td>
            <td>4</td>
        </tr>
        <tr class="oddRow">
            <td><strong>Lose</strong></td>
            <td>17</td>
            <td>2</td>
            <td>3</td>
        </tr>
        <tr>
            <td><strong>WinRatio</strong></td>
            <td>0.4333</td>
            <td>0.5000</td>
            <td>0.5714</td>
        </tr>
        <tr class="oddRow">
            <td><strong>WinRatio on HillToHill</strong></td>
            <td>0.5000(2/4)</td>
            <td>0.0000(0/1)</td>
            <td>1.0000(1/1)</td>
        </tr>
        <tr>
            <td><strong>Oponent who was beated by most</strong></td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Tomonobu+SATOU'>vs Tomonobu SATOU</a>(1)</td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Tomonobu+SATOU'>vs Tomonobu SATOU</a>(1)</td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Takeya+KATO'>vs Takeya KATO</a>(1)</td>
        </tr>
        <tr class="oddRow">
            <td><strong>Oponent who beated most</strong></td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Kouki+SUGIYAMA'>vs Kouki SUGIYAMA</a>(2)</td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Toshio+MORIYASU'>vs Toshio MORIYASU</a>(1)</td>
            <td><a href='https://billi-walker.jp/prodirectory/versus.php?p1=%E5%9D%82%E6%9C%AC%E6%99%83%E4%B8%80&p2=Kenichi+UCHIGAKI'>vs Kenichi UCHIGAKI</a>(1)</td>
        </tr>
    </tbody>
</table>
</div>
</div>
</div>
<script>
jQuery( function() {
	var ranks= {
		1997:null,1998:null,1999:null,2000:null,2001:null,2002:null,2003:null,2004:null,2005:null,2006:null,2007:null,2008:null,2009:null,2010:null,2011:null,2012:null,2013:null,2014:null,2015:93,2016:137,2017:126,2018:148,2019:146,2020:null,2021:null,2022:140,2023:null
		};
	var lastyear = 2023-1;
	var static_year = 2024-1;
	var startyear = 1997
	var yaxmin = 20;
	initplot();

  $("#preyear").click(function(){
    var now= parseInt($('#yearSelect').val());
  	if(now-1>startyear+8) {
  		$('#yearSelect').val(now-1);
		lastyear = now-1;
		initplot();
	}
	});
  $("#nextyear").click(function(){
    var now=  parseInt($("#yearSelect").val());
    console.log(now);
  	if(now+1<static_year+1) {
	  	$('#yearSelect').val(now+1);
		lastyear = now+1;
		initplot();
	}
	});
  $("#yearSelect").change(function(){
	lastyear = parseInt($("#yearSelect").val());
	initplot();

	
	});

	
	function initplot(){
		var rank = new Array();
	 	var num = 0;
	 	var k=0;
	 	var flag =0;
	 	for (var i = 10; i >= -1; i--) {
			if(ranks[lastyear-i] != null){
				if(num==0){
					rank[k] = new Array();
				}
				rank[k][num] = [lastyear-i,ranks[lastyear-i]];
				num++;
				if(ranks[lastyear-i] > yaxmin) yaxmin=ranks[lastyear-i]; 
				flag=1;
			}else{
				if(num!=0) k++;
				num=0;
			}
		}
		if(flag==0) rank[0] = [lastyear,null];
		$("#pastranking").html("");
	    var Ranking = jQuery . jqplot(
	        'pastranking',
	        rank,
	        {
	            seriesDefaults: {
	                pointLabels: {
	                    show: true,
						location: 'w',
	                },
	                color: "#4bb2c5"
	            },
	            axes: {  
					xaxis:{
						min:lastyear-10, 
						max:lastyear,
						ticks: [[lastyear-10, ''] ,[lastyear-9,lastyear-9],[lastyear-8,lastyear-8],[lastyear-7,lastyear-7],[lastyear-6,lastyear-6],[lastyear-5,lastyear-5],[lastyear-4,lastyear-4],[lastyear-3,lastyear-3],[lastyear-2,lastyear-2],[lastyear-1,lastyear-1],[lastyear,lastyear] , [lastyear+1, lastyear+1]],
					},  
					yaxis:{
						max:0,
						min:yaxmin+5,
	                    tickOptions: {
	                        formatString: '%d',
	                    }
					}
				}
	        }
	    );
	    Ranking.replot();

	    window.onresize = function( event) {
	        Ranking.replot();
	    }
		$(document).bind('cbox_complete', function(){
			Ranking.replot();
		});
   }



} );
</script>

<div class="mainContentBox">
	<div class="commonProfileContainer">
		<h5 class="profileSecondaryTitleAlt3">JPBA rankings from <select id='yearSelect'>
<option value='2023'>2023</option>
<option value='2022' selected="selected">2022</option>
<option value='2021'>2021</option>
<option value='2020'>2020</option>
<option value='2019'>2019</option>
<option value='2018'>2018</option>
<option value='2017'>2017</option>
<option value='2016'>2016</option>
<option value='2015'>2015</option>
<option value='2014'>2014</option>
<option value='2013'>2013</option>
<option value='2012'>2012</option>
<option value='2011'>2011</option>
<option value='2010'>2010</option>
<option value='2009'>2009</option>
<option value='2008'>2008</option>
<option value='2007'>2007</option>
<option value='2006'>2006</option>
</select>
 for the past 10 years<span class="wisp"></span></h5>
		<div id="pastranking" style="height: 200px; width: 100%;"></div>
<button id="preyear" style="padding:0px 5px;">&lt;</button><button id="nextyear" style="padding:0px 5px;float:right;"> &gt; </button>
	</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">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/prodirectory/ajaxmode.php?mode=pro_records&name=坂本晃一&lang=en&jpba='></div>
    </div>
  </div>	<div class="media_photos">
	
	</div>
	<br style="clear:both" />
	</div>