| 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 '%On%' OR A.skills LIKE '%On%') | 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 '%On%' OR A.skills LIKE '%On%')
| /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 '%On%' OR A.skills LIKE '%On%') 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 '%On%' OR A.skills LIKE '%On%')
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='6332' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6332'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6322' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6322'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6301' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6301'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6282' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6282'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6275' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6275'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6225' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6225'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6178' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6178'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6156' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6156'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6137' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6137'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6134' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6134'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6117' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6117'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6081' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6081'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6079' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6079'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6070' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6070'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6067' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6067'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6033' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6033'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6029' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6029'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6011' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6011'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5997' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5997'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5956' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5956'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5936' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5936'
| /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='5914' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5914'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5912' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5912'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5894' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5894'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5886' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5886'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5840' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5840'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5838' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5838'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5817' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5817'
| /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='5800' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5800'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5794' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5794'
| /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='5776' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5776'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5774' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5774'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5757' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5757'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5747' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5747'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5719' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5719'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5709' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5709'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5670' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5670'
| /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()
|
