(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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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 "V%" 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)="VALERIANA" 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="2993"  

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

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

(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)="VERBASCUM" 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="2996"  

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

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

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

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

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

(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)="VERBENA" 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="3007"  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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)="VERNONIA" 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="3016"  

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

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

(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)="VERONICA" 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="3018"  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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)="VERONICASTRUM" 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="3040"  

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

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

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

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

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

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

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

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

(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)="VINCA" 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="3047"  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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)="VIOLA" 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="3067"  

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

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3067  
VALERIANA
officinalis120 F. vert06/09B
VERBASCUM
chaixii 'Album'100 Blanc05/07C
phoeniceum70 Variés05/07B
VERBENA
bonariensis150 Violet07/10A
hastata 'Blue Spires'120 Bleu06/09C
hastata f. rosea 'Pink Spires'120 Rose06/09C
'Muriel'40 Mauve04/10C
officinalis60 F. vert07/08A
tenuisecta30 Mauve06/09B
VERNONIA
crinita180 Rose08/10C
VERONICA
austriaca 'Royal Blue' (V. teucrium) 30 Bleu06/08B
beccabunga20 Bleu06/09C
filiformis8 Bleu05/07B
gentianoides40 Bleu05/06C
liwanensis5 Bleu05/09C
longifolia (exaltata)100 Bleu06/08C
longifolia 'Blauriesin'80 Bleu foncé06/08C
longifolia 'Lilac Fantasy'40 Violet06/08C
petraea 'Madame Mercier'10 Mauve04/05C
prostrata10 Bleu05/06C
spicata50 Bleu06/07A
spicata 'Barcarolle'50 Rose06/09C
'Tidal Pool'10 Bleu05/07F
umbrosa 'Georgia Blue' (V. pedunculata)15 Bleu04/07C
VERONICASTRUM
virginicum120 Bleu07/09C
virginicum 'Erika'120 Rose07/09E
virginicum 'Lavendelturm'140 Mauve07/09E
VINCA
major 'Alba'30 Blanc04/06C
major 'Variegata'50 F. panaché argenté04/06B
minor20 Bleu04/06A
minor 'Alba'10 Blanc04/06B
minor 'Argenteovariegata'15 F. panaché argenté04/06C
minor 'Atropurpurea'15 Pourpre04/06C
minor 'Aureovariegata'15 F. panaché doré04/06C
minor 'Grüner Teppich'10 Bleu04/06B
minor 'La Grave' ('Bowles Variety')15 Bleu04/06B
VIOLA
sororia 'Albiflora'20 Blanc05/06C

GRAMINÉES

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)="VERONICA" 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="7897"  

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

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7897  
VERONICA
beccabunga20 Bleu06/09C

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE