Случайные комментарии в макете страницы

// Комментарии о товарах на главной странице
$oShop = Core_Entity::factory('Shop', $id );

$Shop_Controller_Show = new Shop_Controller_Show( $oShop );

$oShop = $Shop_Controller_Show->getEntity();

$oComment = Core_Entity::factory( 'Comment' );

$oComment->queryBuilder()
   ->select( 'comments.*' )
   ->join( 'comment_shop_items', 'comment_shop_items.comment_id', '=', 'comments.id' )
   ->join( 'shop_items', 'comment_shop_items.shop_item_id', '=', 'shop_items.id' )
   ->where( 'shop_items.shop_id', '=', 4 )
   ->where('shop_items.deleted', '=', 0)
   ->where('comments.deleted', '=', 0 )
   ->orderBy( 'RAND()' )
   ->limit(3);

$aShop_Item_Comment = $oComment->findAll(FALSE);

$Shop_Controller_Show->addEntities( $aShop_Item_Comment )
   ->xsl(
      Core_Entity::factory('Xsl')->getByName( $xslName )
   )
   ->show();

SELECT
`comments`.*, `shop_items`.`name` AS `shop_item_name`, `shop_items`.`path` AS `shop_item_path`
FROM `comments`
INNER JOIN `comment_shop_items` ON `comment_shop_items`.`comment_id` = `comments`.`id`
INNER JOIN `shop_items` ON `comment_shop_items`.`shop_item_id` = `shop_items`.`id`
WHERE  `shop_items`.`shop_id` = 4 AND `shop_items`.`deleted` = 0 AND `comments`.`deleted` = 0 AND `comments`.`deleted` = 0
ORDER BY RAND() ASC
LIMIT 3

$oShop = $Shop_Controller_Show->getEntity();

$oComments = Core_Entity::factory('Comment');
$oComments->queryBuilder()
    ->straightJoin()
    ->join('comment_shop_items', 'comments.id', '=', 'comment_shop_items.comment_id')
    ->join('shop_items', 'comment_shop_items.shop_item_id', '=', 'shop_items.id')
    ->where('shop_items.shop_id', '=', $oShop->id)
    ->where('shop_items.deleted', '=', 0)
    ->where('comments.active', '=', 1)
    ->where('comments.deleted', '=', 0 )
    ->clearOrderBy()
    ->orderBy('RAND()');

$aComments = $oComments->findAll();

foreach ($aComments as $Comments)
{
    $oShop_Item = $Comments->Shop_Item;

    $Shop_Controller_Show->addEntity(
        $Comments->addEntity(
            $oShop_Item->clearEntities()
        )
    );
}

Core::factory('Core_Xml_Entity')->name( $name )->value($value)

// Новый тег
$oMytag = Core::factory('Core_Xml_Entity')->name('mytag');

// В него помещаем объект $oMyObject
$oMytag->addEntity($oMyObject->clearEntities());

$Shop_Controller_Show->addEntity($oMytag);