| 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 '%organic%' OR A.skills LIKE '%organic%') | 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 '%organic%' OR A.skills LIKE '%organic%')
| /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 '%organic%' OR A.skills LIKE '%organic%') 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 '%organic%' OR A.skills LIKE '%organic%')
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='76287' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76287'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76080' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76080'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75939' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75939'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75935' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75935'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75300' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75300'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75137' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75137'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74061' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74061'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74635' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74635'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74219' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74219'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73741' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73741'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72769' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72769'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72500' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72500'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72228' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72228'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72164' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72164'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71480' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71480'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='70937' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='70937'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='70766' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='70766'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='70560' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='70560'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='69163' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='69163'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68661' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68661'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68060' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68060'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67991' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67991'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66639' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66639'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66442' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66442'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66261' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66261'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65662' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65662'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65421' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65421'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63155' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63155'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62372' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62372'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61741' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61741'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61596' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61596'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61033' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61033'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60823' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60823'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60740' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60740'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60540' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60540'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60525' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60525'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60316' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60316'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60012' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60012'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='59656' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59656'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='59601' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59601'
| /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()
|
