| 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 '%post%' OR A.skills LIKE '%post%') | 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 '%post%' OR A.skills LIKE '%post%')
| /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 '%post%' OR A.skills LIKE '%post%') 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 '%post%' OR A.skills LIKE '%post%')
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='6318' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6318'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6038' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6038'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6001' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6001'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5975' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5975'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5829' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5829'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5783' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5783'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5637' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5637'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5588' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5588'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5576' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5576'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5574' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5574'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5570' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5570'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5573' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5573'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5474' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5474'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5310' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5310'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5226' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5226'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5224' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5224'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5182' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5182'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5085' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5085'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4994' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4994'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4917' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4917'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4727' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4727'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4385' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4385'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4352' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4352'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4328' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4328'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4183' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4183'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4142' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4142'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4063' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4063'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4031' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4031'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3936' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3936'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3918' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3918'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3917' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3917'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3883' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3883'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3794' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3794'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3488' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3488'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3465' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3465'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3399' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3399'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2800' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2800'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2164' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2164'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2306' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2306'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1045' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1045'
| /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()
|
