Drop shipping or Affiliate Marketing

mybarya Level 1

August 16, 2017, 11:03 am

35

Write the reason you're deleting this FAQ

Drop shipping or Affiliate Marketing

To all Internet marketers on here, do you have any preference on doing business with drop shipping or affiliate marketing? Which one is more cost-effective and less risky? Would be nice to hear actual experiences from marketers who have done both.

Comments

Please login or sign up to leave a comment

Join

DarthHazard

They are both not very risky, to be honest with you. With affiliate marketing, the problem is that you only get a fraction of the sale price and that can be impacted by the business decides to change the prices of their products. But the advantage is that if you setup a blog or website properly, you don't have to do much and all you have to do is ensure that enough visitors visit your website/blog. It's basically a great passive income method.

9 years ago

Are you sure you want to delete this post?

vinaya

Affiliate marketing is easy. All you have to do is set up a website and add affiliate products on your website and start promoting products. When someone buys products from your page, you earn comission. This process is automatic. You do not have to deal with receiving orders and dispatching products.
However, if you are doing drop shipping, you need to take orders and forward it to the drop shipping company and the rest of the work will be done by the dropshipping company. You don't need a website for dropshipping. You can do it on ebay.

8 years ago

Are you sure you want to delete this post?

overcast

To be fair for affiliate marketing. It is one of the difficult skill. And it's not that easy as it may sound. You can see that many times such affiliate marketing takes years to even reach the 1000$ USD. I have mostly noticed that dropshipping is rather easy to setup but difficult to make money. Affiliate marketing is harder due to adblockers and also people blind to ads and links.

7 years ago

Are you sure you want to delete this post?

vinaya

Affiliate marketing has not worked for me. I am yet to try dropshipping. However, I also believe that it is very difficult to make money with both of these earning models. In order to do dropship, you have to establish reputation of your store and this is the most difficult part of dropshipping. As far as affiliate marketing is concerned, people are no longer listening to the recommendations, when they want to buy they directly go to the online shop instead of checking the affiliate links

7 years ago

Are you sure you want to delete this post?

overcast

Yes indeed if this were to be easy. None of us would be spending time on forum. Instead working on those models. Both of those models cost a lot of money too. So keeping up with the methods is not that easy in that case. I personally think that affiliate marketing is easy to get into compared to drop shipping though.

7 years ago

Are you sure you want to delete this post?

clara1993

Both of them are good sources to make money without investments and I will go with drop shipping over affiliate marketing because with drop shipping you get to fix and negociate the price with a client as for affiliate marketing you can't fix the price you can only get some fixed percentages from the selles made and sometimes clients when they click on the link and see that it's an Affiliate one they drop it thinking that the price is higher just because they think you want to get some profits from them.

9 years ago

Are you sure you want to delete this post?

galegatling

The only best thing that I could imagine about affiliate marketing is that it's somehow a passive income of some sort since you won't be doing anything after you have linked all those products or services from your blog posts or websites. You will be just waiting for people to click them and buy them so you will get your own cuts as well.

9 years ago

Are you sure you want to delete this post?

vinaya

That's the beauty of affiliate marketing. On affiliate marketig, you don't have to bother with product procurement (just like in direct selling), taking orders and forwarding shipping address (like in dropshipping). It eases the work. All you have to do is find relevant products and promote on your website. You need high traffic, though.

8 years ago

Are you sure you want to delete this post?

overcast

I think if you have no money at all. Then drop shipping is not the one you should go for. Instead get into affiliate marketing. And once you have some steady stream of income. Then you can get into the product sales. This requires a lot of funding and effort. It's not do it and forget it method. You may have to work on traffic and sales part. It takes a year or so for things to work.

9 years ago

Are you sure you want to delete this post?

vinaya

I have been Amazon associate since 2012. I have not sold many products, however, I find affiliate marketing easy to make passive income. Dropshipping is more of a technical work. I have a website where I am promoting products from various affiliate networks. I hope to convert the website to a dropshipping website once my sales begin to pick up.

8 years ago

Are you sure you want to delete this post?

overcast

I have only success with selling books. Like I recommend books and ebooks to people on some blogs. And that works out. But the thing with dropshipping is it takes a lot of time with the shopify or the woocommerce to make money. And it may mean even a bit harder for the affiliate networks to properly setup in that case.

7 years ago

Are you sure you want to delete this post?

vinaya

Some of the affiliate products that I have been able to sell are essential oils, art works, ebooks, herbs etc. These products were sold through the articles on the same niche. For instance, I listed essential oil products on a webpage about essential oils. Based on my experience, you can actually make money through affiliate marketing of you write article based on certain products and promote related products.

7 years ago

Are you sure you want to delete this post?

Corzhens

On the contrary, it looks like you are talking about affiliate marketing where you need your own website to promote your products. In drop shipping, you can simply connect to a supplier and promote his goods. The buyers are yours and they transact with you which means you are a direct middleman who earns on commission basis. I have many friends in Facebook who are into drop shipping and they are using Facebook for the business.

7 years ago

Are you sure you want to delete this post?

overcast

The case with dropshipping is you need website too. Where you have to list products from the supplier and bring traffic. So the case is same like affiliate marketing where you are asking for users to check out the website and then work with the content for converting. In such context dropshipping is harder because you have to watch out the refunds and the returns of products.

7 years ago

Are you sure you want to delete this post?

vinaya

You can do affiliate marketing and dropshipping even if you do not have a website. You can do affiliate marketing and dropshipping via social media. However, there is a limitation on using social media to do dropshipping and affiliate marketing. The best way to do affiliate marketing and dropshipping is through your own website. First of all, you control your content, secondly you can establish your credibility. Thirdly, you can build your own brand.

