America
Level 1
Write the reason you're deleting this FAQ
Let's say you started a blog about Amazon products in a specific niche. How long would it take to find an audience for such a niche affiliate blog?
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='13820' | 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='13820' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='49657' | 1 | SELECT * FROM seoclerks.members WHERE USERID='49657' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='35' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='35' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=49657 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=49657 | /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=13820 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=13820
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13820' 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='13820' 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=71142 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=71142
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=71143 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=71143
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=133755 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=133755
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=71144 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=71144
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=133736 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=133736
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='13820' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='13820' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='13820' AND status='1' AND (question like '%How long build audience affiliate blog?%' OR question like '%long%' OR question like '%build%' OR question like '%audience%' OR question like '%affiliate%' OR question like '%blog?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='13820' AND status='1'
AND (question like '%How long build audience affiliate blog?%' OR question like '%long%' OR question like '%build%' OR question like '%audience%' OR question like '%affiliate%' OR question like '%blog?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' 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 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='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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=13820%' 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=13820%'
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='73452.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='73452.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.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 |
ShanghaiKiwi84
Also, are you counting the length of time it takes you to learn everything you need to know to get it right by reading SEO blogs etc? I've been studying SEO blogs like source-wave.com and backlinko.com in my spare time for about 3 months as a hobby, and though recently I just started hitting the SERPs for my keywords, I haven't yet made any money. But that was just my learning curve, at least I'm on my way. To make the site took about 2 weeks (I'm a newbie, so it took ages), and to rank on page 1 it took another 2 weeks. I'm expecting it'll take another few months before I start making any significant passive income that I can actually enjoy, but thats just a guesstimate. Amazon might be faster because you have cheaper products, the products I'm selling in my niche site are all more than $1k each so its not so easy to make a sale (but all the traffic is in buying mode). If I was selling cheaper stuff, maybe I'd have made a sale by now? But I like it.
One thing about Amazon - the customer has 24 hours to buy something and if they don't, what they buy the next day won't mean anything to you, you won't get paid (thats not so bad with cheaper, whimsical products I suppose). Some other aff. programs have cookies that last a few months (like my current project), while SEOClerks lasts forever (my next project!). That might be worth thinking about when looking for affiliates. Depends on [I]everything[/I]. Like, are you working full-time or can you do your sites full-time? How good is your niche and keyword research? How are you promoting them, with a site? How is the on-page SEO? The off-page? What colour is your hat? Also, are you counting the length of time it takes you to learn everything you need to know to get it right by reading SEO blogs etc? I've been studying SEO blogs like source-wave.com and backlinko.com in my spare time for about 3 months as a hobby, and though recently I just started hitting the SERPs for my keywords, I haven't yet made any money. But that was just my learning curve, at least I'm on my way. To make the site took about 2 weeks (I'm a newbie, so it took ages), and to rank on page 1 it took another 2 weeks. I'm expecting it'll take another few months before I start making any significant passive income that I can actually enjoy, but thats just a guesstimate. Amazon might be faster because you have cheaper products, the products I'm selling in my niche site are all more than $1k each so its not so easy to make a sale (but all the traffic is in buying mode). If I was selling cheaper stuff, maybe I'd have made a sale by now? But I like it. One thing about Amazon - the customer has 24 hours to buy something and if they don't, what they buy the next day won't mean anything to you, you won't get paid (thats not so bad with cheaper, whimsical products I suppose). Some other aff. programs have cookies that last a few months (like my current project), while SEOClerks lasts forever (my next project!). That might be worth thinking about when looking for affiliates.
Are you sure you want to delete this post?