- Inicio
- Invitaciones ▼
- Tarjeta impresa
- Tarjeta de UV
- Tarjetas de Foil
- Tarjeta digital
- Personalizado
-
Tarjeta con Desgarro
- Papel Albanene
- Envolvente Albanene
- Tarjeta Albanene
- Otras Tarjetas
-
XV Años
- Recordatorios
- Agradecimientos
- Menús
- Mesores
-
Muestras
Corte Láser & Albanene & Terciopelo
- Accesorios ▼
- Letrero
- Info Útil ▼

2023-02-08 13:32:28
Inicio »
Accesorios »
Sello de Lacre
INVITACIONES![]() ![]() ![]() ![]() ACCESORIOSTARJETAS |
select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.products_weight, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '2'
and p2c.categories_id = '38'order by p.products_sort_order, pd.products_name
Mostrando 1-3 de 3 modelos
Mostrando 1-3 de 3 modelos
|
INFO DE PEDIDO

Confirmar
Velamor usará sus cookies para garantizar que tenga una mejor experiencia de navegación. Para que continue su navegación, debemos confirmar que acepta nuestro uso de sus cookies.