| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=848430 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=848430
| /opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()
|
| SELECT * FROM categories | 1 | SELECT * FROM categories
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| SELECT * FROM seoclerks.members WHERE USERID='996228' | 1 | SELECT * FROM seoclerks.members WHERE USERID='996228'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='848430' 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='848430'
AND A.RATER=B.USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM orders WHERE PID='848430' 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='848430'
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='848430' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='848430'
| /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='996228' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='996228' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='996228' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='996228' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='996228' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='996228' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='996228' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='996228' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='996228' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='996228' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| 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()
|
NPAGE SEO:- 1.Complete S.E.O Audit 2.Keywords Research 3.Competitors Analysis 4.Page Speed optimization 5.S.E.O optimized Title Tag 6.S.E.O optimized Meta Description 7.Maintain keywords density 8.URL Optimization 9.Adding Sitemap 10.Installation and optimization of Yoast SEO Plugin 11.Uploading Robots.txt 12.Adding canonical tag 13.Adding contextual internal link 14.Setup Google webmaster tool 15.Local S.E.O OFF-PAGE S.E.O (LINK BUILDING):-
