| Match | Count | SQL | Script |
| 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 (A.tags LIKE '%Guarantee%' OR A.skills LIKE '%Guarantee%') | 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 (A.tags LIKE '%Guarantee%' OR A.skills LIKE '%Guarantee%')
| /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 (A.tags LIKE '%Guarantee%' OR A.skills LIKE '%Guarantee%') 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 (A.tags LIKE '%Guarantee%' OR A.skills LIKE '%Guarantee%')
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='75966' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75966'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='75935' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75935'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='69347' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='69347'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='68107' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68107'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66639' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66639'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65935' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65935'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63916' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63916'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63591' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63591'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='63508' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63508'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60277' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60277'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58205' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58205'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='58043' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58043'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54099' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54099'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52064' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52064'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='51636' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51636'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50993' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50993'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49653' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49653'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='41405' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='41405'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='40351' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='40351'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38765' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38765'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36466' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36466'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33883' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33883'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32329' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32329'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30260' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30260'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29184' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29184'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28109' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28109'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='27321' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='27321'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25172' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25172'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24925' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24925'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15086' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15086'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='23421' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23421'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='20363' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='20363'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='19872' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19872'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='18351' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='18351'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='17218' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='17218'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15502' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15502'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15341' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15341'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15096' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15096'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='11044' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='11044'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='14803' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='14803'
| /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()
|
