| Match | Count | SQL | Script |
| SELECT * FROM wanttotrade as A, categories_wanttotrade B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%visitor%' OR A.skills LIKE '%visitor%') | 1 | SELECT COUNT(A.tradeid) AS total
FROM wanttotrade as A,
categories_wanttotrade B,
seoclerks.members C
WHERE A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%visitor%' OR A.skills LIKE '%visitor%')
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wanttotrade A, categories_wanttotrade B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%visitor%' OR A.skills LIKE '%visitor%') 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 wanttotrade A,
categories_wanttotrade B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND (A.tags LIKE '%visitor%' OR A.skills LIKE '%visitor%')
ORDER BY A.lastgigedit desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6064' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6064'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5801' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5801'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5735' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5735'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5657' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5657'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5581' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5581'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5633' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5633'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5630' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5630'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5582' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5582'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5540' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5540'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5571' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5571'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5544' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5544'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5543' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5543'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5493' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5493'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5458' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5458'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5390' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5390'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5369' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5369'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5306' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5306'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5225' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5225'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5192' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5192'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5187' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5187'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5176' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5176'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5169' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5169'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5083' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5083'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5044' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5044'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4846' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4846'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4743' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4743'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4584' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4584'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4269' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4269'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4018' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4018'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3887' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3887'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3693' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3693'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3335' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3335'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2963' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2963'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2608' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2608'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2149' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2149'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2144' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2144'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1971' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1971'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1970' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1970'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1882' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1882'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1861' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1861'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| 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()
|
