(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
BALLOTA |
---|
(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
hirsuta | 60 | F. Gris-argent | 07/09 | 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)="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
BELLIS |
---|
(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
perennis | 10 | Blanc | 03/06 | A |
(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
BERGENIA |
---|
(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
'Abendglut' | 30 | Rose | 04/05 | E |
(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
'Bartok' | 30 | Rose | 03/04 | 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="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
cordifolia 'Eroica' | 50 | F. pourpre | 02/04 | E |
(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
crassifolia | 40 | Rose | 03/04 | E |
(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
'Harzkristall' | 40 | Blanc | 04/05 | E |
(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
'Morgenröte' | 40 | Rose | 12/04 | E |
(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
purpurascens | 30 | Rose | 03/04 | 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="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
'Rotblum' | 40 | F. pourpre | 04/05 | B |
(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
N 'Spring Fling' | 50 | Rose | 04/06 | 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)="BOLTONIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
BOLTONIA |
---|
(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
asteroides var. latisquama | 200 | Blanc | 09/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="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
asteroides var. latisquama 'Snowbank' | 120 | Blanc | 09/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)="BRACHYGLOTTIS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
BRACHYGLOTTIS |
---|
(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
'Sunshine' | 70 | F. Gris-argent | 06/08 | 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)="BRUNNERA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
BRUNNERA |
---|
(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
N macrophylla 'Alchemy Pewter' ® | 40 | F. panaché argenté | 04/05 | F |
(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
macrophylla 'Alexander's Great' | 60 | F. panaché argenté | 04/06 | F* |
(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
macrophylla 'Variegata' | 40 | F. panaché argenté | 04/05 | F |
(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
sibirica | 40 | Bleu | 04/06 | 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)="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
BUPHTHALMUM |
---|
(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
salicifolium | 50 | Jaune | 06/08 | B |
(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