| 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 '%Python%' OR A.skills LIKE '%Python%') | 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 '%Python%' OR A.skills LIKE '%Python%')
| /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 '%Python%' OR A.skills LIKE '%Python%') 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 '%Python%' OR A.skills LIKE '%Python%')
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='77078' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='77078'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76963' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76963'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76555' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76555'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76498' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76498'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76358' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76358'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75913' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75913'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75491' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75491'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75403' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75403'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75145' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75145'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74955' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74955'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74746' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74746'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74078' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74078'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74060' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74060'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73322' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73322'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72532' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72532'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71851' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71851'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71447' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71447'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71113' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71113'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71095' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71095'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='70728' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='70728'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68083' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68083'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67951' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67951'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66240' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66240'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66134' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66134'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65809' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65809'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65229' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65229'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63939' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63939'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63514' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63514'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63114' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63114'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60379' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60379'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58215' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58215'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='57663' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57663'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55169' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55169'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53034' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53034'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53033' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53033'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52842' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52842'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49545' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49545'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33493' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33493'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33165' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33165'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='27819' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='27819'
| /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()
|
