General
Name |
Open Connections |
Max Connections |
cfforum2000 |
33 |
INF |
magnus |
0 |
40 |
magnus_v2 |
0 |
100 |
_queryofquerydb |
1 |
100 |
sportsnetwork |
80 |
INF |
SQL Queries
|
Name |
Records |
Time |
Usage |
Datasource |
Source |
Line |
Cached |
|
getsettings
|
1 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/Application.cfm |
92 |
No |
SQL
select * from Competitionindex
|
|
navigator
|
1 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/Application.cfm |
106 |
No |
SQL
select * from navigate where ID = 1
|
|
getleague
|
1 |
0.329 ms |
- |
sportsnetwork |
/home/AsianBookie/Application.cfm |
172 |
No |
SQL (Merged Parameters)
SELECT ID,leaguename,leagueodds,leaguegif from oddsindex
where ID= '88'
SQL (Explicit Parameters)
SELECT ID,leaguename,leagueodds,leaguegif from oddsindex
where ID= {type: "CF_SQL_CHAR", value: '88'}
|
|
getsettings
|
1 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/header.cfm |
63 |
No |
SQL
select * from Competitionindex
|
|
playerdb
|
15 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/playerprofile.cfm |
1 |
No |
SQL
select *
from EPL
WHERE LEAGUE = "EPL"
|
|
top20
|
100 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop100.cfm |
8 |
No |
SQL
select MemberID, Username, Balance, rank, prank, streak,longeststreak,BETTEDTODAY
from Members
Where COMPETITIONSTARTED="Y" AND ActiveStatus = 'A' AND rank > 0
Order by Balance DESC, Username ASC
LIMIT 100
|
|
countplayers
|
1 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop100.cfm |
16 |
No |
SQL
select count(MemberID) as membercount
from Members
Where COMPETITIONSTARTED="Y" AND ActiveStatus='A' and rank > 0
and TEAM <> 8013
|
|
getleagues
|
6 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
58 |
No |
SQL
select distinct league from Matches
where Status <> '2' AND HIDDEN = "N" and dbMatchdatetime > now() - interval 111 minute AND dbMatchdatetime + INTERVAL 111 MINUTE < {ts '2025-06-22 12:51:00'}
order by dbMatchdatetime, League desc
|
|
JL2
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='JL2' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
GOLDCUP
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='GOLDCUP' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
SPL2
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='SPL2' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
JL1
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='JL1' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
KOR
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='KOR' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
MISC
|
10 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/quicktop10league.cfm |
80 |
No |
SQL
SELECT L.MemberID,L.PROFITLOST,L.Username,M.Streak,M.BETTEDTODAY FROM BESTOFLEAGUE L, Members M WHERE L.MemberID = M.MemberID and L.LEAGUE ='MISC' and L.SEASON="101" and M.TEAM <> 8013
ORDER BY PROFITLOST desc
limit 10
|
|
grabodds
|
0 |
0.557 ms |
- |
sportsnetwork |
/home/AsianBookie/displayodds.cfm |
58 |
No |
SQL (Merged Parameters)
SELECT
o.league, o.id, o.matchdate, o.home, o.away,
o.asianhandicap, o.ratea, o.odds, o.rateb,
o.neutral, o.althome, o.altaway,
o.HOMESWTEAMID, o.AWAYSWTEAMID, o.HOMEISO, o.AWAYISO,
o.homeposition, o.awayposition, o.ouratea, o.ourateb,
o.ouodds, o.decimal1, o.decimal2, o.decimal3,
o.asianpick, o.decimalpick, o.modified,
o.rateaprevious, o.oddsprevious, o.ourateaprevious, o.ouoddsprevious,
o.STREAMURL, o.oupick, o.showposition, o.showh2h,
o.score, o.yellowcards, o.redcards, o.scorestatus,
o.statustime, o.DURATION, o.matchhash, o.ngidhash,
o.limitedcoverage
FROM Odds o
INNER JOIN (
SELECT league, home, away, MAX(id) AS max_id
FROM Odds
WHERE inprogress = 'N'
AND score <> 'P-P'
AND league = 'asiancupodds'
GROUP BY league, home, away
) latest ON o.id = latest.max_id
WHERE o.matchdate > NOW() - INTERVAL 3 HOUR
ORDER BY
o.matchdate
,
o.home, o.odds, o.id
SQL (Explicit Parameters)
SELECT
o.league, o.id, o.matchdate, o.home, o.away,
o.asianhandicap, o.ratea, o.odds, o.rateb,
o.neutral, o.althome, o.altaway,
o.HOMESWTEAMID, o.AWAYSWTEAMID, o.HOMEISO, o.AWAYISO,
o.homeposition, o.awayposition, o.ouratea, o.ourateb,
o.ouodds, o.decimal1, o.decimal2, o.decimal3,
o.asianpick, o.decimalpick, o.modified,
o.rateaprevious, o.oddsprevious, o.ourateaprevious, o.ouoddsprevious,
o.STREAMURL, o.oupick, o.showposition, o.showh2h,
o.score, o.yellowcards, o.redcards, o.scorestatus,
o.statustime, o.DURATION, o.matchhash, o.ngidhash,
o.limitedcoverage
FROM Odds o
INNER JOIN (
SELECT league, home, away, MAX(id) AS max_id
FROM Odds
WHERE inprogress = 'N'
AND score <> 'P-P'
AND league = {type: "CF_SQL_VARCHAR", value: 'asiancupodds'}
GROUP BY league, home, away
) latest ON o.id = latest.max_id
WHERE o.matchdate > NOW() - INTERVAL 3 HOUR
ORDER BY
o.matchdate
,
o.home, o.odds, o.id
|
|
getforumqoq
|
32 |
0 ms |
- |
cfforum2000 |
/home/AsianBookie/chooseforum.cfm |
1 |
No |
SQL
select ForumID,ForumName,VIEWING,HOT
from Forums
|
|
getforum
|
1 |
0 ms |
- |
|
/home/AsianBookie/chooseforum.cfm |
225 |
No |
SQL
select ForumID,Forumname,VIEWING,HOT from getforumqoq where ForumID=44
|
|
getbookieofthemonth
|
1 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/bookieofthemonth.cfm |
1 |
No |
SQL
select * from Bookieofthemonth
where ID = 99
|
|
getbookieofthemonthdata
|
1 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/bookieofthemonth.cfm |
7 |
No |
SQL
select Data from Bookieofthemonth
where Bookie = "mansion88"
|
|
GETNEWS
|
8 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/inthenews3.cfm |
56 |
No |
SQL
select * from TRIBALNEWS
WHERE photo like "/news/%" AND COUNTRY="ENGLAND"
and DATETIME < NOW() - INTERVAL 15 MINUTE
ORDER BY ID DESC
LIMIT 8
|
|
displaydata
|
1 |
0 ms |
- |
sportsnetwork |
/home/AsianBookie/attheforums.cfm |
1 |
No |
SQL
select * from AutoRefresh
where name = 'forumrefresh'
order by Lastchanged DESC limit 1
|
|
thereislive
|
0 |
0.246 ms |
- |
sportsnetwork |
/home/AsianBookie/footer.cfm |
163 |
No |
SQL
select home,away,id,matchdate,scorestatus from Odds
where INPROGRESS="N" and SCORE <> "P-P" and league='asiancupodds'
GROUP BY HOME,AWAY,SCORESTATUS
order by scorestatus desc,matchdate
limit 3
|
|
|