0 OR storing = 0) "; } else { // len ina ako centralna $id_list .= " AND (((SELECT sum(pieces) FROM company_branch_store WHERE id_company_branch = '".$record_web[store_id_company_branch]."' AND id_product = p.id_product) - (SELECT sum(pieces) FROM product_reservation WHERE id_company_branch = '".$record_web[store_id_company_branch]."' AND id_product = p.id_product)) > 0 OR storing = 0) "; } } else { // vsetky poobcky $id_list .= " AND (((p.pieces + if((SELECT sum(pieces) FROM company_branch_store WHERE id_product = p.id_product) != 0, (SELECT sum(pieces) FROM company_branch_store WHERE id_product = p.id_product), 0)) - IF((SELECT sum(pieces) FROM product_reservation WHERE id_product = p.id_product) != 0, (SELECT sum(pieces) FROM product_reservation WHERE id_product = p.id_product), 0)) > 0 OR storing = 0) "; } } if(!$product) { if(!$page) $page = 1; $nastr = $record_web[products_per_page]; $start = ($page-1)*$nastr; if(!$search_string) $query_product = MySQL_Query("SELECT count(*) pocet FROM product p WHERE ".$id_list." ORDER BY name", $conn_local); if($search_string) $query_product = MySQL_Query("SELECT count(*) pocet FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."'", $conn_local); $record_product = mysql_fetch_array($query_product); $spolu = $record_product[pocet]; /* if($spolu) { echo "".popisok("zoradit-podla-ceny")." "; echo "".popisok("zoradit-podla-nazvu")." "; if($store) echo ""; else echo ""; echo popisok("len-skladom")." "; } */ $stran = (floor($spolu/$nastr)+1); if(floor($spolu/$nastr) == $spolu/$nastr) $stran--; if($stran > 1) { echo "
"; for($i=1;$i<=$stran;$i++) { $show_this = 1; if($stran > 20) { $show_this = 0; if($i<=5) $show_this = 1; if(($i+5)>$stran) $show_this = 1; if(($i-3)<=$page && ($i+3)>=$page) $show_this = 1; } if(!$show_this && !$boldotdotdot) { echo " ... "; $boldotdotdot = 1; } if($show_this) { if($i != $page) echo ""; echo $i; if($i != $page) echo ""; echo " "; $boldotdotdot = 0; } } echo "
"; } $je_aspon_jeden = 0; if(!$search_string) $query_product = MySQL_Query("SELECT * FROM product p WHERE ".$id_list." ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local); if($search_string) $query_product = MySQL_Query("SELECT *, MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) as score FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."' ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local); while($record_product = mysql_fetch_array($query_product)) { $je_aspon_jeden = 1; } $was_product = 0; $kolko = 0; if($je_aspon_jeden) { echo "
"; if(!$search_string) $query_product = MySQL_Query("SELECT * FROM product p WHERE ".$id_list." ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local); if($search_string) $query_product = MySQL_Query("SELECT *, MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) as score FROM product p WHERE MATCH(name, note, part_number) AGAINST('".$search_string."' IN BOOLEAN MODE) OR id_product = '".str_replace("*", "", str_replace("+", "", str_replace("%20", " ", $search_string)))."' ORDER BY ".$orderby_query." LIMIT ".$start.", ".$nastr."", $conn_local); while($record_product = mysql_fetch_array($query_product)) { $kolko++; $was_product = 1; echo "
"; $was = 0; $query_product_file = MySQL_Query("SELECT * FROM product_file WHERE id_product = '".$record_product[id_product]."' LIMIT 1", $conn_local); while($record_product_file = mysql_fetch_array($query_product_file)) { $was = 1; echo "".$record_product[name].""; } echo "
"; echo $record_product[name]; echo "
"; if($url[1] == "mangalicovy-program") { if(fmod($kolko, 3) == 0) { echo "
"; } } } echo "
"; } $content_found = 1; //if(!$was_product) if($last_id) echo popisok("v-kategorii-sa-nenachadza-ziadny-produkt"); if($stran > 1) { echo "
"; for($i=1;$i<=$stran;$i++) { $show_this = 1; if($stran > 20) { $show_this = 0; if($i<=5) $show_this = 1; if(($i+5)>$stran) $show_this = 1; if(($i-3)<=$page && ($i+3)>=$page) $show_this = 1; } if(!$show_this && !$boldotdotdot) { echo " ... "; $boldotdotdot = 1; } if($show_this) { if($i != $page) echo ""; echo $i; if($i != $page) echo ""; echo " "; $boldotdotdot = 0; } } echo "
"; } } ?>
Užhorodská saláma >< Porubská saláma

Strážovská saláma

Strážovská saláma

Strážovská saláma- trvanlivý tepelne opracovaný mäsový výrobok

Zloženie: bravčové mäso 63%, hovädzie mäso 19%, bravčová slanina 13%, pitná voda , jedlá soľ, konzervačná látka E 250, stabilizátor E 450 a E 451, dextróza, čierne korenie, muškátový orech, koriander, cesnak, paprika pálivá, zvýrazňovač chuti E 621, extrakty korenín, antioxidant E 300 a E 316,extrakty korenín.

Skladovať pri teplote 0 až +4°C.

Po otvorení spotrebujte do 24 hodín.

Výrobok určený na priamu spotrebu.

Výživové hodnoty: kcal 362,04 /100g, KJ 1497,67/100g

obsah tuku 32.80% , bielkoviny 16,31% , sacharidy 0,4%, soľ 2,63%

Obal výrobku nie je konzumovateľný.

Spotrebujte do dátumu uvedenom na štítku.