SEOClerks

Clear
Sign In Join

Discussions about Hire

Date Hot Date (old to new)
Unanswered Votes
Showing page: 1 of 1
Start a discussion

How to make sure you hire the right freelancers Answered

You are looking for a freelancer to handle your project or projects but you are reserved in hiring someone over the internet without meeting them in person. You don't trust they can get the job done right and on time and...

  • Cristian
    Cristian Level X3
    • 24 9 years ago

    Have you ever hired an SEO specialist? Answered

    Hello everybody, I've been doing SEO for a few months now and I'm still learning a lot as I do different gigs - all that I've learned so far is basically through the internet, reading articles, and following guides. S...

  • Tronia
    Tronia Level 1
    • 13 9 years ago

    Hire an SEO Freelancer – Here's why I do it! Answered

    Since you are here on this website chances are you have your own website, or possibly even more than one? Maybe you are a blogger or perhaps you have an online store... we are all after the same thing - traffic, rankings...

  • Lynne
    Lynne Level 1
    • 9 9 years ago

    Hire Me or Custom Order on SEOclerks Profiles - Proposal Answered

    Since my recent activity on Community Discussions here on SEOclerks, I've notice I'm starting to get a lot of activity in my Inbox. People contact me with different problems and issues. At the moment I suspended all m...

  • Cristian
    Cristian Level X3
    • 10 10 years ago
    Debate

    i hired someone just because he deliver soon but changed Answered

    i hired someone to do works for me faster but he too late and make me embarased with my clients now he changed delivery time more higher what to do and i have no alternative to him

  • sanfora
    sanfora Level 1
    • 7 10 years ago

    Should I hire a freelancer to write content for my own site? Answered

    For my work I mainly do a lot of content writing and I get a lot of orders. This takes up a lot of my time and makes it harder for me to manage my own websites, which is not an issue normally but I am currently expanding...

  • Hasa1015
    Hasa1015 Level 1
    • 19 10 years ago

    Hire writers for Forum Posts and wages. What should I do? Answered

    I've been working online for the last couple of years and mainly been focusing on Forum Posts (Branding Work using Forums), during this time I've also been contacted multiple times about "the average pay" for Forum Posts...

  • hitmeasap
    hitmeasap Level X5
    • 5 10 years ago

    How to hire a freelancer directly? Answered

    I am not sure is it a simple question that has been answered, or every one knows it already, just I couldn't find the answer directly. If I find a freelancer in here, contacting him/her directly, agree on the work and...

  • hoyinli
    hoyinli Level 1
    • 4 12 years ago

    How would I know that I am hired by someone? Answered

    How would I know that I am hired by someone? Do i get notified by an email or message when someone hire me?

  • gauravpathania
    gauravpathania Level 1
    • 6 13 years ago

    Order Now
    Process Time: 0.15850186347961

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Hire %' OR A.tags LIKE 'Hire %' OR A.tags LIKE '% Hire' OR A.tags='Hire') LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Hire %' OR A.tags LIKE 'Hire %' OR A.tags LIKE '% Hire' OR A.tags='Hire') LIMIT 1

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

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Hire %' OR A.tags LIKE 'Hire %' OR A.tags LIKE '% Hire' OR A.tags='Hire') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT 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 (A.tags LIKE '% Hire %' OR A.tags LIKE 'Hire %' OR A.tags LIKE '% Hire' OR A.tags='Hire') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

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

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

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

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

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

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') 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='134'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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.7840201SELECT 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 (37) AND gtags like'%thai%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.7840200.784020
    0.4969911SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (42,64,90) AND gtags like'%circut%' AND type !=99 0.4969910.496991
    0.4176871SELECT 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 (36) AND gtags like'%traffic%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4176870.417687
    0.1676771SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Surfing%' OR A.skills LIKE '%Surfing%') ORDER BY A.lastgigedit desc LIMIT 0,400.1676770.167677
    0.1451131SELECT 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 AND (A.tags LIKE '%Surfing%' OR A.skills LIKE '%Surfing%')0.1451130.145113