SEOClerks

Pokémon Go - Gotta Catch Them All! Advertising?



Write the reason you're deleting this FAQ

Pokémon Go - Gotta Catch Them All! Advertising?

Yeah, we all know it...
You play it.. Your girlfriend are playing it.. Your son.. Your daughter.. Your wife, husband, literally EVERYONE is playing this game. And for what? Car crashes and bruises? (That has already been covered so we won't talk about that.)


So, with that said, take a look at this:

Pokémon Go - Gotta Catch Them All! Advertising?

As you can see, it's crazy. It's viral. It's POKÉMON.

Is there ANYTHING we, as freelancers/marketers/advertisers can do, to get a piece of the traffic? Do you have any suggestions at all? Are you planning to advertise through this when you can, if you can, and would you, if you could?


YOU GOTTA CATCH THEM ALL!! (Just imagine the subscribers one could get out of these people...)


Best Regards,
hitmeasap

Comments

Please login or sign up to leave a comment

Join
idealmike
I just come across a WF email I was sent about this. I saw it and the first thing I thought was Pokemon Go Away LOL. But according to this this sales page thing, the game has over 21 million daily users and has been downloaded more than Tinder and has surpassed Candy Crush and becoming the BIGGEST mobile game in history. Anyway according to this sales page thing, this lady has made a "Pokemon Go Power Cheatsheet". I don't want to help her for no reason (or maybe I do), but if it's helpful for you or someone else here, and they want to give it a go here is the link to the sales page http://barbaraling.com/caffeine/PG/ where the price of the "Pokemon Go Power Cheatsheet" is only $3.77 anyway.

Truth be told, I don't really get what it is she's selling there. Well it's a cheat sheet for Pokemon Go. Apparently you'll get exact resources for making your OWN Pokemon product such as PLR, a how-to guide, Pokemon Go safety and the like some How to make money with Pokemon Go for businesses insiders tips. Whatever that means. Things that you can use to help you sell this guide or cheet sheet to people I guess, but it was only as cheap as a bag of chips so maybe someone can find out and make good use of it! And if you do, let us know how it goes and if it's truly profitable/lucrative and we can all jump on it.



Are you sure you want to delete this post?

MusicMoguls
21 million users ?! that is next gen stuff, to get on with that kind of traffic and to have it benefit you would be a money train non stop , but i agree in order to really profit off of the Pokemon app you would have to keep what you got going on involved with Pokemon one way or another , so it is not like your really marketing and using the traffic to benefit your service but creating a service to adapt to this traffic, it is all on perspective i guess at the end of the day



Are you sure you want to delete this post?

TommyCarey
There's plenty of ways to catch the traffic and I don't know why we all aren't teaming together to grab a share of the profits.

I don't want to go into too much detail because my ideas can get sniped and then I'm out of a paycheck, sort of lol Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

idealmike
Well you can't say that Raz and then not say nothing else! LOL I agree though I think that could be worth doing. In the long run. I think some keyword research is in order. Whether it's reselling that sort of thing to people that want to resell that sort of thing or actually selling it to the game players as a download, eBook or something. We need to jump on the gravy train before it leaves the station.



Are you sure you want to delete this post?

hitmeasap
I agree with you Mike. First of all Razzy should give us the details. ALL the details, as we "Gotta catch all the money". Pokémon Go - Gotta Catch Them All! Advertising?

And yeah, I would love to find a way to bring traffic from these, but I can't seem to find a good way of doing it.. At least not a way that would actually work in the "long-run" so to speak. I'm not interested in any of these short term / shortcut ways. I want in for real.



Are you sure you want to delete this post?

idealmike
Right on brother! All the way to the top. So far so much as I can see I mean an idea is the same as what that barbaraling is doing with her Power Cheatsheet and safety guide for the players and the other stuff she provides with it like the guide on how to make money with Pokemon Go businesses insiders tips and that. That caters for both the players and people that want to cash in on it too. I've seen people do this before with games and things like that and at that price she'll probably shift a few even on WF. I bet it would sell like steaming hot cakes on ebay and amazon too.



Are you sure you want to delete this post?

TommyCarey
I may actually buy that cheat sheet just to see what's in it. If I can get a link to some hot selling items that poke-mongo players will think are awesome and open up their wallets, I'll be happy Pokémon Go - Gotta Catch Them All! Advertising?

But if it's a garbage ebook with little to no worth, I'm going to be pissed off.



Are you sure you want to delete this post?

hitmeasap
If you buy it, let us know what you think about it and share some nasty details from it! Pokémon Go - Gotta Catch Them All! Advertising?

I bet it's one of those "quality" ebooks with 7 good pages, 4 decent ones and 32 crap ones. Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

Lynne
There you go Andre! That has generally been my experience of eBooks so far oh and big writing with lots of spacing so each page only has 100 words anyway. What I can write on one page some eBook author can make a 30 page eBook out of Pokémon Go - Gotta Catch Them All! Advertising?

By the way I am enjoying your eBook. I have not managed to find the time to read it all yet. I am reading a bit and digesting the information before I read a bit more.

I am also trying to see how I can apply it to my work.



Are you sure you want to delete this post?

hitmeasap
Haha yeah, it usually is that way.. At least it feels like it, but I think that it all depends on what you expect for starters.

And I do agree on the part of using large fonts, lots of spacing and often HUGE screenshots or pictures too.

Feel free to leave your opinions and/or thoughts on my book when you're done. Even if you think that I'm using to much spacing, too large fonts or whatever it might be. I would appreciate any suggestions or opinions you might have. Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

Lynne
LOL so you are saying the reason why most of the ebooks I've read are so bad is because my expectations are too high? bwaahahaaa that is funny.

It is also true. I do have high expectations. It is not about whether I have even paid for it or not. If I take the time to download something and open it up I want to find some sort of value in it, even if it is a tiny smidgen of good info. Usually I can find absolutely nothing of interest to me.

Your ebook on the other hand is so packed I haven't found the time to even read it in one go because I have to digest and process what I have read. So yes for the second time I have been impressed.

The only other ebook that I have read that I really enjoyed and I still have in case I want to read it again is by Pat Flynn.



Are you sure you want to delete this post?

TommyCarey
lol noooooooo I need to keep some secrets Pokémon Go - Gotta Catch Them All! Advertising?

I'm actually in the process of setting up a website to target pokemongo stuff lol. Also, whenever I see pokemongo, I think it says "poke mongo" like you're poking a guy named mongo Pokémon Go - Gotta Catch Them All! Advertising? Yeah, try to get that out of your head now lol



Are you sure you want to delete this post?

hitmeasap
Btw.. The "Poke mongo" thing is HILARIOUS. You know why? .. Not because you're poking a guy named mongo.. But because in Sweden, "mongo" is often used for people with down syndrome. But it's a bad word. It's mean.

However, when I read your "poke mongo" thing a second or a third time, I actually came to think of a meme I've seen. I thought about it even MORE due to what people in Sweden call people with down syndrome...

Here it is:
http://img.memecdn.com/touchdown_o_1110633.jpg

(I choose to not upload the image directly as some people might get offended.)



Are you sure you want to delete this post?

TommyCarey
I've been packing my bags to get on this gravy train, I just have so much crap to do before the train leaves Pokémon Go - Gotta Catch Them All! Advertising? Hopefully I can get it up and running and cash in on all the pokemon players Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

hitmeasap
barbaraling owes me a review for my product.. :/

Anyhow, yeah. She knows what she's doing and her things often result in some success so I bet she's on to something this time too. I don't know, I think I'm not seeing things clear. Perhaps I'm looking INSIDE the box this time.. Even though I'm quite good at staying outside of the box.. But this just.. I don't know. This whole Pokemon thing has went nuts, and perhaps, I have too..



Are you sure you want to delete this post?

TommyCarey
Yeah, I'm probably going to buy that ebook just to see if there's anything in there that I haven't thought of. And like she says on her website, it would take me days to do the research or I could pay her less than $4 for the research she's done and compiled Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

Everett
I always have issues with statistics. I need the data where the statistics is from. Does anyone have links to an actual study detailing the time the user uses the app vs other apps, and how was the data tested?

The image shows being 10 minutes over Facebook, that is fantastic. Just think people never knew that Facebook would lose with anything. . and we have this little Pokemon Go app that seems to be drawing traffic, and surpassing most download counts.. This is what you would call a viral phenomenon.. and I am loving every moment of it. I don't play the app, but it's nice to see how it all plays out. Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

MusicMoguls
I am not how to put my take on this honestly i have not put too much thought in to playing the game myself but i have seen the memes the jokes the complaining and the accidents that happened because of the game, so it is safe to say i acknowledge it now to market off the traffic i am not sure how exactly one would start off to go about that , there is no doubt in my mind there is a great way to capitalize on it honestly i just feel i do not know either i am thinking too hard , or it might be a little challenge to do so



Are you sure you want to delete this post?

EliteWriter
Oh yes, considering all the people using Pokemon Go it certainly makes sense to do something about it. The thing is you need to come up with something that can really work and that can really get you money rolling in before all the craze and addiction related to this game disappears. I am not one who has any practical ideas and/or skills that might come in handy and i know very little about the game, so I wish you guys the best of luck at doing something about this asap Pokémon Go - Gotta Catch Them All! Advertising? let us know if you do.



Are you sure you want to delete this post?

Lynne
Oh I need to think how I will cash in on this craze. I'm still trying to figure out why people have gone so nuts over this game!



Are you sure you want to delete this post?

EliteWriter
It is a really addictive game. I was not one of the first to try it out, but when I saw how popular it was becoming I decided to see what it actually was all about. Now I am not a fanatic or something, but it can actually make you want to go out and walk and see if you manage to catch a pokemon. And whenever I go out I make it a point to check out what is in the vicinity. It is a bit difficult to remain level-headed because it is addictive and I truly think that for most teens it is quite impossible as it is a craze.



Are you sure you want to delete this post?

idealmike
Guys check this out, just saw it come up on my news feed last night; Gamers Can Now Cash In On Pokémon GO. Apparently as of last Friday, more than 100 PG accounts were up for sale on PlayerUp.com, a marketplace for game accounts. Some PG accounts were selling for as much as $600! So players are selling their PG accounts and "it is not illegal to sell these accounts in the U.S". Do you think that the game developers will offer some sort of "account swapping services" for a fee in the future?



Are you sure you want to delete this post?

hitmeasap
Yeah, I actually saw a girl on a marketplace in Sweden (it's called blocket), that offered her assistance.. Kind of cool actually.

Here it is:

Pokémon Go - Gotta Catch Them All! Advertising?

As this is in Swedish I'll wrap this up for you.

Pokéwalker. It's basically like dog walking. She will play pokemon go on your account during the time you're on work or whatever. Whenever you need her too. She will:
  • Catch pokemons.
  • Set out lures.
  • walk several miles per day to hatch eggs.
  • Collect exp. to level your character and your pokemons.
  • collect items and eggs.
  • and much more.


That's basically it and it's a rather cool idea. Pokémon Go - Gotta Catch Them All! Advertising?



Are you sure you want to delete this post?

Everett
I was wondering when someone would offer a service level up the pokemon. LOL

*does a search on the marketplace for 'pokemon go'*

And the results are in!
https://www.seoclerks.com/search/pokemon+go

So it seems that many people are jumping on the bandwagon, and trying to cash in on Pokemon Go's success.



Are you sure you want to delete this post?

EliteWriter
It is a cool idea indeed, considering that there are so many fanatics who would prefer to avoid going to work altogether so as to spend the whole day running around to catch pokemon! This Pokewalker is basically addressing that 'need', and at the same time she is also having fun, which is a great way to make money as I am assuming that she wants to be paid for this service. Was there a price mentioned, I'm curious?



Are you sure you want to delete this post?

Cristian
Wonder how much time will this viral trend continue. To be fair pokemon go is a nice way to fill up your time when you have nothing to do and you need to take a walk. But I find the game very limited, hope they have in plan future updates and add stuff like adding friends, private messages between players, pokemon alerts even though the app is minimized....stuff like that.
And also, training battles between players outside the gym!



Are you sure you want to delete this post?

EliteWriter
I am pretty sure they will be taking into account the many requests avid players are making so as to make this game even more appealing. There are surely going to be updates to it, and they will be improving it as these get released. In my opinion this game was launched at the perfect time - summer - when many teens are on their holidays, and when many people go out to enjoy the sun and the good weather. As the weather gets colder, I guess there are going to be some surprises to encourage people to keep playing it.



Are you sure you want to delete this post?

Cristian
Yes, how are people going to search for pokemons during winter? I don't think they actually expected so much success. Anyways I can already see that the trend is dying out already among my teammates. You have to have huge amounts of free time to play this game. And most of the gyms are already to hard to conquer.



Are you sure you want to delete this post?

EliteWriter
Yes, you need time - not only to walk and catch the pokemon, but also to find pokestops and replenish your supplies such as pokeballs, berries, potions and revives. You also need to take into account the time you need to spend transferring pokemons that are not that good so as to have space for more. It takes time to choose the weak ones.



Are you sure you want to delete this post?

Everett
You know what, I never thought of the colder months. What will they do to drive players to play when the winter hits? In some countries Winter is already here. It'll be cool if the game was based around the seasons where you're located at in the world.. do you think?

I mean, technology has developed to a point where this would be possible. I think games like Pokemon Go will help society leave their house, and actually get some much needed exercises. If I had this app, you could be sure that I would be outside most of the time to play pokemon! lol.



Are you sure you want to delete this post?

Corzhens
I understand that this is an obsolete discussion but let me share my thoughts. I am not surprised with the mention of 21 million users and probably even more. That’s how things work with people in the internet. When there is a hype and it goes trending, people tend to try it with no reason at all but just because of its popularity. But after playing that game for some time, the players soon realized the silly game is not for them. Walking around to play? That’s not a good one for players who want to be in the comfort of their computers.



Are you sure you want to delete this post?

Order Now
Process Time: 3.0744688510895

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='18215'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='18215'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=61601SELECT googleplus_profile FROM seoclerks.members WHERE USERID=6160

/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=18215 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=18215 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18215' 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='18215' 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=100028 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=100028 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=100115 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=100115 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=100039 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=100039 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=100042 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=100042 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=100050 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=100050 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=100058 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=100058 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=100071 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=100071 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=100095 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=100095 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=100183 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=100183 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=100519 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=100519 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=101874 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=101874 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=100070 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=100070 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=100100 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=100100 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=100072 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=100072 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=100059 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=100059 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=100113 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=100113 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=100079 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=100079 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=100114 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=100114 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=100145 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=100145 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=100187 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=100187 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=101729 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=101729 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=100475 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=100475 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=100521 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=100521 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=100706 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=100706 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=101733 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=101733 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=100686 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=100686 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=101754 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=101754 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=101777 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=101777 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=101781 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=101781 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=101959 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=101959 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=154485 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=154485 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='18215' AND status='1' AND (question like '%Pokémon - Gotta Catch All! Advertising?%' OR question like '%Pokémon%' OR question like '%Gotta%' OR question like '%Catch%' OR question like '%All!%' OR question like '%Advertising?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18215' AND status='1' AND (question like '%Pokémon - Gotta Catch All! Advertising?%' OR question like '%Pokémon%' OR question like '%Gotta%' OR question like '%Catch%' OR question like '%All!%' OR question like '%Advertising?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='104322' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='104322' 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='185206' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='185206' 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=18215%' 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=18215%' 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='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='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.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='6160.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.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='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'

/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='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='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 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