SEOClerks

Clear
Sign In Join

What are the Top Services for this Site?

  • Kakashi2020 Level 1
    • 13

    Write the reason you're deleting this FAQ

    What are the Top Services for this Site?

    I'm thinking of creating services for seoclerks and would like to know what are the existing Top Services in this site?

    I'm talking about services which have a high customer demand, services which I can earn a lot from.

    #Services SEO
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    kaushikangara

    kaushikangara

    I think generating traffic for your blog and website or getting you followers on Twitter, Instagram are the most active services. Besides these, designing logos, banners and data entry are some other options. You can view all the services of the website in the popular freelancers page in the community tab.
    7 years ago

    Are you sure you want to delete this post?

    Youngshark

    Youngshark

    Yeeah for now I have seen that the members are focused on making such transactions while also getting an opportunity to learn and exchange ideas.
    7 years ago

    Are you sure you want to delete this post?

    theresajane

    theresajane

    I agree with you. Most of the members here also love threads like this. It's very helpful as people get to share and learn things from each other.
    7 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    Most of the services that I can see here are related to traffic on your blogs and vlogs. You can try this, if you want. However, make sure to provide quality traffic and avoid using traffic exchange and bots.
    There are also a lot of SEO related services such as ranking, backlinking etc. You can also get started with SEO services.
    7 years ago

    Are you sure you want to delete this post?

    Jeane

    Jeane

    I'm thinking of creating services for seoclerks and would like to know what are the existing Top Services in this site?

    SEO-related services are the services in high demand. Thing though is you don't have to limit yourself to one service which you feel will make you more money. Since seller's can list more than one service, you can experiment, find out which of the suggested services gets you more orders.

    Just keep in mind the fact that you can always resell listed services or promote them as an affiliate which would still make you money.
    7 years ago

    Are you sure you want to delete this post?

    Alania

    Alania

    This is a very great website with an amazing active community. To answer your question, the main orientation evolves around traffic, freelancing, and social media. There are obviously a lot of other services, some are more popular, others are less.
    7 years ago

    Are you sure you want to delete this post?

    Kakashi2020

    Kakashi2020

    I was thinking of a service which I could utilize my several Facebook Groups which have about 17000 active members total. Any ideas how I could use my members?
    7 years ago

    Are you sure you want to delete this post?

    vhinz

    vhinz

    Find out what are their interests or problems that they want to solve. Then look for solutions and offer it to them. You can create a website in a particular niche then share it on your group. Give them good quality contents in exchange for their time reading or sharing your content. You can also try affiliate marketing. Find products that are related to your group's concerns and present it to them. With 17000 active members on your group, you could possibly make a sale.
    7 years ago

    Are you sure you want to delete this post?

    Youngshark

    Youngshark

    Affiliate marketing is a great hack that you can manage especially with an accessibility to computer and internet.
    7 years ago

    Are you sure you want to delete this post?

    burgosmichael24

    burgosmichael24

    Seoclerks offers many services for potential income. Seoclerks is a great platform for the freelance writer and aspiring writer. However, though Seoclerks has a great potential, some people here focuses on some services in which they are comfortable. I believe one of the top services for this site is generating traffic for their blogging sites or websites.
    7 years ago

    Are you sure you want to delete this post?

    theresajane

    theresajane

    These comments above have pretty much answered your question. Well, the most common service that this site has is generating traffic for your site.
    7 years ago

    Are you sure you want to delete this post?

    Tehilah27

    Tehilah27

    I don't think you should focus on the service with the highest customer base but on a niche you're good at. There is a market for every service if you present your services well. Also, try to advertise your service outside of Seo and you'll have a better chance of getting customers to buy your service
    7 years ago

    Are you sure you want to delete this post?

    gutzman

    gutzman

    This is kind of tricky since you want to earn a lot but looks on a service that is in demand. Sure people would need that kind of service but I think it also means that you'll have so many competitors which would make it hard for you to earn a lot. You will earn but not a lot if your product or service is below the quality of other sellers. It sounds ironic but I think that's how businesses work. It is still best to focus on things you are good at and make money from it. That way you'll not only earn but also enjoy what you are doing.
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.096518993377686

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=6631921SELECT googleplus_profile FROM seoclerks.members WHERE USERID=663192

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='27642' 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='27642' 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=181265 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=181265 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=181285 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=181285 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=181886 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=181886 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=181312 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=181312 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=181358 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=181358 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=181369 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=181369 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=181391 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=181391 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=181579 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=181579 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=182224 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=182224 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=181546 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=181546 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=181885 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=181885 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=183371 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=183371 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=185063 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=185063 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='27642' AND status='1' AND (question like '% Top Services Site?%' OR question like '%Services%' OR question like '%Site?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='27642' AND status='1' AND (question like '% Top Services Site?%' OR question like '%Services%' OR question like '%Site?%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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='1129' limit 11SELECT 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=27642%' 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=27642%' 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='745124.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='745124.jpg'

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='624598.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='624598.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='740237.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='740237.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
    4.0814541SELECT 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'%tool%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 404.0814544.081454