| 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 '%Translator%' OR A.skills LIKE '%Translator%') | 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 '%Translator%' OR A.skills LIKE '%Translator%')
| /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 '%Translator%' OR A.skills LIKE '%Translator%') 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 '%Translator%' OR A.skills LIKE '%Translator%')
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='68326' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68326'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='66293' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66293'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='65706' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='65706'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='60791' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='60791'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='61338' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61338'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='55334' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55334'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36668' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36668'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37008' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37008'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36576' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36576'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='31952' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='31952'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29015' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29015'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='28707' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='28707'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22251' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22251'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22250' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22250'
| /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()
|
