| 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 '%Programing%' OR A.skills LIKE '%Programing%') | 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 '%Programing%' OR A.skills LIKE '%Programing%')
| /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 '%Programing%' OR A.skills LIKE '%Programing%') 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 '%Programing%' OR A.skills LIKE '%Programing%')
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='75468' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75468'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| 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='75083' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75083'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='74060' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74060'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='67370' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='67370'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='64606' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='64606'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='59569' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59569'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='59156' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59156'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='57917' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57917'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55611' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55611'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54995' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54995'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54445' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54445'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='54408' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54408'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='50625' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50625'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='44755' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44755'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42967' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42967'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='41713' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='41713'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='41514' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='41514'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='40762' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='40762'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='40172' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='40172'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='39879' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='39879'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38287' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38287'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37951' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37951'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37349' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37349'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33967' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33967'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='31252' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31252'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30405' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30405'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='30262' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='30262'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28317' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28317'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='27221' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='27221'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25154' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25154'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25054' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25054'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24076' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24076'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='20373' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='20373'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='17917' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='17917'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15919' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15919'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='15711' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='15711'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='14542' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='14542'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='14422' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='14422'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='14344' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='14344'
| /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()
|
