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 < 1716977070 OR master_pd.start_date = 0) AND (master_pd.end_date >1716977070 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 < 1716977070 OR child_pd.start_date = 0) AND (child_pd.end_date >1716977070 OR child_pd.end_date = 0) WHERE (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 CLICK LED rėmelis
Usually ships in:
Rėmelio dydis: pasirinkite
Plakato gamyba: 2-3 d.d
Vienpusis arba dvipusis
Price:
149,17 €
(including 21 % tax)
123,28 €
(excluding tax)
Number of units in packaging:1
Number of units in box:1
- Product Description
-
Šviečiančio CLICK LED rėmelio aprašymas
- Remelis gali būti vienpusis arba dvipusis;
- Reklamos dydis: A4 (210 x 297 mm), A3 (297 x 420 mm), A2 (420 x 594 mm), A1 (594 x 841 mm), A0 (841 x 1189 mm), B2 (500 x 700 mm), B1 (700 x 1000 mm), B0 (1000 x 1400 mm);
- Matomos reklamos plotas: A4 (193 x 280 mm), A3 (280 x 403), A2 (403 x 577 mm), A1 (577 x 824 mm), A0 (824 x 1172 mm), B2 (483 x 683 mm), B1 (683 x 983 mm);
- Rėmelių išoriniai matmenys: A4 (252 x 339 mm), A3 (339 x 462 mm), A2 (462 x 636 mm), A1 (636 x 883 mm), A0 (883 x 1231 mm), B2 (542 x 742 mm), B1 (742 x 1042 mm), B0 (1024 x 1442 mm);
- Aliuminio profilio korpuso gylis 27-33 mm;
- Plakatas prispaudžiamas rėmelio click sistemos pagalba su skaidriu 8 mm apsauginiu stiklu;
- Spaudai naudojama Backlit medžiaga;
- Sidabrinės spalvos;
- Vidaus naudojimui;
- Komplektą sudaro: šviečiantis LED rėmelis, laidas su integruotu maitinimu.
Mūsų internetinėje parduotuvėje galite įsigyti (pasirinkite):
- Tik rėmelį pasirinkto dydžio (A4, A3, A2, A0, B2 (50x70 cm), B1 (70x100 cm), B0 (100x140 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į).
VIENPUSIO rėmelio dydžių lentelė:
Reklaminio dydis plakato(formatas) |
Išoriniai rėmo matmenys |
Apšvietimo galia |
Svoris |
A4 (210 x 297 mm) |
252 x 339 x 27 mm |
12 W |
1,6 kg |
A3 (297 x 420 mm) |
339 x 462 x 27 mm |
24 W |
2,5 kg |
A2 (420 x 594 mm)
|
462 x 636 x 27 mm |
24 W |
4 kg |
A1 (594 x 841 mm) |
636 x 883 x 27 mm |
36 W |
7 kg |
A0 (841 x 1189 mm) |
883 x 1231 x 27 mm |
48 W |
11,4 kg |
B2 (500 x 700 mm) |
524 x 742 x 27 mm |
24 W |
5 kg |
B1 (700 x 1000 mm) |
724 x 1024 x 27 mm |
36 W |
9 kg |
B2 (1000 x 1400 mm)
| 1024 x 1442 x 27 mm
| 84 W
| 13,2 kg
|
DVIPUSIO rėmelio dydžių lentelė:
Reklaminio dydis plakato(formatas) |
Išoriniai rėmo matmenys |
Apšvietimo galia |
Svoris |
A4 (210 x 297 mm) |
255 x 342 x 33 mm |
12 W |
1,9 kg |
A3 (297 x 420 mm) |
342 x 465 x 33 mm |
24 W |
3,2 kg |
A2 (420 x 594 mm)
|
465 x 639 x 33 mm |
24 W |
5,3 kg |
A1 (594 x 841 mm) |
639 x 886 x 33 mm |
36 W |
8,9 kg |
A0 (841 x 1189 mm) |
886 x 1234 x 33 mm |
48 W |
16,8 kg |
B2 (500 x 700 mm) |
545 x 745 x 33 mm |
24 W |
6,7 kg |
B1 (700 x 1000 mm) |
745 x 1045 x 33 mm |
36 W |
11,6 kg |