(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)="DARMERA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DARMERA |
---|
(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="937"
(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=937 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=937 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 937
peltata | 100 | Rose | 04/05 | 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)="DELOSPERMA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DELOSPERMA |
---|
(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="938"
(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=938 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=938 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 938
ashtonii | 10 | Rose | 06/10 | 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="7932"
(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=7932 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=7932 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7932
congestum | 10 | Jaune | 06/09 | 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="7861"
(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=7861 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=7861 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7861
congestum 'White Nugget' | 10 | Blanc | 05/09 | 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="939"
(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=939 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=939 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 939
cooperi | 10 | Rose | 06/10 | 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="940"
(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=940 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=940 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 940
'Graaf Reinet' | 10 | Blanc | 04/10 | 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="943"
(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=943 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=943 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 943
'Jewel of Desert Peridott' ® | 10 | Jaune | 04/10 | D |
(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="944"
(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=944 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=944 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 944
'Jewel of Desert Rosequartz' ® | 10 | Rose | 05/10 | 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="947"
(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=947 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=947 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 947
sutherlandii | 10 | Rose | 06/10 | 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)="DELPHINIUM" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DELPHINIUM |
---|
(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="955"
(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=955 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=955 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 955
'Casa Blanca' (Belladonna Group) | 100 | Blanc | 06/09 | 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="7362"
(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=7362 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=7362 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7362
'Cha Cha' | 80 | Mauve | 06/08 | 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="956"
(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=956 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=956 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 956
'Cliveden Beauty' (Belladonna Group) | 100 | Bleu | 06/09 | 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="962"
(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=962 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=962 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 962
grandiflorum (sinense) | 40 | Bleu | 06/08 | 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="963"
(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=963 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=963 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 963
'King Arthur' (Pacific Giant Group) | 180 | Violet | 06/09 | 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="8004"
(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=8004 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=8004 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 8004
N nudicaule 'Laurin' | 40 | Rouge | 06/07 | 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)="DIANTHUS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DIANTHUS |
---|
(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="976"
(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=976 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=976 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 976
arenarius | 15 | Blanc | 07/09 | 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="981"
(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=981 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=981 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 981
deltoides 'Flashing Light' ('Leuchtfunk') | 15 | Rouge | 05/07 | A |
(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="982"
(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=982 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=982 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 982
deltoides 'Rosea' | 20 | Rose | 05/07 | A |
(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="983"
(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=983 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=983 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 983
'Desmond' (Plumarius Group) | 25 | Rouge | 05/07 | 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="7363"
(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=7363 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=7363 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7363
pinifolius | 30 | Rouge | 05/07 | 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="996"
(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=996 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=996 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 996
superbus | 40 | Blanc | 06/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)="DIASCIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DIASCIA |
---|
(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="1000"
(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=1000 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=1000 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1000
integerrima | 50 | Rose | 06/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="7754"
(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=7754 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=7754 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7754
personata | 90 | Rose | 05/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)="DICENTRA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DICENTRA |
---|
(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="1008"
(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=1008 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=1008 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1008
spectabilis | 60 | Rose | 04/06 | 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="1009"
(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=1009 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=1009 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1009
spectabilis 'Alba' | 60 | Blanc | 04/06 | D |
(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)="DICHONDRA" 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)="DICTAMNUS" 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)="DIERAMA" 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)="DIGITALIS" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DIGITALIS |
---|
(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="1022"
(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=1022 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=1022 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1022
ferruginea | 150 | Saumon | 07/10 | 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="7636"
(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=7636 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=7636 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7636
'Glory of Roundway' | 90 | Rose | 05/08 | D |
(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="7637"
(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=7637 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=7637 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7637
'Goldcrest' ® | 50 | Orange | 06/09 | 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="1023"
(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=1023 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=1023 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1023
grandiflora (ambigua) | 100 | Jaune | 06/08 | 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="1025"
(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=1025 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=1025 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1025
lutea | 70 | Jaune | 06/08 | 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="1029"
(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=1029 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=1029 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1029
purpurea 'Alba' | 120 | Blanc | 07/08 | 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="7933"
(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=7933 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=7933 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7933
purpurea 'Monstrosa' | 120 | Variés | 06/07 | 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="1031"
(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=1031 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=1031 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1031
purpurea 'Pam's Choice' | 120 | Crème | 06/07 | 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="7862"
(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=7862 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=7862 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 7862
'Spice Island' | 100 | Jaune | 06/09 | 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)="DORONICUM" 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)="DORYCNIUM" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DORYCNIUM |
---|
(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="1035"
(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=1035 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=1035 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1035
hirsutum | 70 | Rose | 06/09 | 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)="DRACOCEPHALUM" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DRACOCEPHALUM |
---|
(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="1039"
(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=1039 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=1039 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1039
ruyschianum | 25 | Bleu | 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)="DUCHESNEA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
DUCHESNEA |
---|
(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="1048"
(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=1048 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=1048 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 1048
indica | 10 | F. vert | 05/09 | B |