(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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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 "B%" 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)="BALLOTA" 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="395"  
(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=395 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=395 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 395  
(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)="BAPTISIA" 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)="BEGONIA" 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)="BELAMCANDA" 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)="BELLIS" 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="7353"  
(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=7353 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=7353 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7353  
(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)="BERGENIA" 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="402"  
(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=402 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=402 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 402  
(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="404"  
(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=404 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=404 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 404  
(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="408"  
(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=408 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=408 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 408  
(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="409"  
(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=409 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=409 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 409  
(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="411"  
(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=411 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=411 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 411  
(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="413"  
(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=413 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=413 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 413  
(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="414"  
(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=414 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=414 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 414  
(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="415"  
(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=415 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=415 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 415  
(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="8027"  
(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=8027 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=8027 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 8027  
(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)="BOLTONIA" 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="421"  
(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=421 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=421 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 421  
(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="422"  
(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=422 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=422 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 422  
(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)="BRACHYGLOTTIS" 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="425"  
(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=425 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=425 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 425  
(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)="BRUNNERA" 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="8028"  
(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=8028 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=8028 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 8028  
(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="3151"  
(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=3151 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=3151 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3151  
(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="7746"  
(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=7746 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=7746 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7746  
(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="7625"  
(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=7625 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=7625 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7625  
(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)="BUGLOSSOIDES" 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)="BUPHTHALMUM" 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="432"  
(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=432 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=432 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 432  
(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)="BUPLEURUM" 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)="BUTOMUS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  
BALLOTA
hirsuta60 F. Gris-argent07/09C
BELLIS
perennis10 Blanc03/06A
BERGENIA
'Abendglut'30 Rose04/05E
'Bartok'30 Rose03/04E
cordifolia 'Eroica'50 F. pourpre02/04E
crassifolia40 Rose03/04E
'Harzkristall'40 Blanc04/05E
'Morgenröte'40 Rose12/04E
purpurascens30 Rose03/04E
'Rotblum'40 F. pourpre04/05B
N 'Spring Fling'50 Rose04/06E
BOLTONIA
asteroides var. latisquama200 Blanc09/10C
asteroides var. latisquama 'Snowbank'120 Blanc09/10C
BRACHYGLOTTIS
'Sunshine'70 F. Gris-argent06/08C
BRUNNERA
N macrophylla 'Alchemy Pewter' ®40 F. panaché argenté04/05F
macrophylla 'Alexander's Great'60 F. panaché argenté04/06F*
macrophylla 'Variegata'40 F. panaché argenté04/05F
sibirica40 Bleu04/06C
BUPHTHALMUM
salicifolium50 Jaune06/08B

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)="BOUTELOUA" 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="424"  
(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=424 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=424 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 424  
(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)="BRIZA" 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="426"  
(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=426 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=426 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 426  
BOUTELOUA
gracilis30 Jaune07/08B
BRIZA
media40 Rouge06/07B

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

FOUGÈRES

(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)="BLECHNUM" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =2 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="3150"  
(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=3150 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=3150 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3150  
BLECHNUM
spicant30 F. vert-D

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)="BERGENIA" 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_FLEUR from PLANTE_AVOIR_REF_COULEUR_FLEUR inner join REF_COULEUR_FLEUR on PKFKID_REF_COULEUR_FLEUR=ID_REF_COULEUR_FLEUR where PKFKID_PLANTE="8027"  
(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=8027 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=8027 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 8027  
(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)="BRUNNERA" 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="8028"  
(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=8028 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=8028 order by VAL_RT_PRIXPART ASC  
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 8028  
(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)="BUPLEURUM" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =54 and trim(CHAR_A_TITRE)<>"" order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC  
BERGENIA
N 'Spring Fling'50 Rose04/06E
BRUNNERA
N macrophylla 'Alchemy Pewter' ®40 F. panaché argenté04/05F