(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