0

There are no products in your cart

+370 670 19 319
l-lV 08-17    V 08-16        

Categories

Filtras

Filtras

No valid database connection Unknown column 'master_t.aukstisArray' in 'where clause' SQL=SELECT GROUP_CONCAT(DISTINCT child.product_id) AS children_id, COUNT(DISTINCT child.product_id) AS children_count, filter_master_mf.manufacturer_id, GROUP_CONCAT(DISTINCT filter_child_mf.manufacturer_id) AS c_manufacturer_id, GROUP_CONCAT(DISTINCT filter_master_tx.product_type_id) AS product_type_id, GROUP_CONCAT(DISTINCT filter_child_tx.product_type_id) AS c_product_type_id, MIN(filter_master_pr.product_price) AS product_price, MIN(filter_child_pr.product_price) AS c_product_price FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_type_19 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_19 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id LEFT JOIN fs_vm_product_mf_xref AS filter_master_mf ON filter_master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_product_mf_xref AS filter_child_mf ON filter_child_mf.product_id = child.product_id LEFT JOIN fs_vm_product_product_type_xref AS filter_master_tx ON fs_vm_product.product_id = filter_master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS filter_child_tx ON child.product_id = filter_child_tx.product_id LEFT JOIN fs_vm_product_price AS filter_master_pr ON fs_vm_product.product_id = filter_master_pr.product_id AND filter_master_pr.shopper_group_id IN ('7','5') LEFT JOIN fs_vm_product_price AS filter_child_pr ON child.product_id = filter_child_pr.product_id AND filter_child_pr.shopper_group_id IN ('7','5') WHERE fs_vm_product_category_xref.category_id = 29 AND (master_tx.product_type_id = 19 OR child_tx.product_type_id = 19) AND (master_t.aukstisArray OR child_t.aukstisArray) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y' AND (filter_master_pr.price_quantity_start <= 1 OR filter_master_pr.product_price IS NULL OR filter_child_pr.price_quantity_start <= 1 OR filter_child_pr.product_price IS NULL) GROUP BY `fs_vm_product`.`product_id` LIMIT 0, 2000
No valid database connection Unknown column 'master_t.aukstisArray' in 'where clause' SQL=SELECT COUNT(DISTINCT fs_vm_product.product_sku) as num_rows FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_type_19 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_19 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id WHERE fs_vm_product_category_xref.category_id = 29 AND (master_tx.product_type_id = 19 OR child_tx.product_type_id = 19) AND (master_t.aukstisArray OR child_t.aukstisArray) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y'
No valid database connection Unknown column 'master_t.aukstisArray' in 'where clause' SQL=SELECT GROUP_CONCAT(DISTINCT child.product_id) AS children_id, COUNT(DISTINCT child.product_id) AS children_count, fs_vm_category.products_per_row, fs_vm_category.category_browsepage, fs_vm_category.category_flypage, fs_vm_category.category_id, fs_vm_category.category_name, master_m.manufacturer_id, master_m.mf_name, fs_vm_product.product_name, fs_vm_product.product_id, fs_vm_product.product_full_image, fs_vm_product.product_thumb_image, fs_vm_product.product_s_desc, fs_vm_product.product_publish, fs_vm_product.product_in_stock, fs_vm_product.product_sku, fs_vm_product.product_url, fs_vm_product.product_weight, fs_vm_product.product_weight_uom, fs_vm_product.product_length, fs_vm_product.product_width, fs_vm_product.product_height, fs_vm_product.product_lwh_uom, fs_vm_product.product_in_stock, fs_vm_product.product_available_date, fs_vm_product.product_availability, fs_vm_product.mdate, fs_vm_product.cdate, fs_vm_product.quantity_options, fs_vm_product.metakey, fs_vm_product.metadata, fs_vm_product.product_special, child_m.manufacturer_id AS c_manufacturer_id, child_m.mf_name AS c_mf_name, child.product_name AS c_product_name, child.product_id AS c_product_id, child.product_full_image AS c_product_fulle_image, child.product_thumb_image AS c_product_thumb_image, child.product_s_desc AS c_product_s_desc, child.product_publish AS c_product_publish, child.product_in_stock AS c_product_in_stock, child.product_sku AS c_product_sku, child.product_url AS c_product_url, child.product_weight AS c_product_weight, child.product_weight_uom AS c_product_weight_uom, child.product_length AS c_product_length, child.product_width AS c_product_width, child.product_height AS c_product_height, child.product_lwh_uom AS c_product_lwh_uom, child.product_in_stock AS c_product_in_stock, child.product_available_date AS c_product_available_date, child.product_availability AS c_product_availability, child.mdate AS c_mdate, child.cdate AS c_cdate, child.quantity_options AS c_quantity_options, child.metakey AS c_metakey, child.metadata AS c_metadata, child.product_special AS c_product_special FROM fs_vm_product LEFT JOIN fs_vm_product AS child ON child.product_parent_id != 0 AND child.product_parent_id = fs_vm_product.product_id AND child.product_publish = 'Y' LEFT JOIN fs_vm_product_category_xref ON fs_vm_product.product_id = fs_vm_product_category_xref.product_id LEFT JOIN fs_vm_category ON fs_vm_product_category_xref.category_id = fs_vm_category.category_id AND fs_vm_category.category_publish = 'Y' LEFT JOIN fs_vm_product_mf_xref AS master_mf ON master_mf.product_id = fs_vm_product.product_id LEFT JOIN fs_vm_manufacturer AS master_m ON master_m.manufacturer_id = master_mf.manufacturer_id LEFT JOIN fs_vm_product_mf_xref AS child_mf ON child.product_id IS NOT NULL AND child_mf.product_id = child.product_id LEFT JOIN fs_vm_manufacturer AS child_m ON child_mf.manufacturer_id IS NOT NULL AND child_m.manufacturer_id = child_mf.manufacturer_id LEFT JOIN fs_vm_product_type_19 AS master_t ON fs_vm_product.product_id = master_t.product_id LEFT JOIN fs_vm_product_type_19 AS child_t ON child.product_id = child_t.product_id LEFT JOIN fs_vm_product_product_type_xref AS master_tx ON fs_vm_product.product_id = master_tx.product_id LEFT JOIN fs_vm_product_product_type_xref AS child_tx ON child.product_id = child_tx.product_id WHERE fs_vm_product_category_xref.category_id = 29 AND (master_tx.product_type_id = 19 OR child_tx.product_type_id = 19) AND (master_t.aukstisArray OR child_t.aukstisArray) AND fs_vm_product.product_parent_id = 0 AND fs_vm_product.product_publish = 'Y' GROUP BY fs_vm_product.product_sku ORDER BY fs_vm_product_category_xref.product_list ASC LIMIT 0, 18

PDFPrint
Fiberglass flagpoles

Hi-end quality FLAGMORE fiberglass flagpoles. Flagmore group is biggest flagpoles provider in the world, which is making of them more than 50 years.

We are an official representative, and selling only original product, therefore we can offer attractive prices, fast delivering and assembling.

Basic fiberglass flagpoles features: Veliavų stiebai Flagmore atstovavimas

  • lightweight;
  • strudly;
  • easy in use;
  • high mechanical durability;
  • non-corrosive;
  • tapering, solid;
  • flagpole with flag have wind force resistance about 25 m/s, without them  - 40 m/s;
  • safe in use in cause of non-electrical supply;
  • height from 5 to 22 m.

Gamintojo garantija. Akabaltic vienintelis oficialus Flagmore atstovas Lietuvoje