(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)="MELICA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
MELICA |
---|
(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="2065"
(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=2065 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=2065 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2065
altissima 'Atropurpurea' | 100 | Pourpre | 05/07 | C |
(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)="MILIUM" 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 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)="MISCANTHUS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
MISCANTHUS |
---|
(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="2083"
(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=2083 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=2083 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2083
giganteus (M. floridulus) | 300 | F. vert | 08/12 | C |
(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="2084"
(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=2084 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=2084 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2084
'Purpurascens' | 150 | F. pourpre | 08/12 | E |
(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="2085"
(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=2085 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=2085 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2085
sacchariflorus | 130 | F. vert | 08/12 | C |
(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="2086"
(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=2086 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=2086 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2086
sinensis 'Adagio' | 100 | F. vert | 08/12 | E |
(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="7831"
(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=7831 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=7831 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7831
sinensis 'Caramel' | 170 | F. vert | 08/11 | E |
(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="2089"
(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=2089 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=2089 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2089
sinensis 'Dixieland' | 130 | F. panaché argenté | 08/09 | E |
(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="2091"
(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=2091 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=2091 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2091
sinensis 'Emmanuel Lepage' | 150 | F. vert | 08/12 | E |
(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="2094"
(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=2094 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=2094 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2094
sinensis 'Flamingo' | 150 | F. vert | 08/12 | E |
(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="3228"
(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=3228 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=3228 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3228
sinensis 'Ghana' | 150 | F. vert | 08/10 | E |
(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="2096"
(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=2096 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=2096 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2096
sinensis 'Gracillimus' | 200 | F. vert | 08/12 | C |
(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="2099"
(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=2099 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=2099 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2099
sinensis 'Kleine Silberspinne' | 120 | F. vert | 08/12 | E |
(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="2102"
(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=2102 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=2102 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2102
sinensis 'Morning Light' | 160 | F. panaché argenté | 08/12 | E |
(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="2104"
(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=2104 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=2104 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2104
sinensis 'Pünktchen' | 150 | F. panaché doré | 09/11 | E |
(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="2106"
(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=2106 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=2106 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2106
sinensis 'Silberfeder' | 180 | F. vert | 08/12 | E |
(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="2107"
(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=2107 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=2107 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2107
sinensis 'Sirène' | 180 | F. vert | 09/11 | E |
(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="2115"
(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=2115 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=2115 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2115
sinensis 'Yaku Jima Dwarf' | 80 | F. vert | 08/12 | E |
(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="2117"
(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=2117 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=2117 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2117
transmorrisonensis | 200 | F. vert | 08/11 | E |
(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)="MOLINIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
MOLINIA |
---|
(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="2118"
(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=2118 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=2118 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2118
arundinacea | 180 | F. vert | 08/10 | C |
(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="2131"
(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=2131 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=2131 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2131
arundinacea 'Les Ponts de Cé' | 150 | Noir | 07/10 | C |
(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="2122"
(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=2122 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=2122 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2122
arundinacea 'Transparent' | 160 | F. vert | 08/10 | C |
(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="2123"
(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=2123 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=2123 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2123
arundinacea 'Windspiel' | 180 | F. vert | 08/10 | C |
(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="2125"
(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=2125 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=2125 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2125
caerulea 'Dauerstrahl' | 100 | F. vert | 07/10 | C |
(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="2126"
(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=2126 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=2126 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2126
caerulea 'Edith Dudszus' | 60 | Noir | 07/10 | C |
(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="2129"
(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=2129 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=2129 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2129
caerulea 'Overdam' | 50 | F. vert | 07/10 | C |
(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="2130"
(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=2130 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=2130 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2130
caerulea 'Variegata' | 50 | F. panaché doré | 07/10 | C |
(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)="MUHLENBERGIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC