| 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 CATID='17' | 1 | SELECT CATID, seo, name, h2header, metatitle, metakeywords, metadescription, metaheader, image_name FROM categories_wanttobuy WHERE CATID='17'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
|
| SELECT * FROM categories_wanttobuy WHERE parentid=30 | 1 | SELECT CATID FROM categories_wanttobuy WHERE parentid=30
| /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='Site-Links-Sales' AND category IN (30) | 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='Site-Links-Sales' AND category IN (30)
| /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='Site-Links-Sales' AND category IN (30) ORDER BY A.viewcount 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='Site-Links-Sales' AND category IN (30)
ORDER BY A.viewcount desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42779' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42779'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50282' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50282'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='51108' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51108'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='48894' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='48894'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='47703' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47703'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24920' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24920'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='44102' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44102'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63545' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63545'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53863' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53863'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45511' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45511'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49990' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49990'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42859' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42859'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22294' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22294'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62434' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62434'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='14544' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='14544'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50822' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50822'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63137' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63137'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='43667' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='43667'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='40241' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='40241'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39047' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39047'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50236' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50236'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49020' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49020'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='2996' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2996'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62203' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62203'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29048' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29048'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38748' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38748'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24273' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24273'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='44119' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44119'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='20855' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='20855'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='21668' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='21668'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='4690' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4690'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30019' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30019'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62736' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62736'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='41910' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='41910'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='44366' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44366'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22233' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22233'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='16923' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16923'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34083' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34083'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='9186' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9186'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='23935' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23935'
| /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()
|
