Error executing request:
select distinct product_SIZE_VARIANTS_AVAILABLE from mapp_product where ((((((((wh_EN_PATH_1="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_1 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_2="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_2 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_3="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_3 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_4="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_4 like "product-catalogue/caps-and-hats/hats/%") ) and (product_EN_SHOW=1)) and (wh_EN_PATH_1 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_2 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_3 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_4 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and ((product_SHOW_FROM="0000-00-00" or product_SHOW_FROM<="2026-07-05") and (product_SHOW_TO="0000-00-00" or product_SHOW_TO>="2026-07-05"))) and (product_SHOW_ADMIN=0)
Can't create/write to file '/var/tmp/#sql_31ab_0.MAI' (Errcode: 28)
Error executing request:
select distinct product_MATERIAL from mapp_product where ((((((((wh_EN_PATH_1="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_1 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_2="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_2 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_3="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_3 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_4="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_4 like "product-catalogue/caps-and-hats/hats/%") ) and (product_EN_SHOW=1)) and (wh_EN_PATH_1 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_2 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_3 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_4 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and ((product_SHOW_FROM="0000-00-00" or product_SHOW_FROM<="2026-07-05") and (product_SHOW_TO="0000-00-00" or product_SHOW_TO>="2026-07-05"))) and (product_SHOW_ADMIN=0)
Can't create/write to file '/var/tmp/#sql_31ab_0.MAI' (Errcode: 28)
Error executing request:
select distinct product_SIZE_VARIANTS_AVAILABLE from mapp_product where ((((((((wh_EN_PATH_1="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_1 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_2="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_2 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_3="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_3 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_4="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_4 like "product-catalogue/caps-and-hats/hats/%") ) and (product_EN_SHOW=1)) and (wh_EN_PATH_1 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_2 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_3 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_4 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and ((product_SHOW_FROM="0000-00-00" or product_SHOW_FROM<="2026-07-05") and (product_SHOW_TO="0000-00-00" or product_SHOW_TO>="2026-07-05"))) and (product_SHOW_ADMIN=0)
Can't create/write to file '/var/tmp/#sql_31ab_0.MAI' (Errcode: 28)
Error executing request:
select distinct product_MATERIAL from mapp_product where ((((((((wh_EN_PATH_1="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_1 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_2="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_2 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_3="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_3 like "product-catalogue/caps-and-hats/hats/%" or wh_EN_PATH_4="product-catalogue/caps-and-hats/hats" or wh_EN_PATH_4 like "product-catalogue/caps-and-hats/hats/%") ) and (product_EN_SHOW=1)) and (wh_EN_PATH_1 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_2 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_3 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and (wh_EN_PATH_4 not in ("product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem","product-catalogue/t-shirts-and-polo-shirts/trika-s-vysivkou","product-catalogue/boots-and-boots-covers/udrzba-obuvi","product-catalogue/clothing-accessories/sle","product-catalogue/backpacks-and-bags/tasky","product-catalogue/caps-and-hats/kukly","product-catalogue/clothing-accessories/kravaty","product-catalogue/noze-a-naradi","product-catalogue/noze-a-naradi/sekery-macety","product-catalogue/noze-a-naradi/dyky","product-catalogue/noze-a-naradi/zaviraci-noze","product-catalogue/noze-a-naradi/multifunkcni-noze","product-catalogue/noze-a-naradi/naradi","product-catalogue/backpacks-and-bags/pouzdra","product-catalogue/t-shirts-and-polo-shirts/trika-s-potiskem/trika-s-barevnym-potiskem","product-catalogue/trousers/shorts","product-catalogue/noze-a-naradi/brousky","product-catalogue/noze-a-naradi/vrhaci-noze","product-catalogue/noze-a-naradi/pribory","product-catalogue/backpacks-and-bags/backpacks/univerzalni-batohy","product-catalogue/backpacks-and-bags/backpacks/klasicke-myslivecke-batohy","product-catalogue/backpacks-and-bags/ledvinky","product-catalogue/backpacks-and-bags/backpacks/velkoobjemove-batohy","product-catalogue/backpacks-and-bags/backpacks/se-stolickou","product-catalogue/noze-a-naradi/moderni-noze","product-catalogue/dalekohledy","product-catalogue/dalekohledy/priblizeni-7x-10x","product-catalogue/dalekohledy/priblizeni-11x-15x","product-catalogue/dalekohledy/priblizeni-pres-15x","product-catalogue/dalekohledy/zoom","product-catalogue","product-catalogue","product-catalogue","product-catalogue","product-catalogue/rybarska-straz-crs-sus-2025"))) and ((product_SHOW_FROM="0000-00-00" or product_SHOW_FROM<="2026-07-05") and (product_SHOW_TO="0000-00-00" or product_SHOW_TO>="2026-07-05"))) and (product_SHOW_ADMIN=0)
Can't create/write to file '/var/tmp/#sql_31ab_0.MAI' (Errcode: 28)
Hats | Product catalogue | BANNER Exclusive&Outdoor
Offer for professional organizations and retail stores
  • Česky
  • Deutsch
  • English
Filter

Filters

Hats

hat HUBERT Exclusive
S klima membránou
Detaily

hat HUBERT Exclusive

Elegant hat with lining and climate membrane - upper fabric sewn between the lining and waterproof / breathable inside), ...
Materials: Cheris

Microfibre - light, strong, durable fabric with a slightly polished surface (80 % polyester, 20 % cotton), water-resistant treatment

Materials: KLIMARON (climate-membrane)

Special, very thin fabric ensures full waterproofness and windproofness of the clothes while it also keeps breathability for the pairs from the inside. Used for modern outdoor clothes for every weather.

hat PRESTIGE
S klima membránou
Detaily

hat PRESTIGE

Elegant hat with lining and climate membrane - upper fabric sewn between the lining and waterproof / breathable inside), ...
Materials: KLIMARON (climate-membrane)

Special, very thin fabric ensures full waterproofness and windproofness of the clothes while it also keeps breathability for the pairs from the inside. Used for modern outdoor clothes for every weather.

Materials: Siletex

"Micro-fibre", firm, soft durable two-layer fabric with a slightly polished surface (100 % polyester), water-resistant treatment.

Zavoláme Vám