Million Bells

Query Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38 Execution Time: 6.84 ms Record Count: 24 Cached: No Lazy: No SQL: select p.friendlyURL as myval from tb_users_plants p where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829 and p.type = 'Annual' group by p.friendlyURL order by p.NameLine2, p.nameLine1
	myval
1	Abutilon-suntense-White-Charm-Flowering-Maple
2	Acalypha-Jungle-Dragon-Beefsteak-Plant
3	Acalypha-godseffiana-Heterophylla-Threadleaf-Copperleaf
4	Angelonia-hybrid-Angelface-Super-Pink-Summer-Snapdragon
5	Argyanthemum-Grand-Daisy-Yellow-Grandessa
6	Begonia-Belleconia-Hot-Orange-Begonia
7	Calibrachoa-Callie-Orange-Sunrise
8	Calibrachoa-Aloha-Kona-Lavender-Mini-Petunia
9	Calibrachoa-Aloha-Kona-Mango-Mini-Petunia
10	Calibrachoa-Callie-Apricot-Million-Bells
11	Calibrachoa-Catwalk-8482-Perfect-Yellow-Millionbells
12	Calibrachoa-x-Callie-Burgundy-Million-Bells
13	Calibrachoa-x-hybrida-Can-Can-Apricot-Trailing-Petunia
14	Calibrachoa-x-hybrida-Minifamous-153-Apricot-with-Red-Eye-Trailing-Petunia
15	Chrysanthemum-morifolium-Moonglow-White-White-Garden-Mum
16	Coleus-Dutch-Mill-Drive-Main-Street-Coleus
17	Coleus-Under-The-Sea-Molten-Coral-Coleus
18	Cosmos-bipinnatus-Hot-Pink-Cosmos
19	Lablab-purpurea-Hyacinth-Bean
20	Pelargonium-Calliope-Medium-Red-Interspecific-Geranium
21	Pericallis-hybrid-Blue-Bicolor-Senetti-Blue-Bicolor
22	Petunia-Cascadias-Purple-Gem-Cascadias-Petunia
23	Petunia-hybrid-Dekko-Dark-Lavender-Petunia
24	Petunia-hybrida-Bingo-Perfectunia-reg-Magic-Morn-Bingo-reg-Petunia