SEOClerks

SEO for Youtube internal Search?



Write the reason you're deleting this FAQ

SEO for Youtube internal Search?

Hello guys! Let's talk a little about doing SEO outside search engines. What about bigger than life platforms like Youtube? They have their own internal search engine.

I had clients that wanted to be first when searching on youtube a certain keyword.
So I discovered SEO for youtube exists!
Main things to consider are the keywords in title and description. As well as tags.
If the subject and niche permits you can write a small article in the description to drive real organic traffic from the search engines.
Otherwise, just use searchable keywords, there is no keyword planner for Youtube search so you'll have to presume they're pretty much the same.
Sorting your videos into playlist named after category keywords can also help.

But probably the biggest factor in Youtube rankings are the views. If you have lots of view compared with the competition, Youtube will automatically assume you have the best video on that subject.

Comments

Please login or sign up to leave a comment

Join
anwebservices
I guess SEO for YouTube is very important. Few days ago i was reading some statistics where it state that YouTube is second (after Google) where simple people performing search for anything, then Bing and Yahoo is far behind. So, when it comes to natural organic traffic, it's smart idea to publish even short videos on YouTube and make nice SEO job done for it. BTW it's not so complicated as for websites. YouTube's auto-suggest search tool is very good keyword planer too i guess...



Are you sure you want to delete this post?

Corzhens
Does that mean that Youtube has more traffic than Bing and Yahoo? In that case Youtube is a super power site. And if has a higher ranking in Alexa than Facebook then I guess we can concentrate on making videos for traffic to our site. But with the internal search, I didn’t know that you can optimize the video via the description and the tags. Perhaps I can enhance the SEO capability of our videos by improving the keyword tags.



Are you sure you want to delete this post?

idealmike
But probably the biggest factor in Youtube rankings are the views. If you have lots of view compared with the competition, Youtube will automatically assume you have the best video on that subject.

I wish! :genie I think it might indeed correlate with rankings but not on its own. Not just views by itself. If that was the case, then you would be able to rank a video higher than the competing video by just views alone. However, YouTube knows that people can buy views and thus, because of that, it's not a major ranking factor. All the other stuff is right though that it all comes down to every other part of the video. That includes the title, the tags and the description of it. But that combined with how much engagement and sharing that video gets. YouTube can see how many shares a video has. Because a video is a webpage with its own URL like any other webpage and they can check see how many shares or social signals that video has. This includes how many facebook signals such as shares, reshares, mentions (comments) it's caused, how many tweets or retweets its had, how many linkedin shares, how many pinterest pins, how many other social media shares or mentions it has. The more it has, the more popular it is or is seen to be over the actual amount of views it has. Although views, likes and comments on that video come into play as well. I'm not going to disagree with you. I'll digress though because while I can't be sure as I don't know YouTubes algorithm, I've done enough YouTube marketing in my time to know for sure that its not just views and likes that help a video. But rather both the on-page SEO of it as well as the off-page SEO and social media strength it has. I really do believe that YouTube look at this when ranking a video. I think they also use how many subscribers your channel has and how many daily views all your videos are generating and prefer to show videos nearer the top by popular channels as opposed to less popular channels. So even if your video has more views, the channel that has the same video, the same keywords in the title, will likely rank higher if the channel of that video has more subs and their previous/current videos have a lot of engagement/activity/signals already. I'm just saying I think that it's possible that comes into play but that it's not views alone that rank a video higher. I wish that was the case!

I've got someone on here working on a Whiteboard explainer video for me for promoting SEOClerks and looking forward to when it's finished. But I'm probably going to have to do more on it than get it lots of views if I want it to rank real high both on Google and YouTube.

By the way.

My channel: https://www.youtube.com/c/MikeBikerton

Subscribe me so you know when I post it.
I'm planning to post lot of cool videos, animated explainers, testimonials, reviews etc.
Going to blow the competition out the water! Maybe, LOL.

Watch this space!



Are you sure you want to delete this post?

Cristian
Thanks for the detailed explanation! Yes you are totally right, guess Youtube has some form of looking for page authority when ranking a video on its own search. Of course, fake view won't get you anywhere and youtube can make a difference between real and fake, but overall real social media engagement along with backlinks, and real people watching your video is more important than a perfect optimized text content.



Are you sure you want to delete this post?

danigo
I also think youtube needs seo optimation,
because it is already like some search engine but filtered only videos,
so if we can handle it well, I'm sure our videos will be on highest positions



