1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ro'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ro' LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id
Linella :: NEMIRA Dune (coperta Tie in) 
  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ro'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ro' LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ro'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ro' LEFT JOIN ?:ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 LEFT JOIN ?:ult_product_prices as shared_prices_2 ON shared_prices.product_id = shared_prices_2.product_id AND shared_prices_2.company_id = 1 AND shared_prices_2.lower_limit = 1 AND shared_prices_2.price < shared_prices.price  AND shared_prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id

  1. products

  2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id   LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id
Москва
+78000000000Lu-Vi 9:00-18:00
Cereri de apel
Salvati 10%

NEMIRA Dune (coperta Tie in)

NO NAME
Scrie o recenzie
Pret vechi: 312.00 ₽
280.80 ₽
Discount: 31.20 ₽ (10%)

Pune o întrebare
400051
in stoc
+ −
Cumpără acum cu un singur clic 
    1. products

    2.  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ro'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ro' LEFT JOIN ?:warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id
+1

Nu au fost găsite recenzii

Похожие товары

Salvati 10%
250 de lucruri de incercat intr-o viata - pentru cupluri
164.00 ₽ 147.60 ₽
Vizualizare rapida
2x2 Chiftelute de gaina 400g
43.90 ₽
Vizualizare rapida
33 COROVI Biscuiti smetanca 180g
13.50 ₽
Vizualizare rapida
33 КОРОВЫ Biscuiti brinzica 180g
13.50 ₽
Vizualizare rapida

За ту же цену!

ABSOLUT Vodca 0.7l
2889
269.00 ₽
ADLER Oglinda Led 20cm
394278
579.00 ₽ 289.50 ₽
ARTHUR Harry Potter si Printul Semisange. Vol.6
399976
308.00 ₽ 277.20 ₽