hitmeasap
Level X5
Write the reason you're deleting this FAQ
A few months back, I made a topic about: "Ask Me Anything Threads. Cool or crazy idea for SEOClerks?"
However, this time around, I'll ask more or less the same thing, but it's something I've thought of doing on my blog, if and when I create one. You could obviously do this on a website too.
(And video converted to .mp3)
LOL Lynne. I've actually been on Youtube before. ;) (But not in a video review.)
But nah, I don't really like the thought of it, even though it would be SUPERCOOL! - I have too much stage fright for it. ;)
Video reviews would probably yield better results than plain text, and I've actually had thoughts of doing this previously, sort of, as a product. Like a "[i]this and that for dummies[/i]" books, but with Videos instead. :D (And video converted to .mp3)
Anyhow, it seems like most people think it's a decent idea, so I'll make sure to remember this in the near future. :)
And by the way Lynne. You will be the very first person I'll ever do a video review with. I promise you that! :D
Are you sure you want to delete this post?
Are you sure you want to delete this post?
That's actually a solid idea for good blog content. And seeing as your blog will be a freelance blog, having content based on questions that other freelancers ask and another freelancer answers, will be appealing and interesting to other freelancers. And not just rookie, newbie freelancers either. But even advanced, experienced, seasoned, veteran freelancers like myself and other long running freelancers too.
This isn't overworked or boring in any way at all. Since when anyone does something like that, they're always usually interviewing someone else. And they always usually go about it in a different and unique way to how anyone has done it before.
And this would be an excellent way to come up with great blog content for your blog. And helping to keep your blog relevant as well. This actually reminds me of something I was working on myself recently. If you remember I asked recently [url=https://www.seoclerks.com/faq/20382/If-you-had-to-interview-a-freelancer-what-questions-would-you-ask-and-why]what some questions are that you would ask a freelancer[/url] if you had 60 minutes alone with them. I actually posted that because I wanted to actually interview some freelancers and pose a series of questions to them which I would be able to use as content for my site.
Either for my site or put on here. I haven't decided yet lol. I was looking for content ideas for my site and that's one thing I thought of. But I think it might be better to post their answers to the questions that I had formed on here. I was going to post all the questions I'd put together on here, and then let people answer them in that thread. But you could do something like that on your blog as well. :)
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='20677' | 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='20677' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='6160' | 1 | SELECT * FROM seoclerks.members WHERE USERID='6160' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='52' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='52' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=6160 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=6160 | /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=20677 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=20677
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20677' 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='20677' 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=112606 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=112606
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=112742 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=112742
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=112566 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=112566
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=112570 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=112570
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=112650 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=112650
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=168677 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=168677
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20677' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20677' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20677' AND status='1' AND (question like '%AMA/Interviews - Cool idea overworked?%' OR question like '%AMA/Interviews%' OR question like '%Cool%' OR question like '%idea%' OR question like '%overworked?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20677' AND status='1'
AND (question like '%AMA/Interviews - Cool idea overworked?%' OR question like '%AMA/Interviews%' OR question like '%Cool%' OR question like '%idea%' OR question like '%overworked?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='33015' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='33015' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='33097' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='33097' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='7161' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='7161' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='14581' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='14581' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='62649' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='62649' 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=20677%' 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=20677%'
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='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='139192.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.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='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.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 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 |
Lynne
On a serious note though yes I think interviews on your blog would be cool, and I do think video interviews would really go down well... and I know you aren't so keen to put yourself on Youtube though but I think it would rock.
The written interviews are ok, but I do find them a little boring. If you can do fun and engaging interviews I think that would be really awesome.
I am going to do my first mommy blog interview at some stage in the new year and I am so looking forward to it! I'll let you know how that goes down.
I am going to interview another mommy that has a mom based business. Woohooo that sounds awesome! We could do an interview together Andre and then put it on Youtube... you know us with our sexy accents. I can just tell that you would love to put yourself out there and be on Youtube right? On a serious note though yes I think interviews on your blog would be cool, and I do think video interviews would really go down well... and I know you aren't so keen to put yourself on Youtube though but I think it would rock. The written interviews are ok, but I do find them a little boring. If you can do fun and engaging interviews I think that would be really awesome. I am going to do my first mommy blog interview at some stage in the new year and I am so looking forward to it! I'll let you know how that goes down. I am going to interview another mommy that has a mom based business.
Are you sure you want to delete this post?