Топ за 30 дней

Db error: Unknown column 'num_sales' in 'order clause'

Error code: 1054

Query: SELECT DISTINCT CatID, COUNT(DISTINCT catalog_models.ID) as filter_num 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 (CatID = '827' OR CategoryID = 827) AND catalog_models.Source != 'ad' AND (catalog_brands.Domains = '' OR FIND_IN_SET('69', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('69', 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('69', catalog_models.Domains)) AND catalog_models.HideIndex = ? AND catalog_models.Status != 200 AND NOT (catalog_models.Status IN ('202') AND catalog_models.Q = 0) GROUP BY CatID ORDER BY num_sales DESC

Params:

Array
(
    [0] => 
)

Db 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 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 (CatID = '827' OR CategoryID = 827) AND catalog_models.Source != 'ad' AND (catalog_brands.Domains = '' OR FIND_IN_SET('69', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('69', 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 CategoryID > 0 AND (catalog_models.Domains = '' OR FIND_IN_SET('69', catalog_models.Domains)) AND catalog_models.HideIndex = ? AND catalog_models.Status != 200 AND NOT (catalog_models.Status IN ('202') AND catalog_models.Q = 0) GROUP BY catalog_models.ID ORDER BY num_sales DESC

Params:

Array
(
    [0] => 
)

Db 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 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 (CatID = '827' OR CategoryID = 827) AND catalog_models.Source != 'ad' AND (catalog_brands.Domains = '' OR FIND_IN_SET('69', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('69', 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('69', catalog_models.Domains)) AND catalog_models.HideIndex = ? AND catalog_models.Status != 200 AND NOT (catalog_models.Status IN ('202') AND catalog_models.Q = 0) GROUP BY TopBrandID ORDER BY num_sales DESC

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)

Db error: Unknown column 'Array' in 'where clause'

Error code: 1054

Query: SELECT catalog_props_vals.ID, catalog_props_vals.ID as ValID, catalog_props_vals.Val as Val, catalog_props_vals.Text as Text, catalog_props_vals.Color, catalog_props_vals.SortIndex , IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Val' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Val) as Val, IFNULL((SELECT IF(Text != '', Text, NULL) FROM lang_values WHERE TableName='catalog_props_vals' AND FieldName='Text' AND TableID=catalog_props_vals.ID AND Lang='ru' AND Domain IN(0, 69) ORDER BY Domain DESC LIMIT 1), catalog_props_vals.Text) as Text FROM catalog_props_vals WHERE ID IN (Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array) AND `HideInFilter` = ?

Params:

Array
(
    [0] => 
)