(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)="NEPETA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
NEPETA |
---|
(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="2173"
(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=2173 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=2173 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2173
cataria 'Citriodora' | 50 | Violet | 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="2176"
(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=2176 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=2176 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2176
faassenii | 40 | Bleu | 05/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="2177"
(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=2177 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=2177 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2177
govaniana | 100 | Jaune | 06/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="3229"
(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=3229 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=3229 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3229
grandiflora 'Bramdean' | 50 | 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="2178"
(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=2178 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=2178 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2178
grandiflora 'Dawn to Dusk' | 65 | Rose | 05/08 | 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="2179"
(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=2179 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=2179 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2179
nervosa | 40 | Bleu | 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="2182"
(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=2182 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=2182 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2182
racemosa (mussinii) | 25 | Bleu | 04/09 | 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="3233"
(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=3233 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=3233 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 3233
racemosa 'Grog' | 20 | 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="2184"
(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=2184 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=2184 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2184
racemosa 'Snowflake' (faassenii) | 25 | 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="2185"
(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=2185 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=2185 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2185
sibirica | 90 | Bleu foncé | 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="2187"
(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=2187 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=2187 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2187
'Walker's Low' (Faassenii Group) | 50 | Bleu | 05/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)="NIEREMBERGIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =40
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC