(mysqli): select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_P_TOXIQUE=1 and BE_A_ACTIVE=1 and CHAR_P_GENRE like "D%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =1) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

le catalogue Lepage


A B C D E F G H I J K L M N O P Q R S T U V W X Y Z A-Z

VIVACES

DEINANTHE
'Blue Wonder'50 Bleu05/06F
DELOSPERMA
ashtonii10 Rose06/10B
congestum10 Jaune06/09B
cooperi10 Rose06/10B
'Graaf Reinet'10 Blanc04/10B
'Jewel of Desert Garnet' ®10 Rose05/09D
'Jewel of Desert Moon Stone' ®10 Blanc04/10D
'Jewel of Desert Peridott' ®10 Jaune04/10D
'Jewel of Desert Rosequartz' ®10 Rose05/10E
'Jewel of Desert Ruby' ®10 Bicolore04/10D
nubigenum5 Jaune06/10B
sutherlandii10 Rose06/10B
DELPHINIUM
'Astolat' (Pacific Giant Group)180 Rose06/09B
'Atlantis' (Belladonna Group)100 Bleu foncé06/09E
'Bellamosum' (Belladonna Group)120 Bleu foncé06/09E
'Black Knight' (Pacific Giant Group)180 Bleu foncé06/09B
'Blue Bird' (Pacific Giant Group)180 Bleu06/09B
'Blue Jay' (Pacific Giant Group)180 Bleu06/09B
'Bolero' ®80 Bleu06/08F
'Camelliard' (Pacific Giant Group)180 Mauve06/09B
'Cha Cha'80 Mauve06/08F
'Cinderella'120 Rose06/09F
'Cliveden Beauty' (Belladonna Group)100 Bleu06/09B
'Flamenco'80 Rose06/08F
'Galahad' (Pacific Giant Group)100 Blanc06/09B
grandiflorum (sinense)40 Bleu06/08B
'King Arthur' (Pacific Giant Group)180 Violet06/09B
'Summer Skies' (Pacific Giant Group)180 Bleu06/09B
'Sweet Sensation'80 Bleu foncé06/08F
'Völkerfrieden' (Belladonna Group)120 Bleu06/09E
DIANTHUS
anatolicus20 Rose05/07B
arenarius15 Blanc07/09C
carthusianorum60 Rose06/08B
'David' (Plumarius Group)25 Rouge05/07B
deltoides 'Albus'20 Blanc05/07A
deltoides 'Brilliant'20 Rouge05/07A
deltoides 'Flashing Light' ('Leuchtfunk')15 Rouge05/07A
deltoides 'Rosea'20 Rose05/07A
'Desmond' (Plumarius Group)25 Rouge05/07B
'Doris' (Plumarius Group)30 Rose05/07B
gratianopolitanus (caesius)20 Rose05/08A
gratianopolitanus 'Badenia'15 Rose06/08B
gratianopolitanus 'Eydangeri'15 Rose06/08B
'Haytor White' (Plumarius Group)30 Blanc05/07B
knappii30 Crème06/07C
'Maggie' (Plumarius Group)25 Rose05/07B
pinifolius30 Rouge05/07B
superbus40 Blanc06/09C
DIASCIA
barberae 'Blackthorn Apricot'20 Saumon05/10C
barberae 'Pink Queen'30 Rose05/10C
personata90 Rose05/10C
'Ruby Field'30 Rose05/10C
DICENTRA
formosa30 Rose05/08E
formosa 'Luxuriant'35 Rouge05/08E
spectabilis60 Rose04/06C
spectabilis 'Alba'60 Blanc04/06D
spectabilis 'Ruby Gold'65 Rouge - F. Doré05/06F
DICHONDRA
repens10 F. vert05/06C
DICTAMNUS
T albus80 Rose06/08F
DIERAMA
pulcherrimum100 Rose05/07F*
DIGIPLEXIS
'Rising Phoenix' ®90 Rose06/10E
DIGITALIS
N 'Apple Blossom' ®60 Rose05/07F
T ferruginea150 Saumon07/10B
T 'Glory of Roundway'90 Rose05/08D
T 'Goldcrest' ®50 Orange06/09E
T grandiflora (ambigua)100 Jaune06/08B
T laevigata f. alba80 Blanc06/08E
T lanata80 Bicolore06/08B
T lutea70 Jaune06/08B
T 'Mertonensis'80 Rose06/08B
T obscura50 Orange06/07B
T purpurea120 Rose07/08B
T purpurea 'Alba'120 Blanc07/08B
T 'Spice Island'100 Jaune06/09E
DORONICUM
orientale 'Magnificum'50 Jaune04/05B
DORYCNIUM
hirsutum70 Rose06/09E
hirsutum 'Fréjorgues'70 Blanc06/07E

GRAMINÉES

DESCHAMPSIA
T cespitosa120 Doré - F. vert06/08B
T cespitosa 'Goldgehänge'80 Doré06/08C
T cespitosa 'Goldschleier'120 Doré06/08C
T cespitosa 'Goldtau'80 Doré06/08C
T cespitosa 'Tauträger'80 Doré06/09C

PLANTES DE RIVES

FOUGÈRES

DRYOPTERIS
affinis120 F. vert-D
cycadina (atrata)80 F. vert-E
erythrosora80 F. Bronze-D
erythrosora 'Prolifica'80 F. vert-E
filix-mas90 F. vert-D
filix-mas 'Cristata'60 F. vert-D
sieboldii30 F. vert-D
wallichiana70 F. vert-D
wallichiana 'Jurassic Gold'90 F. Doré-G

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

DIGITALIS
N 'Apple Blossom' ®60 Rose05/07F

TOXIQUES

DESCHAMPSIA
T cespitosa120 Doré - F. vert06/08B
T cespitosa 'Goldgehänge'80 Doré06/08C
T cespitosa 'Goldschleier'120 Doré06/08C
T cespitosa 'Goldtau'80 Doré06/08C
T cespitosa 'Tauträger'80 Doré06/09C
DICTAMNUS
T albus80 Rose06/08F
DIGITALIS
T ferruginea150 Saumon07/10B
T 'Glory of Roundway'90 Rose05/08D
T 'Goldcrest' ®50 Orange06/09E
T grandiflora (ambigua)100 Jaune06/08B
T laevigata f. alba80 Blanc06/08E
T lanata80 Bicolore06/08B
T lutea70 Jaune06/08B
T 'Mertonensis'80 Rose06/08B
T obscura50 Orange06/07B
T purpurea120 Rose07/08B
T purpurea 'Alba'120 Blanc07/08B
T 'Spice Island'100 Jaune06/09E