| Match | Count | SQL | Script |
| SELECT * FROM categories_wanttotrade WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_wanttotrade WHERE seo=?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo()
|
| SELECT * FROM categories_wanttotrade WHERE parentid=29 | 1 | SELECT CATID FROM categories_wanttotrade WHERE parentid=29
| /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() ()
|
| 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 B.seo='Programming' AND category IN (29) | 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 B.seo='Programming' AND category IN (29)
| /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 B.seo='Programming' AND category IN (29) 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 wanttotrade A,
categories_wanttotrade B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND B.seo='Programming' AND category IN (29)
ORDER BY A.viewcount desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5383' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5383'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3332' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3332'
| /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='5314' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5314'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5378' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5378'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1404' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1404'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5534' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5534'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4227' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4227'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='160' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='160'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2019' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2019'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5271' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5271'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='952' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='952'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1173' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1173'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2394' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2394'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4270' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4270'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5601' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5601'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1110' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1110'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1908' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1908'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1068' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1068'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4223' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4223'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1520' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1520'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4491' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4491'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1042' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1042'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4814' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4814'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5569' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5569'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5093' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5093'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5746' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5746'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5172' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5172'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5491' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5491'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5092' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5092'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5036' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5036'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5518' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5518'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5583' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5583'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5897' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5897'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6025' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6025'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5494' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5494'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5177' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5177'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5748' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5748'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5159' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5159'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5895' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5895'
| /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()
|
