| 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=51 | 1 | SELECT CATID FROM categories_wanttobuy WHERE parentid=51
| /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='Data-Entry' AND category IN (51) | 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='Data-Entry' AND category IN (51)
| /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='Data-Entry' AND category IN (51) 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 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='Data-Entry' AND category IN (51)
ORDER BY A.lastgigedit desc
LIMIT 0,40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='77211' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='77211'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76918' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76918'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76647' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76647'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76527' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76527'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76190' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76190'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75976' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75976'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75898' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75898'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75816' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75816'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75250' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75250'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75048' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75048'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74350' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74350'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74267' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74267'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74137' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74137'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74021' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74021'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73948' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73948'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73748' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73748'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73573' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73573'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73527' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73527'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73278' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73278'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73177' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73177'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72867' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72867'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72833' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72833'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72757' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72757'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72749' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72749'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72613' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72613'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72534' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72534'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72470' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72470'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72455' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72455'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72450' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72450'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72446' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72446'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72414' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72414'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72168' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72168'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71999' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71999'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71860' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71860'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71811' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71811'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71743' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71743'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71629' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71629'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71602' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71602'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71452' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71452'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71345' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71345'
| /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()
|
