Exception message »Can't perform query on database.
Error: Duplicate entry '2938' for key 'group_key'
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 (2,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) && 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: Duplicate entry '2938' for key 'group_key'

Rybářské potřeby | Nevoránek

Rybářské potřeby

Litujeme, ale nebyla nalezena žádná položka.

Košík je prázdný

Schránka je prázdná

Jetelové pelety Chytil 1kg

59,00 Kč

Jednorázový gril Lucifer 500g

59,00 Kč

Vlasec Awa shima FLUO Black 0,37mm/600m

549,00 Kč

Nůž zavírací Herbertz 222511

699,00 Kč

Úvodní stránka | Jak na to | Obchodní podmínky | Mapa stránek | Kontakt

| Exporty: RSS, Atom, RDF