1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 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.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND companies.show_products_on_login = 'N' AND ?:product_required_products.product_id = 252545 GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC 
    
Friskies granule sterilecats losos +zelenina 300g
Demo webová verze, objednávky nebudou doručeny.
AB: FLY menu (Clone)

Friskies granule sterilecats losos +zelenina 300g

Přihlaste se k objednávka
ZnačkaFriskies EAN7613033000218
  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'cs' AND c_var.variant_id = 5602 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 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.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  WHERE 1  AND ?:categories.category_id IN (289) AND products.product_id NOT IN (252545) AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND products.amount >= 1 AND (products.min_qty IS NULL OR products.amount >= products.min_qty)  AND companies.show_products_on_login = 'N' GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC  LIMIT 0, 12
    

Podobné produkty

Značka
Friskies
Měřící jednotka
300g
EAN
7613033000218
Najít podobné
Friskies granule pro kočky sterile cats 300g
Obiloviny, maso a výrobky živočišného původu, bílkovinné extrakty rostlinného původu, vedlejší výrobky rostlinného původu, oleje a tuky, ryby a vedlejší výrobky z ryb (z toho 3 % tuňák a 1 % losos v hranatých granulích*), minerální látky, kvasnice, zeleniny (0,6 % sušené zeleniny, odpovídá 4 % rehydratované zeleniny v granulích ve tvaru disku**), *Celkový obsah ve výrobku: 2,4 % tuňáka a 0,8 % lososa, **Celkový obsah ve výrobku: 0,6 % rehydratované zeleniny., Typické složení produktu: 80 % hranatých granulí; 20 % granulí ve tvaru disku
Výživové hodnoty na Doplňkové látky:Nutriční doplňkové látky:m.j./kg:, vit A:14000, vit D3:1100, vit E:100, mg/kg:, síran železnatý monohydrát:(Fe: 54), jodičnan vápenatý bezvodý:(I: 1,7), síran měďnatý pentahydrát:(Cu: 10), síran manganatý monohydrát:(Mn: 5,8), síran zinečnatý monohydrát:(Zn: 75), seleničitan sodný:(Se: 0,12), taurin:1000, Barviva(1) a antioxidanty:, (1)bez umělých barviv:, Analytické složky:, protein:31 %, obsah tuku:9 %, obsah anorganických látek:7 %, hrubá vláknina:4,5 %