(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
faassenii 'Purrsian Blue' ®20 Bleu06/08F
grandiflora 'Bramdean'50 Bleu06/09B
'Joanna Reed'70 Bleu06/09C
parnassica120 Bleu06/10B
racemosa (mussinii)25 Bleu04/09A
racemosa 'Grog'20 Bleu06/09B
'Six Hills Giant' (Faassenii Group)40 Bleu05/10B

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

TOXIQUES