| Match | Count | SQL | Script |
| SELECT * FROM categories_wanttobuy WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_wanttobuy WHERE seo=?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo()
|
| SELECT * FROM categories_wanttobuy WHERE parentid=42 | 1 | SELECT CATID FROM categories_wanttobuy WHERE parentid=42
| /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() ()
|
| SELECT * FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND B.seo='design' AND category IN (42) | 1 | SELECT COUNT(A.wantid) AS total
FROM wanttobuy as A,
categories_wanttobuy B,
seoclerks.members C
WHERE A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND B.seo='design' AND category IN (42)
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND B.seo='design' AND category IN (42) 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 wanttobuy A,
categories_wanttobuy B,
seoclerks.members C
WHERE
A.active = 1 AND
A.category = B.CATID AND
A.USERID = C.USERID
AND B.seo='design' AND category IN (42)
ORDER BY A.viewcount desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54068' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54068'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25750' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25750'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='4095' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4095'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65722' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65722'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='8103' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='8103'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='41468' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='41468'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45406' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45406'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62495' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62495'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52019' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52019'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54841' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54841'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='45833' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='45833'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='9839' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='9839'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39051' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39051'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='16030' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16030'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49750' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49750'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='21160' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='21160'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53269' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53269'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='27956' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='27956'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24085' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24085'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49642' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49642'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='2759' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='2759'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='4899' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='4899'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68114' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68114'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54528' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54528'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='57816' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57816'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50404' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50404'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58933' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58933'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38019' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38019'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52968' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52968'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67066' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67066'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='62806' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62806'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='10684' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='10684'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='13727' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='13727'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49791' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49791'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63879' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63879'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49412' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49412'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58503' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58503'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='48747' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='48747'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='3069' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='3069'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67851' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67851'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| 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()
|
