Jump to content

Query help for selecting top selling customers


myflashstore

Recommended Posts

Hi,

 

I'm trying to select the top 10 selling customers. I have 2 tables involves, a user table jos_users and an items table jos_mfs_items. This is the sql i'm using but it's not returning any results, i'm not sure if I am doing it right, can someone help?

 

SELECT jos_users.*, COUNT(jos_mfs_items.*)

FROM jos_users

INNER JOIN jos_mfs_items

ON jos_users.id = jos_mfs_items.producer

WHERE jos_mfs_items.order_status = 1

GROUP BY jos_users.id

ORDER BY COUNT(jos_mfs_items.*)

DESC LIMIT 10

 

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.