SEOClerks

What makes up a good business plan?



Write the reason you're deleting this FAQ

What makes up a good business plan?

Being in business is something that is always necessary when we are looking at having some financial freedom and being happy. However, when we are looking at getting some loans for our business, we should try to have a good business plan. What are the core contents of one? 

Comments

Please login or sign up to leave a comment

Join
kaushikangara
Getting to know your customers is the most essential part of the plan. Without identifying the potential customer base, thinking of stating a business is useless. You should do a preliminary analysis of who your target audience would be, what is the probability of your business to succeed, already existing competitors, the prices in the market at present and the location where you intend to set up your business.



Are you sure you want to delete this post?

Barida
That is true as we should know who our target audience are. This is one of the ways that we can get to enjoy some better moments as well instead of having to just start up a business without understanding the customers.



Are you sure you want to delete this post?

Kakashi2020
Well for starters the higher the profit margin the better and you can do that if you have a unique product or service. To much competition in a niche drives the price down as well as your chances of becoming successful. Find a niche where you could maximize profit.



Are you sure you want to delete this post?

MelanthaKrasos
I believe there are basic rule that we have to follow to start with a good business plan. First, know the place and it's people. Check whether the location you are planning to put up a business can generate customer. Find out if how many competitor you have to deal with and how to get ahead of them in terms of marketing. Then, think about your capital and the cost that it may incur during the actual startup. Most importantly include good customer service, it is the face of business that may either make it a success or failure.



Are you sure you want to delete this post?

cjctm11
I agree, when we start a business and didn't know how to manage one or even doesn't know your target market will be surely unsuccessful. You must know what is your product and what would be your targer market. Location must be on your priority list when building a business to ensure that there are customers who would avail your products even though it was retail or services.



Are you sure you want to delete this post?

Enyi
This is like taking a market survey to really know what really works. So first thing is to find out if there's really a market for the proposed business before embarking on one. A business plan must be concise and have the ability to succeed at least above 90% success rate.



Are you sure you want to delete this post?

ghednepo
I think being a business man you should change your mindset. You need to know the mindset of a business man and how they use their money properly and wisely. As a business man you should know hot to communicate to other people because people is your customer and without communication skill you will lose your customer. As a business man you should have this characteristic: Kind, Hardworking, Have a long patient, Smart, Brave, and lastly God Centered



Are you sure you want to delete this post?

Youngshark
Someone should underline the point on patience and highlight it as well so that nobody forgets its huge significance. Businesses can take long to pick and even longer to scale but with perseverance the results expected and more will be realized.



Are you sure you want to delete this post?

burgosmichael24
Planning is very important in everything you do especially in business. Someone said, "Failing to plan is planning to fail." So if you want to make your business a successful one, make sure that you are prepared with a concrete business plan. Here are some basic steps in making a business plan.

1. Establish a goal for your business.
2. Identify the present situation of the business you want to have.
3. Define the barriers that can hinder your success and the aids to solve it.
4. Make a step by step action plan.

I hope this could help you with your plan.



Are you sure you want to delete this post?

theresajane
This really helps. Thank you for sharing these tips.



Are you sure you want to delete this post?

burgosmichael24
You're welcome theresajane. Thanks for appreciating my tips. Anyway, Merry Christmas to you and to your family. May God's love and abundant blessings overflows in your family. God bless you.



Are you sure you want to delete this post?

astraherondale
I can't emphasize the importance of being goal-directed enough - in any endeavor, it's always important that you have your short-term and long-term goals clear in your mind. The goals will guide your entire process, and it keeps you anchored so you don't go off-track.



Are you sure you want to delete this post?

Jelineex
It's always best to have a feasibility study on what kind of business you want to venture. This will give you enough observation and analysis if it will have a probability of growth. Knowing and understanding in one's business will advance your skills and strategies. I know business is a risk but it's best to take security measures to stay on track.



Are you sure you want to delete this post?

jaymish2
I think to have a good business plan you should first look for a template.A template will have an outline of what should include in your business plan. The most important thing you have to pay attention to is your marketing research and plan. This would lay out the viability of your idea. Do you have an audience for it e.t.c. This is what a potential bank/investor would be looking at first.



Are you sure you want to delete this post?

theresajane
You have a point. It is really important to be prepared in any aspects. It's good to have a big plan broken down into detailed plan.



Are you sure you want to delete this post?

Alania
Best business plan is a plan where you've mastered all the aspect of the both income and outcome, the subject and the clients. What I mean is that you must plan ahead every step, and even consider what to do in case you will suffer a failure. That way, you'll be unbeatable, and your business will succeed.



Are you sure you want to delete this post?

