| Match | Count | SQL | Script |
| 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 categories_wanttobuy WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_wanttobuy WHERE seo=?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo()
|
| SELECT * FROM categories_wanttobuy WHERE parentid=19 | 1 | SELECT CATID FROM categories_wanttobuy WHERE parentid=19
| /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() ()
|
| 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 B.seo='Forums' AND category IN (19,31,36) | 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 B.seo='Forums' AND category IN (19,31,36)
| /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 B.seo='Forums' AND category IN (19,31,36) ORDER BY A.bdays 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 B.seo='Forums' AND category IN (19,31,36)
ORDER BY A.bdays desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34042' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34042'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52818' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52818'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='8857' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='8857'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33186' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33186'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29014' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29014'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='31174' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31174'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='16879' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16879'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='18543' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='18543'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36628' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36628'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38170' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38170'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='1805' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1805'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='9256' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9256'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='1425' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1425'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='5001' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='5001'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='6634' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='6634'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='12357' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='12357'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50737' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50737'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60026' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60026'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65903' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65903'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61531' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61531'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68005' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68005'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68006' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68006'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68007' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68007'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67715' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67715'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53696' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53696'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61259' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61259'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='1444' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1444'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='1598' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='1598'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='2310' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2310'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='2836' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2836'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='3704' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='3704'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='9343' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9343'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='48512' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='48512'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50327' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50327'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62576' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62576'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66305' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66305'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72790' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72790'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='12903' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='12903'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36868' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36868'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58305' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58305'
| /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()
|