7 years ago

Are you sure you want to delete this post?

Corzhens

I am not familiar with affiliate marketing so I can only speak for dropshipping which I think is a good business. In fact, I have plans of engaging in dropshipping of clothing and accessories because I had that business before although it was not in the internet. What's good in dropshipping is that your only job is to get orders for the products that you sell. And marketing is done in social media so practically there is no capital needed. Once you get an order, the supplier will handle everything and you will just wait for your commission. From what I see in my Facebook friends, it's a pretty good online business.

9 years ago

Are you sure you want to delete this post?

overcast

I have found that dropshipping requires some initial capital. But that does not seem to be the case with the affiliate marketing. And that's the real difference between the two. You can see that affiliate marketing can make more passively. But it's more or less a gamble. And ranking pages is not easy. So I think drop shipping is more reliable model in that case.

9 years ago

Are you sure you want to delete this post?

vinaya

If you develop contents on certain topics and share related affiliate products with the content, you are likely to sell affiliate products. Affiliate marketing works better for reviews, you can review products and refer related products.
IN dropshipping, you launch your own store. Since people do not trust new store, you will first have to build your credibility, which is very difficult when you are starting small.

7 years ago

Are you sure you want to delete this post?

augusta

two good sources of making money without investing a dime but I prefer affiliate marketing especially if you're affiliating for the big names.You only need to advertise and you might not need to push much because people already know the brand and what they're capable of .

You could go for affiliate marketing stores with good commission rate.

9 years ago

Are you sure you want to delete this post?

overcast

Dropshipping requires a lot of investing. So I don't think it's a dime. In fact the most investment required is through dropshipping. For example, you need a site. And you have to also consider spending money on initial subscription to the drop shipping site. That surely ends up helping you. I think for each person the cost would vary with dropshipping.

9 years ago

Are you sure you want to delete this post?

anwebservices

Both of these are good. No risk involved, specially as affiliating because you not providing services or products, in some words you just recommending it to your audience. Dropshipping is nice and could be more profitable because you can set your own selling price, while you again not providing services or products but letting original supplier to do that part os business. Nice to do any of these to if you have good ability to promote such products, services or links...

9 years ago

Are you sure you want to delete this post?

kgord

I think you have to weigh the advantages and disadvantages of each before you commit to a method. It would seem to me that affiliate marketing may be the way to start initially because you would be taking less risk. It is up to each individual though to decide what will work for them in internet marketing.

9 years ago

Are you sure you want to delete this post?

Authord

I think two of the easiest opportunities to get started with, are dropshipping and affiliate marketing.
Both opportunities are in fact relatively similar. The business models
rely on selling someone else's products, that you don't have to buy or
stock before you can sell them, and once you have a customer, the
product owner ships the item direct to them.
On the face of it then, as long as you can find buying customers, they
both seem like easy enough ways to start your own business. But there
are some key differences that could make dropshipping the preferred
option.

9 years ago

Are you sure you want to delete this post?

centurion

I think affiliate marketing . There is no risk on affiliate marketing shipment. If shipment goes for miss- than there have a guarantee is that affiliate marketing company will do again shipment.

Thanks
Centurion

9 years ago

Are you sure you want to delete this post?

overcast

I think there is a lot of risk. If the google penalizes the site on the web. Then getting back the ranking. And even getting some traffic form the google at all is going to be hard. Same can be said about the dropshipping. You need people who buy. And that seems to be the way for both affiliate marketing and dropshipping works. Not a lot of people manage to make money from both.

9 years ago

Are you sure you want to delete this post?

seolads

As affiliate you earn only commission from the sale while as dropshipper you can set your own price and calculate your earnings to earn more money then affiliate only (in most cases), while you spend same time in promoting one or another link.

8 years ago

Are you sure you want to delete this post?

Process Time: 0.18600821495056

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='23928'	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='23928'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='601615'	1	SELECT * FROM seoclerks.members WHERE USERID='601615'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=601615	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=601615	/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=23928 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=23928 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23928' 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='23928' 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=130621 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=130621 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=141067 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=141067 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=174918 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=174918 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=175402 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=175402 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=175547 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=175547 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=130017 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=130017 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=130484 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=130484 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=144606 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=144606 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=130070 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=130070 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=144643 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=144643 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=174920 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=174920 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=175405 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=175405 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=174686 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=174686 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=174921 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=174921 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=175410 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=175410 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=130073 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=130073 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=130192 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=130192 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=175412 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=175412 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=130084 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=130084 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=130298 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=130298 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=130121 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=130121 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=130175 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=130175 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=130370 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=130370 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=130538 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=130538 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=133674 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=133674 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=141079 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=141079 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='23928'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='23928'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='23928' AND status='1' AND (question like '%Drop shipping Affiliate Marketing%' OR question like '%Drop%' OR question like '%shipping%' OR question like '%Affiliate%' OR question like '%Marketing%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23928' AND status='1' AND (question like '%Drop shipping Affiliate Marketing%' OR question like '%Drop%' OR question like '%shipping%' OR question like '%Affiliate%' OR question like '%Marketing%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
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='337' limit 1	1	SELECT 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 seoclerks.members WHERE USERID='672' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='672' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3861' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3861' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3489' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3489' 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=23928%' 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=23928%' 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='599711.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='599711.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'	1	SELECT 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='589438.jpg'	1	SELECT 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='591586.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='591586.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
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='254580.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='614330.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='614330.png'	/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='277339.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='277339.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