Are you sure you want to delete this post?

TommyCarey
Every search feature has a type of optimization, you just have to crack it's code SEO for Youtube internal Search?

Some search features are tougher to crack than others, and YouTubes search feature is fun to toy with SEO for Youtube internal Search?

The YouTube search feature is a little more advanced than others because, you know, it's owned by Google lol. Just because it's advanced, doesn't mean it's uncrackable lol. Just focus on the same factors you would if you were putting up an article on a blog. There are a few different things that will help, and I'll cover some of it.

First: Work on your titles. Not all titles are created equal because you could accidentally be hurting your video by using too many keywords in the title, knows as keyword stuffing. Try to just get one keyword into the title so that you will have a better chance of ranking for that one keyword. Don't stuff 3 or 4 keywords in there because it could just hurt you later on.
Second: Content/Description of the video. You'll need to optimize the content or description of your video with the proper amount of keywords and making it readable. Make sure it doesn't look like it was written by a 5 year old SEO for Youtube internal Search?
Third (harder): You need to get views on your video to help increase it's position in the search features on YouTube. The more "popular" your video is, the higher it will rank just like in the search engines.
Fourth: Obtaining likes. Having a lot of views isn't the only thing that will help you increase in the platforms search rankings. You'll need to get a lot of likes, or thumbs up, in order to increase your positioning.

Now I know the first and second stages are easier than the third and fourth, but you can do it SEO for Youtube internal Search?



Are you sure you want to delete this post?

idealmike
Hi Raz, regarding steps three and four on your list, are you referring to buying views/likes for it? If so see my reply above to Cristian about views and likes alone not being a ranking factor. I believe they help of course, but you can't just go whacking 100k views and likes on your video and expect that it will rank higher. It doesn't trust me! Also YouTube can tell whether they're fake views or real because that many real views would produce a lot of engagement as it's shared on social media etc and they can see whether it has this as well or not. They can see all its ranking stats and where it's ranking for every one of their ranking factors. No doubt it can help but you also run the risk of getting your video and subsequently your channel banned from YouTube if they think you've been trying to manipulate their algorithm by artificially inflating your views and like stats and that's never fun! You probably already know this so am saying more for the newbies that might be reading this. SEO for Youtube internal Search? I agree though with everything else you've said! And yes it can be fun trying to crack it's code but that should be done through good on-page SEO and safe off-page SEO and then the views and likes and other engagement will happen naturally.



Are you sure you want to delete this post?

TommyCarey
Oh, or course. You can't just buy 100k views, likes and comments and see your video at the top of everything SEO for Youtube internal Search?



Are you sure you want to delete this post?

EliteWriter
When you post a video on YouTube you are doing a really good thing. Some advertisers fail to realize that a good portion of their followers and prospective customers tend to use YouTube as they prefer videos to written stuff. So step 1 is to create a good video and post it on YouTube. Next you need to see to its optimization. As explained above, including a short description and several relevant keywords is of essence. Even though YouTube clearly considers the number of views you get, the keywords and tags are very important as well. Avoid posting a video without accompanying keywords and an explanatory description.



Are you sure you want to delete this post?

ppscslv
Use paid advertising on YT and you'll solve the problem.



Are you sure you want to delete this post?

Lynne
I've been rocking page 1 of Youtube and here's what I have found.
  1. Add your keyword in your title
  2. Add your keyword in the first sentence then add a call to action underneath. Don't make this more than 2 lines or it will be under the fold.
  3. Write a min 200 word description for your video
  4. At the end of your description add your name, then underneath your website name (and url if you have correlating post), then underneath that your title with your keyword
  5. Then at the very end add the url for this Youtube video
  6. Add a custom thumbnail. The thumbnail should be named as the keyword.
  7. Your video should also be named your keyword before you upload it.

Regarding the keyword research, I just do normal keyword research and then I check my competitors on Youtube using the keyword I want to use. I just see if I can beat those videos.



Are you sure you want to delete this post?

Cristian
Great tips Lynne! One of the best I seen on Youtube SEO, straight to the point. I forgot about the custom thumbnail! It also haves to be pretty high-quality right? I always found myself to stay away from thumbnails that look like they were made in Microsoft Paint.



Are you sure you want to delete this post?

