| 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 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 '%Hits%' OR A.skills LIKE '%Hits%') | 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 '%Hits%' OR A.skills LIKE '%Hits%')
| /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 '%Hits%' OR A.skills LIKE '%Hits%') 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 '%Hits%' OR A.skills LIKE '%Hits%')
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='74058' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74058'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71715' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71715'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='69112' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='69112'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65666' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65666'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='64160' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='64160'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61717' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61717'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='56864' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56864'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55614' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55614'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55473' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55473'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54836' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54836'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54678' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54678'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54479' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54479'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54411' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54411'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54085' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54085'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54078' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54078'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53951' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53951'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53217' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53217'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53180' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53180'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='51516' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51516'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49574' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49574'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49228' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49228'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49094' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49094'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='47756' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47756'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='46862' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46862'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='46404' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46404'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='46035' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='46035'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45866' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45866'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45865' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45865'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45817' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45817'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='44218' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44218'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43782' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43782'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43753' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43753'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43665' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43665'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43610' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43610'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43446' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43446'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43356' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43356'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42644' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42644'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42597' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42597'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42336' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42336'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42122' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42122'
| /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()
|
