SEOClerks

What SEO is working for you 2018+? Can you rank up new sites today as easy?



Write the reason you're deleting this FAQ

What SEO is working for you 2018+? Can you rank up new sites today as easy?

Some people ask me what SEO is. In as little words as possible I tell them it's the process of ranking up a website in Google so that it ranks number 1 or as close as possible to number 1 ranking position as possible.

And when it comes to SEO and ranking a site up using SEO it's still the same today as it has been then. You still have to do SEO on that site to get it ranked up, ranking higher, number 1 or as high as possible.

But obviously SEO and what it means has changed and evolved over the years. And the main pattern and emphasis has always been on quality and relevance. Where quality and relevance is the type of "backlinks" you have.

Basically showing that Google has and always probably will use the backlinks you have in its ranking algorithm. Though we know today that it also looks at on-page SEO as well. But your backlinks and "social signals" are counted as a "ranking factor".

And of course, every site, in any niche, needs its own unique SEO and SMM in order to get that site ranked up in the SERPs. It needs its own good on-page SEO, something that's usually sorted with a lot of great unique content in your niche.

Are SEO Backlinks even needed to rank up a site in the SERPs?

In fact, some people swear down that they rank up sites in the SERPs using nothing but sheer content only. Without even building backlinks. By just focusing on on-page SEO (content) only, they are able to rank up sites in time without even needing to do any off-page SEO or SMM at all.

You can find those guys videos on YouTube was watching it the other day. Search "how to rank sites without backlinks" on YouTube for the videos. This is one of them from some bloggers that rank up websites without ever building any backlinks.



OMG rank up websites without building backlinks!? Then what have I been building backlinks for this whole time right!? Don't get me wrong or take this out of context, while it's still possible to rank up sites without any off-page SEO (backlinks/SMM etc), for those sites that you don't have a lot of content on, such as few page stores, landing pages, etc, you can rank them up using SEO (backlinks/SMM etc). It's just that you can also do it without too it depends which route you want to go! What SEO is working for you 2018+? Can you rank up new sites today as easy?

So there's a lot of benefits to SEO backlinks of course. And as SEO has evolved, the SEO you can do has too which comes in many different ways, formats, shapes and means from simple guest posts to more.

As for me these days I am finding that niche related guest posts are working well as well as signals from high traffic blogs and sites like Reddit, Quora, Yahoo Answers from quality answers which also drives targeted traffic works best but it takes time and you have to do it professionally but they provide some good links with juice and traffic so you can't go wrong! 

What SEO is working for you 2018+?

Comments

Please login or sign up to leave a comment

Join
cmoneyspinner
What seems to be working for me is creating profiles on community sites that have a good reputation and a good ranking and within that profile bio about myself including links to my websites and blogs to redirect traffic.

Being more active on social media, not just sharing my links but sharing the links of others and making genuine relevant comments seems to be working as well. I found a comment accidentally via a Google search. That's when I realized commenting was important.

Posting to the Google Plus social network with proper hashtagging seems to be a good content strategy.

Is this response relevant to the discussion?



Are you sure you want to delete this post?

idealmike
Yes definitely it is since SMM is all part of SEO where you would do SMM such as Google+ Community posting, Facebook group posting etc as part of your SEO. And that's good to know I also do that and find it works well if the profile URLs are also keyword friendly. Since they are usually high authority sites, it's not too uncommon to get those profile URLs being ranked by Google for their keywords too which all links back to you. Definitely Google+ Community posting works though! When done consistently and not just wham bam thank you mam posts but actual interaction even if it's just dropping one liners on other people's posts sometimes. Great answer cheers! What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

cmoneyspinner
Thank you. I have more questions for you.

RE: “niche related guest posts”.

~ DO you write guest posts and charge for it?
~ DO you invite others to guest posts on your blog and pay them for it?
~ DO you write guest posts, no charge but embed links in your content or author's bio?
~ DO you invite others to guest posts, do not pay but allow them to embed links in their content?



Are you sure you want to delete this post?

Corzhens
Being active in social media is imperative for freelancers because social media is having your own network of people that you can later utilize for your work. Since I have a full time job in the office and add to that my part time freelancing work that leaves me with very little time in social media. Maybe when the time comes that I retire from my office job then I will be indulging more in social media.



