No valid database connection Unknown column 'child_pd.discount_id' in 'on 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_parent_id,
fs_vm_product.price_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.product_order_levels,
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.price_product_id AS c_price_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.product_order_levels AS c_product_order_levels,
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' AND child_pd.discount_id > 0 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_price AS master_pr ON master_pr.product_id = IF (fs_vm_product.price_product_id > 0, fs_vm_product.price_product_id, fs_vm_product.product_id) AND master_pr.shopper_group_id IN (5,5) LEFT JOIN fs_vm_product_price AS child_pr ON child_pr.product_id = IF (child.price_product_id > 0, child.price_product_id, child.product_id) AND child_pr.shopper_group_id IN (5,5) LEFT JOIN fs_vm_product_discount as master_pd on master_pd.discount_id = master_pr.product_discount_id AND (master_pd.start_date < 1716479726 OR master_pd.start_date = 0) AND (master_pd.end_date >1716479726 OR master_pd.end_date = 0) LEFT JOIN fs_vm_product_discount as child_pd on child_pd.discount_id = child_pr.product_discount_id AND (child_pd.start_date < 1716479726 OR child_pd.start_date = 0) AND (child_pd.end_date >1716479726 OR child_pd.end_date = 0) WHERE fs_vm_product_category_xref.category_id = 99 AND (master_pd.discount_id > 0 OR child.product_id IS NOT NULL) 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
Lauko stendai su užspaudžiamais rėmeliais
Доставка обычно занимает:
- Описание товара
-
Lauko stendai su užspaudžiamais rėmeliais:
- Galimi formatai: A1, A0, B1, B0;
- Plakatas/informacija eksponuojami lentoje su užspaudžiamais rėmeliais (32 mm pločio profilis);
- Plakatai uždengiami pakankamai tvirta antirefleksine PVC plėvele (storis = 0,7 mm) su UV filtru;
- Rėmas su stačiais kampais, su padidintu spyruoklių skaičiumi ir sandaria tarpine;
- Stendo kojos pagamintos iš 50mm aliuminio vamzdžio, papildomai sustiprintos apatinėje dalyje viduje esančiu cinkuoto plieno strypu;
- Priklausomai nuo formato, lenta montuojama ant 2 arba 3 skersinių, tai suteikia konstrukcijai tvirtumo;
- Priklausomai nuo varianto, stovas montuojamas ant sunkių plieninių arba betoninių pagrindų;
- Konstrukcija tinkama naudoti lauko sąlygomis, tačiau negarantuoja 100% sandarumo, dėl to rekomenduojame naudoti oro sąlygoms atsparius plakatus/spaudą;
- Stendas siunčiamas dalimis savarankiškam surinkimui naudojant šešiakampius raktus (yra komplekte);
- Stendo konstrukcija leidžia jį išplėsti papildomomis lentomis, tvirtinant jas tiesia linija arba kampu;
- Informacijos pateikimas: vienpusis arba dvipusis.
| 1. Stendas su milteliniu būdu dažytais apvaliais plieniniais pagrindais
- kiekvienas pagrindas sveria 15 kg (pagrindo skersmuo 500 mm);
- konstrukcijos aukštis: A1 - 1800 mm, A0 - 1850 mm, B1 - 1850 mm, B0 - 1900 mm;
- jei reikia, prie kiekvienos kojos galima prisukti daugiau nei po 1 pagrindą;
- pagrindai yra su rankenomis, todėl jie yra labai patogūs transportuoti;
- dėl savo dydžio ir svorio stendai gali būti sėkmingai naudojami ir patalpose.
|
| 2. Stendas su milteliniu būdu dažytais stačiakampiais plieniniais pagrindais
- kiekvienas pagrindas sveria 23 kg (pagrindo matmenys 400x800);
- konstrukcijos aukštis: A1 - 1800 mm, A0 - 1850 mm, B1 - 1850 mm, B0 - 1900 mm;
- jei reikia, prie kiekvienos kojos galiam prisukti daugiau nei po 1 pagrindą;
- pagrindai yra su rankenomis, todėl jie yra labai patogūs transportuoti;
- dėl savo dydžio ir svorio yra labai stabilūs;
- stora plieno plokštė tarnaus ilgą laiką, o dažų sluoksnį, reikalui esant galima atnaujinti.
|
| 3. Stendas su apvaliais, natūralios spalvos betoniniais pagrindais - kiekvieno pagrindo svoris yra 29 kg (pagrindo skersmuo 500 mm);
- konstrukcijos aukštis: A1 - 1800 mm, A0 - 1850 mm, B1 - 1850 mm, B0 - 1900 mm;
- gabaritai ir didelis svoris suteikia daugiau stabilumo;
- didelis jų privalumas – mažesnė kaina, nei su metaliniais pagrindais.
|