SELECT *, catalogue_textile.Price AS prix, catalogue_textile.Catalog_Ref AS Catalogue_Ref FROM catalogue_textile LEFT JOIN all_catalogue_textile ON catalogue_textile.Catalog_Ref=all_catalogue_textile.Catalog_Ref WHERE Is_Discontinued=0 AND (Composition_fr='100% Coton' OR Composition_fr='80% Coton, 20% Polyester' OR Composition_fr='98% Coton, 2% Elasthanne' OR Composition_fr='97% Coton, 3% Elasthanne' OR Composition_fr='85% Coton, 15% Polyester' OR Composition_fr='95% Coton, 5% Elasthanne') AND veotex_image!='' ORDER BY is_site_standard DESC, prix ASC LIMIT 0,60