| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.114' | 1 | SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.114'
| /opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once()
|
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400
| /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
|
| SELECT * FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%5000%' OR A.skills LIKE '%5000%') | 1 | SELECT COUNT(A.wantid) AS total
FROM wanttobuy as A,
categories_wanttobuy B,
seoclerks.members C
WHERE A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%5000%' OR A.skills LIKE '%5000%')
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%5000%' OR A.skills LIKE '%5000%') ORDER BY A.lastgigedit desc LIMIT 0,40 | 1 | SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture
FROM wanttobuy A,
categories_wanttobuy B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%5000%' OR A.skills LIKE '%5000%')
ORDER BY A.lastgigedit desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68187' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68187'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58910' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58910'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58829' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58829'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='57530' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57530'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53422' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53422'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53277' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53277'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53057' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53057'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52689' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52689'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38830' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38830'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='51209' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51209'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='46867' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46867'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='46210' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46210'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43841' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43841'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42754' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42754'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='40685' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='40685'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39766' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39766'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39492' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39492'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38326' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38326'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36570' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36570'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34583' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34583'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32944' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32944'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32316' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32316'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30999' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30999'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30125' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30125'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28827' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28827'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28771' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28771'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28733' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28733'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28574' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28574'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28272' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28272'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28239' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28239'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28059' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28059'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28058' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28058'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='27489' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='27489'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25182' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25182'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25044' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25044'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22330' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22330'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22090' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22090'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='20363' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='20363'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='18458' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='18458'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='18282' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='18282'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM categories | 1 | SELECT * FROM categories
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
|
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
|
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
|
