Mysql error: Unknown column 'SortPrice' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT catalog_models.ID,catalog_models.CatID,catalog_models.TopCatID,catalog_models.Name,catalog_models.Code,catalog_models.BrandID,catalog_models.TopBrandID,catalog_models.Articul,catalog_models.BarCode,catalog_models.Weight,catalog_models.WeightBrutto,catalog_models.Volume,catalog_models.Length,catalog_models.Width,catalog_models.Height,catalog_models.BaseUnit,catalog_models.ModelType,catalog_models.Price,catalog_models.Currency,catalog_models.SortIndex,catalog_models.Image,catalog_models.Images,catalog_models.Images360,catalog_models.Image3d,catalog_models.Status,catalog_models.StatusSortIndex,catalog_models.Props,catalog_models.Q,catalog_models.Mods,catalog_models.NumModsAvailable,catalog_models.NumParams,catalog_models.DiscountID,catalog_models.MaxDiscountQ,catalog_models.MinQ,catalog_models.Notice,catalog_models.Hide,catalog_models.Groups,catalog_models.NumBindings,catalog_models.NumComplects,catalog_models.BindCode,catalog_models.Code1C,catalog_models.ImportID,catalog_models.H,catalog_models.Title,catalog_models.Keywords,catalog_models.Description,catalog_models.YmlDisabled,catalog_models.Rss2Disabled,catalog_models.LocalDeliveryCost,catalog_models.PreOrderDaysMin,catalog_models.PreOrderDaysMax,catalog_models.Pickup,catalog_models.Delivery,catalog_models.DisableDelivery,catalog_models.Tags,catalog_models.NoIndex,catalog_models.Rating,catalog_models.Created,catalog_models.ModifiedDate,catalog_models.AcceptDate,catalog_models.NumComments,catalog_models.NumReviews,catalog_models.NumSales,catalog_models.MiniComment,catalog_models.CountryOriginID,catalog_models.SalesNotes,catalog_models.HideCat,catalog_models.HideBrand,catalog_models.HideIndex,catalog_models.SearchSyn,catalog_models.NumGifts,catalog_models.DigitalResID,catalog_models.Source,catalog_models.SourceUrl,catalog_models.SourceName,catalog_models.SourceLogo,catalog_models.SourceUserID,catalog_models.Domains,COUNT(shop_orders_models.ID) as num_sales FROM catalog_models LEFT JOIN catalog_models_to_cats ON catalog_models_to_cats.ModelID = catalog_models.ID LEFT JOIN catalog_cats ON catalog_cats.ID = catalog_models.CatID LEFT JOIN catalog_brands ON catalog_brands.ID = catalog_models.BrandID LEFT JOIN shop_orders_models ON shop_orders_models.ModelID = catalog_models.ID WHERE catalog_models.Status != 200 AND (CatID = '15' OR CategoryID = 15) AND catalog_models.Source != 'ad' AND (catalog_brands.Domains = '' OR FIND_IN_SET('91', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('91', catalog_cats.Domains) OR catalog_cats.Domains IS NULL) AND (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND (catalog_models.Domains = '' OR FIND_IN_SET('91', catalog_models.Domains)) AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY SortPrice DESC, catalog_models.Price asc LIMIT 0, 40
Params:
Array
(
    [0] => 
)

Топ товаров

Топ товаров

Не найдено товаров