Logo: Kilts&More Logo: Kilts&More (Druck)
Choose a language
DE German EN English FR French
You would like to pay in another currency?
Please note: Changing to another currency will delete any items you may have in the shopping basket!
Basket: Your Basket is empty.
[query] 1030:  Got error 28 from storage engine
        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 
[query] 1030:  Got error 28 from storage engine
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 

 Special offers


Dekorelement für Marken Merchandising

Logo: Andante
Logo: Kilts & More
Logo: McCallum
Logo: Pearl
Logo: St Kilda (Holdings) Ltd (R.G. Hardies & Co.)

Dekorelement für zuletzt angesehen  Last viewed

  • Nothing listed