SELECT SQL_CALC_FOUND_ROWS ident,
					CONCAT(znamka,' ',komercialno_ime,'<br>',naziv) as naziv,
					slika_1 as slika ,
					cena * 1.22 AS cena_z_ddv,
					cena_pred_akcijo * 1.22 as cena_pred_akcijo,
					znamka 
				FROM  _produkti_moto_gume 
					 WHERE znamka = 'MITAS'
					ORDER BY cena LIMIT 9,9                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/573368/mitas-b-13br350-8-46j-" class="link"></a>
                    <h1>MITAS B-13<br>3.50-8    46J </h1>
                    <div class="price">
                        <span class="old">32,45 €</span>                        <span class="new">22,72 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>3.50-8    46J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>3.50-8    46J " data-productid="573368-dd3c5436a0f0ff3b18ac2fcf226feb31"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/572942/mitas-b-4br2-1-4-18-225-18-42j-" class="link"></a>
                    <h1>MITAS B-4<br>2 1/4-18 (2.25-18) 42J </h1>
                    <div class="price">
                        <span class="old">34,04 €</span>                        <span class="new">23,83 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-4<br>2 1/4-18 (2.25-18) 42J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-4<br>2 1/4-18 (2.25-18) 42J " data-productid="572942-d6e4578144d525e996d303d1d0724b31"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/572941/mitas-b-3br2-1-2-18-250-18-43j-" class="link"></a>
                    <h1>MITAS B-3<br>2 1/2-18 (2.50-18) 43J </h1>
                    <div class="price">
                        <span class="old">34,89 €</span>                        <span class="new">24,42 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-3<br>2 1/2-18 (2.50-18) 43J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-3<br>2 1/2-18 (2.50-18) 43J " data-productid="572941-2fff227aa910b1f4092090de93dae6e4"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/572944/mitas-b-4br2-1-2-17-250-17-43j-" class="link"></a>
                    <h1>MITAS B-4<br>2 1/2-17 (2.50-17) 43J </h1>
                    <div class="price">
                        <span class="old">35,62 €</span>                        <span class="new">24,94 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-4<br>2 1/2-17 (2.50-17) 43J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-4<br>2 1/2-17 (2.50-17) 43J " data-productid="572944-6bd13c0b1a4e1ad2d2d9a08abb305e7e"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/573356/mitas-b-13br400-8c-66n-" class="link"></a>
                    <h1>MITAS B-13<br>4.00-8C 66N </h1>
                    <div class="price">
                        <span class="old">35,75 €</span>                        <span class="new">25,02 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>4.00-8C 66N " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>4.00-8C 66N " data-productid="573356-7dcf43015d7f019ad1e0c9b2a5095e03"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/573354/mitas-b-13br400-8c-71j-" class="link"></a>
                    <h1>MITAS B-13<br>4.00-8C  71J </h1>
                    <div class="price">
                        <span class="old">36,48 €</span>                        <span class="new">25,53 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>4.00-8C  71J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>4.00-8C  71J " data-productid="573354-c16dc2264579ce491351ccc2912de8ec"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/573390/mitas-b-14br350-10-59j-" class="link"></a>
                    <h1>MITAS B-14<br>3.50-10 59J </h1>
                    <div class="price">
                        <span class="old">36,60 €</span>                        <span class="new">25,62 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-14<br>3.50-10 59J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-14<br>3.50-10 59J " data-productid="573390-4d366447897cf1991647b0430e242899"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/572950/mitas-mc-2br2-1-2-16-250-16-42j-" class="link"></a>
                    <h1>MITAS MC-2<br>2 1/2-16 (2.50-16) 42J </h1>
                    <div class="price">
                        <span class="old">37,82 €</span>                        <span class="new">26,47 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS MC-2<br>2 1/2-16 (2.50-16) 42J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS MC-2<br>2 1/2-16 (2.50-16) 42J " data-productid="572950-4329ad44336334f5d6e003495ad84fac"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
                        
                <li class="infinite-item"><a href="/moto-pnevmatike/produkt/572975/mitas-mc-11br2-1-2-17-250-17-43j-" class="link"></a>
                    <h1>MITAS MC-11<br>2 1/2-17 (2.50-17) 43J </h1>
                    <div class="price">
                        <span class="old">37,82 €</span>                        <span class="new">26,47 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS MC-11<br>2 1/2-17 (2.50-17) 43J " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS MC-11<br>2 1/2-17 (2.50-17) 43J " data-productid="572975-877eb32c25d91f369513685cb52f9e6b"  class="add-to-cart"><i class="flaticon-shopping-cart12"></i><span>Dodaj <br>v košarico</span></a>
                    </div>
                </li>
	<a class="infinite-more-link" href="/_ajax/ajax.load-moto-gume.php?page=2&filter=znamka-MITAS"></a>