| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='sharpcoders' AND status='1' | 1 | SELECT *
FROM seoclerks.members
WHERE username='sharpcoders'
AND status='1'
| /opt/clerks-staging/docroot/user.php 54 () ()
|
| SELECT * FROM seoclerks.members WHERE USERID='20014' | 1 | SELECT lastlogin FROM seoclerks.members WHERE USERID='20014'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays()
|
| SELECT * FROM posts WHERE USERID=20014 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=20014
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()
|
| SELECT * FROM follow F, members M WHERE F.FOLLOWING=20014 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4 | 1 | SELECT F.USERID,
M.profilepicture,
M.username,
M.userlevel,
M.status
FROM follow F, members M
WHERE F.FOLLOWING=20014
AND F.USERID = M.USERID
ORDER BY F.time_added
DESC LIMIT 4
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
|
| SELECT * FROM follow F, members M WHERE F.USERID=20014 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4 | 1 | SELECT F.FOLLOWING AS USERID,
M.profilepicture,
M.username,
M.userlevel,
M.status
FROM follow F, members M
WHERE F.USERID=20014
AND F.FOLLOWING = M.USERID
ORDER BY F.time_added
DESC LIMIT 4
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
|
| SELECT * FROM follow WHERE FOLLOWING=20014 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=20014
| /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
|
| SELECT * FROM follow WHERE USERID=20014 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE USERID=20014
| /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
|
| SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99 | 1 | SELECT
count(A.PID) AS total
FROM
posts A,
seoclerks.members C
WHERE A.active = '1'
AND A.USERID = C.USERID
AND A.USERID = ?
AND A.type != 99
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
C.profilepicture
FROM
posts A,
seoclerks.members C
WHERE A.active = 1
AND A.type != 99
AND A.USERID = C.USERID
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM categories_software | 1 | SELECT * FROM categories_software
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| SELECT * FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? | 1 | SELECT
count(A.wantid) AS total
FROM
wanttobuy A,
seoclerks.members C
WHERE A.active = 1
AND A.USERID = C.USERID
AND A.USERID = ?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
D.seo
FROM
wanttobuy A,
seoclerks.members C,
categories_wanttobuy D
WHERE A.active = 1
AND A.USERID = C.USERID
AND D.CATID = A.category
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='11045' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='11045'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM categories_wanttotrade WHERE seo='body-ads' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='body-ads'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
|
| SELECT * FROM wantbids WHERE active=1 AND wantid='6511' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='6511'
| /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
|
| SELECT * FROM categories_wanttotrade WHERE seo='Blogs' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Blogs'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
|
| SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC | 1 | SELECT
count(A.tradeid) AS total
FROM
wanttotrade A,
seoclerks.members C
WHERE A.active = 1
AND A.USERID = C.USERID
AND A.USERID = ?
ORDER BY A.tradeid DESC
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
D.seo
FROM
wanttotrade A,
seoclerks.members C,
categories_wanttotrade D
WHERE A.active = '1'
AND A.USERID = C.USERID
AND D.CATID = A.category
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='20014' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
codeclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='20014'
ORDER BY A.lastgigedit DESC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='20014' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
listingdock.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='20014'
ORDER BY A.lastgigedit DESC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='20014' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
pixelclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='20014'
ORDER BY A.lastgigedit DESC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='20014' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
wordclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='20014'
ORDER BY A.lastgigedit DESC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1 | 1 | SELECT time
FROM inbox2
WHERE MSGFROM = ?
AND action = 'delivery'
ORDER BY time
DESC LIMIT 1
| /opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='20014' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='20014' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='20014' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='20014' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='20014' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='20014' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='20014' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='20014' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='20014' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='20014' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| 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()
|
