(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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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 "R%" 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)="RABDOSIA" 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="2601"  

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

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

(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)="RAOULIA" 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="2603"  

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

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

(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)="REINECKEA" 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="2605"  

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

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

(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)="RHEUM" 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="2606"  

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

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

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

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

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

(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)="RHODANTHEMUM" 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)="RODGERSIA" 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="2610"  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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)="ROSMARINUS" 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="2618"  

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

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

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

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

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

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

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

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

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

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

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

(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)="RUBUS" 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="2622"  

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

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

(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)="RUDBECKIA" 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="7969"  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(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)="RUMEX" 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="2634"  

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

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

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

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

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

(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)="RUTA" 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="2637"  

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

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2637  
RABDOSIA
longituba120 Bleu10/11C
RAOULIA
australis2 F. Gris-argent07/08C
REINECKEA
carnea30 Rose04/05C
RHEUM
palmatum var. tanguticum200 F. vert05/06C
rhabarbarum150 F. vert05/07B
RODGERSIA
aesculifolia100 Blanc06/07E
N 'Bronze Peacock'120 F. pourpre06/07F
henrici120 Rose06/07E
pinnata100 Blanc06/07E
pinnata 'Chocolate Wings'130 F. pourpre06/07F
ROSMARINUS
officinalis150 Bleu05/06B
officinalis 'Majorca Pink'80 Rose05/06E
officinalis 'Pointe du Raz'60 Bleu foncé03/05C
officinalis 'Prostratus' (lavandulaceus)15 Bleu05/06D
RUBUS
'Betty Ashburner'20 F. vert05/06C
RUDBECKIA
fulgida 'American Gold Rush' ®60 Jaune07/10E
fulgida 'Goldsturm' (sullivantii)70 Jaune07/10B
fulgida var. deamii80 Jaune06/09B
fulgida var. speciosa60 Jaune07/09B
laciniata 'Goldquelle'80 Jaune07/09C
maxima120 Jaune08/09C
nitida 'Herbstsonne' ('Autumn Glory')170 Jaune07/09C
occidentalis 'Green Wizard'120 Noir06/07C
subtomentosa150 Jaune08/10C
subtomentosa 'Henry Eilers'120 Jaune07/10E
triloba120 Jaune08/09C
RUMEX
arifolius30 F. vert06/09B
sanguineus var. sanguineus40 F. panaché05/07C
RUTA
graveolens60 F. Bleuté06/08B

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE


(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)="RODGERSIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =54 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="7955"  

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

(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7955  
RODGERSIA
N 'Bronze Peacock'120 F. pourpre06/07F