(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =40) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =3) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =2) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =33) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =32) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =31) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =12) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =4) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =5) group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC  

(mysqli): select CHAR_P_GENRE,ID_ARTICLE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GENRE<>'' and BE_A_ACTIVE=1 and CHAR_P_GENRE like "Z%" and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =54) 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


(mysqli): select distinct A.*,P.*, TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) from ARTICLE A inner join PLANTE P on ID_ARTICLE=PKFKID_ARTICLE inner join ARTICLE_APPARTENIR_COLLECTION on ARTICLE_APPARTENIR_COLLECTION.PKFKID_ARTICLE=P.PKFKID_ARTICLE inner join ARTICLE_EXISTER_CONDITIONNEMENT on ARTICLE_EXISTER_CONDITIONNEMENT.PKFKID_ARTICLE= A.ID_ARTICLE where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and trim(CHAR_P_GENRE)="ZANTEDESCHIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

(mysqli): select LIB_REF_COULEUR_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="3075"  

(mysqli): select FKID_REF_MOIS_DEBUT as dbt, FKID_REF_MOIS_FIN as fin from PERIODE_FLORAISON where FKID_REF_MOIS_DEBUT>0 and FKID_REF_MOIS_FIN<>0 and FKID_PLANTE=3075 limit 1  

(mysqli): select CHAR_CODE_COURT,VAL_RT_PRIXPART,CHAR_CAEC_CODE from ARTICLE_EXISTER_CONDITIONNEMENT inner join REF_TARIF on PKFKID_REF_TARIF=ID_REF_TARIF where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and PKFKID_ARTICLE=3075 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3075  

(mysqli): select distinct A.*,P.*, TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) from ARTICLE A inner join PLANTE P on ID_ARTICLE=PKFKID_ARTICLE inner join ARTICLE_APPARTENIR_COLLECTION on ARTICLE_APPARTENIR_COLLECTION.PKFKID_ARTICLE=P.PKFKID_ARTICLE inner join ARTICLE_EXISTER_CONDITIONNEMENT on ARTICLE_EXISTER_CONDITIONNEMENT.PKFKID_ARTICLE= A.ID_ARTICLE where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and trim(CHAR_P_GENRE)="ZAUSCHNERIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

(mysqli): select LIB_REF_COULEUR_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="3078"  

(mysqli): select FKID_REF_MOIS_DEBUT as dbt, FKID_REF_MOIS_FIN as fin from PERIODE_FLORAISON where FKID_REF_MOIS_DEBUT>0 and FKID_REF_MOIS_FIN<>0 and FKID_PLANTE=3078 limit 1  

(mysqli): select CHAR_CODE_COURT,VAL_RT_PRIXPART,CHAR_CAEC_CODE from ARTICLE_EXISTER_CONDITIONNEMENT inner join REF_TARIF on PKFKID_REF_TARIF=ID_REF_TARIF where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and PKFKID_ARTICLE=3078 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3078  

(mysqli): select LIB_REF_COULEUR_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="3079"  

(mysqli): select FKID_REF_MOIS_DEBUT as dbt, FKID_REF_MOIS_FIN as fin from PERIODE_FLORAISON where FKID_REF_MOIS_DEBUT>0 and FKID_REF_MOIS_FIN<>0 and FKID_PLANTE=3079 limit 1  

(mysqli): select CHAR_CODE_COURT,VAL_RT_PRIXPART,CHAR_CAEC_CODE from ARTICLE_EXISTER_CONDITIONNEMENT inner join REF_TARIF on PKFKID_REF_TARIF=ID_REF_TARIF where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and PKFKID_ARTICLE=3079 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3079  

(mysqli): select LIB_REF_COULEUR_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="3080"  

(mysqli): select FKID_REF_MOIS_DEBUT as dbt, FKID_REF_MOIS_FIN as fin from PERIODE_FLORAISON where FKID_REF_MOIS_DEBUT>0 and FKID_REF_MOIS_FIN<>0 and FKID_PLANTE=3080 limit 1  

(mysqli): select CHAR_CODE_COURT,VAL_RT_PRIXPART,CHAR_CAEC_CODE from ARTICLE_EXISTER_CONDITIONNEMENT inner join REF_TARIF on PKFKID_REF_TARIF=ID_REF_TARIF where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and PKFKID_ARTICLE=3080 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3080  

(mysqli): select LIB_REF_COULEUR_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="3081"  

(mysqli): select FKID_REF_MOIS_DEBUT as dbt, FKID_REF_MOIS_FIN as fin from PERIODE_FLORAISON where FKID_REF_MOIS_DEBUT>0 and FKID_REF_MOIS_FIN<>0 and FKID_PLANTE=3081 limit 1  

(mysqli): select CHAR_CODE_COURT,VAL_RT_PRIXPART,CHAR_CAEC_CODE from ARTICLE_EXISTER_CONDITIONNEMENT inner join REF_TARIF on PKFKID_REF_TARIF=ID_REF_TARIF where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and PKFKID_ARTICLE=3081 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3081  
ZANTEDESCHIA
aethiopica 'Crowborough'90 Blanc06/08C
ZAUSCHNERIA
californica60 Rouge07/09E
californica ssp. latifolia40 Rouge07/09E
californica 'Western Hills'60 Rouge05/10E
cana60 Rouge07/09F

GRAMINÉES


(mysqli): select distinct A.*,P.*, TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) from ARTICLE A inner join PLANTE P on ID_ARTICLE=PKFKID_ARTICLE inner join ARTICLE_APPARTENIR_COLLECTION on ARTICLE_APPARTENIR_COLLECTION.PKFKID_ARTICLE=P.PKFKID_ARTICLE inner join ARTICLE_EXISTER_CONDITIONNEMENT on ARTICLE_EXISTER_CONDITIONNEMENT.PKFKID_ARTICLE= A.ID_ARTICLE where BE_AEC_DISPO=1 and BE_AEC_ACTIVE=1 and trim(CHAR_P_GENRE)="ZOYSIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE