keen2write
Level 1
Write the reason you're deleting this FAQ
Thought I would share this video with you all on getting backlinks . Many people gain backlinks easily now some struggle or are new to getting backlinks.
Also check out linkcollider this is a kind of social exchange link exchange site. Where daily you can traffic exchange earn points and use these points for other members to social signal like your site members can wordpress your website even tumblr post your site stumbleupon it and so much more you can even use your points to get backlinks in the backlinks section. Now here is a great video from A guy called lazyass stoner on youtube.
Are you sure you want to delete this post?
To add videos, don't use the video button in the RTE (Rich Text Editor) it doesn't work. All you need to do is wrap the actual YouTube video URL in video brackets.
Example
[code][video]https://www.youtube.com/watch?v=5bKM_rphj3E[/video][/code]
And yeah, that's another thing I like about him in that the things he talks about can all be put into action and actually work if you do it like he says to do it. I really like his style of sharing stuff and you don't often see that in people. Most people are only doing it to get more followers/subscribers theirself. And he's doing it for that reason too I'd expect. But it's more for doing it as he knows how to and then passing that knowledge on. I wish there was more people like that in theworld today! :)
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='21819' | 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='21819' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='322073' | 1 | SELECT * FROM seoclerks.members WHERE USERID='322073' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=322073 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=322073 | /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=21819 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=21819
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21819' 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='21819' 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=115301 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=115301
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=115306 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=115306
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=115348 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=115348
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=115305 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=115305
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=156940 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=156940
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=159830 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=159830
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='21819' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='21819' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='21819' AND status='1' AND (question like '%A good gain Backlinks%' OR question like '%good%' OR question like '%gain%' OR question like '%Backlinks%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='21819' AND status='1'
AND (question like '%A good gain Backlinks%' OR question like '%good%' OR question like '%gain%' 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='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' 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=21819%' 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=21819%'
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='322073.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png' | /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 seoclerks.members WHERE USERID='589438.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.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 |
idealmike
Some of the post I've done that were partially inspired by his videos you might like to check out are;
How to Build Insanely Powerful High PR High Authority Web 2.0 Social Media Backlinks. ?
How to Build Insanely Powerful Forum Profile Backlinks from Forums.
How to Build Insanely Powerful Backlinks from Tumblr,
Here's one of his videos for anyone that hasn't heard of the guy before.
SEO For Dummies: How To Rank In Google
On another note, I've also posted about Link Collider before as well in my post, What can you tell me about LinkCollider? Social Media SEO Tool Site. ?
I was experimenting with that site for a while to earn social signals and web 2 posts and stuff with and a little traffic too. But it's not exactly high quality. What I figured out speaking honestly is that you can treat it like any like4like or addmefast type site where you can basically set up many different accounts and use different VPS's to run them on and then build up thousands of social signals to any URL you want. That takes some doing and it might even break their rules although it's a bit of a grey area though. But if I could do that, I bet my back teeth there's thousands of other people doing that too and all using dummy accounts so all the signals you earn drop in the end anyway or are just completely abandoned. That's no good since abandoned accounts don't generally engage with your content!
Although I've not done that much experimenting with it to that degree but it's still a very interesting site and can be put to use!
Mike. Ohh yeah we was talking about him earlier. That guy, honestly, you got to hand it to him, and I'm not talking about a dooby either lol sure, he might like to sample Gods herb, but he certainly knows his stuff when it comes to building insanely powerful backlinks! I've wrote a few posts on here actually that were kind of inspired by him and his "larger than life" approach to Internet Marketing and SEO. Where all these other so called "SEO gurus" talk about SEO and make it sound complicated and boring. He has an approach that simplifies doing SEO and building backlinks in particular. I really liked his video back in the day about building insanely powerful backlinks. Some of the post I've done that were partially inspired by his videos you might like to check out are; [url=https://www.seoclerks.com/faq/20585/How-to-Build-Insanely-Powerful-High-PR-High-Authority-Web-2-0-Social-Media-Backlinks]How to Build Insanely Powerful High PR High Authority Web 2.0 Social Media Backlinks[/url]. ? [url=https://www.seoclerks.com/faq/20604/How-to-Build-Insanely-Powerful-Forum-Profile-Backlinks-from-Forums]How to Build Insanely Powerful Forum Profile Backlinks from Forums[/url]. [url=https://www.seoclerks.com/faq/20591/How-to-Build-Insanely-Powerful-Backlinks-from-Tumblr]How to Build Insanely Powerful Backlinks from Tumblr[/url], Here's one of his videos for anyone that hasn't heard of the guy before. [size=150][b]SEO For Dummies: How To Rank In Google[/b][/size] [video]https://www.youtube.com/watch?v=5bKM_rphj3E&t=1s [/video] On another note, I've also posted about Link Collider before as well in my post, [url=https://www.seoclerks.com/faq/18719/What-can-you-tell-me-about-LinkCollider-Social-Media-SEO-Tool-Site]What can you tell me about LinkCollider? Social Media SEO Tool Site[/url]. ? I was experimenting with that site for a while to earn social signals and web 2 posts and stuff with and a little traffic too. But it's not exactly high quality. What I figured out speaking honestly is that you can treat it like any like4like or addmefast type site where you can basically set up many different accounts and use different VPS's to run them on and then build up thousands of social signals to any URL you want. That takes some doing and it might even break their rules although it's a bit of a grey area though. But if I could do that, I bet my back teeth there's thousands of other people doing that too and all using dummy accounts so all the signals you earn drop in the end anyway or are just completely abandoned. That's no good since abandoned accounts don't generally engage with your content! Although I've not done that much experimenting with it to that degree but it's still a very interesting site and can be put to use! :) Mike.
Are you sure you want to delete this post?