anwebservices
Level X5
Write the reason you're deleting this FAQ
Lately i was reading a lot about some changes and new tactics and trends regarding search engine optimization and how to use it to boost my website SERP. However it's still confusing and too many different things to do QUALITY SEO. Please share your thoughts, what is working best for you to improve SERP on Google and Bing or Yahoo.
Also, how important is mobile SEO and do you get much sales from mobile users?
Razzy, thanks for your answer, but this is well known and old story to have [b]quality and unique contents[/b]. Also you mention PR websites while PR does not exist any more. I was interested in [b]LATEST SEO TRENDS[/b], something new which i don't know yet :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='9855' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='9855' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='254580' | 1 | SELECT * FROM seoclerks.members WHERE USERID='254580' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=254580 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=254580 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=9855 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=9855
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9855' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='9855' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=38391 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=38391
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=38394 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=38394
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=38621 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=38621
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=38403 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=38403
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=38622 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=38622
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=154055 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=154055
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9855' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9855' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9855' AND status='1' AND (question like '% current SEO trends 2016 boost SERP?%' OR question like '%current%' OR question like '%trends%' OR question like '%2016%' OR question like '%boost%' OR question like '%SERP?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9855' AND status='1'
AND (question like '% current SEO trends 2016 boost SERP?%' OR question like '%current%' OR question like '%trends%' OR question like '%2016%' OR question like '%boost%' OR question like '%SERP?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='21832' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='21832' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4674' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4674' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17847' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17847' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9399' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9399' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='873' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='873' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=9855%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=9855%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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 seoclerks.members WHERE USERID='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='254580.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='311920.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='311920.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
This does take work, and it's not easy since you have to generate a lot of quality content. But this will differentiate you from the people wanting to use software to post. You'll have the better content since it will not be spun and the readers will actually like it and possibly share it.
High quality content on a high PR website plus a tiered linking system is always a good method that helps websites get ranked. Try it out and let me know what you think.
If you're doing this yourself it could take a while. If you can afford it, I advise searching on SeoClerks and hiring a VA (Virtual Assistant) and have them write up quality content, do the posting and tiered linking for you. Be sure to do your due diligence because this will be for your website and you don't want any random person just going in and screwing up your rankings forever.
Also, if you can set up a private blog network and control everything about it, that will definitely get your ranked. But that is even more work compared to the quality content on third party websites and tier linking them. It's more work because lets say you have 10 blogs, you'd have to do 10 times the content. It's very worth it, but it does take 10 times longer to do unless you can afford Virtual Assistants. You would also have to tier link these blog posts in order to rank as well.
So, in a nutshell:
- High quality content
- High PR websites
- Tiered linking
- PBNs with tiered linking if you can afford to pay for a good VA
Thanks,
Razzy [i][b]Content marketing[/b][/i] is a big thing right now. And not just any spun content, it has to be high quality and unique. Take your time to write up a good article and post it on a high PR website that has decent traffic. This way you'll get the benefit from the PR, the backlink itself, and there's a possibility you'll be getting some traffic from that website itself. You could even build a few links aimed at your post and get the article on the third party website ranked. I've done that plenty of times with my websites and they've been ranked pretty quickly and stayed on top for a while. This does take work, and it's not easy since you have to generate a lot of quality content. But this will differentiate you from the people wanting to use software to post. You'll have the better content since it will not be spun and the readers will actually like it and possibly share it. High [i][b]quality content[/b][/i] on a high PR website plus a tiered linking system is always a good method that helps websites get ranked. Try it out and let me know what you think. If you're doing this yourself it could take a while. If you can afford it, I advise searching on SeoClerks and hiring a VA (Virtual Assistant) and have them write up quality content, do the posting and tiered linking for you. Be sure to do your due diligence because this will be for your website and you don't want any random person just going in and screwing up your rankings forever. Also, if you can set up a private blog network and control everything about it, that will definitely get your ranked. But that is even more work compared to the quality content on third party websites and tier linking them. It's more work because lets say you have 10 blogs, you'd have to do 10 times the content. It's very worth it, but it does take 10 times longer to do unless you can afford [i][b]Virtual Assistants[/b][/i]. You would also have to tier link these blog posts in order to rank as well. So, in a nutshell: - High quality content - High PR websites - Tiered linking - PBNs with tiered linking if you can afford to pay for a good VA Thanks, Razzy
Are you sure you want to delete this post?