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 < 1716465727 OR master_pd.start_date = 0) AND (master_pd.end_date >1716465727 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 < 1716465727 OR child_pd.start_date = 0) AND (child_pd.end_date >1716465727 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
Šviečiantis LED rėmas PREMIUM laukui
Usually ships in:
Rėmelio dydis: pasirinkite
Plakato gamyba: 2-3 d.d
Tinkamas naudoti lauko sąlygomis
Price:
1 271,36 €
(including 21 % tax)
1 050,71 €
(excluding tax)
Number of units in packaging:1
Number of units in box:1
- Product Description
-
Šviečiantis LED rėmas PREMIUM laukui - šiuolaikiškas ir originalus reklamos pateikimo būdas. Šviečiančio rėmo privalumai - puikus matomumas 24/7 bei paprastas plakato keitimas. Elegantiškos išvaizdos šviečiantis rėmas tinkamas naudoti lauko sąlygomis. Taip pat, rėmas rakinamas, todėl plakatas bus apsaugotas nuo vandalų.
Šviečiančio LED rėmo PREMIUM laukui aprašymas
- Reklamos dydis: A1 (594 x 841 mm), A0 (841 x 1189 mm), 700 x 1000 mm, 1200 x 1800 mm;
- Matomos reklamos plotas: A1 (571 x 818 mm), A0 (818 x 1166 mm), 677 x 977 mm, 1177 x 1777 mm;
- Rėmelių išoriniai matmenys: A1 (737 x 984 mm), A0 (984 x 1332 mm), 843 x 1143 mm, 1343 x 1943 mm;
- Apšvietimo galia: A1 (27,3W), A0 (38,4W), 70x100 cm (32,3W), 120x180cm (90W);
- Aliuminio profilio korpuso gylis 70 mm;
- Svoris: A1 (22,19 kg), A0 (36,01 kg), 70x100 cm (27,75 kg), 120x180cm (68,50 kg);
- Rėmas rakinamas;
- Spynelių kiekis: A1 - 1 vnt., A0 - 2 vnt., 70x100 cm - 1 vnt., 120x180cm - 2 vnt.;
- Tinkamas naudoti lauke;
- Silikoninės tarpinės apsaugo plakatą nuo drėgmės;
- Apšvietimas: LED;
- Spalvinė temperatūra: 5000K;
- Spaudai naudojama Backlit medžiaga;
- Rėmo spalva - sidabrinė, o apvado - juoda;
- Rėmas pagamintas iš anoduoto aliuminio, nugarinė dalis iš plieno, o durelės iš grūdinto stiklo (4mm);
- Komplektą sudaro: šviečiantis LED rėmelis, plakatas su spauda, laidas su integruotu maitinimu.
Mūsų internetinėje parduotuvėje galite įsigyti (pasirinkite):
- Tik rėmelį pasirinkto dydžio (A1, A0, 70x100 cm, 100x140 cm, 120x180 cm);
- Pasirinkto dydžio rėmelį kartu su plakatu ir spauda.
Mes siūlome:
- trumpus gamybos terminus. Plakatą su spauda pagaminsime per 2-3 dienas;
- dizainerio-maketuotojo paslaugas (už papildomą mokestį).
DYDŽIŲ LENTELĖ
Reklaminio dydis plakato(formatas) | Matomos reklamos plotas
| Išoriniai rėmo matmenys
| Spynelių kiekis
| Apšvietimo galia
| Svoris |
A1 (594 x 841 mm) | 571 x 818 mm
| 737 x 984 x 70 mm
| 1 | 27,3 W | 22,19 kg |
A0 (841 x 1189 mm)
| 818 x 1166 mm
| 984 x 1332 x 70 mm
| 2 | 38,4 W | 36,01 kg |
700 x 1000 mm
| 677 x 977 mm
| 843 x 1143 x 70 mm
| 1 | 32,3 W | 27,75 kg |
1200 x 1800 mm
| 1177 x 1777 mm
| 1343 x 1943 x 70 mm
| 2 | 90 W | 68,50 kg |