Category Product Counts

Custom SQL query returning 109 rows (hide) 

SELECT c.name as category, COUNT(pc.product_id) as product_count
FROM categories c
LEFT JOIN product_categories pc ON c.id = pc.category_id
GROUP BY c.id
ORDER BY product_count DESC

Edit SQL

This data as json, CSV

categoryproduct_count
Obsolete 79
Christmas 61
Buketter 54
Funerals 48
Brudebuketter 47
Weddings 46
Bouquets 45
Pink 42
Homepage Specials 41
Rosa 39
Spring 38
Jul 37
Mothers Day 36
Morsdag 36
Brudepikene 36
Rod 35
Valentines 34
Red 34
Winter 34
Hvit 34
White 33
Valentines Day 33
Var 33
Bridal Bouquets 32
Blomster i en boks 31
Planter 31
Plants 31
Kranser 30
Host 30
Best Sellers 30
Bestselger 29
Vinter 29
Flowers in a box 29
Snittblomster 28
Multicolor 28
Romance 26
Bonita Coffee 26
Fresh Cut Flowers 25
Autumn 25
Flerfarget 24
Summer 23
Sommer 23
Romanse 23
Decoration 23
OutOfSeason 23
Wreath Decoration 22
Purple 22
Lilla 22
Oransj 21
Floral Arrangements 20
Orange 20
Homepage No 20
Anniversary 20
Dekorasjon 18
Seasonal Product 17
Cards 16
Other Decoration 16
Sympathy 16
Brides Maid 14
Gifts 14
Nasjonaldagen 17 mai 13
Colombianske Roser 13
Colombian Roses 12
Norwegian National Day 12
Baby 11
Jubileum 11
Kondolanse 11
Groom and Best Man 11
Baarebukett 11
Funeral Sheaf 11
Kistedekorasjon 11
Corporate Solutions 11
Heart Decoration 10
Green Indoor 10
Knappehulsblomster 10
Hjerter 10
Chocolates 10
Kondolanse buketter 9
Roses 9
Gront Innendors 8
Autumn Plants 8
Floral Accessories 7
Sympathy Bouquet 7
Pots and Baskets 7
Vases 7
Birthday 6
Coffin Decoration 6
Greeting Cards 6
Bedrift 6
Hydrangeas 5
Green Outdoor 5
Coffee 4
Hortensia 4
Seasonal baskets 4
Orchids 4
Gront Utendors 3
Orkideer 3
Lunch Menu 3
Bursdag 2
Sesongprodukt 2
Balloons 2
Afrikanske Roser 2
Teddy Bears 1
Nyfodt 1
Nasjonaldagen 17 mai 0
Other Products 0
Potter og Kurver 0
Smoothies And Juices 0
Wine 0