Are you sure you want to delete this post?

onlinephp
I have heard people say backlinks does not matter to rank your website on search engines. like you said it depend on the niche. The guy that rank his site on google without backlinks did it for the knife niche But in my own opinion quality backlinks,SMM still works.



Are you sure you want to delete this post?

idealmike
Yeah I agree, sure, I guess it also depends on the competition like but you can rank a site with just content alone I know I've done it myself. But you can also rank a site up without content and just pure SEO and SMM too. For those that can't do a lot of content, SEO/SMM etc is the only other option! What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

Kakashi2020
What remains to be the best factor in rankings is a regular supply of Good Interesting Quality Content. If you have it then you have accomplish 7/10, a good social media presence 1/10, other SEO 1/10. So basically having good content is the surest way to boost your site.



Are you sure you want to delete this post?

treecko142
Definitely, no amount of promotion will give you success and a guaranteed audience if your content is poorly done in the first place. Always focus your efforts first on improving the quality of your services or content before moving onto ads or SEOs.



Are you sure you want to delete this post?

idealmike
That's interesting but true though, you can have and do all the best SEO/SMM in the world, you can have a great social media presence, but if your content sucks none of it really matters that much lol. Unless your content is so bad that it forces people to click out via one of your ads. I know people that make sites/blogs/content like that just to make people do that! What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

aeon
I think your website should provide goods, services, or content that a web searcher using only a specific keyword. Having relevant content increases the chance people will stay and interact with your website and it will help you to increase your rank.



Are you sure you want to delete this post?

keen2write
I see you shared the video by income school off of YouTube I also follow them and give great advice. Backlinks are good but content always wins hands down. The more articles you write blog posts the better.



Are you sure you want to delete this post?

idealmike
Yeah Kev those guys are awesome at what they do. They come up with an idea, form a plan and stick to it and over the course of time just keeps growing and growing and from just content only. And agreed, the more content you have on your site covering many different topics etc, the more likely your site is going to be crawled, indexed and ranked for that content and the more it will pick up natural organic visitors and backlinks, citations, social signals, shares etc on its own anyway. Although doing some SEO and SMM at the same time wouldn't hurt if done right and help you grow and rank up faster anyway right? What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

keen2write
Thanks Mike yeah I know what you mean. But sometimes I do work on my social signals and I am struggling to rank one of my websites. Probably because my main blog is spiritual psychic and paranormal and that niche is popular. I need to re write few old articles I think. Because like income school mentions the more words the better it is ranked of course the grammar use correctly as well.



Are you sure you want to delete this post?

overcast
For me forum posting the article sites where I can put the backlink. That is the only formula working out for me all those years. I have seen other ways for earning. But so far nothing of value as such. So I am working harder on this part and hoping to be changing in some ways there. Hopefully I can find more ways to backlink and get some traffic. SEO on it's own hasn't changed much.



Are you sure you want to delete this post?

idealmike
Yeah that's a good strategy since you can join forums in your niche and thus get a relevant, related backlink. More than this, you can establish yourself as an expert in your niche/industry and those with forum profiles that have a lot of respect from the members are the ones that can go on to use those forums members to their benefit as well whether subtly directing them to their blog or of course selling things, services etc on those forums too you know? ;)



Are you sure you want to delete this post?

overcast
Yes it can be a good lead generator. Something like for both direct product or say for the mailing list. It can be tiring though posting all the time. But it can be done. I have seen people trying on forums. And getting lead though hard but many do.



Are you sure you want to delete this post?

kgord
I think being able to use backlinks is one of the best ways to rank your site. I may be wrong about this but I think it is probably one of the best ways to be able to rank your site. What do others think? Obviously, good quality content is the most important thing, but backlinks rank right up there as well.



Are you sure you want to delete this post?

idealmike
Yeah that's it, my point exactly. A bit of both can't hurt. Sure, you can rank up a site with just content alone. But it can't hurt to do some SEO and SMM promotion / advertising at the same time to drive more traffic back to it can I get an Amen!? What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

treecko142
I personally think that building up through backlinks is still the way to go, but of course, you can find other ways to rank up your sites. You also have to be updated with the current events, for example right now advertising through Facebook may not work out as well due to the recent controversy.



