| 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 '%Followrequirem%' OR A.skills LIKE '%Followrequirem%') | 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 '%Followrequirem%' OR A.skills LIKE '%Followrequirem%')
| /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 '%Followrequirem%' OR A.skills LIKE '%Followrequirem%') 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 '%Followrequirem%' OR A.skills LIKE '%Followrequirem%')
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='66407' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='66407'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='42859' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='42859'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38116' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38116'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='38057' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='38057'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37954' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37954'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37703' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37703'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='37278' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='37278'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36806' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36806'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36673' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36673'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36630' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36630'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='36478' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='36478'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='35548' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='35548'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34579' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34579'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='34242' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='34242'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33441' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33441'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='33342' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='33342'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32818' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32818'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32695' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32695'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32682' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32682'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='32259' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='32259'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29997' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29997'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='29668' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='29668'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='26230' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='26230'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25435' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25435'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25198' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25198'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='25000' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='25000'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='24070' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24070'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='23894' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23894'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='23067' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='23067'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22961' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22961'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='22876' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='22876'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='21898' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='21898'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='21811' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='21811'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='21277' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='21277'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='19876' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19876'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='19828' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19828'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='19760' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='19760'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='18775' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='18775'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='17680' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='17680'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='16032' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='16032'
| /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()
|
