robertman11
Level 2
Write the reason you're deleting this FAQ
I want to collect all the backlinks to my site to go through and discover the bad ones. Google Webmaster tools/console only has a small portion. What is the best method to obtain all backlinks of my site for review?
Are you sure you want to delete this post?
Well the first thing to do is do it manually in Google search results using the minus site operator of [b]-site:yoursite.com "yoursite.com"[/b].
This will show you all the results where your site is indexed to but none of your actual site results. So for instance, if I wanted to see how many sites there are that are linking to seoclerks.com for example (whether they be hyperlinked URLs or just citations) I would use;
[size=120][b]-site:seoclerks.com "seoclerks.com"[/b][/size]
Of course, seoclerks.com also has seoclerk.com so for that you would want to minus out both sites from showing in the results but also tell it to search for and show all results from the other domain too with this operator;
[size=120][b]-site:seoclerks.com -site: seoclerk.com "seoclerks.com" + "seoclerk.com"[/b][/size]
That tells it to find all results showing for both seoclerks.com and seoclerk.com but minus out those sites from the results. Just apply the same method using your own sites domain name. That only applies for Google though. The search operators to use for Bing/Yahoo are a little different. You can search for "bing and yahoo search operators or they do provide an Advanced Search Form here: [color=#0000FF]https://search.yahoo.com/web/advanced[/color] but its still not as comprehensive as say the Google Advanced Search Form: [color=#0000FF]https://www.google.com/advanced_search[/color]
The above mentioned crawlers can help as well. But there are literally so many backlink count site out there now that can do the job just as well as any paid service can. Just do a Google search for "how to find my backlinks" and you'll find many free services that will be more than adequate in finding them.
But one tool I can definitely [b]recommend[/b] using is [size=120][b]ScrapeBox[/b][/size]. I've been an owner/user of ScrapeBox for the past 5 years now. It was one of the first tools I ever purchased because it is so flexible and has a lot of features for webmasters. One of them is the Link Harvester and the Backlink Checker which literally enables you to download up to 1000 backlinks for a URL or a domain for analysic. The backlinks are ordered from highest to lowest for you by MozRank and can be exported as a text file, csv etc provided you set up a free Moz API and provided you own a copy of ScrapeBox that is.
I hope this is insightful for you! :)
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='9857' | 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='9857' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='9' | 1 | SELECT * FROM seoclerks.members WHERE USERID='9' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=9 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=9 | /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=9857 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=9857
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9857' 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='9857' 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=38336 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=38336
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=38386 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=38386
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=38620 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=38620
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=165903 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=165903
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9857' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9857' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9857' AND status='1' AND (question like '% collect backlinks?%' OR question like '%collect%' OR question like '%backlinks?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9857' AND status='1'
AND (question like '% collect backlinks?%' OR question like '%collect%' OR question like '%backlinks?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4059' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4059' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2572' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2572' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='7299' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7299' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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=9857%' 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=9857%'
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='4.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| 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='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='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 |
Void
And any others you can find. Use the list from GWTs as well. You'll have to use multiple sources, not just one. Google webmaster tools only has the latest ones found and is not a complete reference. I'd suggest signing up for several link crawling companies and combining all of their links together. Here are some: [list][*][url=https://majestic.com]Majestic[/url][/*][*][url=https://ahrefs.com]Ahrefs[/url][/*][*][url=https://moz.com]Moz[/url][/*][/list] And any others you can find. Use the list from GWTs as well.
Are you sure you want to delete this post?