SEOClerks

Answers from user mssoftmind

Showing page: 1 of 1

There was a recent discussion about whether anyone has scammed someone...now I am interested to know if anyone here has been the victim of a scam before? I was scammed once. It was about 20 years ago. I have always wa...

  • Lynne
    Lynne Level 1
  • 140 10 years ago

    As you might already know we had temporarily switched to manual review of all withdrawals due to a high fraud risk situation, resulting in delays and fees. We are happy to announce that, with limited exceptions, all wit...

  • Beverly
    Beverly Level X3
  • 91 10 years ago

    We've added a streamlined version of the order page for users that are not logged in (guests) allowing them to register on the fly, at the order page. This should increase sales for everyone since the order process no lo...

  • ionicware
    ionicware Level X5
  • 76 12 years ago

    Hey Clerks Nation, It's time for a new Fun Friday Raffle. Just reply to this thread your name will be added to a random drawing. It will close on Monday July 28th at 12:00 a.m. EST Good luck to everyone!

  • EricElliott
    EricElliott Level 1
  • 80 12 years ago

    Hey Clerks Nation, It's time for a new Fun Friday Raffle. Just reply to this thread your name will be added to a random drawing. It will close on Monday July 21st at 12:00 a.m. EST Good luck to everyone!

  • EricElliott
    EricElliott Level 1
  • 81 12 years ago

    Hello Clerks Nation, We are replacing the Fun Friday Contest with a Fun Friday Raffle. All you have to do is reply to this thread and your name will be entered into a random drawing. The raffle will close on Monday at...

  • EricElliott
    EricElliott Level 1
  • 111 12 years ago

    Hello Clerks Nation, It's time for the Fun Friday Contest! This contest will be for the user with the most affiliate sales between now and Monday June 30th at 12:00 a.m. EST. You must reply to this thread to enter into...

  • EricElliott
    EricElliott Level 1
  • 38 12 years ago

    Hello Clerks Nation, It's time again for the Fun Friday Contest! This weeks contest will be for the user that brings the most affiliate users. To enter into the contest you must reply to this thread. Good luck to e...

  • EricElliott
    EricElliott Level 1
  • 35 12 years ago

    Hello Clerks Nation, This weeks contest will be another random drawing. Just reply to the thread and your name will be entered into a random drawing. The contest is simple so don't miss out on the opportunity to win a...

  • EricElliott
    EricElliott Level 1
  • 90 12 years ago

    Hey Clerks Nation, It's time again for the Fun Friday Contest! This weeks contest will be a random drawing. All you need to do is reply to the forum thread and your name will be put in the random drawing to win a $25...

  • EricElliott
    EricElliott Level 1
  • 89 12 years ago

    We are accepting new users (affiliates) to generate and give out free $5 coupons. The coupons are redeemable by any new members of SEOClerks/CodeClerks/ListingDock, typically after they have signed up under you as an aff...

  • ionicware
    ionicware Level X5
  • 69 12 years ago

    Hey Clerks Nation, It's time again for the Fun Friday Contest. This weeks contest will be for whoever can get the most positive reviews on completed sales. This will include positive reviews for both buyers and seller...

  • EricElliott
    EricElliott Level 1
  • 71 12 years ago

    Hey Clerks Nation, We have been receiving many complaints from users due to late delivery. Many are requesting orders to be force canceled and are stating that they do not wish to use our website any longer. This issu...

  • EricElliott
    EricElliott Level 1
  • 133 12 years ago

    Hey Clerks Nation, It's time again for the Fun Friday Contest. This week we are pulling ideas from last weeks contest. This week will be for the best ionicware slogan or motto. It should include something that applie...

  • EricElliott
    EricElliott Level 1
  • 50 12 years ago

    Hello Clerks Nation, It's time for the Fun Friday Contest. As you can imagine, it is not easy to come up with contests weekly. This weeks contest is completely different than our contests in the past. To participate...

  • EricElliott
    EricElliott Level 1
  • 57 12 years ago

    You may have received multiple emails for the Buy 3, Get 20% promo announcement this morning. This was due to a glitch which spawned several instances of the script to initiate at the same time. We are very sorry for thi...

  • ionicware
    ionicware Level X5
  • 24 13 years ago

    In celebration of launching the new SEOClerks (more details here), we are starting the third affiliate contest. We are giving away a total of $1,000 to winners of this contest with first place receiving $500 (all withdr...

  • ionicware
    ionicware Level X5
  • 29 13 years ago

    As part of the celebration of the new SEOClerks, we are giving out $5 coupons. Code: TheNewSEOClerks! Apply the code here: https://www.seoclerks.com/balance Feel free to share it with any potential affiliates (...

  • ionicware
    ionicware Level X5
  • 115 13 years ago

    We've added new data to the service page for the new SEOClerks only in order to help buyers find sellers who are more responsive. This will hopefully encourage sellers to be more responsive as well although looking at ou...

  • ionicware
    ionicware Level X5
  • 55 13 years ago

    Share inspiring and motivational quotes “Walk away from anything or anyone who takes away from your joy. Life is too short to put up with fools.” – Unknown

  • GeeOne
    GeeOne Level 1
  • 32 13 years ago
    Order Now
    Process Time: 0.05833101272583

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='mssoftmind' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='mssoftmind' AND status='1'

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

    SELECT * FROM answers WHERE userid=311721SELECT distinct quesid FROM answers WHERE userid=31172

    /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 (10338,10346,10355,10450,10452,10453,10501,10505,10506,10507,10508,10515,10517,10519,10520,10521,10522,10524,18291,17278) 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 (10338,10346,10355,10450,10452,10453,10501,10505,10506,10507,10508,10515,10517,10519,10520,10521,10522,10524,18291,17278) 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 (10338,10346,10355,10450,10452,10453,10501,10505,10506,10507,10508,10515,10517,10519,10520,10521,10522,10524,18291,17278) 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.quesid IN (10338,10346,10355,10450,10452,10453,10501,10505,10506,10507,10508,10515,10517,10519,10520,10521,10522,10524,18291,17278) 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='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='147'1SELECT profilepicture FROM seoclerks.members WHERE USERID='147'

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

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

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

    /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
    4.1102271SELECT 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 (42,64,90) AND gtags like'%123123%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 404.1102274.110227
    0.1954721SELECT 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 '%Fbfollowers%' OR A.skills LIKE '%Fbfollowers%') ORDER BY A.lastgigedit desc LIMIT 0,400.1954720.195472
    0.1393201SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 1764 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%PPC Facebookads paidmedia%' ) LIMIT 40.1393200.139320
    0.1211851SELECT 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 '%Transcription%' OR A.skills LIKE '%Transcription%')0.1211850.121185