(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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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 "U%"
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
(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)="UNCINIA" and BE_A_ACTIVE=1 and PKFKID_COLLECTION =3
and trim(CHAR_A_TITRE)<>""
order by TRIM(UPPER(REPLACE(CHAR_P_ESPECE,"'",""))) ASC
UNCINIA
(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="2992"
(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=2992 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=2992 order by VAL_RT_PRIXPART ASC
(mysqli): select * from ARTICLE_APPARTENIR_COLLECTION WHERE
PKFKID_COLLECTION ="54" AND PKFKID_ARTICLE= 2992
