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 "
"; } } ?>
Koleno predné >< Bravčový bôčik s kosťou

Bravčový lalok

Bravčový lalok

Bravčový lalok s kožou paprikovaný – varený mäsový výrobok

Zloženie: bravčový lalok 92%, pitná voda ,jedlá soľ, konzervačná látka  E 250 a E 535 , stabilizátor E 450 a E451 , modifikovaný škrob E 1420 a E 1422, dextróza , sojovy proteín , zahusťovadlo E 407, a E 417, antioxidant E 316, stimulátor chutnosti E 621 ,prírodné farbivo E 120, extrakty korenín paprika sladká , sušená zelenina ,cesnak.

Skladovať pri teplote 0 až 4°C, výrobok určený na priamu spotrebu.

UPOZORNENIE PRE ALERGIKOV: VÝROBOK OBSAHUJE  SÓJU.

Vhodné pre celiatikov- pre bezlepkovú dietu

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

Výživové hodnoty: kcal 387,46/100g ,KJ 1598,08 / 100g

obsah tuku 38,9%, bielkoviny 9,34% , sacharidy < 0,1%, soľ 1,84%

Balené v ochrannej atmosfére ,vákuovo balené po otvorení spotrebujte do 24 hodín.