SEOClerks

Clear
Sign In Join

how to feature my Service?

  • ranjith Level 1
    • 8

    Write the reason you're deleting this FAQ

    how to feature my Service?

    Hello, I am new to SEO Clerks and I am working to get my way up to Level 3 but I am having troubles on how to get my Service features so that I can get some more sales. So if anybody could lend me a hand and help me figure this out.

    please help anyone how to feature my Service.

    thank u

    #seo #feature SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    tshitiz

    tshitiz

    If you want to get your gig featured on the first page of seo clerks then you should consult a guy, his name is jordan! He charges 30 bucks and 19 bucks for highlighting your gig! He is very friendly and helpful. 
    13 years ago

    Are you sure you want to delete this post?

    Malabi

    Malabi

    It is one of the easiest work on seoclerks. And if you want to featured you gig then at first you have to complete first level after you just contact with jordan. He will direct you. As it my knowledge he is very friendly.
    13 years ago

    Are you sure you want to delete this post?

    BestSeoCompany

    BestSeoCompany

    Hello

    Its simple process, Just send an email to support helpdesk.ionicware.com ....And Ask JORDAN to place your gig as Featured.

    But its a bit expensive now 300$ to get featured your Gig how to feature my Service? 
    13 years ago

    Are you sure you want to delete this post?

    Seofreak

    Seofreak

    Not a tough question, just send a mail to Jordan and ask him to feature your service he will guide you. You will require $300 to feature your service.
    Thanks
    Seofreak
    13 years ago

    Are you sure you want to delete this post?

    sayra

    sayra

    https://www.seoclerks.com/Other/3030/Permanently-Feature-your-Service-for-1-Month
    And if you want to featured you gig then at first you have to complete first level after you just contact with Jordan.
    Best luck, happy selling!Best wishes to you buddy!
     
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.32661294937134

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=499381SELECT googleplus_profile FROM seoclerks.members WHERE USERID=49938

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='6341' 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='6341' 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=29242 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=29242 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=29536 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=29536 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=29582 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=29582 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=29915 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=29915 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=33464 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=33464 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='6341' AND status='1' AND (question like '%how feature Service?%' OR question like '%feature%' OR question like '%Service?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='6341' AND status='1' AND (question like '%how feature Service?%' OR question like '%feature%' 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='3764' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='13997' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='13997' 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=6341%' 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=6341%' 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='59574.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='59574.jpg'

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='24913.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='24913.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.2300371SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=390.2300370.230037
    0.0814181SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND B.seo='SEOClerks' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 280, 400.0814180.081418