How to create a "selling" post title

TsuyoyRival Level 1

July 13, 2017, 4:55 pm

28

Write the reason you're deleting this FAQ

How to create a "selling" post title

Hi everyone,
I was thinking to invest on a blog, and I think I'm into something. My writing skills are sufficient for the task, but now I need some help from experts.
What steps should I take in consideration for writing a title for an article/post that will gather the attention of many people, for example purposes, let's say we have a bricolage blog.

Comments

Please login or sign up to leave a comment

Join

PedroP

While I'm no expert I have been dealing with the same struggles you have buddy. What I would suggest is that you do some keyword research and focus your titles on those keywords. Also, it's good to mention your keywords once or twice on your first couple of paragraphs. That should improve your odds of being noticed a lot.

9 years ago

Are you sure you want to delete this post?

galegatling

Right. Same for me too. Seems like any other titles or thoughts or concepts that you might think of has been published already. But you can always make one that is eye-catching. But before you can even do that, you got to have good traffics if you are planning to publish it soon because, what's a good title if nobody can even see it?

9 years ago

Are you sure you want to delete this post?

Corzhens

I have to agree that the inclusion of the keyword in the title has a strong effect on the SEO of your web page. So many discussions have that and I believe it is a fact that’s why some of my freelancer friends would always say that the titles of the web pages are direct to the point which means the keyword or keywords can be found in the title. I am still not well versed with keywords but I guess what I said are true.

7 years ago

Are you sure you want to delete this post?

kgord

Yes, I think the suggestion above is a good one. Keyword research is probably your most important tool when it comes to developing your blog. It is just one of the things that you probably need to do to get a killer post that will have lots of attention.

9 years ago

Are you sure you want to delete this post?

thart

And you can explain the benofit too. The title shoould let the readers know instantly that the post will provide them with something they need.

9 years ago

Are you sure you want to delete this post?

PedroP

Exactly man. I have used Jaaxy for most of my blogging life. Do you know other good sites (Free if possible) where I can find good keywords?

9 years ago

Are you sure you want to delete this post?

zackd

Avoid using all CAPS because that's annoying, at least to me. You're going to want to attack one's attention like a money value, I've found success with this and do it a lot.

9 years ago

Are you sure you want to delete this post?

zackd

When I make postings in Craigslist when I'm marketing a website or product, I avoid all caps and put in $xxx.xx then the title and have success that way.

9 years ago

Are you sure you want to delete this post?

thart

Using keywords that your reader might searching for, make good title because the post title can match the search term. This is a good SEO and it draws readers in because it clearly shows that the post will answer a question they have.

9 years ago

Are you sure you want to delete this post?

Tronia

