SEOClerks

Clear
Sign In Join

I may have my first SeoClerks buyer and I don't even have a service

  • Lynne Level 1
    • 11

    Write the reason you're deleting this FAQ

    I may have my first SeoClerks buyer and I don't even have a service

    So many sellers have asked how to get their services noticed here at SeoClerks and how to make more sales.

    Each and every time I have suggested to be active here in the community discussions because not only will creating a new discussion earn you a free bump for your services but you also get noticed by people browsing the discussions.

    Of course I have seen some appalling discussions added before obviously just for the purpose of a free bump, but if you actually take part and engage with others in a meaningful way and add value to the community discussions you will be noticed and your profile will be looked at.

    This has just been proven to me since a member has inboxed me asking to do a service... oh and I don't have any services on my profile at all, I am a buyer here!

    It sounds like a really fun job and it is totally in line with what I do so I have quoted and we will see...

    Whether I get the job or not is irrelevant to this discussion but I wanted to let you all know the value of joining in here!

    So yes let's get chatting!

    #First #Seocerks #Buyer Freelance
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    TommyCarey

    TommyCarey

    That's pretty awesome I may have my first SeoClerks buyer and I don

    I haven't been so lucky to get people to message me on here wanting me to help them with the websites, optimization or lead generation I may have my first SeoClerks buyer and I don But that may be due to the fact that my lowest service costs $550+ I may have my first SeoClerks buyer and I don I'm like you, I don't sell on here either, I'm just a buyer looking for the next great service I can have set up for my website I may have my first SeoClerks buyer and I don

    Do you think you'll set up a service and run it for the person who messaged you? I'm sure you would do a great job and get a positive review of the service. In turn this could be your start to becoming a popular seller on SeoClerks lol I may have my first SeoClerks buyer and I don It's like a blessing in disguise, or something along those lines lol.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks Razzy, yes unfortunately I can't afford services like yours yet, but I would jump at the chance if I could afford you I may have my first SeoClerks buyer and I don

    Yes I am honestly quite flattered that I was inboxed like that, honestly what a cool feeling!

    Yes I will add a custom service here if that buyer accepts my quote I may have my first SeoClerks buyer and I don
    10 years ago

    Are you sure you want to delete this post?

    procoder

    procoder

    That's cool Lynne!

    I think this is the time to start your career as a freelancer here on SEOClerks. Go for it Lynne, simply add some extra time to your services if you think that you will need more time to complete them, and that's nothing wrong with it.

    Everything depends by you, and I clearly understand that the time is very limited, specially with kids, but personally I would say that you can create a service only for your client, that means that is a custom service only for your client, I'm sure that doing this wouldn't take too much from your time.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks Procoder I may have my first SeoClerks buyer and I don

    Yes that is true, I would have to add extra time and that was what I was thinking of doing. Most of the time I will be able to complete quite quickly, but then you add in a bad day with kids and everything comes crashing down LOL. I need to accommodate for those days!
    10 years ago

    Are you sure you want to delete this post?

    chetaseo

    chetaseo

    I have had several potential buyers inbox m e with messages that they need me to do some seo services for them at certain prices. it is really a good thing to experience such due to my constant participation in this forum for over 2 years now. but lynne, i will like to know how you made mosey here on seoclerks since you say you dont offer any services? is it through AFFILIATES? or any other means?
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    I buy services here and I have started affiliate marketing too. I mostly make my money from my blogs but I am also a moderator here I may have my first SeoClerks buyer and I don

    I hope that answers your questions I may have my first SeoClerks buyer and I don
    10 years ago

    Are you sure you want to delete this post?

    EliteWriter

    EliteWriter

    That's just great Lynne. I agree with you that many members do take a look at discussions and see what is posted here, and who makes regular valid suggestions and comments and not. I also got a couple of buyers who got to know about me through community discussions, and there have also been a few who just sent a message to ask a question and I did not mind giving them a helping hand to get used to the site. I suggest you put up that service this potential buyer needs, as maybe you might get sales from others too! ;)
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks EliteWriter I may have my first SeoClerks buyer and I don

    I put that custom service up and I just received my first order this morning! Quite exciting I may have my first SeoClerks buyer and I don
    10 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Yes indeed. Here here! It's the same with using any website, blog or social networking site. If you want people to trust and respect you and see you as an authority in some certain subject on that site, you need to participate in that site in some way. No participation = no followers and no interest and nobody even knowing about you. Sure you can promote your services in many ways online. Run SEO and SMO campaigns on them. Promote them on social media, forums, blogs and all sorts. But by being active in that community around that site (such as the SEOClerks Community Discussions) you can build up a name for yourself and build up respect as well. Then that way people are going to be much more likelier to trust you and purchase from you if they can see you are talking about things they are interested in and they can see you actually know what it is you're talking about as well. That's what I find anyway! I may have my first SeoClerks buyer and I don

    And I hope you do put some services up soon Lynne. I think people trust you because you have made a name for yourself on here (proving my point). In that if you participate and post quality, valuable content here, then people are going to respond to that postively. I may have my first SeoClerks buyer and I don
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks Mike I may have my first SeoClerks buyer and I don I appreciate that!

    As you know I do want to start adding some services here but I have been hesitant mainly due to my time constraints. Writing for my own three websites and managing them all on my own in addition to all the additional marketing and tasks that need to be done takes up almost all my time. Add in being a mom and only having about 3-4 hours in the morning during the week to work undisturbed does not equal having any free time LOL.

    If I offer services I want to make sure I don't disappoint anyone by giving orders late.
    10 years ago

    Are you sure you want to delete this post?

    Barida

    Barida

    This is the benefits of active participation in discussions and creating new discussions. I mean that can help some members discovered what you do or plan to do and by so doing, they will be interested in working with you. Big congrats on getting your first job over here.
    9 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 2.5835220813751

    Possible Duplicate queries found!
    MatchCountSQLScript
    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='19739'1SELECT 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='19739'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='306632'1SELECT * FROM seoclerks.members WHERE USERID='306632'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

    		/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=19739 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19739 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19739' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='19739' 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=107853 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107853 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=107856 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107856 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=107862 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107862 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=107863 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107863 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=107893 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107893 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=107902 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107902 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=108075 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=108075 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=108079 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=108079 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=107840 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107840 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=107855 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107855 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=136002 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=136002 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='19739'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='19739'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='19739' AND status='1' AND (question like '%I SeoClerks buyer I service%' OR question like '%SeoClerks%' OR question like '%buyer%' OR question like '%service%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19739' AND status='1' AND (question like '%I SeoClerks buyer I service%' OR question like '%SeoClerks%' OR question like '%buyer%' OR question like '%service%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='750' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='1159' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' 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 11SELECT 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='3446' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3446' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='957' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='957' 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=19739%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19739%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='19821.png'1SELECT 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='306632.jpg'1SELECT 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='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='198791.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='198791.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='212316.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT 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='617077.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    3.8291001SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (42,64,90) AND gtags like'%pbnlinks%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 403.8291003.829100