This is a public-interest archive. Personal data is pseudonymized and retained under
GDPR Article 89.
Top hort.net search queries
This isn't directly related to anything, but I thought that it was interesting
nonetheless.
On hort.net there's an image gallery with a search option. I track all
search queries in a database to see what people are looking for so that
I can fill in the more-requested holes in the gallery.
Anyhow, of the 38,404 queries made to the search page since January 1st,
2002 these are the top 50 queries (the first entry is just a blank --
they didn't fill out the form):
mysql> select count(string) as foo,string from query where date > "20020101000000" group by string order by foo desc limit 50;
+-----+----------------+
| foo | string |
+-----+----------------+
| 364 | |
| 130 | rose |
| 111 | viburnum |
| 105 | Azalea |
| 101 | iris |
| 100 | dogwood |
| 99 | salvia |
| 97 | Geranium |
| 94 | Magnolia |
| 93 | hosta |
| 93 | hydrangea |
| 92 | petunia |
| 91 | Heather |
| 88 | Lilac |
| 84 | fern |
| 78 | juniper |
| 76 | holly |
| 72 | Verbena |
| 72 | spirea |
| 71 | Dianthus |
| 70 | Begonia |
| 69 | lily |
| 69 | sedum |
| 68 | malus |
| 68 | phlox |
| 67 | lantana |
| 63 | coleus |
| 62 | delphinium |
| 62 | hibiscus |
| 61 | Japanese Maple |
| 61 | cherry |
| 60 | lavender |
| 60 | prunus |
| 59 | Zinnia |
| 58 | impatiens |
| 58 | clematis |
| 58 | crabapple |
| 58 | Marigold |
| 57 | acer |
| 56 | Gardenia |
| 55 | Aster |
| 55 | daisy |
| 55 | palm |
| 54 | barberry |
| 50 | honeysuckle |
| 50 | million bells |
| 49 | lobelia |
| 49 | Forsythia |
| 48 | poppy |
| 48 | Astilbe |
+-----+----------------+
50 rows in set (1.62 sec)
Similarly, here are the most frequently viewed plants since January 1st
(out of 303,462 image views). This doesn't take into account the fact
that some plants have more photos available than others, however.
mysql> select count(sci_name) as foo,sci_name from hit left join image on hit.dig_id=image.dig_id left join plant on image.code=plant.code where date > "20020101000000" group by sci_name order by foo desc limit 50;
+------+-----------------------------------------------+
| foo | sci_name |
+------+-----------------------------------------------+
| 4380 | Pieris japonica |
| 2804 | Amelanchier laevis |
| 2476 | Amelanchier arborea |
| 2329 | Abelia x grandiflora |
| 2210 | Acer palmatum |
| 1696 | Rhododendron maximum |
| 1348 | Malus floribunda |
| 1297 | Amelanchier x grandiflora |
| 1296 | Echinops ritro |
| 1259 | Cercis canadensis |
| 1251 | Acer x freemanii 'Autumn Blaze' |
| 1200 | Acer palmatum 'Dissectum Atropurpureum' |
| 1196 | Echinacea purpurea |
| 1161 | Malus 'Prairifire' |
| 1152 | Cornus florida |
| 1146 | Malus sargentii |
| 1131 | Itea virginica 'Henry's Garnet' |
| 1120 | Viburnum plicatum forma tomentosum 'Mariesii' |
| 1090 | Calibrachoa 'Million Bells Purple' |
| 1066 | Agastache cana 'Heather Queen' |
| 1006 | Acer palmatum 'Bloodgood' |
| 1006 | Magnolia soulangiana |
| 986 | Buddleia davidii |
| 943 | Malva sylvestris 'Zebrina' |
| 931 | Cornus kousa |
| 899 | Magnolia 'Ann' |
| 877 | Viburnum lantana |
| 868 | Oxalis triangularis |
| 835 | Rhododendron 'PJM' |
| 821 | Acer ginnala |
| 802 | Calibrachoa 'Million Bells' |
| 775 | Verbena 'Homestead Purple' |
| 757 | Magnolia x soulangiana 'Picture' |
| 754 | Abies balsamea |
| 749 | Fothergilla gardenii |
| 746 | Acer griseum |
| 737 | Forsythia x intermedia |
| 733 | Magnolia grandiflora |
| 733 | Acer negundo 'Flamingo' |
| 732 | Betula nigra |
| 730 | Veronica 'Sunny Border Blue' |
| 720 | Crataegus crusgalli |
| 710 | Alchemilla mollis |
| 680 | Acer pseudosieboldianum |
| 678 | Malus 'Red Jewel' |
| 678 | Betula jacquemontii |
| 672 | Aralia spinosa |
| 669 | Lavatera 'White Satin' |
| 665 | Alcea rosea |
| 662 | Centranthus ruber 'Coccineus' |
+------+-----------------------------------------------+
50 rows in set (28.56 sec)
Chris
http://www.hort.net/gallery/ 2631 online plant photos and growing!
http://www.hort.net/gallery/date/2002-05-05/ The latest additions
_______________________________________________
gardenwriters mailing list
gardenwriters@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/gardenwriters
GWL has searchable archives at:
http://www.hort.net/lists/gardenwriters
If you have photos for GWL, send them to gwlphotos@hort.net and they will
show up at: http://www.hort.net/lists/gwlphotos
Other Mailing lists |
Author Index |
Date Index |
Subject Index |
Thread Index
