SEOClerks

Clear
Sign In Join

My 1 Year in Seoclerks

  • shubh Level 4
    • 7

    Write the reason you're deleting this FAQ

    My 1 Year in Seoclerks

    Today , one year is going to be completed in seoclerks. A lot of things happens with me in seoclerks. I am happy as well not. Just see what happen new in this year.

    # Success Stories
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    robertman11

    robertman11

    Congrats! Tell us a little more a out your first year with seoclerks? Did you make a lot of money? What do you recommend for sales?
    13 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    It's nice that you could stay with SEOClerks for a full year. Hopefully, you have advanced very far and earned a good deal of money in your time with the site. And, maybe another year will help you even more money My 1 Year in Seoclerks
    13 years ago

    Are you sure you want to delete this post?

    shubh

    shubh

    I am having some bad experience with seoclerks support. But i ignore it. Today again,. a buyer choose negative thumb becuase i have not cancel his order. Its a blackmailing. I know what support reply , but still i generate the ticket.
    13 years ago

    Are you sure you want to delete this post?

    angie828

    angie828

    I have had the best luck with SEOclerks. I have gotten a lot of jobs with them and it has all been good. I look forward to this year as well.
    13 years ago

    Are you sure you want to delete this post?

    seogawd

    seogawd

    almost a year... but was not here for last 6 months, lol

    seems like it's coming around though

    sorry to hear about the silent support issues Shubh! Maybe this time they will respond. Not much worse than being ignored. I feel for ya!
    13 years ago

    Are you sure you want to delete this post?

    Void

    Void

    Congrats on being here one year! I'm sure it is a sticky situation for staff on when they can remove a negative review and when to leave it. They can't just remove it on will and still be fair to buyers.

    How much have you made in one year?
    13 years ago

    Are you sure you want to delete this post?

    GeeOne

    GeeOne

    Today , one year is going to be completed in seoclerks. A lot of things happens with me in seoclerks. I am happy as well not. Just see what happen new in this year.


    I have completed about six months at SEOClerks, joined in Aug 2012.

    Honestly I thought and under the impression, it's just one more site on 'Micro Job Marketplace', and so for about 3/4 months I was not very active and was also not login for many days. Suddenly one day I got couple of orders and notice good response from the buyers. And I started spending time by reading many gigs and services offered. And started adding my other services/gigs.

    I realized that SEOClerks is mainly focusing on SEO and related services, believe me I don't think there are many sites on this niche, also SEOClerks is very well promoted, it has also offering affiliated program/sales and also many other way to earn their member from SC, which many sites are not offering in this segment.

    In short, I would say SEOClerks is one of the best and leading site in this segment on net. It is also neat, clean and well maintained site.

    And the most important thing is the admin, he is really interested to add new and innovative features to improve SEOClerks. He is always asking about new ideas and feedback from the members via support, where he and his team are very quick at support which is really a positive point from owner point of view. He is easily approachable, unlike other admins.

    I would really like to know the person who has recommended & suggested this site (I am sure it was through affiliate link), and say him/her big 'Thank You'. Is there any way to know that person?

    I am really happy to be part of this site. Here I can offer my services like signature links sell/rent, banner & sponsor link selling etc. and also can buy the service to promote my forum.

    Undoubtedly SEOClerks would be a leading site in this segment / niche in coming days.

    All the very best SEOClerks.

    G!
    13 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.2356231212616

    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='12671'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='12671'

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

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

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

    SELECT * FROM categories_faq WHERE CATID='42'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42'

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

    SELECT * FROM seoclerks.members WHERE USERID=18951SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1895

    		/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=12671 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=12671 LIMIT 5

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12671' 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='12671' 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=60540 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=60540 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=60541 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=60541 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=60542 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=60542 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=60543 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=60543 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=60544 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=60544 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=60545 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=60545 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=60546 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=60546 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='12671' AND status='1' AND (question like '%My 1 Year Seoclerks%' OR question like '%Year%' OR question like '%Seoclerks%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12671' AND status='1' AND (question like '%My 1 Year Seoclerks%' OR question like '%Year%' OR question like '%Seoclerks%') -- ORDER BY RAND() LIMIT 15

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

    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 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='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='498' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='498' 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 11SELECT 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=12671%' 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=12671%' 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='9.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png'

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='46.gif'1SELECT profilepicture FROM seoclerks.members WHERE USERID='46.gif'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='10381.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='10381.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
    0.1789131SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1789130.178913