idealmike
Very good tips she is a pro YouTuber and will go on to get even bigger hopefully! SEO for Youtube internal Search? Yes there is no reason to make low quality thumbnails anymore and no excuse for it this isn't the 90's! Not when there are many free online image tools and even some great free image editing software you can get today. Canva is one place for making many types of presentations. I wrote about them earlier in my post on Top 5 Free Infographic Creation Sites Used and Reviewed. Using any of those sites you can make some spectacular and stunning artwork, visuals and thumbnails and anything else like that for free. SEO for Youtube internal Search?



Are you sure you want to delete this post?

Lynne
LOL Mike a "pro Youtuber"? Me?? Hahahaa I don't think so. I do Youtube and I do ok but I wouldn't call myself a Youtube professional by a long shot.

But thanks for the compliment SEO for Youtube internal Search?



Are you sure you want to delete this post?

Lynne
I am not great in design, not at all! I just use Canva and I try my best. So far it works for me SEO for Youtube internal Search?

One day when I have buckets of cash I'll outsource my image designs but for now I have to do everything myself.



Are you sure you want to delete this post?

idealmike
Canva have an app now Lynne. Have you tried it? It's free from the Apple app store. I think they might have an Android version too. I checked it out quickly and it seems okay. Not quite like the web version! But you can still make presentations, posters, covers, graphics etc with it. You should try it out! SEO for Youtube internal Search?



Are you sure you want to delete this post?

Lynne
Oooh noooo!

I detest using my phone for anything other than phone calls, texts and email. I don't even like Whatsapp but since my kids school uses Whatsapp groups to stay in contact and share any news I have downloaded it to my phone.

You know what I miss? My old Nokia phone. No it wasn't a smart phone and no it didn't even have a touch screen. I couldn't even get email on it.

I had it for over 8 years and it was brilliant. I could phone and text on it. I could drop it and my kids could throw it.

Recently there was an echo when I made or received calls and I replaced it with a Samsung smartphone.

So thanks for making me aware of the Canva app but it is not for me. I will use my laptop or pc for work Canva SEO for Youtube internal Search?



Are you sure you want to delete this post?

idealmike
You should try it out. It's awesome for creating quick graphics and things you might need for video thumbnails etc. I'll put up a guide about it later with some screenshots and that of it as I think it's really cool and a real time saver which is always useful. SEO for Youtube internal Search?



Are you sure you want to delete this post?

ajlancer
Hi Cristian thanks for your question. I think you may Google SEO and YouTube SEO is not same. It is completely different but process almost same. YouTube completely different search engine. But, it is more easy to get result on YT search rank than Google search rank. I have some method but I do not want to teach publicly and I did SEO for some channel and they got first page on YouTube. I just want to say few simple tips for YT optimization. Use long tail keywords. Do not use shot tail keyword Anyways for YT. Make your video unpublished and get some like and dislike and view before publish. And use custom thumbnail which looking very attractive. Do not need to use thumbnail from exact video. You can collect it related of subject. And so on.

Regards by Ajlancer



Are you sure you want to delete this post?

Lynne
Yes I have found it relatively easy to rank on Youtube, I guess it is because there is less competition on Youtube.

I use the same method of keyword research for Youtube and then just check out my competitors and what they are doing on Youtube.

And yes I also use long tail keywords, no point in targeting short keywords that are high competition.

I haven't made use of any Youtube services though, I have done everything naturally so far.



Are you sure you want to delete this post?

Order Now
Process Time: 2.5030930042267

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='18302'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='18302'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

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

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM seoclerks.members WHERE USERID=1341SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134

/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18302 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18302 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18302' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='18302' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100694 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100694 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=167179 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=167179 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100718 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100718 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100745 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100745 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100728 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100728 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100749 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100749 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100859 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100859 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101081 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101081 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100762 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100762 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100788 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100788 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100814 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100814 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100823 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100823 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100861 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100861 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101001 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101001 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100999 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100999 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101003 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101003 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101023 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101023 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101433 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101433 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100950 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=100950 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101449 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=101449 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='18302'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='18302'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='18302' AND status='1' AND (question like '%SEO Youtube internal Search? %' OR question like '%Youtube%' OR question like '%internal%' OR question like '%Search?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18302' AND status='1' AND (question like '%SEO Youtube internal Search? %' OR question like '%Youtube%' OR question like '%internal%' OR question like '%Search?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18302%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18302%' 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='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

/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.2551771SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=420.2551770.255177
0.0723311SELECT 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 B.seo='freelance' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 1200, 400.0723310.072331