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

KALIMERIS
incisa	60	Blanc	06/10	C
incisa 'Blue Star'	60	Mauve	06/09	C
KNAUTIA
macedonica	70	Rouge foncé	06/10	B
macedonica 'Mars Midget'	50	Rouge	07/09	B
macedonica 'Midget Mauves'	40	Mauve	06/10	B
KNIPHOFIA
'Banana Popsicle'	50	Jaune	06/10	F
'Bees' Lemon'	90	Jaune	07/09	E
citrina	70	Jaune	06/09	C
'Ice Queen'	120	Blanc	05/09	F
'Little Maid'	50	Jaune	07/09	F
'Mango Popsicle' ®	70	Orange	06/10	F
'Orange Vanilla Popsicle' ®	50	Bicolore	06/10	F
'Papaya Popsicle' ®	50	Bicolore	06/10	F
'Poco Orange' ®	40	Orange	05/09	E
'Poco Red' ®	40	Rouge	05/09	E
'Poco Sunset' ®	40	Bicolore	05/09	E
'Redhot Popsicle' ®	80	Rouge	06/10	F
uvaria 'Grandiflora'	100	Bicolore	06/09	B

GRAMINÉES

KOELERIA
glauca	30	F. Bleuté	06/07	B

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

TOXIQUES