Вывод товаров до опредененной цены - JoomShopping

<?php 
	defined( '_JEXEC' ) or die();
?>

		<?php 
		$i = 0;
		foreach($last_prod as $curr){ 
			if (($i % 3 ==0) && ($i != 0)) { } ?>

<?php 
					$db = JFactory::getDBO();
					$query = "SELECT * FROM #__menu WHERE menutype = 'left-menu-". $lng ."' AND link like 'index.php?option=com_jshopping&controller=category&task=view&category_id=". $category->category_id ."%'";
					$db->setQuery($query);
					$rez = $db->loadObject();
					$str = str_replace("/home", "", $category->category_link);
				?>

<div class="categ_head">
<div class="left_c">
<span>
<a href="<?php print $curr->product_link?>"><?php print $curr->name?></a>
</span>
</div>
<div class="right_c"><?php print formatprice($curr->product_price);?></div>
</div>
<div class="cartbtn">

<a href="/index.php/cart/add.html?category_id=<?php print $curr->category_id?>&product_id=<?php print $curr->product_id?>"><?php echo JTEXT::_(ADDTOCART); ?></a>
<a href="<?php print $curr->product_link?>">
<img class="jshop_img" style="height:217px;width:366px;" src="<?php print $jshopConfig->image_product_live_path?>/<?php if ($curr->product_thumb_image) print $curr->product_thumb_image; else print $noimage?>" alt="" />
</a>

</div>

<?php $i++; } ?>

<?php 
					$db = JFactory::getDBO();
					[b]$query = "SELECT * FROM #__jshopping_products WHERE product_price BETWEEN 1 AND 101 ";[/b]
					$db->setQuery($query);
					$rez = $db->loadObject();
					$str = str_replace("/home", "", $category->category_link);
?>

 WHERE product_price < 101

$db = JFactory::getDBO();
$query = "SELECT * FROM #__jshopping_products WHERE product_price < 101 LIMIT 5 ORDER BY product_id";
$db->setQuery($query);
$last_prod=$db->loadObjectList();

   $product = JTable::getInstance('product', 'jshop');
    $cat_str = $params->get('catids',NULL); 
    if (is_array($cat_str)) {    
        $cat_arr = array();
        foreach($cat_str as $key=>$curr){
           if (intval($curr)) $cat_arr[$key] = intval($curr);
        }  
    } else {
        $cat_arr = array();
        if (intval($cat_str)) $cat_arr[] = intval($cat_str);
    }
    $last_prod = $product->getRandProducts($params->get('count_products', 5), $cat_arr);   
    foreach($last_prod as $key=>$value){
        $last_prod[$key]->product_link = SEFLink('index.php?option=com_jshopping&controller=product&task=view&category_id='.$value->category_id.'&product_id='.$value->product_id, 1);
    }

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY product_price' at line 1 SQL=SELECT * FROM cnfsa_jshopping_products WHERE product_price < 1001 LIMIT 5 ORDER BY product_price

$db = JFactory::getDBO();
$query = "SELECT * FROM #__jshopping_products WHERE product_price < 101 LIMIT 5 ORDER BY product_id";
$db->setQuery($query);
$last_prod=$db->loadObjectList();