| 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=17 | 1 | SELECT CATID FROM categories_wanttotrade WHERE parentid=17
| /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='Link-Building' AND category IN (17,30) | 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='Link-Building' AND category IN (17,30)
| /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='Link-Building' AND category IN (17,30) ORDER BY A.bdays 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='Link-Building' AND category IN (17,30)
ORDER BY A.bdays desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='296' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='296'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1457' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1457'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1643' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1643'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4386' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4386'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3891' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3891'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4083' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4083'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1478' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1478'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5202' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5202'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='983' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='983'
| /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='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='5787' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5787'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1790' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1790'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='648' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='648'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2115' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2115'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5597' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5597'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3870' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3870'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='469' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='469'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5941' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5941'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6133' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6133'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='6393' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='6393'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2126' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2126'
| /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='712' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='712'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='3304' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='3304'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4324' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4324'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='5635' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5635'
| /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='4199' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4199'
| /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='5084' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='5084'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='190' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='190'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='261' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='261'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='604' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='604'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='1516' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='1516'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4000' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4000'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2505' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2505'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='2863' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='2863'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4751' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4751'
| /opt/clerks-staging/docroot/include/functions/main.php 18513 GetTotalWTTBids() ChangeWTTPostData()
|
| SELECT * FROM tradebids WHERE active=1 AND tradeid='4992' | 1 | SELECT COUNT(bidid) AS total FROM tradebids WHERE active=1 AND tradeid='4992'
| /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()
|
