(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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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 "T%" 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)="TANACETUM" 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="2891"  

(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=2891 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=2891 order by VAL_RT_PRIXPART ASC  

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

(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="2892"  

(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=2892 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=2892 order by VAL_RT_PRIXPART ASC  

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

(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="7804"  

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="7804"  

(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=7804 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=7804 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2894"  

(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=2894 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=2894 order by VAL_RT_PRIXPART ASC  

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

(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)="TELEKIA" 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 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)="TELLIMA" 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_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2896"  

(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=2896 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=2896 order by VAL_RT_PRIXPART ASC  

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

(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)="TEUCRIUM" 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="3212"  

(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=3212 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=3212 order by VAL_RT_PRIXPART ASC  

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

(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="2899"  

(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=2899 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=2899 order by VAL_RT_PRIXPART ASC  

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

(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="7989"  

(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=7989 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=7989 order by VAL_RT_PRIXPART ASC  

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

(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)="THALIA" 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 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)="THALICTRUM" 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="2906"  

(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=2906 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=2906 order by VAL_RT_PRIXPART ASC  

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

(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="2909"  

(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=2909 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=2909 order by VAL_RT_PRIXPART ASC  

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

(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)="THERMOPSIS" 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 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)="THYMUS" 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_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2911"  

(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=2911 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=2911 order by VAL_RT_PRIXPART ASC  

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

(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="2913"  

(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=2913 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=2913 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2914"  

(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=2914 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=2914 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2915"  

(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=2915 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=2915 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2917"  

(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=2917 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=2917 order by VAL_RT_PRIXPART ASC  

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

(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="7824"  

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="7824"  

(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=7824 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=7824 order by VAL_RT_PRIXPART ASC  

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

(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="2919"  

(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=2919 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=2919 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2920"  

(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=2920 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=2920 order by VAL_RT_PRIXPART ASC  

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

(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="3214"  

(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=3214 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=3214 order by VAL_RT_PRIXPART ASC  

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

(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="7670"  

(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=7670 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=7670 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="7403"  

(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=7403 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=7403 order by VAL_RT_PRIXPART ASC  

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

(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="2925"  

(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=2925 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=2925 order by VAL_RT_PRIXPART ASC  

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

(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="2928"  

(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=2928 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=2928 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2929"  

(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=2929 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=2929 order by VAL_RT_PRIXPART ASC  

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

(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)="TIARELLA" 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="2933"  

(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=2933 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=2933 order by VAL_RT_PRIXPART ASC  

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

(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="7575"  

(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=7575 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=7575 order by VAL_RT_PRIXPART ASC  

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

(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="2935"  

(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=2935 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=2935 order by VAL_RT_PRIXPART ASC  

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

(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="7814"  

(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=7814 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=7814 order by VAL_RT_PRIXPART ASC  

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

(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="2936"  

(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=2936 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=2936 order by VAL_RT_PRIXPART ASC  

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

(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="2937"  

(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=2937 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=2937 order by VAL_RT_PRIXPART ASC  

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

(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)="TITANOTRICHUM " 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="7990"  

(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=7990 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=7990 order by VAL_RT_PRIXPART ASC  

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

(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)="TOLMIEA " 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 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)="TRACHYSTEMON" 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 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)="TRADESCANTIA" 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="2942"  

(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=2942 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=2942 order by VAL_RT_PRIXPART ASC  

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

(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="2943"  

(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=2943 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=2943 order by VAL_RT_PRIXPART ASC  

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

(mysqli): select LIB_REF_COULEUR_FEUILLE from PLANTE_AVOIR_REF_COULEUR_FEUILLE inner join REF_COULEUR_FEUILLE on PKFKID_REF_COULEUR_FEUILLE=ID_REF_COULEUR_FEUILLE where PKFKID_PLANTE="2946"  

(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=2946 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=2946 order by VAL_RT_PRIXPART ASC  

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

(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="2948"  

(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=2948 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=2948 order by VAL_RT_PRIXPART ASC  

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

(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)="TRICYRTIS" 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="2954"  

(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=2954 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=2954 order by VAL_RT_PRIXPART ASC  

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

(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)="TRIFOLIUM" 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="3216"  

(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=3216 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=3216 order by VAL_RT_PRIXPART ASC  

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

(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)="TROLLIUS" 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="2960"  

(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=2960 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=2960 order by VAL_RT_PRIXPART ASC  

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

(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)="TULBAGHIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  
TANACETUM
coccineum 'Robinson's Pink'60 Rose05/07B
coccineum 'Robinson's Red'70 Rouge05/07B
haradjanii 'Little Frosty'10 Jaune - F. Gris-argent07/08E
vulgare120 F. vert07/09A
TELLIMA
grandiflora70 F. vert05/07B
TEUCRIUM
chamaedrys 'Album'30 Blanc06/10B
flavum50 Crème07/09B
orientale40 Violet06/09B
THALICTRUM
delavayi 'Album'120 Blanc06/08C
flavum ssp. glaucum180 Jaune06/08B
THYMUS
ciliatus10 F. Gris-argent04/06B
citriodorus 'Aureus'15 Rose06/08B
citriodorus 'Bertram Anderson'15 F. panaché doré06/08B
citriodorus 'Golden Dwarf'10 F. Doré06/08B
citriodorus 'Variegatus'25 F. panaché doré06/08B
comosus15 Rose - F. vert06/08B
doerfleri 'Bressingham'10 Rose06/07B
'Doone Valley'10 F. panaché doré06/07B
longicaulis20 Rose05/06B
mastichina25 Blanc05/06A
nitens20 F. vert05/06B
praecox 'Coccineus'8 Rose06/08B
serpyllum15 Rose06/08A
vulgaris20 F. vert06/08A
TIARELLA
cordifolia20 Blanc04/05B
cordifolia 'Eco'15 Blanc04/06B
'Sugar and Spice'35 Rose05/06E
'Sunset Ridge'20 Blanc05/06E
'Tiger Stripe'40 Blanc04/05E
wherryi40 Blanc04/05B
TITANOTRICHUM
oldhamii50 Bicolore09/11D
TRADESCANTIA
'Karminglut' (Andersoniana Group)40 Rouge05/09B
'Osprey' (Andersoniana Group)40 Bleu05/09B
'Sweet Kate'40 F. Doré05/09E
'Zwanenburg Blue' (Andersoniana Group)40 Bleu05/09B
TRICYRTIS
'Tojen'70 Rose07/10E
TRIFOLIUM
fragiferum10 Rose05/06B
TROLLIUS
chinensis 'Golden Queen'50 Jaune07/09C

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)="TYPHA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3 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="2988"  

(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=2988 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=2988 order by VAL_RT_PRIXPART ASC  

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

(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="2990"  

(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=2990 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=2990 order by VAL_RT_PRIXPART ASC  

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

(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="2991"  

(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=2991 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=2991 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2991  
TYPHA
angustifolia180 Brun07/08B
laxmannii150 Brun07/09C
minima60 Brun06/07C

PLANTES DE RIVES


(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)="THALIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =4 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

(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)="TROLLIUS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =4 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="2960"  

(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=2960 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=2960 order by VAL_RT_PRIXPART ASC  

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

(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)="TYPHA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =4 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="2988"  

(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=2988 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=2988 order by VAL_RT_PRIXPART ASC  

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

(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="2990"  

(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=2990 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=2990 order by VAL_RT_PRIXPART ASC  

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

(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="2991"  

(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=2991 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=2991 order by VAL_RT_PRIXPART ASC  

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2991  
TROLLIUS
chinensis 'Golden Queen'50 Jaune07/09C
TYPHA
angustifolia180 Brun07/08B
laxmannii150 Brun07/09C
minima60 Brun06/07C

FOUGÈRES

BULBES D'AUTOMNE


(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)="TRITELEIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =33 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

(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)="TULIPA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =33 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE