SEOClerks

Clear
Sign In Join

Discussions about purchase

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

WTB vs. Services for Sale Answered

To Whom It May Concern: I fell ill a few months ago...only to return to a shifted paradigm of freelancing here on SEOClerks.com - folks used to shop our profiles and category listing for services, etc... to purchase; ...

  • southsidesmoka
    southsidesmoka Level X3
    • 9 9 years ago

    Purchased the Traffic Demon, need help!!!! Answered

    Hello, My name is Richard Uriegas, has anybody else purchase the Traffic Demon? I'm not complaining just need to know how to get in touch with the seller. His name is Karoshio. I tried the start conversation page but ...

  • uriegas65
    uriegas65 Level 1
    • 6 9 years ago

    How do I pay for a service using PayPal balance without a credit/debit card? Answered

    Basically need my question answered: "How do I pay for a service using PayPal balance without a credit/debit card?" I currently don't have a card right now so I'm just wondering if it's possible to purchase a service ...

  • Glacial
    Glacial Level 1
    • 3 12 years ago

    How can i get my balance back that was used to pay other services here in seoclerks? Answered

    Hi good day to all, i want to ask about something about my balance. Months ago i've bought a vcc here in seoclerks but unfortunately it was not working to the site i want it to be used. So the seller gave my money back, ...

  • kimjoshua99
    kimjoshua99 Level 1
    • 5 13 years ago

    Why can't I order for service? Answered

    Please I try requesting for a service on the website and it is not going. It say I don't have right and I don't understand what it means. I registered recently. Thanks

  • bestbulk
    bestbulk Level 1
    • 4 13 years ago

    On WTB service, Is it possible to pay freelancers using free purchase balance? Answered

    May I ask if the free purchase balance from seoclerks can be utilize to pay freelancers on want to buy service?

  • ledbyjm
    ledbyjm Level 1
    • 1 13 years ago

    Question regarding Seoclerk's Purchase Balance/Account balance? Answered

    Hello! I have some amount in my account balance which I earned from selling services!I also have some amount in my Purchase Balance(which I'm not allowed to withraw!), I made from Promoting SeoClerks. I want to make som...

  • ahmedjadoon
    ahmedjadoon Level 1
    • 3 13 years ago

    Should Sellers be able to BLOCK Abusive Buyers?? Answered

    Please give your opinion as to whether you think Sellers should have the option to BLOCK certain Problem Buyers from being able to purchase their services in the future. This may be a better solution than an Abusive B...

  • exjordanary
    exjordanary Level X5
    • 12 14 years ago

    Do I get paid for affiliate sales? Answered

    I want to know if I also get paid if one of my affiliates one of their services or only if they actually purchase something.

  • Ricus
    Ricus Level 1
    • 12 14 years ago

    Order Now
    Process Time: 0.12245583534241

    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 '% purchase %' OR A.tags LIKE 'purchase %' OR A.tags LIKE '% purchase' OR A.tags='purchase') 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 '% purchase %' OR A.tags LIKE 'purchase %' OR A.tags LIKE '% purchase' OR A.tags='purchase') 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 '% purchase %' OR A.tags LIKE 'purchase %' OR A.tags LIKE '% purchase' OR A.tags='purchase') 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 '% purchase %' OR A.tags LIKE 'purchase %' OR A.tags LIKE '% purchase' OR A.tags='purchase') 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='57569'1SELECT profilepicture FROM seoclerks.members WHERE USERID='57569'

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

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

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

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

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

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

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

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

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

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

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

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

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

    		/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.4690091SELECT 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 (16) AND gtags like'%articlewritting%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4690090.469009
    0.4619751SELECT 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 (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Alexabacklink%' AND type !=99 0.4619750.461975
    0.4617481SELECT 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'%CompititorAnalys%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4617480.461748
    0.4006351SELECT 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 (83) AND gtags like'%Talking%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4006350.400635
    0.2156271SELECT 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 (83) AND gtags like'%Talking%' AND type !=99 0.2156270.215627
    0.1597201SELECT 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 '%V3%' OR A.skills LIKE '%V3%') ORDER BY A.lastgigedit desc LIMIT 0,400.1597200.159720
    0.1276411SELECT 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 '%V3%' OR A.skills LIKE '%V3%')0.1276410.127641