Can't perform query on database. Error: Got error 28 from storage engine Query: SELECT SQL_CALC_FOUND_ROWS
i_id AS id,
i_variant AS variant,
i_code AS code,
i_code_internal AS code_internal,
i_guaranty AS guaranty,
i_guaranty_type AS guaranty_type,
i_ean AS ean,
i_eanid AS eanid,
i_lang AS lang,
i_name AS name,
i_name_internal AS name_internal,
i_legend AS legend,
i_desc AS description,
i_furl AS furl,
i_maker AS makerid,
i_marker AS markerid,
i_provider AS providerid,
i_active AS active,
i_checked AS checked,
i_system AS system,
i_delete AS fordelete,
i_dph AS dphid,
i_price_freeze AS price_freeze,
i_sort_def AS sort_def,
i_sort AS sort,
i_category_main AS category_main,
dph_value AS dph,
p_value AS price,
max(ic_category) AS category,
DATE_FORMAT(A.i_make, '%d.%m.%y %H:%i') AS make,
UNIX_TIMESTAMP(A.i_make) AS maketimestamp,
DATE_FORMAT(A.i_modify, '%d.%m.%y %H:%i') AS modify,
UNIX_TIMESTAMP(A.i_modify) AS modifytimestamp
FROM `items_a` AS A
INNER JOIN `items_b` AS B
ON A.i_id = B.i_extid && B.i_lang = '1'
LEFT JOIN `items_category` AS C
ON A.i_id = C.ic_item
LEFT JOIN `group_items` AS D
ON A.i_id = D.gi_itemid
INNER JOIN `dph` AS F
ON F.dph_id = A.i_dph
INNER JOIN `prices` AS G
ON A.i_id = G.p_iid && G.p_pid = '2'
WHERE C.ic_category IN (3,179,180,181,182,183,184,185,186,187,188,193,195,534,436,533,563,196,197,199,564,200,201,429,204,205,206,207,208,209,210,524,523,212,213,214,215,384,220,221,222,566,224,225,227,228,230,231,385,532,518,232,233,234,255,257,496,546,547,562,551,550,267,497,386,402,490,556,558) && A.i_active = 'Y' && A.i_delete <> 'Y'
GROUP BY A.i_id
ORDER BY A.i_sort_def DESC, A.i_sort DESC, A.i_make DESC
LIMIT 9 OFFSET 0
Exception message »
Error in fetch all. Error: Got error 28 from storage engine
Oděvy a doplňky | Nevoránek
Oděvy a doplňky
Veškeré oděvy a doplňky pro myslivce, rybáře i outdoor!