SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
do
SELECT onleft,name,title FROM gl_blocks
do
DELETE FROM gl_sessions WHERE remote_ip = '18.188.175.182' AND uid = 1
do
INSERT INTO gl_sessions (sess_id, start_time, remote_ip, uid) VALUES (507749169, 1714012091, '18.188.175.182', 1)
DELETE FROM gl_sessions WHERE uid = 1 AND start_time < 1714011791
do
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)
do
SELECT pi_version FROM gl_plugins WHERE pi_name='forum'
do
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
do
SELECT * FROM gl_forum_settings
do
SELECT * FROM gl_mg_config
SELECT pi_version FROM gl_plugins WHERE pi_name = 'mediagallery'
do
SELECT format FROM gl_dateformats WHERE dfid = 0
do
SELECT * FROM gl_cp_config
SELECT value FROM gl_vars WHERE name='last_scheduled_run'
do
SELECT city,COUNT(id) total FROM `gl_bwpoolhall` WHERE pref='18' AND active !=2 and active !=4 and active !=5 and active !=6 and active !=7 GROUP BY city
do
SELECT COUNT(*) total,SUM(pocket) pocket,SUM(3c) 3c,SUM(4b) 4b,SUM(snooker) snooker,SUM(c8) c8, SUM(carpark) carpark,SUM(softdk) softdk,SUM(bar) bar,SUM(food) food,SUM(rentcue) rentcue,SUM(jrcue) jrcue, SUM(sellcue) sellcue,SUM(goods) goods,SUM(tips) tips,SUM(smoke) smoke,SUM(barrierfree) barrierfree, SUM(free_price) free_price,SUM(daytime) daytime,SUM(h24) h24 FROM ( select name, CASE WHEN qtypocket>0 THEN 1 ELSE 0 END AS pocket, CASE WHEN qty4b>0 THEN 1 ELSE 0 END AS 4b, CASE WHEN qty3c>0 THEN 1 ELSE 0 END AS 3c, CASE WHEN qtysnook>0 THEN 1 ELSE 0 END AS snooker, CASE WHEN qtyc8>0 THEN 1 ELSE 0 END AS c8, CASE WHEN carpark > 0 THEN 1 ELSE 0 END AS carpark, CASE WHEN foods like '%A%' THEN 1 ELSE 0 END AS softdk, CASE WHEN foods like '%B%' THEN 1 ELSE 0 END AS bar, CASE WHEN foods like '%C%' THEN 1 ELSE 0 END AS food, CASE WHEN housecue like '%A%' THEN 1 ELSE 0 END AS rentcue, CASE WHEN housecue like '%B%' THEN 1 ELSE 0 END AS jrcue, CASE WHEN goodssell like '%A%' THEN 1 ELSE 0 END AS sellcue, CASE WHEN goodssell like '%B%' THEN 1 ELSE 0 END AS goods, CASE WHEN goodssell like '%C%' THEN 1 ELSE 0 END AS tips, CASE WHEN smoke = 1 THEN 1 ELSE 0 END AS smoke, CASE WHEN barrierfree = 1 THEN 1 ELSE 0 END AS barrierfree, CASE WHEN free_price = 1 THEN 1 ELSE 0 END AS free_price, CASE WHEN daytime = 1 THEN 1 ELSE 0 END AS daytime, CASE WHEN h24 = 1 THEN 1 ELSE 0 END AS h24 from gl_bwpoolhall where pref='18' AND city = '0' AND active != 2 and active !=4 and active !=5 and active !=6 and active!=7 )tb1
do
select id, name, furiname, pref, address, storepr, active,qtypocket,qty4b,qty3c,qtysnook,photo1,mapgoogle,url,mainphoto from gl_bwpoolhall WHERE active !=2 and pref='18' and address not like '富山市%' and address not like '高岡市%' and address not like '魚津市%' and address not like '小矢部市%' and address not like '砺波市%' and address like '%' order by active DESC,weight DESC,qtypocket DESC, address, furiname
do
select id, name, furiname, pref, address, storepr, active,qtypocket,qty4b,qty3c,qtysnook,photo1,mapgoogle,url,mainphoto from gl_bwpoolhall WHERE active !=2 and pref='18' and address not like '富山市%' and address not like '高岡市%' and address not like '魚津市%' and address not like '小矢部市%' and address not like '砺波市%' and address like '%' order by active DESC,weight DESC,qtypocket DESC, address, furiname limit 0,40
do
SELECT tbl1.hallid,s.name name, a.spid spid, a.banner banner, a.url url FROM gl_bwpoolhall_affi tbl1 LEFT JOIN gl_prosponsor s ON tbl1.spid = s.id LEFT JOIN gl_prosponsor_ad a ON tbl1.spid = a.spid AND a.size = 'hall' AND a.num =1 ORDER BY s.sort DESC
do
SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
do
SELECT * FROM gl_topinfo WHERE place='top'
do
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
do
SELECT sp_id, sp_label FROM gl_staticpage WHERE sp_onmenu = 1 AND (perm_anon >= 2) ORDER BY sp_label
do
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)
do
SELECT COUNT(id) num FROM gl_bwpoolhall WHERE pref="18" AND active=1
do
SELECT pi_version FROM gl_plugins WHERE pi_name = 'ogp'
do
do
SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'all') ORDER BY blockorder,title asc
do
SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'all') ORDER BY blockorder,title asc
do
SELECT * FROM gl_autotags_plg WHERE is_enabled = 1
do
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('',url) OR (INSTR('',accessurl) AND accessurl != '')ORDER BY LENGTH(url) DESC
do
SELECT pi_version FROM gl_plugins WHERE pi_name = 'ogp'
do
富山県 その他の地域 ビリヤード場ガイド(閉店済店舗表示) - ビリヤード・ウォーカー ビリヲカ
【今こそ非三密で安全なビリヤードを】(記事へリンク) 生涯楽しめる最高の趣味
◆本格ビリヤードヒロイン漫画『ミドリノバショ』7巻が1/12に発売!【ビリヤードガール】(関連記事へリンク)

ビリヤードウォーカー ビリヲカ ビリヤード場ガイド

富山県その他の地域

絞り込み

16件 ->

店舗名 住所 台数  
ビリヤード M-style 【閉店】 富山県/黒部市新牧野354 ユアーズ黒部 -5
フリークス黒部店 【閉店】 富山県/黒部市沓掛645 プレーランド黒部 2F -3
トヤマレジャーランド小杉店 【閉店】 富山県/射水市大江1243-5
Pool jam 【閉店】 富山県/射水市戸破1658-1
トヤマレジャーランド小杉店 富山県/射水市大江1243-5 -5
サービスエリアイン入善 富山県/下新川郡入善町上野7253-2 サービスエリアイン入善2F -3
Bar 柿Pi~ 富山県/黒部市前沢2380-2 -2


1 - 7 ( 7 件中 )