SEOClerks

Answers from user SyedBahadurShah Page 2

Showing page: 2 of 2

Hey Clerks Nation, today, i decided to share with you a few things that will help you succeed as a seller on SEOClerks. Some of you may already know this, but i am sure there are beginners that will find use of this thre...

  • Jovan
    Jovan Level 3
  • 81 12 years ago

    We all know that in order to survive at freelancing, you need to have good clients. Maybe you only have a few clients, but are looking to get some more. So how can you successfully get new clients. Here are a few tips...

  • Miken34
    Miken34 Level 1
  • 44 12 years ago

    So I thought I would post a quick list of tips you could keep in mind while you are setting the price(s) on your service(s). Please have a read at them and they might help you get more sales and make bigger purchases. D...

  • Sean101
    Sean101 Level 1
  • 69 12 years ago

    We'd like to see more Level X users and our current selection criteria is a bit strict. We've removed the FAQ Requirement from leveling up so more users should be able to reach Level 3 without any issues. First and fo...

  • ionicware
    ionicware Level X5
  • 187 12 years ago

    Finally , i am very happy , atleast i helped the site in some ways , i had just noticed that my affiliate total purchased is now more than $1000 , so what is urs ? also how u advertize seoclerk to get more affiliate

  • baaso
    baaso Level 5
  • 24 12 years ago

    Every Service on SEOClerks has a Unique Service ID Number. If you browse through a few different Services, you'll notice a Number located in each URL following the "Category". For example, the URL below is in the "Youtu...

  • exjordanary
    exjordanary Level X5
  • 20 13 years ago

    What is Pocket: Read it here => Pocket Steps To Install Pocket: 1. Navigate to Pocket Sign Up page and sign up for a new account. 2. Now go to Pocket Extras page. If you are using Google Chrome web browser to s...

  • sunil0021
    sunil0021 Level 1
  • 23 13 years ago

    Hi friends i want to know that how can i withdraw money from SEOClerks through paypal !! please give me complete instruction what we have to do after clicking withdraw your earnings etc. Please give me a full instruct...

  • sunil0021
    sunil0021 Level 1
  • 11 13 years ago

    This tutorial is very simple and will guide you through adding your Google+ profile URL to your SEOClerks settings. Your profile URL is entered in the settings area of the marketplace and if you have this field populated...

  • ionicware
    ionicware Level X5
  • 66 13 years ago

    In first episode, http://www.seoclerks.com/forum/threads/how-to-create-strong-passwords-for-online-accounts-part-1.2860/, we discussed about how to create strong password and creating strong password is first step of def...

  • shek
    shek Level 1
  • 12 13 years ago

    Hey guys! I'm bringing you another tutorial on domains today. I'm sure some of us have had that moment where we go to a website and think something along the lines of: "I wonder who owns this website?" or "How do I cont...

  • FredericM
    FredericM Level 1
  • 19 13 years ago

    I did this on my home forum a long time ago before it turned into a dino pit LoL and it received quite a bit of attention. I can remember back when It was always motivation to see real stats from earnings in a thread lik...

  • tacitinc
    tacitinc Level X3
  • 7 13 years ago

    -SEOClerks affiliate store for $25!- SEOClerks recently added an api feature to their website, with this api feature I was able to create the first ever SEOClerks based affiliate store. What does it do and why you N...

  • ShadyX
    ShadyX Level 4
  • 82 13 years ago
    Order Now
    Process Time: 0.074136972427368

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

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

    SELECT * FROM answers WHERE userid=584991SELECT distinct quesid FROM answers WHERE userid=58499

    /opt/clerks-staging/docroot/faq.php 258 () ()

    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.quesid IN (8265,5665,8382,8420,10335,10338,10339,10340,10341,10342,10343,10348,10353,10358,10511,10512,10514,10520,10523,10524,11411,11527,11528,11556,11591,11691,12098,12104,12108,12110,12111,12650,12674,12675,12683,12693,12703,12710,12728,12737,12891,13091,13093,13123,13421,13825,13826,13827,13829,13836,13842,13902,14814,15348,15349,17191) 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.quesid IN (8265,5665,8382,8420,10335,10338,10339,10340,10341,10342,10343,10348,10353,10358,10511,10512,10514,10520,10523,10524,11411,11527,11528,11556,11591,11691,12098,12104,12108,12110,12111,12650,12674,12675,12683,12693,12703,12710,12728,12737,12891,13091,13093,13123,13421,13825,13826,13827,13829,13836,13842,13902,14814,15348,15349,17191) 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.quesid IN (8265,5665,8382,8420,10335,10338,10339,10340,10341,10342,10343,10348,10353,10358,10511,10512,10514,10520,10523,10524,11411,11527,11528,11556,11591,11691,12098,12104,12108,12110,12111,12650,12674,12675,12683,12693,12703,12710,12728,12737,12891,13091,13093,13123,13421,13825,13826,13827,13829,13836,13842,13902,14814,15348,15349,17191) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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.quesid IN (8265,5665,8382,8420,10335,10338,10339,10340,10341,10342,10343,10348,10353,10358,10511,10512,10514,10520,10523,10524,11411,11527,11528,11556,11591,11691,12098,12104,12108,12110,12111,12650,12674,12675,12683,12693,12703,12710,12728,12737,12891,13091,13093,13123,13421,13825,13826,13827,13829,13836,13842,13902,14814,15348,15349,17191) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='146019'1SELECT profilepicture FROM seoclerks.members WHERE USERID='146019'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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
    0.5959402SELECT 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 ORDER BY A.bdays desc LIMIT 0,400.3019680.293972
    0.3776342SELECT 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.1919600.185674

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.2979702SELECT 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 ORDER BY A.bdays desc LIMIT 0,400.3019680.293972
    0.1888172SELECT 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.1919600.185674
    0.1522361SELECT 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 '%Documentcreate%' OR A.skills LIKE '%Documentcreate%') ORDER BY A.lastgigedit desc LIMIT 0,400.1522360.152236
    0.1199061SELECT 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 '%Documentcreate%' OR A.skills LIKE '%Documentcreate%')0.1199060.119906