dullian
Establishing your goals, knowing your capacities, knowing what is the budget you'll need and making a good estimation of how to spend that budget effectively so you can see the results of your efforts. Also, learning from others and try to follow or imitate conducts you can apply to yourself.



Are you sure you want to delete this post?

Alania
Remember the cliche from movies where a group of people plan every single move on a desk? That's how a business plan works actually. You have to calculate every single step. Never miss out on anything!



Are you sure you want to delete this post?

theresajane
I agree with you. It's is important to make your plans clear in you mind. You should be sure of the things like the budget.



Are you sure you want to delete this post?

NikSuks
Well, the businessman should examine the target market first. He/she should know everything about the needs of potential customers, what they do like and what they do not. Also, a businessman should have a clear vision how much money does he/she want to earn.



Are you sure you want to delete this post?

idealmike
I think first you have identify a demand for something. And then plan how you can provide/sell/retail that product/service that is in demand. And from there, hopefully form and keep a good business plan / model, for your business to succeed.

There's some good points made here already though so good advice. I agree about the mental outlook / attitude part. As well as the part about about knowing your targeted audience. That's why research companies spend millions on market research so they can better target and sell to people.

I like the part about working out your finances and budgeting options too. Many businesses go out of business simply because they didn't take some other costs into consideration. Hey when you're spending more than you're earning, that's negative business lol

And the part about learning from others too such as rival/competitor sites/businesses, what they are doing, achieving or failing at. You can learn a lot / poach ideas from them and put your own spin on them / make them better. The punters love it.

As well as the template idea too, sometimes setting up a business can be timely, mundane and a bit of a minefield to navigate / hassle to setup. But you can buy template ready to go businesses you just have to stamp your mark on and be in business quicker.

Now then, if you're talking about getting a loan to start a business, and needing to show a business plan of sorts to your lenders / creditors, then indeed you'll likely need something solid in place that is viable and sustainable. Since they definitely want their money back.

That said, these days, you can get business grants and things you don't have to pay back. You can/could use the power of the crowd for example and setup a crowdfunding campaign for it. That's what savvy entrepreneurs that want a free business do. But even they need to have a solid business plan in place else you wont even get the wheels on let alone rock the wheels off!?



Are you sure you want to delete this post?

esteban123
I think that a good business plan is something that is well executed were it is very near to reality and can provide us some benefits such as a huge amount of profit. But of course we all know that it is very hard to have a good business plan because there are some business plan that doesn't have a good outcome which is something that we do not want to happen.



Are you sure you want to delete this post?

Kakashi2020
Well there's a lot of requirements in getting a business loan like Positive Financial Statements for the past 3 years, Business Licences, Tax Clearances and you must have a sound Business Plan. It's best if you have a collateral but ifvyou don't have one, then you can't get a business Loan. But you can apply for a Line of Credit against any Purchase Orders or Contracts.



Are you sure you want to delete this post?

NerdIndeed
Regarding business loans, I feel that it's better to have investors rather than borrowing from a bank. As a business owner, you need to convince them that they'll get their money's worth in the investment, so have a good business pitch.



Are you sure you want to delete this post?

Martinsx1
Depending on the kind of business you are looking at getting into should be what determines whether you are to go for a loan or not.

If it's a short term business deal, then getting a long would be a good idea but if it's a long term business, it's better to use investors rather than getting a loan.



Are you sure you want to delete this post?

Alymae
Yes. I agree with you. If you are in it for the long run, find investors. It is not easy to find them, you would have to present a perfect business plan to gather investors. It is not easy to make a successful plan, it would have to undergo a lot of research and hard work.



Are you sure you want to delete this post?

NerdIndeed
I agree. I guess it also depends on the timeframe you need the money. It's just that regarding business strategies, isn't it better to plan for long-term goals rather than short-term ones?



Are you sure you want to delete this post?

satheeshsoft
This comment has been split into a new thread here.



Are you sure you want to delete this post?

overcast
Every good business makes use of the cashflow and clients as the top priority in their plan. You can see that having such good business plan would make business have much better long term results. Many business plans design the business in such way that they assume the clients are easy to come. And that means they find the clients out there are easy to work with as well. So on that note you can see that each business plan should have a lot of focus on the lead generation and cashflow.



Are you sure you want to delete this post?

knnon
A business project feasibility is essential if you're planning on taking a loan for your business. You'll need to do a lot of research and calculations. You'll also need to have a possible location listed in your feasibility report. Another thing to consider listing is the services you will offer and the set amount of price. You'll also need to list possible income and expense estimation for at least a month. You'll need to make sure that everything you calculated and put on your feasibility project is realistic and believable enough in order for your loan to be granted.



Are you sure you want to delete this post?

amelia88
One of the biggest things that I think helps a business plan are things like scalability, plans for expansion, and a framework for how you’re funding your business ventures. Ensuring that you know the financial side of the business is extremely important.



