Basket: Your Basket is empty.

[query] 1030:  Got error 28 from storage engine
query:
        SELECT          N.*, N.cat_name_en AS cat_name,
                                                                        COUNT(*)-1 AS level
                                                FROM            `57-kilts-shop`.kam_shop_categories AS N, `57-kilts-shop`.kam_shop_categories AS P
                                                WHERE           N.cat_lft BETWEEN P.cat_lft AND P.cat_rgt
                                                                        AND N.cat_lft > 1
                                                GROUP BY        N.cat_lft
                                                ORDER BY        N.cat_lft

Tartan Face Mask, Select Clan

Item code: 103458

Tartan Face Mask, various tartans (please select)

This face mask has an outer layer of hypoallergenic polyviscose cloth and a breathable inner lining, with elastic straps, making them machine washable.

Tartan: please select

Tartan Face Mask, various tartans (please select) This face mask has an outer layer of hypoallergenic polyviscose cloth and a breathable inner lining, with elastic straps, making them

Zoom

[query] 1030:  Got error 28 from storage engine
query:
SELECT          P.*, PTC.cat_id, P.prod_name_en AS prod_name
                                                FROM            `57-kilts-shop`.kam_shop_products AS P, `57-kilts-shop`.kam_shop_cross_selling AS CS, `57-kilts-shop`.kam_shop_products_to_categories AS PTC
                                                WHERE           CS.prod_bought = '103458'
                                                                        AND P.prod_id = CS.prod_also
                                                                        AND PTC.prod_id = P.prod_id
                                                GROUP BY        P.prod_id
                                                ORDER BY        CS.count DESC
                                                LIMIT           0, 5;

[query] 1030:  Got error 28 from storage engine
query:
SELECT          P.*, PTC.cat_id,
                                                                        P.prod_name_en                                                                                  AS prod_name,
                                                                        P.angebot_netto_eur                                                                             AS special_netto,
                                                                        P.angebot_netto_eur * ((100 + P.ust_eur) / 100)         AS special_brutto,
                                                                        REPLACE(description_en, '|', '
')      AS description
                                                FROM            `57-kilts-shop`.kam_shop_products P, `57-kilts-shop`.kam_shop_products_to_categories PTC
                                                WHERE           P.prod_id                               = PTC.prod_id
                                                                        AND P.angebot_eur       = 1
                                                                        AND P.in_shop_eur       = 1
                                                                        AND P.angebot_menge             > 0
                                                GROUP BY        P.prod_id
                                                ORDER BY        RAND()
                                                LIMIT           4