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

IBERIS
'Absolutely Amethyst'30 Rose04/06D
aurosica 'Sweetheart'15 Rose05/07B
sempervirens 'Pink Ice'30 Rose04/06D
sempervirens 'Snow Cushion'15 Blanc04/06B
sempervirens 'Weisser Zwerg'15 Blanc03/05B
IPHEION
'Alberto Castillo'20 Blanc12/05C
uniflorum15 Bleu01/05B
uniflorum 'Album'15 Blanc12/05C
IRIS
b-e 'Accent Variegata'90 Bicolore05/06B
b-e 'Arpège'90 Bicolore05/06B
b-e 'Bayberry Candle'90 Jaune05/06B
b-e 'Flamant Rose'80 Rose05/06B
b-e 'Flaming'90 Orange05/06B
b-e 'Flaming Dragon'65 Bicolore05/06B
b-e 'Frontier Marshall'90 Pourpre05/06B
b-e 'Glacier'75 Blanc05/06B
b-e 'Jane Phillips'80 Bleu05/06B
b-e 'Margarita'90 Bicolore05/06B
b-e 'Night Edition'85 Bicolore05/06B
b-e 'Ola Kala'90 Jaune05/06B
b-e 'Spartan'90 Rouge foncé05/06B
b-e 'Study in Black' 90 Pourpre05/06B
b-m 'Cutie'40 Bicolore04/05B
b-n 'Bingo' (Lilliput)40 Violet04/05B
b-n 'Blue Denim' (Lilliput)40 Bleu04/05B
b-n 'Brassie' (Lilliput)40 Jaune04/05B
b-n 'Candy Apple' (Lilliput)40 Pourpre04/05B
b-n 'Cherry Garden' (Lilliput)40 Pourpre04/05B
b-n 'Crispy' (pumila)20 Blanc03/04B
b-n 'Delicatissima' (pumila)20 Jaune03/04B
b-n 'Lilli-White' (Lilliput)40 Blanc04/05B
b-n 'Melon Honey' (Lilliput)40 Orange04/05B
b-n 'Orange Caper (Lilliput)40 Orange04/05B
b-n 'Pink Cushion' (Lilliput)20 Saumon03/04B
b-n 'Sapphire Gem' (Lilliput)25 Bleu04/05B
ensata 'White Ladies'90 Blanc06/08E
germanica 'Florentina'60 Blanc04/05C
orientalis ('Ochroleuca')120 Blanc05/07C
pseudacorus100 Jaune05/06B
pseudacorus 'Variegata'100 F. panaché doré05/06F
sibirica 'Double Standard'85 Violet05/06C
sibirica 'Imperial Opal'70 Mauve05/06C
sibirica 'Not Quite White'70 Blanc05/06C
versicolor80 Bleu05/07E

GRAMINÉES

IMPERATA
cylindrica 'Red Baron'40 F. pourpre09/10F

PLANTES DE RIVES

IRIS
ensata 'White Ladies'90 Blanc06/08E
pseudacorus100 Jaune05/06B
pseudacorus 'Variegata'100 F. panaché doré05/06F
sibirica 'Double Standard'85 Violet05/06C
sibirica 'Imperial Opal'70 Mauve05/06C
sibirica 'Not Quite White'70 Blanc05/06C
versicolor80 Bleu05/07E

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

TOXIQUES