(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 "N%" 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

NEPETA
cataria 'Citriodora'50 Violet06/10C
'Cat's Meow'40 Bleu06/10B
'Cat's Pajamas'30 Bleu06/10C
faassenii40 Bleu05/10B
faassenii 'Purrsian Blue' ®20 Bleu06/08F
govaniana100 Jaune06/09C
grandiflora 'Bramdean'50 Bleu06/09B
'Joanna Reed'70 Bleu06/09C
'Neptune' ®30 Bleu foncé07/10C
nervosa40 Bleu07/09C
nuda120 Mauve06/08B
parnassica120 Bleu06/10B
racemosa (mussinii)25 Bleu04/09A
racemosa alba45 Blanc04/10B
N racemosa 'Amelia'40 Rose05/09C
racemosa 'Grog'20 Bleu06/09B
racemosa 'Snowflake' (faassenii)25 Blanc05/09B
sibirica90 Bleu foncé06/10B
'Six Hills Giant' (Faassenii Group)40 Bleu05/10B
'Walker's Low' (Faassenii Group)50 Bleu05/10B
NIEREMBERGIA
repens10 Blanc06/08B

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

NARCISSUS
'Actaea' (lot de 3)40 Bicolore04/05E
'February Gold' (lot de 5)25 Jaune03/03D
'Mount Hood' (lot de 3)45 Blanc04/05D
obvallaris (lot de 5)30 Jaune03/04E
poeticus (lot de 3)30 Bicolore04/05D
'Standard Value' (lot de 5)40 Jaune03/04C
triandrus 'Thalia' (lot de 5)30 Blanc03/04F

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

NEPETA
N racemosa 'Amelia'40 Rose05/09C

TOXIQUES