8 (861) 203-40-71
Обратный звонок
профессиональная консультация
г. Краснодар, ул. Кубанская Набережная, 37/11
без выходных пн-вс 11:00-21:00

Топ за 30 дней

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 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('32', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('32', 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('32', 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] => 
)

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 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('32', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('32', 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('32', 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] => 
)

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 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('32', catalog_brands.Domains) OR catalog_brands.Domains IS NULL) AND (catalog_cats.Domains = '' OR FIND_IN_SET('32', 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('32', 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] => 
)

Mysql 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, 32) 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, 32) 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)

Mysql 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, 32) 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, 32) 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)

Mysql 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, 32) 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, 32) 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,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array)

Mysql 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, 32) 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, 32) 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,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array)

Mysql 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, 32) 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, 32) 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,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array)

Mysql 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, 32) 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, 32) 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,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array,Array)

без выходных пн-вс 11:00-21:00