(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
cooperi10 Rose06/10B
'Jewel of Desert Rosequartz' ®10 Rose05/10E
nubigenum5 Jaune06/10B
DELPHINIUM
'Blue Bird' (Pacific Giant Group)180 Bleu06/09B
'Blue Jay' (Pacific Giant Group)180 Bleu06/09B
'Galahad' (Pacific Giant Group)100 Blanc06/09B
DIANTHUS
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
'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
DICENTRA
spectabilis60 Rose04/06C
spectabilis 'Alba'60 Blanc04/06D
DIGIPLEXIS
'Rising Phoenix' ®90 Rose06/10E
DIGITALIS
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 purpurea120 Rose07/08B
T 'Spice Island'100 Jaune06/09E
DORONICUM
orientale 'Magnificum'50 Jaune04/05B

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
sieboldii30 F. vert-D
wallichiana70 F. vert-D

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

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
DIGITALIS
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 purpurea120 Rose07/08B
T 'Spice Island'100 Jaune06/09E