SEOClerks

Questions from user Zaria

Showing page: 1 of 1

Hi Everyone i want to Feature my services, what i do? I heard that SEOclerks have ability to feature your gigs. but i am not sure. anyone can will help me to find this feature, or just tell me where i have to contact f...

  • Zaria
    Zaria Level 1
  • 11 12 years ago

    Hi, Any one knows How to Delete Messages from Inbox ? i have conversation with more than 50 people. i read all messages. But still on my inbox options, it shows that i have 6 messages. but i don't have any unread messa...

  • Zaria
    Zaria Level 1
  • 6 12 years ago

    Greetings Everyone, HI, is there any option that i can delete my negative review from my gigs? Some one give me negative review about my services despite i complete my order and then also he give me negative review. TH...

  • Zaria
    Zaria Level 1
  • 7 13 years ago

    exactly i know how to check how many question and answer i questioned or answerd but, onece my friend give me the link that shows everything...you complete profile and your current status, by mistake i delete that URL, s...

  • Zaria
    Zaria Level 1
  • 8 13 years ago

    is there any chance my level go down when rating go down? my rating is 97%. i was thinking that if i get promoted then SEO will assign me level two the basis of my current rating. but if my rating go down then what happ...

  • Zaria
    Zaria Level 1
  • 1 13 years ago

    is there any chance that my level go down on SEO? Today may be i will reach to level 2 i was thinking if i get promoted what will be the factors / reason that my level go down. or SEO Clerks can reverse my level autom...

  • Zaria
    Zaria Level 1
  • 1 13 years ago

    is that legal to sell account on SEO. i think its crazy and stupid idea to sell SEOcleks account. but i just want to know for my knowledge, if some one say that he is selling his account then it will be wise to buy his ...

  • Zaria
    Zaria Level 1
  • 11 13 years ago

    My level is not increasing. i am still on level one I answered 20 questions and my rating is 100% also complete more than 200 orders but still my rating is one. what should i do now? i think i am missing some of...

  • Zaria
    Zaria Level 1
  • 6 13 years ago

    Hi ! Anyone know how to change username on SEOClerks ? i am bit of tired of using my current user name but i just want to change my user name without changing or closing my account. what will i do ? is there any chance...

  • Zaria
    Zaria Level 1
  • 3 13 years ago

    HI everyone, i just want to know that if some one account is banned due to violating the rules and regulations of SEOclerks then how much time, or days SEOclerks will take to reactivate the account? They give warning o...

  • Zaria
    Zaria Level 1
  • 3 13 years ago

    Greetings i am new on SEOclerk. i create lots of gig when i create my account. now i want to remove some of my gigs. but i didn't find anywhere delete option for the gig. i only saw edit options. Please help to me to fi...

  • Zaria
    Zaria Level 1
  • 7 13 years ago
    Order Now
    Process Time: 0.12063908576965

    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 seoclerks.members WHERE username='Zaria' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='Zaria' AND status='1'

    /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

    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.userid=81256 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.userid=81256 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.userid=81256 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.userid=81256 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='81256'1SELECT profilepicture FROM seoclerks.members WHERE USERID='81256'

    /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.4233391SELECT 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 (62) AND gtags like'%bounce%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4233390.423339
    0.1032021SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Writti%') ORDER BY total_recommendations desc LIMIT 0,400.1032020.103202
    0.1005681SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Pinterestlikes%') ORDER BY total_recommendations desc LIMIT 0,400.1005680.100568