| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400
| /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
|
| SELECT * FROM posts WHERE PID=742277 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=742277
| /opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()
|
| SELECT * FROM categories_software | 1 | SELECT * FROM categories_software
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| SELECT * FROM seoclerks.members WHERE USERID='411538' | 1 | SELECT * FROM seoclerks.members WHERE USERID='411538'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='742277' AND A.RATER=B.USERID | 1 | SELECT COUNT(A.RID) as total,
SUM(bad) as badTotal,
SUM(good) as goodTotal
FROM
ratings A,
seoclerks.members B
WHERE A.PID='742277'
AND A.RATER=B.USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM orders WHERE PID='742277' AND status in (1, 4, 6) | 1 | SELECT
OID,
stime,
extradays1,
extradays2,
extradays3,
extra1ordered,
extra2ordered,
extra3ordered,
days,
status,
quantity,
extras_data
FROM
orders
WHERE PID='742277'
AND status in (1, 4, 6)
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| UPDATE posts SET viewcount = viewcount + 1 WHERE PID='742277' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='742277'
| /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='411538' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='411538' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='411538' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='411538' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='411538' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='411538' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='411538' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='411538' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='411538' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='411538' 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()
|
| SELECT * FROM categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()
|
| SELECT * FROM seoclerks.members WHERE USERID=? | 1 | SELECT usergroup
FROM seoclerks.members
WHERE USERID=?
| /opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()
|
Right now, it’s all about sights and sounds… that’s the next big thing…what they can convey to you with audio recordings… or animations. Hence, the increase in video based squeeze pages.
