1030 Got error 28 from storage engine
in:
[SELECT pd.products_name as product_name, p.products_price as products_price, p.isPriceFeatured as isPriceFeatured, p.features_code as features_code, p.products_weight as products_weight, p.priceTax as priceTax, p.products_retail_price as products_retail_price, p.actionPrice as actionPrice, p.actionPriceTax as actionPriceTax, p.finalPrice as finalPrice, p.finalPriceTax as finalPriceTax, p.originalPriceTax as originalPriceTax, p.originalPrice as originalPrice, IS_CUSTOMER_IN_PRICE_GROUP(794,p.products_id,1) as is_price_group, p.products_model as product_model, p.products_quantity as quantity, p.products_trade_status as availability, p.products_id as pid, p2c.categories_id as cid, pd.products_description as description, p.products_image as image, max(pgt.code) as group_code, m.name as manufacturer FROM _pneulux__products_description pd left outer join products_groups pg on pg.products_id = pd.products_id left outer join products_groups pg_master on pg_master.master_product_id = pd.products_id AND pg_master.shops_id = "794" LEFT OUTER JOIN products_groups_types pgt on pgt.id = pg_master.types_id AND pgt.code IN( "var", "set") INNER JOIN _pneulux__products p on p.products_id = pd.products_id INNER JOIN _pneulux__products_to_categories p2c on p2c.products_id = p.products_id INNER JOIN products cp on cp.id = p2c.products_id INNER JOIN taxes t on t.id = cp.tax_id LEFT OUTER JOIN manufacturers m ON m.id = cp.manufacturers_id WHERE (pg.types_id is null or pg.types_id <> 2) AND p2c.categories_id = "220493" GROUP BY p.products_id ORDER BY p.products_quantity DESC,if(p.products_trade_status=0, 90000, p.products_trade_status) ASC , p.products_id LIMIT 0, 16]
1030 Got error 28 from storage engine
in:
[SELECT pd.products_name as product_name, p.products_price as products_price, p.isPriceFeatured as isPriceFeatured, p.features_code as features_code, p.products_weight as products_weight, p.priceTax as priceTax, p.products_retail_price as products_retail_price, p.actionPrice as actionPrice, p.actionPriceTax as actionPriceTax, p.finalPrice as finalPrice, p.finalPriceTax as finalPriceTax, p.originalPriceTax as originalPriceTax, p.originalPrice as originalPrice, IS_CUSTOMER_IN_PRICE_GROUP(794,p.products_id,1) as is_price_group, p.products_model as product_model, p.products_quantity as quantity, p.products_trade_status as availability, p.products_id as pid, p2c.categories_id as cid, pd.products_description as description, p.products_image as image, max(pgt.code) as group_code, m.name as manufacturer FROM _pneulux__products_description pd left outer join products_groups pg on pg.products_id = pd.products_id left outer join products_groups pg_master on pg_master.master_product_id = pd.products_id AND pg_master.shops_id = "794" LEFT OUTER JOIN products_groups_types pgt on pgt.id = pg_master.types_id AND pgt.code IN( "var", "set") INNER JOIN _pneulux__products p on p.products_id = pd.products_id INNER JOIN _pneulux__products_to_categories p2c on p2c.products_id = p.products_id INNER JOIN products cp on cp.id = p2c.products_id INNER JOIN taxes t on t.id = cp.tax_id LEFT OUTER JOIN manufacturers m ON m.id = cp.manufacturers_id WHERE (pg.types_id is null or pg.types_id <> 2) AND p2c.categories_id = "220493" GROUP BY p.products_id ORDER BY p.products_quantity DESC,if(p.products_trade_status=0, 90000, p.products_trade_status) ASC , p.products_id LIMIT 0, 16]
Invalid address: objednavky@pneulux.cz,mirdasima@seznam.cz