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/573877/mitas-mc-12br300-10" class="link"></a>
                    <h1>MITAS MC-12<br>3.00-10</h1>
                    <div class="price">
                        <span class="old">27,82 €</span>                        <span class="new">19,47 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS MC-12<br>3.00-10" >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS MC-12<br>3.00-10" data-productid="573877-9bd42b514e2bb908c938766869a6bf88"  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" class="link"></a>
                    <h1>MITAS B-4<br>2 1/4-18 (2.25-18)</h1>
                    <div class="price">
                        <span class="old">27,82 €</span>                        <span class="new">19,47 €</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)" >
                    </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)" 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/573368/mitas-b-13br350-8-" class="link"></a>
                    <h1>MITAS B-13<br>3.50-8   </h1>
                    <div class="price">
                        <span class="old">28,06 €</span>                        <span class="new">19,64 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>3.50-8   " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>3.50-8   " 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/572941/mitas-b-3br2-1-2-18-250-18" class="link"></a>
                    <h1>MITAS B-3<br>2 1/2-18 (2.50-18)</h1>
                    <div class="price">
                        <span class="old">28,55 €</span>                        <span class="new">19,98 €</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)" >
                    </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)" 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/573869/mitas-mc-26-capribr80-80-16" class="link"></a>
                    <h1>MITAS MC-26 CAPRI<br>80/80-16</h1>
                    <div class="price">
                        <span class="old">30,87 €</span>                        <span class="new">21,61 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS MC-26 CAPRI<br>80/80-16" >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS MC-26 CAPRI<br>80/80-16" data-productid="573869-f8010a3596f24f17c58b9a5834e5d9ec"  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" class="link"></a>
                    <h1>MITAS B-13<br>4.00-8C</h1>
                    <div class="price">
                        <span class="old">30,87 €</span>                        <span class="new">21,61 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>4.00-8C" >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>4.00-8C" 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/572950/mitas-mc-2br2-1-2-16-250-16" class="link"></a>
                    <h1>MITAS MC-2<br>2 1/2-16 (2.50-16)</h1>
                    <div class="price">
                        <span class="old">30,87 €</span>                        <span class="new">21,61 €</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)" >
                    </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)" 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" class="link"></a>
                    <h1>MITAS MC-11<br>2 1/2-17 (2.50-17)</h1>
                    <div class="price">
                        <span class="old">30,87 €</span>                        <span class="new">21,61 €</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)" >
                    </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)" data-productid="572975-877eb32c25d91f369513685cb52f9e6b"  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-" class="link"></a>
                    <h1>MITAS B-13<br>4.00-8C </h1>
                    <div class="price">
                        <span class="old">31,48 €</span>                        <span class="new">22,03 €</span>
                    </div>
                    <div class="img-wr">
                        <img src="/gfx/_box-images/ni_slike.jpg" alt="MITAS B-13<br>4.00-8C " >
                    </div>
                    <div class="actions">
                        <i class="flaticon-magnifying47"></i> 
                        <a href="#" data-producttype="2" data-productname="MITAS B-13<br>4.00-8C " data-productid="573354-c16dc2264579ce491351ccc2912de8ec"  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>