Ingresar/Registrarse
MÍNIMO DE COMPRA $100.000 / ENVIOS A TODO EL PAIS
|
Ingresar/Registrarse
PRODUCTOS
Todos
BASICS
SALE
NUEVA COLECCIÓN
CARTERAS DE CUERO
CARTERAS DE ECO CUERO PREMIUM
SALE CALZADO HASTA 40% OFF!
SALE SWEATERS HASTA 30% OFF!
PRODUCTOS
CARTERAS DE CUERO
Bandoleras
Mini Bandoleras y sobres
Carteras
Riñoneras
Mochilas
Bolsos
Billeteras
Billeteras hombre
CARTERAS DE ECO CUERO PREMIUM
Línea Black
Carteras
Bandoleras
Mini bags
Riñoneras
Bolsos
Mochilas
Billeteras
Sobres y neceseres
Bolsos materos y mates
SALE CALZADO HASTA 40% OFF!
Zapatillas
Borcegos
Texanas
Zapatos
SS23
SALE SWEATERS HASTA 30% OFF!
Accesorios
Sweaters HASTA 30% OFF
Atención personalizada
Cómo comprar?
×
Catálogos
>
Catálogo Precio Mayorista
>
Catálogo sin precios
Inicio
>
Tienda
Menor Precio
Inicial
Mayor Precio
A - Z
Z - A
1054 -
select distinct m.manufacturers_id as id, m.manufacturers_name as name, CONCAT(m.manufacturers_name, ' (',manufacturers_products,')') as nombre_cantidad, m.manufacturer_grouper_id as grouper_id, mfd.filename as fileDeqName, m.url_amigable, m.manufacturers_image as imagen from manufacturers as m left join products p on p.manufacturers_id = m.manufacturers_id left join products_to_categories p2c on p.products_id = p2c.products_id left join specials s on s.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id left join mods_product_groupers mpg on p.product_grouper_id = mpg.id left join mods_file_deqs mfd on m.manufacturers_id = mfd.parent_id AND mfd.class LIKE 'Manufacturer' AND mfd.field LIKE 'image' where manufacturers_products > 0 and p.is_rentable = 0 and products_price > 0 and p.products_status = 1 and p2c.categories_id is not null and p.products_id in (select products_id from products_attributes where options_values_id in (12aamp)) and p.is_rentable = 0 and p.products_price > 0 and ((p.products_quantity - IF(p.products_min_stock_to_sell IS NULL,0,p.products_min_stock_to_sell)) > 0 or p.products_ignore_stock = 1) and p.products_status = 1 order by m.manufacturers_name asc
[TEP STOP]