SEOClerks

Clear
Sign In Join

Discussions about viral

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

How do I sell my video submission & backlinks services? Answered

I want to sell my video submission & backlinks services. How do I advertise the best way to get maximum traffic to the services?

  • MfaheemPBN
    MfaheemPBN Level 1
    • 4 7 years ago

    As a business, artist, freelancer, entrepreneur or whatever! Do you do/make podcasts? Answered

    As a business, artist, freelancer, entrepreneur or whatever! Do you do/make podcasts? Podcasts are basically audio files. Usually of someone talking. Or reading something out. They are getting much more popular ...

  • idealmike
    idealmike Level X3
    • 21 8 years ago

    Best way to make a video go viral? Answered

    Viral videos, especially on YouTube, can turn your business into a successful one overnight. It has happened and worked for many people but nobody has discovered the real formula that would work 100% of the time. Mos...

  • Tronia
    Tronia Level 1
    • 21 9 years ago

    10 Solid Viral Methods to Make Your Blog Posts Go Viral! Answered

    Are you struggling to make your awesome blog posts and articles to go viral? Want to get more shares and engagement on the thing you post? Well those clever people over on the BuzzSumo blog analyzed over 100 million arti...

  • idealmike
    idealmike Level X3
    • 6 9 years ago

    What happens when your website can't handle viral traffic? Answered

    What happens when your website goes viral and your host simply cannot maintain the amount of traffic it suddenly got? Has anyone been in the situation of buying a low budget hosting packages and starting a small webs...

  • Cristian
    Cristian Level X3
    • 9 9 years ago

    Is Viral Traffic A Good Thing? Answered

    I am sure you are all aware about viral posts on social media and how useful they can be for some people, but is it really a good approach? One of my websites is in a particularly viral nice and some posts on the site ca...

  • Hasa1015
    Hasa1015 Level 1
    • 8 10 years ago

    What is considered viral for Youtube? Answered

    I posted a question recently asking what makes a Youtube video go viral. Now what I am wondering is when exactly is a Youtube video considered a viral video? Is it a specific amount of views that needs to be gained? I...

  • Lynne
    Lynne Level 1
    • 10 10 years ago

    What Makes a Youtube Video Go Viral? Answered

    I've just had one of my Youtube videos go viral (for me maybe not for big time Youtubers!) with over 12 000 views. I've noticed that when I make a video that is controversial it gets a lot more views. So if I say thin...

  • Lynne
    Lynne Level 1
    • 27 10 years ago

    Please recommend a good voice clip recorder Answered

    I need a really good (hopefully free) voice recording app that will record audio clips when I need to make notes about writing projects or to record random writing related ideas. I would want to use this on my desktop, ...

  • Beverly
    Beverly Level X3
    • 10 10 years ago

    Can I record video serial about SEOClerks? Answered

    I already recorded some videos about SEOClerks (and get money for that) and I am enthusiastic to made small video serial with 10-15 videos about it, about impression, options, working etc. I think I am good enough to do ...

  • djqb031
    djqb031 Level 3
    • 4 13 years ago

    Order Now
    Process Time: 0.14611005783081

    Possible Duplicate queries found!
    MatchCountSQLScript
    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 '% viral %' OR A.tags LIKE 'viral %' OR A.tags LIKE '% viral' OR A.tags='viral') 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 '% viral %' OR A.tags LIKE 'viral %' OR A.tags LIKE '% viral' OR A.tags='viral') 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 '% viral %' OR A.tags LIKE 'viral %' OR A.tags LIKE '% viral' OR A.tags='viral') 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 '% viral %' OR A.tags LIKE 'viral %' OR A.tags LIKE '% viral' OR A.tags='viral') 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='791865'1SELECT profilepicture FROM seoclerks.members WHERE USERID='791865'

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

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

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

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

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

    		/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
    15.2364741SELECT 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'%sony%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 4015.23647415.236474
    0.5905901SELECT 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 (42,64,90) AND gtags like'%Newspaper%' AND type !=99 0.5905900.590590
    0.1185941SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%since%') ORDER BY total_recommendations desc LIMIT 0,400.1185940.118594
    0.0646481SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600 0.0646480.064648