Are you sure you want to delete this post?

Martinsx1
It's very important to keep your customers needs included when making your business plans because no business can survive without its customers base.

Detailed research should be done by the business owner before setting up the business.



Are you sure you want to delete this post?

ghednepo
I think the best business plan is get some pointer to a expert, Because they know what is bad and good for you



Are you sure you want to delete this post?

cmoneyspinner
When it comes to a business plan I use those free ready-made templates. They are excellent guides.

https://www.thebalancesmb.com/entrepreneur-simple-business-plan-template-4126711



Are you sure you want to delete this post?

Alania
Oh wow, that's a wonderful tool. Guess that simplifies things by a degree, I'm surprised how I've never got the idea to use such template. Gonna try to fill it out and see how it works out for my future goal.



Are you sure you want to delete this post?

overcast
These are some good business plans. I think there is one more website named bplans. And the thing is that word or the excel document of such plans can be good. So I think you have found a good resource. I am also these days trying some of such on the Google docs.



Are you sure you want to delete this post?

axl2468
A good business plan should be detailed, have realistic objectives, and should be checked by an expert. It may cost you initially, but at least there will be a lower chance of your business failing.



Are you sure you want to delete this post?

ghednepo
i think the best business plan is to know what is your goal and wants to achieve



Are you sure you want to delete this post?

Kakashi2020
Well for starters the higher the profit margin the better and you can do that if you have a unique product or service. To much competition in a niche drives the price down as well as your chances of becoming successful. Find a niche where you could maximize profit.



Are you sure you want to delete this post?

Kakashi2020
Well for starters the higher the profit margin the better and you can do that if you have a unique product or service. To much competition in a niche drives the price down as well as your chances of becoming successful. Find a niche where you could maximize profit.



Are you sure you want to delete this post?

Corzhens
For a new business the core of the business plan centers on the capital and the profitability. A business person always looks for the potential revenue and eventual profit against the amount of capital. In other words the ROI or return on investment is the main concern for a new business. Why would you embark on a business if you do not have the assurance that it will earn? At least the business plan will give you confidence.



Are you sure you want to delete this post?

Rathiel
You have to know your market, and the ways that it grows, or can possibly grow. This allows you to adapt to changes better, and makes expansion a lot easier for you to do. After you get to know your market, get to know about the needs of said market. Why are people buying your product? Is it because it's affordable? Because it's a pioneer product?

Ask yourself how to keep your current customers while growing your customer base. Invest in good infrastructure and keep up to date with technological trends. And always, always, have back-up plans just in case something falls through the cracks.



Are you sure you want to delete this post?

ebetura
Earning now is not very easy if there is no strategy.



Are you sure you want to delete this post?

Order Now
Process Time: 0.27441787719727

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=6170771SELECT googleplus_profile FROM seoclerks.members WHERE USERID=617077

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='27727' 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='27727' 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=183394 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=183394 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=183771 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=183771 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=184550 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=184550 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=183410 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=183410 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=184000 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=184000 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=184130 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=184130 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=183413 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=183413 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=183472 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=183472 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=183422 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=183422 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=183462 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=183462 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=183605 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=183605 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=183592 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=183592 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=183428 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=183428 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=183433 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=183433 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=183971 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=183971 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=183442 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=183442 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=183445 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=183445 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=183645 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=183645 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=183972 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=183972 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=183474 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=183474 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=183492 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=183492 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=183503 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=183503 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=183524 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=183524 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=183528 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=183528 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=183646 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=183646 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=183749 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=183749 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=183903 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=183903 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=183577 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=183577 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=183615 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=183615 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=183629 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=183629 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=183631 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=183631 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=183638 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=183638 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=183639 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=183639 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=183730 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=183730 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=183789 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=183789 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=183792 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=183792 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=183776 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=183776 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=184377 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=184377 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=184548 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=184548 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=184549 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=184549 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=184863 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=184863 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=185001 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=185001 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=195233 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=195233 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='27727' AND status='1' AND (question like '% good business plan? %' OR question like '%good%' OR question like '%business%' OR question like '%plan?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='27727' AND status='1' AND (question like '% good business plan? %' OR question like '%good%' OR question like '%business%' OR question like '%plan?%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='9' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='9' 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='3084' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3084' limit 1

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

SELECT * FROM seoclerks.members WHERE USERID='337' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='337' 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=27727%' 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=27727%' 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='745124.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='745124.jpg'

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

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

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

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

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

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

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

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

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

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

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

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

/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='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='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
0.1090501SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 57937 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Seo Soundcloud Chartsystem%' ) LIMIT 40.1090500.109050
0.1049851SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 53810 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Css Php Js Html Laravel%' ) LIMIT 40.1049850.104985