| 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 '%on%' OR A.skills LIKE '%on%') | 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 '%on%' OR A.skills LIKE '%on%')
| /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 '%on%' OR A.skills LIKE '%on%') 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 '%on%' OR A.skills LIKE '%on%')
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='77116' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='77116'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='77078' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='77078'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76963' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76963'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76913' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76913'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76853' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76853'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76661' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76661'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76456' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76456'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76591' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76591'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76593' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76593'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76577' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76577'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76556' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76556'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76555' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76555'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76554' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76554'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76458' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76458'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76498' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76498'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76482' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76482'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76481' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76481'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76448' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76448'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76429' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76429'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76421' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76421'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76379' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76379'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76358' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76358'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76316' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76316'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76307' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76307'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76302' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76302'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76259' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76259'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76251' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76251'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76250' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76250'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76234' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76234'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76233' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76233'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76182' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76182'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76167' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76167'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76087' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76087'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76075' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76075'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76072' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76072'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76068' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76068'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76063' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76063'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76027' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76027'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76016' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76016'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='76015' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76015'
| /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()
|
