Query Failed! SQL: SELECT * FROM (
SELECT pro.`id` as product_id , pro.`name`, pro.`unit_import`, pro.`unit_export`, pro.`on_sales`, pro.`web_id`,
pro.`ratio_convert`, pro.`multi_attribute`,pro.`bought`,
pro.`img_1` `image`, pro.`img_1`, pro.`img_2`, pro.`img_3`, pro.`img_4`, pro.`img_5`, pro.`img_6`,pro.`attribute_1`,pro.`attribute_2`,
pro.`sum_stock`, '' description, pro.`short_description`, pro.`point`, pro.`for_point`,pro.`supplier_id`,pro.`link_url`,pro.`views`,pro.`sales`,
SKU.`code`, SKU.`on_stock`, SKU.`id` as sku_id, pro.`price`, pro.`wholesale_price`,
IFNULL(SKU.`name`, '') sku_name, IFNULL(SKU.`img_1`, '') sku_img_1, SKU.`unique_id`, pro.`product_commission_id`, SKU.`price_promotion`, SKU.`price` sku_price
, tb.`theme_cat_id`
, IFNULL(`tb`.id, 0) added
, `tb`.`priority` theme_priority
, `pro`.`priority` pro_priority
FROM sees_r_docsachnhanh.`product` pro
INNER JOIN sees_r_docsachnhanh.`SKU` ON `SKU`.product_id = `pro`.`id`
LEFT JOIN sees_r_docsachnhanh.`theme_product` tb ON tb.`unique_id` = `SKU`.`unique_id` AND tb.`deleted` = 0 AND tb.`theme_cat_id` = '8'
WHERE pro.`deleted` = '0' AND SKU.`deleted` = '0'
AND tb.`id` IS NOT NULL
AND pro.`hidden` = 0
AND tb.`theme_cat_id` = '8'
AND pro.`shop_id` = '1'
GROUP BY SKU.`product_id`
) nTB
ORDER BY `theme_priority` DESC, `pro_priority` DESC
LIMIT 0, 5 - Error: Unknown column 'pro.bought' in 'field list'
Đăng ký tài khoản
© Bản quyền thuộc về Đọc sách nhanh. Cung cấp bởi Vinateks.vn
