|
select distinct p.products_id, pd.TypeProduit
from produits_associes pa, products_description pd, products p, produits_minprice pm
where pa.products_model = 'CH575A'
and pa.products_model_associe = p.products_model
and pd.products_id = p.products_id
and p.products_model = pm.products_model
and pd.language_id = order by TypeProduit ASC, pm.ordre, pd.products_name
|
