Top products in Moscow
3-way JOIN on orders × products × users + GROUP BY on unindexed users.city.
Query took 141.1 ms
| # | Product | Category | Orders | Qty sold | Revenue |
|---|---|---|---|---|---|
| 3941 | Mechanical keyboard food | food | 8 | 25 | $17,473.12 |
| 2446 | Notebook A5 clothes | clothes | 7 | 23 | $16,042.47 |
| 2757 | Cotton t-shirt auto | auto | 5 | 23 | $15,805.90 |
| 2407 | Cotton t-shirt books | books | 6 | 22 | $15,359.10 |
| 4190 | Sunglasses garden | garden | 5 | 21 | $15,020.22 |
| 2299 | Sunglasses toys | toys | 6 | 20 | $14,721.62 |
| 3849 | Running shoes office | office | 7 | 22 | $14,715.15 |
| 4141 | Power bank office | office | 7 | 22 | $14,432.43 |
| 2694 | Travel pillow electronics | electronics | 4 | 18 | $14,419.16 |
| 2331 | Mechanical keyboard books | books | 5 | 20 | $14,296.90 |
| 2066 | Desk lamp clothes | clothes | 5 | 21 | $14,182.49 |
| 4441 | Mechanical keyboard beauty | beauty | 5 | 18 | $14,028.76 |
| 4839 | Bluetooth speaker office | office | 6 | 18 | $13,985.67 |
| 4620 | Power bank garden | garden | 5 | 20 | $13,889.92 |
| 1598 | Notebook A5 books | books | 6 | 19 | $13,674.22 |
| 3178 | Sunglasses books | books | 6 | 19 | $13,671.68 |
| 2993 | Tea kettle office | office | 5 | 22 | $13,431.30 |
| 2065 | Running shoes beauty | beauty | 7 | 23 | $13,253.05 |
| 3730 | Office chair garden | garden | 8 | 28 | $13,180.56 |
| 1628 | Desk lamp music | music | 5 | 18 | $12,976.45 |
rendered in 188.1 ms