Are you sure you want to delete this post?

Kakashi2020
What would happen if you did a lot of backlinks but you have shitty content, let's say you're a blogger or someone selling products and you have good SEO and has a lot backlinks but not so good products or blog content, what would happen next?



Are you sure you want to delete this post?

idealmike
Well Google would use the same algorithm ranking factors on your site as any other regardless. So it would look at your off-page SEO (backlinks) and decide if the huge amount of them you have are natural or not (and it's got a lot better at doing that). And also look at your on-page SEO (your content, images etc) and rank your site in the SERPs accordingly based on where it thinks it should rank according to your backlinks and content. If your site didn't have great content / products / descriptions etc and just didn't provide a very good experience, Google would likely pick up on that too as it's well known that CTR and visit length plays an important role in ranking. So if it sees that people are leaving your site quick (since those people aren't liking your content) then your site would suffer as a result of it. This is why everything needs to be quality today from your on-page SEO and content etc to your backlinks too. Hope this helps? What SEO is working for you 2018+? Can you rank up new sites today as easy?



Are you sure you want to delete this post?

Martinsx1
The only way backlinks wouldn't be helpful in one's ranking is when they are not of high quality. This is the major mistake most people do, for trying to build too many backlinks, they would create a useless one that wouldn't impact positively on their site. But when you have just 2 good quality backlinks, they are definitely going to help with your site ranking.



Are you sure you want to delete this post?

vinaya
I began writing on Hubpages in 2010. By 2012, I had published hundreds of articles on hubpages and over a dozen articles appeared on the top ranks on Google. Quite a few were even on the #1. Interestingly, I did not know what exactly was SEO. IN 2013, I attended 6 months intensive apprentice program on Hubpages and learned about SEO. When I knew about SEO, I did an SEO audit of my articles and discovered why my articles were ranked high.
The articles were on less competitive niche
The articles used long tail search terms in the title and the body.
The articles had primary and secondary keywords.
I believe you can rank on Google with well written contents. You don't even need backlinks. However, in order to get ranked on search engines without other SEO strategies, you need to produce well written contents that are not only unique but also interesting.



Are you sure you want to delete this post?

Corzhens
I have to agree that you can get a good ranking in the search results list if you have high quality contents. Uploading high quality contents frequently can continuously improve the ranking of your website even if you don’t use keywords or you don’t promote your website with the backlinks and in bookmarking sites. However, if you have the time to spare, it is still good sense to promote your website in the internet and also use keywords whenever possible.



Are you sure you want to delete this post?

owravs
Nice..
the video provided is working.... u recomend this...



Are you sure you want to delete this post?

sanaamaan
I think, it is very hard to get backlinks for website, I am writing blog for my site www.thescientificworld.ml,
http://www.thescientificworld.ml/2018/05/why-do-we-forget-things.html



Are you sure you want to delete this post?

Order Now
Process Time: 1.335743188858

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=2721SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='25771' 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='25771' 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=153283 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=153283 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=153438 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=153438 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=154431 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=154431 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=179060 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=179060 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=153315 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=153315 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=153439 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=153439 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=153328 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=153328 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=153389 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=153389 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=153440 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=153440 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=153332 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=153332 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=153339 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=153339 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=153441 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=153441 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=153482 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=153482 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=153395 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=153395 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=153443 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=153443 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=153462 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=153462 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=153427 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=153427 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=153444 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=153444 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=153547 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=153547 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=153567 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=153567 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=153568 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=153568 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=153572 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=153572 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=153609 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=153609 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=153614 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=153614 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=153751 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=153751 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=156852 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=156852 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='25771' AND status='1' AND (question like '% SEO working 2018+? rank sites today easy?%' OR question like '%working%' OR question like '%2018+?%' OR question like '%rank%' OR question like '%sites%' OR question like '%today%' OR question like '%easy?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='25771' AND status='1' AND (question like '% SEO working 2018+? rank sites today easy?%' OR question like '%working%' OR question like '%2018+?%' OR question like '%rank%' OR question like '%sites%' OR question like '%today%' OR question like '%easy?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='707' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='707' 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=25771%' 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=25771%' 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='596028.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='596028.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='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='673826.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='673826.jpg'

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

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

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

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

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

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

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

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

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

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

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

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