Вывод товаров в карточке с одинаковым значением характеристик - JoomShopping

<!--Товары из такой же серии-->
<?php if (is_array($this->product->extra_field)) { ?>
<?php foreach ($this->product->extra_field as $extra_field) { ?>
<?php $extra_field_id = JRequest::getVar('extra_field_id', null); ?>
<?php
switch ($extra_field['name']) {
	case Серия: ?>
	<?php $a = $extra_field['value']; ?>
	<?php break;
}
?>
<?php } ?><?php } ?>	

<p>Товары такой же серии:</p>
<?php 
$product = &JTable::getInstance('product', 'jshop');
$db = &JFactory::getDBO();
   $Query = "SELECT product_id 	FROM #__jshopping_products WHERE extra_field_194=".$a."";
	  $db->setQuery($Query);
	  $prodid = $db->loadObjectList();
														
						foreach($prodid as $prid) 
						{ 
						$Query = "SELECT `name_ru-RU` AS name, product_publish 	FROM #__jshopping_products WHERE product_id=$prid->product_id AND `product_publish` = 1";
	  $db->setQuery($Query);
	  $prodname = $db->loadObjectList();
									
						foreach($prodname as $prdname){ 	
														
						if ($prid->product_id != $this->product->product_id){ ?> <a style="padding:5px" href="<?php print SEFLink('index.php?option=com_jshopping&controller=product&task=view&category_id='.$this->category_id.'&product_id='.$prid->product_id)?>">
	  <?php print $prdname->name;?>
	</a> <?php }}}
?> 
<!--Товары из категории END-->