Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT CatID, COUNT(*) as filter_num FROM catalog_models LEFT JOIN catalog_models_to_cats ON catalog_models_to_cats.ModelID = catalog_models.ID 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 (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND catalog_models.HideIndex = ? GROUP BY CatID ORDER BY num_sales DESC
Params:
Array
(
    [0] => 
)

Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT CategoryID FROM catalog_models INNER JOIN catalog_models_to_cats ON catalog_models_to_cats.ModelID = catalog_models.ID 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 (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND CategoryID > 0 AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY num_sales DESC
Params:
Array
(
    [0] => 
)

Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT TopBrandID, COUNT(*) as filter_num FROM catalog_models LEFT JOIN catalog_models_to_cats ON catalog_models_to_cats.ModelID = catalog_models.ID 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 (shop_orders_models.ID IS NULL OR TIMESTAMPDIFF(DAY, shop_orders_models.Created, NOW()) <= 30) AND TopBrandID > 0 AND catalog_models.HideIndex = ? GROUP BY TopBrandID ORDER BY num_sales DESC
Params:
Array
(
    [0] => 
)

Фильтр
  • Вес, г
  • Входы
  • Множественное

Топ товаров

Фильтр
  • Снят с производства
    1 000 –5%
    950
    • Множественное Значение 1
    В наличии
    23 300 –5%
    22 135
    • Цена за м3 1 000 за м3
    • Множественное Значение 1, Значение 2
    В наличии
    10 000 –5%
    9 500
    за 100 ящ.
Пн-Сб: с 9 до 21, Вс: с 9 до 20