By using the right keywords - using them in your title and throughout your content will help you with your SEO ranking and therefore increase your traffic. Other than that, you should try some catchy, shocking, surprising titles. The guides of ''how to'' or ''XY tips for ... ''' are popular because they grab attention

How to create a "selling" post title

9 years ago

Are you sure you want to delete this post?

peachpurple

Yes, I agree with the rest, use keywords, in your title and contents. Spread the keywords about 5 times in the content article, maybe one in the url link and the title. use Google keyword tool

9 years ago

Are you sure you want to delete this post?

ajlancer

Hi there thanks for thinking about making a blog as business purpose. I should say according to your question make right sentence as look easy and nice which looking eye catching for reader. But, as a SEO learner, I should suggest to you the concern of SEO. If you understand on-page SEO, any type of content can make big role for SEO affect. For that you must to select correct keyword for your title and is bearing your main keyword of that content or blog post. And in body part of your content, you must to try to highlight main keyword and some supporting keywords as well. So, if you only concentrate of tile either not looking SEO factor, that will not be beneficial for you. Permalink also good things for SEO affect.

Hope you understand

Regards by Ajlancer

9 years ago

Are you sure you want to delete this post?

Dhanidhamy

I totally agree with you. Also your posts should be based on the needs and interest of people, try as much as possible to make it simple and understandable.

9 years ago

Are you sure you want to delete this post?

zeedollar

Yeah i agree with all but there are some few take away.

1. Make sure you dont over stuff your title with keywords
2. Always keep it above 30 characters, but below 80 characters
3. Avoid making unrealistic and misleading titles, it does more damage than good.

But in all do a proper keyword research and make sure your headings are straight to the point.

9 years ago

Are you sure you want to delete this post?

TsuyoyRival

All the other threads were good, but you sir summarized what i needed ;) Props on that! About the "misleading title" is a good tip! i see many people use this and i personally hate when the post that i'm about to read is not what was expected initially.

9 years ago

Are you sure you want to delete this post?

JackDan

Definitely, the first thing you need to do is to use a keyword tool, so it can help you what kind of keywords can generate more traffics to your blogs. More importantly, you need to justify your content with the suitable title which can relate to your topic. Your readers will like it if your title is related to your content.

9 years ago

Are you sure you want to delete this post?

Laibrown

I do write for a bimonthly publication and also on a website that do post regularly. I am not saying I am a guru or something. But I always try to be poetic when choosing my title. In most cases I would have the title before writing the article. Like in most cases I develop the article from the title. Let me give an instance I want to write about political patronizing and deceit and picked the title as "wolves by the night" I don't know if you understand me but of you do this will give you a hint.

9 years ago

Are you sure you want to delete this post?

goldlady

Nowadays, it's kind of hard. The social media (Including blogs) are more competitive than ever. You will need to complement the blog with another social media like facebook, instagram, snapchat, twitter. It's easier to reach people throug this platforms than it is to reach people from a blog. It's very important you use keywords that help people find your post if they're looking for what you're selling and catches their attention immediately.

9 years ago

Are you sure you want to delete this post?

JoeMilford

I have several different blogs and sites, and so I try to cater each of those to its appropriate audience with the titles of my posts. It's good, of course, to link all of your pages to social media to generate traffic, but I also look at the statistics on my blogs and see which ones get the most traffic in terms of content and title, and then try to duplicate that, in a way, in new posts. It seems to be working, to some extent...

9 years ago

Are you sure you want to delete this post?

amazingsteven

Use attention catching words with your keywords in the title. Then spread the keywords in the article not more than 5 times.

9 years ago

Are you sure you want to delete this post?

TsuyoyRival

I feel the need to say that this community is amazing, thank you for the awesome tips, every one of you has given me. I will take every single one into consideration

How to create a "selling" post title

9 years ago

Are you sure you want to delete this post?

centurion

Selling post title means your title will be attractive within a sentence so that users or visitors can come to you and can visit your website or products and will buy the product from you. You can do keyword analyzation and can create a title with high volume of keywords so that you can get huge traffic.

Thanks
Centurion

9 years ago

Are you sure you want to delete this post?

mybarya

While I agree with the importance of keyword research, at the end of the day, you should still endeavor to write for people, and not for search engines. Write titles that will grab the attention of readers, as many have pointed out above, but not to the extent of employing clickbait and similar yellow journalism tactics.

9 years ago

Are you sure you want to delete this post?

TsuyoyRival

Of course, the customers are the boss, so I'm devoting myself to provide a good service, and not for search engines.

9 years ago

Are you sure you want to delete this post?

augusta

Writing a selling post title needs one to research the keyword for such topic, Don't capitalize all the words,to me I feel one is shouting.Let it be a bit subtle.Make the title a catchy one and if possible chip in some trending words to capture the imagination of the visitor.

9 years ago

Are you sure you want to delete this post?

PinkTurtle

Keep it short but interesting! Never use more than 70 characters I think exciting titles are always going to attract people into it. Also use only once the key word. I like writing titles as a question because that way people get interested by getting a answer and don't just read it in the title which would save me the time to read te entire article.

9 years ago

Are you sure you want to delete this post?

Corzhens

Thinking of a title is also my weakness. However, one advice I got was to make the title an action word like Go or Do. Another is to make the title slightly controversial or intriguing. I know it is not easy because it is on a case to case basis. But I am trying to learn the art of making catchy titles. For example in my niche that is about pets, an article detailing the breeding of dogs can have a catchy title of to breed or not to breed. Is that good enough? Oh well, that’s the best I can think of.

8 years ago

Are you sure you want to delete this post?

Process Time: 0.53121304512024

Possible Duplicate queries found!

Match	Count	SQL	Script
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='23481'	1	SELECT 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='23481'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='603012'	1	SELECT * FROM seoclerks.members WHERE USERID='603012'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=603012	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=603012	/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=23481 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23481 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23481' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='23481' 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=124234 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124234 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=124445 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124445 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=172618 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172618 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=124259 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124259 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=124347 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124347 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=124361 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124361 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=124329 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124329 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=124330 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124330 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=124346 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124346 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=124355 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124355 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=124373 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124373 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=124403 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124403 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=124558 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124558 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=124480 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124480 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=124516 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124516 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=124568 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124568 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=124681 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124681 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=124919 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124919 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=124921 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124921 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=124957 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124957 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=125050 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125050 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=125502 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125502 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=125764 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125764 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=125937 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125937 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=129126 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129126 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=129301 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=129301 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=147635 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=147635 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='23481'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='23481'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='23481' AND status='1' AND (question like '%How create "selling" post title%' OR question like '%create%' OR question like '%"selling"%' OR question like '%post%' OR question like '%title%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23481' AND status='1' AND (question like '%How create "selling" post title%' OR question like '%create%' OR question like '%"selling"%' OR question like '%post%' OR question like '%title%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='5478' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='5478' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='840' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='840' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3764' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1177' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1177' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1915' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1915' 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=23481%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23481%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='598592.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598592.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT 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='598676.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598676.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='584702.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='598910.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598910.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='4987.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='601783.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='601783.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='599432.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='599432.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='604318.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='604318.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='603739.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='603739.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='301993.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='301993.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='601615.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='601615.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='605129.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='605129.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.209902	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID	0.209902	0.209902