Cathrina
Level 1
Write the reason you're deleting this FAQ
How do I find out how many backlinks my site has?
Are you sure you want to delete this post?
Umm why is everyone being so Lazy? If you want shoddy results, then use a free service - In terms of getting a grip on where you stand, you want to be precise so you don't waste time and don't get deindexed on accident. Go to Alexa.com and pay for the SEO lookup, its not that expensive, less than $20 bucks in fact, and you will get the entire break down of your sites back link structure.
That backlinkfinder you guys are recommending does not even accurately transcribe my DMOZ status for any of my sites, nor the Pagerank correctly, those are huge factors when building your plans for building sites... So i would highly recommend finding your info at Alexa.com (You can use their free look up if you dont have $$) But don't take it from me... I only have 11 years experience with SEO and own the 7th largest private email services provider on the net :)
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='646' | 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='646' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='3080' | 1 | SELECT * FROM seoclerks.members WHERE USERID='3080' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=3080 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=3080 | /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=646 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=646
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='646' 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='646' 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=39132 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=39132
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=5260 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=5260
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=5267 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=5267
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='646' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='646' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='646' AND status='1' AND (question like '%How I find backlinks site has?%' OR question like '%find%' OR question like '%backlinks%' OR question like '%site%' OR question like '%has?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='646' AND status='1'
AND (question like '%How I find backlinks site has?%' OR question like '%find%' OR question like '%backlinks%' OR question like '%site%' OR question like '%has?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| 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='707' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='707' 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=646%' 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=646%'
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='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='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='7465.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7465.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 |
idealmike
The other option is to use a website that can do it such as one of those free backlink checker sites. However all they really do is the exact same thing that is done here manually anyway only they provide the results as a list for you. Some are more complex and comprehensive than others and will show you a lot more stuff such as what anchor text was used to create it, how old it is, what the metrics of the page where it's on are such as the PA, DA, mozRank, Alexa rating etc etc. But these aren't always accurate either.
As mentioned here already as well, another option is to use ScrapeBox, you can get really clever using ScrapeBox to scrape your sites backlinks. You can use the above search operators but also some advanced ones as well. You might need to use some proxies to prevent your IP being temporarily banned from doing all that scraping in Google but you can use ScrapeBox for that too. That's why they call it the allinone Swiss knife for SEO's and webmasters. The first option is to check using Google search operators. Simply go to Google and search using [color=#0000FF][b]"yoursite.com" -site:yoursite.com[/b][/color]. What that will do will show any sites that have your site on them as a backlink or some other type of link or just a citation perhaps. But also minus out any results from your own domain as well. So if I wanted to see how many backlinks are showing for seoclerks.com I would search in Google for [b]"seoclerks.com" -site:seoclerks.com[/b] and that shows me it's saying "[color=#0000FF][b]about 91,400 results[/b][/color]". I could also filter our results from seoclerks.com as well using the operator of [color=#0000FF][b]"seoclerks.com" -site:seoclerks.com -site:seoclerk.com[/b][/color] and that would filter out any results from both seoclerks.com and seoclerk.com which says there are about 64,300 results showing right now. But the first page is never the most accurate page. For the most accurate results, navigate to the last page of results, in this case, it's page 4, and that will then show you a much more accurate number as to how many results were actually found but it's a sure fire way to get an accurate number on how many backlinks your site has which will show everything. The other option is to use a website that can do it such as one of those free backlink checker sites. However all they really do is the exact same thing that is done here manually anyway only they provide the results as a list for you. Some are more complex and comprehensive than others and will show you a lot more stuff such as what anchor text was used to create it, how old it is, what the metrics of the page where it's on are such as the PA, DA, mozRank, Alexa rating etc etc. But these aren't always accurate either. As mentioned here already as well, another option is to use ScrapeBox, you can get really clever using ScrapeBox to scrape your sites backlinks. You can use the above search operators but also some advanced ones as well. You might need to use some proxies to prevent your IP being temporarily banned from doing all that scraping in Google but you can use ScrapeBox for that too. That's why they call it the allinone Swiss knife for SEO's and webmasters.
Are you sure you want to delete this post?