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