SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1<br>SELECT onleft,name,title FROM gl_blocks<br>DELETE FROM gl_sessions WHERE remote_ip = '3.15.211.107' AND uid = 1<br>INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1543852219, 1714011509, '3.15.211.107', 1)<br>DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011209<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>SELECT pi_version FROM gl_plugins WHERE pi_name='forum'<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>SELECT * FROM gl_forum_settings<br>SELECT * FROM gl_mg_config<br>SELECT pi_version FROM gl_plugins WHERE pi_name = 'mediagallery'<br>SELECT format FROM gl_dateformats WHERE dfid = 0<br>SELECT * FROM gl_cp_config<br>SELECT value FROM gl_vars WHERE name='last_scheduled_run'<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ' OR name_en='ロドリゴ・ジェロニモ' OR oldname LIKE '%ロドリゴ・ジェロニモ%'<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ'<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>SELECT * FROM gl_ranking_data_now n LEFT JOIN gl_ranking r ON n.id=r.rankid WHERE proid='1435' ORDER BY r.ordernum<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='1435' AND category = 0 ORDER BY sort DESC<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='1435' AND category != 0 ORDER BY category<br>SELECT profile,profile_en,retired FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ'<br>SELECT * FROM gl_autotags_plg WHERE is_enabled = 1<br>SELECT name,oldname FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ'<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ' OR name_en='ロドリゴ・ジェロニモ' OR oldname LIKE '%ロドリゴ・ジェロニモ%'<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>SELECT name,oldname FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ'<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ' OR name_en='ロドリゴ・ジェロニモ' OR oldname LIKE '%ロドリゴ・ジェロニモ%'<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>SELECT name,oldname FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ'<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ' OR name_en='ロドリゴ・ジェロニモ' OR oldname LIKE '%ロドリゴ・ジェロニモ%'<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>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>SELECT * FROM gl_prodirectory WHERE name='岩谷正男' OR name_en='岩谷正男' OR oldname LIKE '%岩谷正男%'<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>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>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>SELECT * FROM gl_prodirectory WHERE name='アロイシウス・ヤップ' OR name_en='アロイシウス・ヤップ' OR oldname LIKE '%アロイシウス・ヤップ%'<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>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>
		SELECT * 
			FROM gl_prosponsor
			WHERE  weight !=  0
		<br>SELECT * FROM gl_prosponsor_player WHERE player='ロドリゴ・ジェロニモ' AND spid!='' AND display=1<br>SELECT * FROM gl_prosponsor_ad WHERE spid='5' AND size='728' AND banner!=''<br>INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua) 
	VALUES('5','/en/prodirectory/ajax.php?name=%E3%83%AD%E3%83%89%E3%83%AA%E3%82%B4%E3%83%BB%E3%82%B8%E3%82%A7%E3%83%AD%E3%83%8B%E3%83%A2&eng=1','5-728-5','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','5','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
	<br>SELECT year FROM gl_proranking ORDER BY year LIMIT 1<br>SELECT year FROM gl_proranking WHERE year='2024' LIMIT 1<br>SELECT * FROM gl_prodirectory WHERE name='ロドリゴ・ジェロニモ' OR name_en='ロドリゴ・ジェロニモ' OR oldname LIKE '%ロドリゴ・ジェロニモ%'<br>SELECT turned,retired FROM gl_prodirectory WHERE  (name = 'ロドリゴ・ジェロニモ'  OR name = 'Rodrigo Geronimo'  OR name = 'Rodrigo D Geronimo'  OR name = 'ロドリゴ･ジェロニモ' ) <br>SELECT * FROM gl_proranking WHERE  (name = 'ロドリゴ・ジェロニモ'  OR name = 'Rodrigo Geronimo'  OR name = 'Rodrigo D Geronimo'  OR name = 'ロドリゴ･ジェロニモ' )  ORDER BY year DESC<br>SELECT * FROM gl_proranking_desc WHERE year='2023' AND category=''<br>
	SELECT name,name_en,oldname,proid FROM gl_prodirectory WHERE name_en!=''
	<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><div id='procontents' style='text-align:left'><div class="mainContentBox clearfix">
	<div id="ProBio">

			<h2 class="red">Rodrigo Geronimo<a class="inEnglishLink" href="https://billi-walker.jp/article.php/rodrigogeronimo">In Japanese</a></h2>
		<div id="ProBioMain">
			<div id="ProBioPhoto" class="player_photobox">
				<p id="ProBioPhotoCopy"></p>
				<img src="https://billi-walker.jp/en/images/nophoto_240x180.png" />
							<button class="fan dologin disactive proid_1435" data-proid="1435">
			<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> Rodrigo Geronimo</li>
			    <li><span>Birthplace:</span> Philippines</li>
			    <li><span>Plays:</span> Right-handed</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/en/images/flags24/ph.png" width="22" height="14" title="PHILIPPINES" alt="PHILIPPINES" />
					<p>PHL</p>
				</div>
				<div id="ProBioAssociation"><span></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,978</span><p>2021-09-18</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">12</span></div>
								<div class="bwr_label"><span class="rotate">WIN</span></div>
							</li>
							<li class="bwr_box">
								<div class="bwr_content"><span class="num">3</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_1435" data-proid="1435">
			<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.newart.co.jp/questionnairetop" target="_blank" class="noListLink clearfix" rel="nofollow"><img src="https://billi-walker.jp/mediagallery/mediaobjects/orig/0/0_newart_728x90_.jpg" alt="NEW ART" data-size="728" data-spid="5" data-num="5" /></a><p><a href="https://www.newart.co.jp/questionnairetop" 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>12</td>
            <td>0</td>
            <td>0</td>
        </tr>
        <tr class="oddRow">
            <td><strong>Lose</strong></td>
            <td>3</td>
            <td>0</td>
            <td>0</td>
        </tr>
        <tr>
            <td><strong>WinRatio</strong></td>
            <td>0.8000</td>
            <td>-</td>
            <td>-</td>
        </tr>
        <tr class="oddRow">
            <td><strong>WinRatio on HillToHill</strong></td>
            <td>1.0000(2/2)</td>
            <td>-(0/0)</td>
            <td>-(0/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=%E3%83%AD%E3%83%89%E3%83%AA%E3%82%B4%E3%83%BB%E3%82%B8%E3%82%A7%E3%83%AD%E3%83%8B%E3%83%A2&p2=Masao+IWATANI'>vs Masao IWATANI</a>(2)</td>
            <td>no data()</td>
            <td>no data()</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=%E3%83%AD%E3%83%89%E3%83%AA%E3%82%B4%E3%83%BB%E3%82%B8%E3%82%A7%E3%83%AD%E3%83%8B%E3%83%A2&p2=Aloysius+Yapp'>vs Aloysius Yapp</a>(1)</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">Recent videos of Rodrigo Geronimo</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>