Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT CatID FROM catalog_models 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 (catalog_brands.Domains = '' OR FIND_IN_SET('70', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('70', 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 CatID > 0 AND (catalog_models.Domains = '' OR FIND_IN_SET('70', catalog_models.Domains)) AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY num_sales DESC
Mysql error: Unknown column 'num_sales' in 'order clause'
Error code: 1054
Query: SELECT DISTINCT TopBrandID FROM catalog_models 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 (catalog_brands.Domains = '' OR FIND_IN_SET('70', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('70', 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 TopBrandID > 0 AND (catalog_models.Domains = '' OR FIND_IN_SET('70', catalog_models.Domains)) AND catalog_models.HideIndex = ? GROUP BY catalog_models.ID ORDER BY num_sales DESC
