[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
Highland Dancing
[query] 1030: Got error 28 from storage engine
query:
SELECT N.*, 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 > '247' AND N.cat_rgt < '262'
GROUP BY N.cat_lft
ORDER BY N.cat_lft
[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
Special offers
Offer:
Merchandising
Last viewed