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.145.74.54' AND uid = 1 INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (1813487329, 1714011593, '3.145.74.54', 1) DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011293 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 sp_id,sp_title,sp_content,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_id SELECT cb_enable, cb_homepage, cb_where FROM gl_forum_settings SELECT count(*) as count FROM gl_stories WHERE featured = 1 SELECT * FROM gl_mg_albums ORDER BY album_order DESC SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all') SELECT * FROM gl_topinfo WHERE place='top' SELECT * FROM gl_result_bet_tournament WHERE active=1 AND cancel=0 AND series!='test' AND ((startdate<=CURDATE() AND CURDATE() <=lastdate) OR (entry_startdate<=NOW() AND NOW() <= entry_lastdate)) ORDER BY startdate DESC SELECT sp_id, sp_label FROM gl_staticpage WHERE sp_onmenu = 1 AND (perm_anon >= 2) ORDER BY sp_label SELECT COUNT(*) AS cnt
FROM gl_faq AS faq,
gl_faq_category AS cat
WHERE faq.category = cat.id AND (faq.perm_anon >= 2) AND (cat.perm_anon >= 2) SELECT pi_version FROM gl_plugins WHERE pi_name = 'ogp' SELECT sp_id,sp_title,sp_content,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 1 OR sp_where = 2) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_where,sp_id UPDATE gl_staticpage SET sp_hits = sp_hits + 1 WHERE sp_id = 'topppage' SELECT cb_enable, cb_homepage, cb_where FROM gl_forum_settings SELECT count(*) as count FROM gl_stories WHERE featured = 1 SELECT fid,type,topic,limits,update_info FROM gl_syndication WHERE is_enabled = 1 SELECT tid FROM gl_topics WHERE (perm_anon >= 2) SELECT sid FROM gl_stories WHERE draft_flag = 0 AND date <= NOW() AND (tid IN ('profiles','profiles-w','profilesoversea','hobby-top','profilesoversea-w','movie','rakuraku-billi','cuedirectory','staffdiary','cuetube','letsbegin','results','results_a','results_w','RaceTo11','foolpool','urayougo','results_en','shadoubu','playback','grandprix-east','grandprix-west','billiardgirl')) AND perm_anon > 0 ORDER BY date DESC LIMIT 10 SELECT dic_id FROM gl_bwdictionary ORDER BY date DESC LIMIT 10 SELECT * FROM gl_syndication WHERE fid = 2 SELECT topic,limits,content_length FROM gl_syndication WHERE fid = '2' SELECT dic_id,owner_id,title,description,UNIX_TIMESTAMP(date) AS modified FROM gl_bwdictionary ORDER BY date DESC LIMIT 10 SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' UPDATE gl_syndication SET updated = NOW(), update_info = ',,,,,,,,,' WHERE fid = 2 SELECT tid FROM gl_topics WHERE (perm_anon >= 2) SELECT sid FROM gl_stories WHERE draft_flag = 0 AND date <= NOW() AND (tid IN ('profiles','profiles-w','profilesoversea','hobby-top','profilesoversea-w','movie','rakuraku-billi','cuedirectory','staffdiary','cuetube','letsbegin','results','results_a','results_w','RaceTo11','foolpool','urayougo','results_en','shadoubu','playback','grandprix-east','grandprix-west','billiardgirl')) AND perm_anon > 0 ORDER BY date DESC LIMIT 10 SELECT tid FROM gl_topics WHERE archive_flag=1 SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statuscode = 11) SELECT tid FROM gl_topics WHERE (perm_anon >= 2) SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 AND (s.perm_anon >= 2) AND (s.tid IN ('profiles','profiles-w','profilesoversea','hobby-top','profilesoversea-w','movie','rakuraku-billi','cuedirectory','staffdiary','cuetube','letsbegin','results','results_a','results_w','RaceTo11','foolpool','urayougo','results_en','shadoubu','playback','grandprix-east','grandprix-west','billiardgirl')) ORDER BY date DESC LIMIT 0, 20 SELECT COUNT(*) AS count FROM gl_stories AS s WHERE (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1 AND (s.perm_anon >= 2) AND (s.tid IN ('profiles','profiles-w','profilesoversea','hobby-top','profilesoversea-w','movie','rakuraku-billi','cuedirectory','staffdiary','cuetube','letsbegin','results','results_a','results_w','RaceTo11','foolpool','urayougo','results_en','shadoubu','playback','grandprix-east','grandprix-west','billiardgirl')) SELECT sp_id,sp_title,sp_content,sp_format,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (sp_where = 3) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (perm_anon >= 2) ORDER BY sp_id SELECT cb_enable, cb_homepage, cb_where FROM gl_forum_settings SELECT count(*) as count FROM gl_stories WHERE featured = 1 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 a.id, a.forum, a.name, a.date, a.lastupdated, a.last_reply_rec, a.subject, a.comment, a.uid, a.name, a.pid, a.replies, a.views, b.forum_name FROM gl_forum_topic a LEFT JOIN gl_forum_forums b ON a.forum=b.forum_id WHERE pid=0 AND b.grp_id IN (2) AND b.no_newposts = 0 ORDER BY lastupdated DESC LIMIT 3 SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT uid,name,comment FROM gl_forum_topic WHERE id=573 SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT uid,name,comment FROM gl_forum_topic WHERE id=569 SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT username, fullname, remoteusername, remoteservice FROM gl_users WHERE uid='4' SELECT * FROM gl_autotags_plg WHERE is_enabled = 1 SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title asc SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title asc select unix_timestamp(rdate) AS u_rdate, a.lid,url,cnt1,cnt2,cnt3,cnt4,cnt5,cnt6,cnt7,cnt_all,rdate,lastip,accessurl from gl_links AS a LEFT JOIN gl_linkaccess AS b ON a.lid = b.lid where INSTR('https://billi-walker.jp/links/portal.php/rss1/20080304115749923',url) OR (INSTR('https://billi-walker.jp/links/portal.php/rss1/20080304115749923',accessurl) AND accessurl != '')ORDER BY LENGTH(url) DESC SELECT pi_version FROM gl_plugins WHERE pi_name = 'ogp'
SELECT *
FROM gl_prosponsor
WHERE weight != 0
SELECT * FROM gl_prosponsor_ad WHERE spid='5' AND size='smart' AND banner!='' INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua)
VALUES('5','/','5-smart-3','smart','',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)')
select * from gl_bwnews_config where id=14 select * from gl_bwnews_config where id=12 SELECT * FROM gl_special WHERE title='試合結果' AND mobile=1 AND tid!='' ORDER BY rank DESC SELECT s.*,u.topic,p.banner2 FROM gl_stories AS s LEFT JOIN gl_topics AS u ON s.tid=u.tid LEFT JOIN gl_special AS p ON u.tid=p.tid WHERE ((s.date <= NOW()) AND (s.draft_flag = 0)) AND ((s.tid='results') OR (s.tid='results_w') OR (s.tid='results_a') ) AND (s.perm_anon >= 2) ORDER BY s.date DESC limit 5
SELECT
SUM(CASE WHEN (video_active1=1 AND video_idx1=0) OR (video_active2=1 AND video_idx2=0) OR (video_active3=1 AND video_idx3=0) THEN 1 ELSE 0 END )idx0,SUM(CASE WHEN (video_active1=1 AND video_idx1=1) OR (video_active2=1 AND video_idx2=1) OR (video_active3=1 AND video_idx3=1) THEN 1 ELSE 0 END )idx1,SUM(CASE WHEN (video_active1=1 AND video_idx1=2) OR (video_active2=1 AND video_idx2=2) OR (video_active3=1 AND video_idx3=2) THEN 1 ELSE 0 END )idx2
FROM `gl_result_video`
WHERE v_sid = '2024kantouopen'
SELECT
SUM(CASE WHEN (video_active1=1 AND video_idx1=0) OR (video_active2=1 AND video_idx2=0) OR (video_active3=1 AND video_idx3=0) THEN 1 ELSE 0 END )idx0,SUM(CASE WHEN (video_active1=1 AND video_idx1=1) OR (video_active2=1 AND video_idx2=1) OR (video_active3=1 AND video_idx3=1) THEN 1 ELSE 0 END )idx1,SUM(CASE WHEN (video_active1=1 AND video_idx1=2) OR (video_active2=1 AND video_idx2=2) OR (video_active3=1 AND video_idx3=2) THEN 1 ELSE 0 END )idx2
FROM `gl_result_video`
WHERE v_sid = '2024GPE2nd'
SELECT
SUM(CASE WHEN (video_active1=1 AND video_idx1=0) OR (video_active2=1 AND video_idx2=0) OR (video_active3=1 AND video_idx3=0) THEN 1 ELSE 0 END )idx0,SUM(CASE WHEN (video_active1=1 AND video_idx1=1) OR (video_active2=1 AND video_idx2=1) OR (video_active3=1 AND video_idx3=1) THEN 1 ELSE 0 END )idx1,SUM(CASE WHEN (video_active1=1 AND video_idx1=2) OR (video_active2=1 AND video_idx2=2) OR (video_active3=1 AND video_idx3=2) THEN 1 ELSE 0 END )idx2
FROM `gl_result_video`
WHERE v_sid = '2024GPW1st'
SELECT
SUM(CASE WHEN (video_active1=1 AND video_idx1=0) OR (video_active2=1 AND video_idx2=0) OR (video_active3=1 AND video_idx3=0) THEN 1 ELSE 0 END )idx0,SUM(CASE WHEN (video_active1=1 AND video_idx1=1) OR (video_active2=1 AND video_idx2=1) OR (video_active3=1 AND video_idx3=1) THEN 1 ELSE 0 END )idx1,SUM(CASE WHEN (video_active1=1 AND video_idx1=2) OR (video_active2=1 AND video_idx2=2) OR (video_active3=1 AND video_idx3=2) THEN 1 ELSE 0 END )idx2
FROM `gl_result_video`
WHERE v_sid = '2024alljapanrotationchampionship'
SELECT
SUM(CASE WHEN (video_active1=1 AND video_idx1=0) OR (video_active2=1 AND video_idx2=0) OR (video_active3=1 AND video_idx3=0) THEN 1 ELSE 0 END )idx0,SUM(CASE WHEN (video_active1=1 AND video_idx1=1) OR (video_active2=1 AND video_idx2=1) OR (video_active3=1 AND video_idx3=1) THEN 1 ELSE 0 END )idx1,SUM(CASE WHEN (video_active1=1 AND video_idx1=2) OR (video_active2=1 AND video_idx2=2) OR (video_active3=1 AND video_idx3=2) THEN 1 ELSE 0 END )idx2
FROM `gl_result_video`
WHERE v_sid = '2024AJLPT2nd'
select * from gl_bwnews_config where id=4 SELECT dic_id,title,description,date,hits FROM gl_bwdictionary WHERE (perm_anon >= 2) ORDER BY date DESC LIMIT 22 SELECT eid,title,url,datestart,dateend,timestart,timeend,group_id,owner_id,perm_owner,perm_group,perm_members,perm_anon,event_type, CASE event_type
WHEN 'プロ公式戦' THEN 1
WHEN 'アマ公式戦' THEN 4
WHEN 'オープン戦' THEN 3
WHEN 'ハウストーナメント' THEN 9
WHEN '各種イベント' THEN 6
WHEN '海外試合' THEN 2
WHEN 'キャロム' THEN 7
WHEN 'スヌーカー' THEN 8
WHEN 'その他' THEN 5
ELSE 10 END event_num FROM gl_events WHERE (datestart >= '2024-03-31') AND (datestart <= '2024-05-04') ORDER BY event_num select * from gl_bwnews_config where id=5 select * from gl_bwblog where active =1 order by ddatetime DESC limit 4 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_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_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_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_bwnews_config where id=15 (
SELECT name,name_en, sid, country, rating, rating_plus, rating_rank, photo,
CASE WHEN rating_plus_date = rating_maxdate
THEN 1
ELSE 0
END max
FROM `gl_prodirectory`
WHERE sid != ''
AND rating_rank !=0
AND sex =0
AND rating_plus_date >= DATE_ADD( NOW( ) , INTERVAL -45
DAY )
AND retired =''
AND photo != ''
ORDER BY max DESC , rating_plus DESC
LIMIT 6
)
UNION ALL (
SELECT name,name_en, sid, country, rating, rating_plus, rating_rank, photo,
CASE WHEN rating_plus_date = rating_maxdate
THEN 1
ELSE 0
END max
FROM `gl_prodirectory`
WHERE sid != ''
AND rating_rank !=0
AND sex =1
AND rating_plus_date >= DATE_ADD( NOW( ) , INTERVAL -45
DAY )
AND retired =''
AND photo !=''
ORDER BY max DESC , rating_plus DESC
LIMIT 6
)
ORDER BY RAND( )
LIMIT 1 SELECT tid FROM gl_result_bet_tournament t WHERE t.series!='test' AND t.active != 0 AND t.active != 2 SELECT t.*,s.color FROM gl_result_bet_tournament t LEFT JOIN gl_result_bet_series s ON t.series=s.seriesid WHERE t.series!='test' AND t.active != 0 AND t.active != 2 ORDER BY startdate DESC LIMIT 0 ,12
SELECT *
FROM gl_prosponsor
WHERE weight != 0
SELECT * FROM gl_prosponsor_ad WHERE spid='26' AND size='728' AND banner!='' INSERT INTO gl_prosponsor_count (spid,path,banner_id,size,uid,date,layout,num,ua)
VALUES('26','/','26-728-2','728','',NOW(),'https://billi-walker.jp/layout/billi-walker_new','2','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)')
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='NEWS' ORDER BY RAND() LIMIT 1