(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
KNAUTIA
arvensis	80	Mauve	05/09	B
N macedonica 'Mars Midget'	50	Rouge	07/09	B
KNIPHOFIA
'Banana Popsicle'	50	Jaune	06/10	F
citrina	70	Jaune	06/09	C
'Creamsicle' ®	50	Orange	06/10	F
'Papaya Popsicle' ®	50	Bicolore	06/10	F
'Poco Orange' ®	40	Orange	05/09	E
'Redhot Popsicle' ®	80	Rouge	06/10	F
rooperi	150	Orange	08/10	B
uvaria 'Grandiflora'	100	Bicolore	06/09	B
'Vincent Lepage'	100	Orange	06/10	F

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

KNAUTIA
N macedonica 'Mars Midget'	50	Rouge	07/09	B

TOXIQUES