Lovecké a rybářské potřeby Nevoránek

25.5. 2023 ZAVŘENO

Exception message »
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'
                 
                
                INNER JOIN `stock` AS J
                    ON i_id = J.itemid
           	WHERE C.ic_category IN (0,2,3,4,10,437,593,503,406,505,426,432,608,51,52,53,55,56,57,58,59,61,62,63,64,65,66,572,574,67,70,72,73,315,75,314,462,463,464,317,316,313,82,318,319,382,575,458,467,84,85,86,577,491,492,493,494,535,536,587,589,590,578,579,94,95,96,97,98,99,100,101,102,103,104,105,106,472,366,367,368,370,468,475,476,545,321,369,371,372,373,473,474,107,108,109,110,111,112,113,592,114,115,116,117,119,120,121,122,123,124,125,126,127,312,138,601,140,141,142,143,145,146,147,148,149,152,154,569,591,156,157,158,159,160,585,165,167,573,581,582,583,584,163,164,166,169,567,178,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,525,498,514,517,478,487,499,500,501,600,615,526,527,528,529,486,405,481,482,483,484,309,48,49,50,424,455,454,456,440,441,438,445,446,448,443,442,444,504,559,586,407,408,411,459,460,479,480,485,409,410,415,489,412,413,414,519,521,513,506,507,508,509,510,511,512,433,434,435,576,609,610,613,614) && A.i_active = 'Y' && A.i_delete <> 'Y'
             && J.afloat > 0
            GROUP BY A.i_id
            ORDER BY A.i_modify DESC
            LIMIT 16 OFFSET 0
            

Exception message »
Error in fetch all.
Error: Got error 28 from storage engine

Exception message »
Can't perform query on database.
Error: Got error 28 from storage engine
Query: SELECT s_query AS query FROM `search_query` WHERE s_query != '' ORDER BY RAND() LIMIT 0,5

Exception message »
Error in fetch all.
Error: Got error 28 from storage engine

Uživatelé nejčastěji hledají: