| 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 '%Rts%' OR A.skills LIKE '%Rts%') | 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 '%Rts%' OR A.skills LIKE '%Rts%')
| /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 '%Rts%' OR A.skills LIKE '%Rts%') 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 '%Rts%' OR A.skills LIKE '%Rts%')
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='75314' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75314'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73999' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73999'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='73992' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73992'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='72971' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72971'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71361' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71361'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='71061' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71061'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67770' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67770'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67150' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67150'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66244' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66244'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65823' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65823'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65109' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65109'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='64308' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='64308'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='64200' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='64200'
| /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='61779' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61779'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61743' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61743'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61097' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61097'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60367' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60367'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='59821' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59821'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='57937' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57937'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='56554' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56554'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='56280' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56280'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55811' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55811'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55369' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55369'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54325' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54325'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53773' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53773'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='53509' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53509'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52730' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52730'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52609' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52609'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='52112' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52112'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50643' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50643'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='49472' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49472'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='47738' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47738'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='47384' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47384'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='31073' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31073'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39961' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39961'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39319' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39319'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38474' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38474'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37465' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37465'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34721' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34721'
| /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()
|
