(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	Violet	06/10	C
'Cat's Meow'	40	Bleu	06/10	B
'Cat's Pajamas'	30	Bleu	06/10	C
faassenii	40	Bleu	05/10	B
grandiflora 'Bramdean'	50	Bleu	06/09	B
'Joanna Reed'	70	Bleu	06/09	C
'Neptune' ®	30	Bleu foncé	07/10	C
nervosa	40	Bleu	07/09	C
racemosa alba	45	Blanc	04/10	B
racemosa 'Amelia'	40	Rose	05/09	C
racemosa 'Grog'	20	Bleu	06/09	B
racemosa 'Snowflake' (faassenii)	25	Blanc	05/09	B
sibirica	90	Bleu	06/10	B
N subsessilis 'White Dreams'	60	Blanc	06/08	B
'Walker's Low' (Faassenii Group)	50	Bleu	05/10	B
NIEREMBERGIA
repens	10	Blanc	06/08	B

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

NARCISSUS
'February Gold' (lot de 5)	25	Jaune	03/03	D
obvallaris (lot de 5)	30	Jaune	03/04	E
'Standard Value' (lot de 5)	40	Jaune	03/04	C
triandrus 'Thalia' (lot de 5)	30	Blanc	03/04	F

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

NEPETA
N subsessilis 'White Dreams'	60	Blanc	06/08	B

TOXIQUES