Category Product Counts

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