Вывод поля категории в default_children.php - Joomla 3.x: Общие вопросы

<?php $myCustomFields = array();
				foreach($this->category->jcfields as $field) :
					$myCustomFields[$field->name] = $field->value; endforeach; ?>
					<?php if (isset($myCustomFields['full-price']) and !empty($myCustomFields['full-price'])) : ?>
						<h2 class="full-price"><?=$myCustomFields['full-price']; endif; ?></h2>

<h2 class="full-price">
	<?php
$db =JFactory::getDBO();
	$query = $db->getQuery(true);
	$query->select('a.value')
		->from($db->quoteName('#__fields_values', 'a'))
		->where($db->quoteName('a.field_id'). '  = 10' );
	$query->select($db->quoteName('b.id'))
		->where($db->quoteName('b.id'). '= ' .$child->id )
		->where($db->quoteName('b.level'). '= 4' )
		->where($db->quoteName('b.published'). '= 1' );
	$query->innerJoin(
	$db->quoteName('#__categories', 'b')
		. ' ON ' 
		. $db->quoteName('b.id') 
		. ' = ' . $db->quoteName('a.item_id')
	);
	$db->setQuery($query);
	$result = $db->loadObjectList();
		foreach($result as $row) {
			echo $this->escape($row->value);
	} ?>
</h2>

->where($db->quoteName('a.field_id'). '  = 10' )

->where($db->quoteName('b.level'). '= 4' )

->where($db->quoteName('b.id'). '= ' .$child->id )

->where($db->quoteName('b.published'). '= 1' );