Вывести список товаров с той же ценой - Управление атрибутами, характеристиками и т.п.

<div class="jshop_list_product">
    <table class = "jshop list_related">
        <?php foreach($this->related_prod as $k=>$product){?>  
            <?php if ($k%$in_row==0) print "<tr>";?>
            <td width="<?php print 100/$in_row?>%" class="jshop_related">
                <?php include(dirname(__FILE__)."/../".$this->folder_list_products."/".$product->template_block_product);?>
            </td>
            <?php if ($k%$in_row==$in_row-1) print "</tr>";?>   
        <?php }?>
        <?php if ($k%$in_row!=$in_row-1) print "</tr>";?>
    </table>
    </div>

<?php
    print $this->_tmp_product_html_before_related;
    include(dirname(__FILE__)."/related.php");
    print $this->_tmp_product_html_before_review;
    include(dirname(__FILE__)."/review.php");
?>

$query = "SELECT * FROM `m06wr_jshopping_products` WHERE `product_price` LIKE '2000'";
echo $query;

$db = JFactory::getDBO();

$db = JFactory::getDbo();
	$query = $db->getQuery(true);
 
	$query
    ->select($db->quoteName(array('product_id', 'product_price', 'product_thumb_image', 'ordering')))
    ->from($db->quoteName('#__jshopping_products'))
    ->where($db->quoteName('product_price'). ' LIKE '. $db->quote('\'2125%\''))
    ->order('ordering ASC');
 
	$db->setQuery($query);
	$results = $db->loadObjectList();
	print_r($results);

->where($db->quoteName('product_price'). ' LIKE "2125%"')

$db = JFactory::getDbo();
	$query = $db->getQuery(true);
 
	$query
    ->select($db->quoteName(array('product_id', 'product_price', 'product_thumb_image', 'ordering')))
    ->from($db->quoteName('#__jshopping_products'))
    ->where($db->quoteName('product_id'). ' LIKE '. $db->quote('185'))
    ->order('ordering ASC');
 
	$db->setQuery($query);
	$results = $db->loadObjectList();
	print_r($results);

print_r($query->__toString());

SELECT `product_id` , `name_ru-RU` , `product_price` , `product_thumb_image`
FROM `m06wr_jshopping_products`
WHERE `product_price`
BETWEEN '8000'
AND '9000'
LIMIT 0 , 30

SELECT `name_ru-RU` , `product_price` , `product_thumb_image`
FROM `m06wr_jshopping_products` AS prod
LEFT JOIN `m06wr_jshopping_products_to_categories` AS pr_cat ON pr_cat.`product_id` = prod.`product_id`
WHERE `product_price`
BETWEEN '8000'
AND '9000'

WHERE pr_cat.category_id = 'нужный id категории' AND `product_price`...

SELECT `name_ru-RU` , `product_price` , `product_thumb_image`
FROM `m06wr_jshopping_products` AS prod
LEFT JOIN `m06wr_jshopping_products_to_categories` AS pr_cat ON pr_cat.`product_id` = prod.`product_id`
WHERE pr_cat.category_id = '250' AND `product_price` BETWEEN '8000' AND '9000'