SEOClerks

Discussions about Drop

Showing page: 1 of 1

On the 1st of August 2018, Google went live with a core algorithm update. This update was one of the largest core algorithm changes I've seen in years. I haven't witnessed so much volatility in my client's ranks i...

  • Cristian
    Cristian Level X3
  • 19 8 years ago

    We've all tried to do drop-shipping at one point or another. If you haven't, I'm sure you've thought about doing it but just haven't pulled the trigger yet. For those people on the fence about drop-shipping, I understa...

  • TommyCarey
    TommyCarey Level X3
  • 8 9 years ago

    As the title says, WordPress or WIX? Which do you use or prefer? To provide some background information for those that don't know these two web softwares. First is the WordPress. Wordpress is a web software tha...

  • Tronia
    Tronia Level 1
  • 10 9 years ago

    Hey guys. Anybody knows when issue will be fixed and why it happens? because I was working very good but now no ????

    4 9 years ago

    What happens if even the Real followers are dropped over night? I hade this terrible experience 03 days ago... And it looks like it is just me! My family, friends and colleagues just dumped me, but the thing is they di...

  • brrj
    brrj Level 1
  • 8 10 years ago

    Please i wish to know if festive celebrations like eld-el-fitir, Christmas, Easter, new year etc do lead to drastic drop or no sales at all? Or the sales remain unaffected? i noticed this last year December during the Ch...

  • chetaseo
    chetaseo Level 3
  • 12 10 years ago

    Why has my response disappear from SeoClerks faq and can't find it? yesterday I had 51 seo questions and responses, and today I just found that I have 41? 10 questions/responses disappeared, is this normal? Someone else ...

  • Takfarivas
    Takfarivas Level 1
  • 8 13 years ago
    Order Now
    Process Time: 0.11279797554016

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

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

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

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

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

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

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

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

    /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
    2.8379191SELECT 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 (17,18,22,30,33,47,49,50,72,84) AND gtags like'%Alpha%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 402.8379192.837919
    0.2483721SELECT 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 (87) AND gtags like'%Submit%' AND type !=99 0.2483720.248372