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 Manufacturer='PROACT®' AND veotex_image!='' ORDER BY is_site_standard DESC, prix ASC