Top products in Novosibirsk
3-way JOIN on orders × products × users + GROUP BY on unindexed users.city.
Query took 86.6 ms
| # | Product | Category | Orders | Qty sold | Revenue |
|---|---|---|---|---|---|
| 2450 | Smart watch food | food | 8 | 27 | $19,047.71 |
| 4957 | Yoga mat books | books | 7 | 27 | $16,089.78 |
| 1261 | Yoga mat home | home | 6 | 26 | $15,967.86 |
| 451 | Smart watch clothes | clothes | 6 | 20 | $15,865.68 |
| 1213 | Wireless headphones auto | auto | 6 | 21 | $15,679.78 |
| 3960 | Coffee mug home | home | 6 | 22 | $14,984.18 |
| 2413 | Yoga mat home | home | 7 | 18 | $14,547.93 |
| 1681 | Sunglasses clothes | clothes | 5 | 20 | $13,612.99 |
| 319 | Coffee mug garden | garden | 5 | 21 | $13,546.11 |
| 4855 | Running shoes auto | auto | 5 | 19 | $13,512.73 |
| 1769 | Notebook A5 music | music | 5 | 16 | $13,372.09 |
| 1339 | Backpack books | books | 8 | 21 | $13,303.64 |
| 2916 | Yoga mat office | office | 5 | 22 | $13,197.97 |
| 1588 | Power bank toys | toys | 4 | 18 | $12,970.87 |
| 3671 | Backpack sports | sports | 6 | 21 | $12,559.00 |
| 1279 | Wireless headphones music | music | 6 | 19 | $12,533.79 |
| 1301 | Action camera sports | sports | 5 | 22 | $12,529.15 |
| 4233 | Coffee mug electronics | electronics | 5 | 22 | $12,486.86 |
| 4779 | Yoga mat toys | toys | 4 | 17 | $12,466.28 |
| 3130 | Mechanical keyboard music | music | 3 | 15 | $12,289.40 |
rendered in 120.8 ms