Hello!
Dear Respective Client, Thank you for viewing my profile!
I will manually create Citations in high PA and high DA local directories. Local Citations helps to boost Google place ranking and local business in online. Local Citations are highly recommended for better Google local search results. I will create business listing/citations in local citation sites which help search engines (especially Google) and new customers find your business online. I have done a lot of USA citations projects. My best service offering you guaranteed Local SEO/Citation for your business.
I'm a local Citation expert. I have a list of high DA and high PA USA business directories. My service is 100 % manual, safe and highest quality links will improve your SEO and ranking in SERP and will get popular in USA region to increase your product sale.
What we will do:
1. I will submit your business in top USA local citation sites.
2. Will make sure business details are consistent across all the local sites.
3. Will report all the submissions and activation's details in easy to understand and accessible format.
4. We will provide logins for each and every citation we created
| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=671503 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=671503 | /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='494876' | 1 | SELECT * FROM seoclerks.members WHERE USERID='494876' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='671503' 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='671503'
AND A.RATER=B.USERID | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM portfolio WHERE PID='671503' ORDER BY id ASC LIMIT 10 | 1 | SELECT
*
FROM
portfolio
WHERE PID='671503'
ORDER BY id ASC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM orders WHERE PID='671503' 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='671503'
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='671503' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='671503' | /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() () |
| SELECT * FROM seoclerks.ratings WHERE USERID='494876' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='494876' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM codeclerks.ratings WHERE USERID='494876' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='494876' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM listingdock.ratings WHERE USERID='494876' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='494876' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM pixelclerks.ratings WHERE USERID='494876' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='494876' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM wordclerks.ratings WHERE USERID='494876' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='494876' 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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.172767 | 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 | 0.172767 | 0.172767 |
