Вывод групп товаров на главную страницу поддомена

$Shop_Controller_Show = new Shop_Controller_Show(
         Core_Entity::factory('Shop',4 )
      );

$Informationsystem_Controller_Show = new Informationsystem_Controller_Show(
         Core_Entity::factory('Informationsystem', 15)
      );

      $Shop_Controller_Show = new Shop_Controller_Show(
         Core_Entity::factory('Shop',4 )
      );
      $Shop_Controller_Show
         ->xsl(
            Core_Entity::factory('Xsl')->getByName('МагазинКаталогТоваровНаГлавнойСпецПредСайт10')
         )
         ->groupsMode('none')
         ->group(FALSE)
         ->cache(FALSE)
         ->limit(3);

      $Shop_Controller_Show
         ->shopItems()
         ->queryBuilder()
         ->join('shop_item_discounts', 'shop_item_discounts.shop_item_id', '=', 'shop_items.id')
         ->join('shop_discounts', 'shop_discounts.id', '=', 'shop_item_discounts.shop_discount_id')
         ->where('shop_discounts.active', '=', 1)
         ->where('shop_discounts.start_datetime', '<', Core_Date::timestamp2sql(time()))
         ->where('shop_discounts.end_datetime', '>', Core_Date::timestamp2sql(time()))
         ->where('shop_discounts.deleted', '=', 0)
         ->where('shop_items.modification_id', '=', 0)
         ->clearOrderBy()
         ->orderBy('RAND()');

      $Shop_Controller_Show->show();
   }

<shop id="21">
   <shop_dir_id>0</shop_dir_id>
   <shop_company_id>1</shop_company_id>
   <site_id>10</site_id>
   <name>Демонстрационный магазин</name>
   <description></description>
   <yandex_market_name></yandex_market_name>
   <image_small_max_width>270</image_small_max_width>
   <image_small_max_height>270</image_small_max_height>
   <image_large_max_width>800</image_large_max_width>
   <image_large_max_height>800</image_large_max_height>
   <structure_id>765</structure_id>
   <shop_country_id>175</shop_country_id>
   <shop_currency_id>4</shop_currency_id>
   <shop_order_status_id>0</shop_order_status_id>
   <shop_measure_id>0</shop_measure_id>
   <email>admin@localhost.ru</email>
   <items_on_page>6</items_on_page>
   <url_type>0</url_type>
   <reserve>1</reserve>
   <send_order_email_admin>1</send_order_email_admin>
   <send_order_email_user>1</send_order_email_user>
   <items_sorting_field>0</items_sorting_field>
   <items_sorting_direction>1</items_sorting_direction>
   <groups_sorting_field>0</groups_sorting_field>
   <groups_sorting_direction>0</groups_sorting_direction>
   <user_id>19</user_id>
   <comment_active>1</comment_active>
   <watermark_file></watermark_file>
   <watermark_default_use_large_image>0</watermark_default_use_large_image>
   <watermark_default_use_small_image>0</watermark_default_use_small_image>
   <watermark_default_position_x>50%</watermark_default_position_x>
   <watermark_default_position_y>100%</watermark_default_position_y>
   <guid>32108C90-6872-0ACE-581E-6831735A5736</guid>
   <format_date>%d.%m.%Y</format_date>
   <format_datetime>%d.%m.%Y %H:%M:%S</format_datetime>
   <typograph_default_items>0</typograph_default_items>
   <typograph_default_groups>0</typograph_default_groups>
   <apply_tags_automatically>1</apply_tags_automatically>
   <write_off_paid_items>1</write_off_paid_items>
   <apply_keywords_automatically>0</apply_keywords_automatically>
   <change_filename>1</change_filename>
   <attach_digital_items>1</attach_digital_items>
   <yandex_market_sales_notes_default></yandex_market_sales_notes_default>
   <siteuser_group_id>0</siteuser_group_id>
   <use_captcha>1</use_captcha>
   <group_image_small_max_width>100</group_image_small_max_width>
   <group_image_large_max_width>800</group_image_large_max_width>
   <group_image_small_max_height>100</group_image_small_max_height>
   <group_image_large_max_height>800</group_image_large_max_height>
   <producer_image_small_max_width>100</producer_image_small_max_width>
   <producer_image_large_max_width>800</producer_image_large_max_width>
   <producer_image_small_max_height>100</producer_image_small_max_height>
   <producer_image_large_max_height>800</producer_image_large_max_height>
   <preserve_aspect_ratio>1</preserve_aspect_ratio>
   <preserve_aspect_ratio_small>1</preserve_aspect_ratio_small>
   <preserve_aspect_ratio_group>1</preserve_aspect_ratio_group>
   <preserve_aspect_ratio_group_small>1</preserve_aspect_ratio_group_small>
   <reserve_hours>24</reserve_hours>
   <deleted>0</deleted>
   <http>//moskva.rfrussia.ru</http>
   <url>/shop/</url>
   <captcha_id>13671</captcha_id>
   <items_count>0</items_count>
   <items_total_count>18</items_total_count>
   <subgroups_count>6</subgroups_count>
   <subgroups_total_count>6</subgroups_total_count>
   <siteuser_id>0</siteuser_id>
   <group>0</group>
   <page>0</page>
   <limit>3</limit>
   <total>3</total>
   <shop_item_properties>
      <property id="146">
         <property_dir_id>0</property_dir_id>
         <list_id>0</list_id>
         <informationsystem_id>0</informationsystem_id>
         <shop_id>0</shop_id>
         <name>Доп. изображения</name>
         <description></description>
         <type>2</type>
         <default_value></default_value>
         <tag_name>img</tag_name>
         <sorting>10</sorting>
         <image_large_max_width>1000</image_large_max_width>
         <image_large_max_height>1000</image_large_max_height>
         <image_small_max_width>1000</image_small_max_width>
         <image_small_max_height>1000</image_small_max_height>
         <hide_small_image>0</hide_small_image>
         <guid>5B0C3AA7-25C4-3C22-35C7-C8DF3142223C</guid>
         <multiple>1</multiple>
         <user_id>19</user_id>
         <prefix></prefix>
         <filter>0</filter>
         <show_in_group>1</show_in_group>
         <show_in_item>1</show_in_item>
      </property>
      
      <property id="147">
         <property_dir_id>0</property_dir_id>
         <list_id>0</list_id>
         <informationsystem_id>0</informationsystem_id>
         <shop_id>0</shop_id>
         <name>Строка</name>
         <description></description>
         <type>1</type>
         <default_value></default_value>
         <tag_name>string</tag_name>
         <sorting>10</sorting>
         <image_large_max_width>300</image_large_max_width>
         <image_large_max_height>300</image_large_max_height>
         <image_small_max_width>70</image_small_max_width>
         <image_small_max_height>70</image_small_max_height>
         <hide_small_image>0</hide_small_image>
         <guid>A7F06E6D-900D-E122-1B78-81E464C44BDE</guid>
         <multiple>1</multiple>
         <user_id>19</user_id>
         <prefix></prefix>
         <filter>0</filter>
         <show_in_group>1</show_in_group>
         <show_in_item>1</show_in_item>
      </property>
      
      <property id="148">
         <property_dir_id>0</property_dir_id>
         <list_id>213</list_id>
         <informationsystem_id>0</informationsystem_id>
         <shop_id>0</shop_id>
         <name>Список</name>
         <description></description>
         <type>3</type>
         <default_value></default_value>
         <tag_name>list</tag_name>
         <sorting>10</sorting>
         <image_large_max_width>300</image_large_max_width>
         <image_large_max_height>300</image_large_max_height>
         <image_small_max_width>70</image_small_max_width>
         <image_small_max_height>70</image_small_max_height>
         <hide_small_image>0</hide_small_image>
         <guid>829933E1-10B2-D798-F19D-70924B52E830</guid>
         <multiple>1</multiple>
         <user_id>19</user_id>
         <prefix></prefix>
         <filter>2</filter>
         <show_in_group>1</show_in_group>
         <show_in_item>1</show_in_item>
         <list id="213">
            <list_dir_id>6</list_dir_id>
            <name>ЦветаСайт10</name>
            <description></description>
            <user_id>19</user_id>
            <site_id>10</site_id>
            <list_item id="1450">
               <list_id>213</list_id>
               <value>Красный</value>
               <sorting>10</sorting>
               <description></description>
               <active>1</active>
               <user_id>19</user_id>
            </list_item>
            <list_item id="1451">
               <list_id>213</list_id>
               <value>Синий</value>
               <sorting>20</sorting>
               <description>Описание синего</description>
               <active>1</active>
               <user_id>19</user_id>
            </list_item>
            <list_item id="1452">
               <list_id>213</list_id>
               <value>Зеленый</value>
               <sorting>30</sorting>
               <description></description>
               <active>1</active>
               <user_id>19</user_id>
            </list_item>
            <list_item id="1453">
               <list_id>213</list_id>
               <value>Серебристый</value>
               <sorting>40</sorting>
               <description></description>
               <active>1</active>
               <user_id>19</user_id>
            </list_item>
            <list_item id="1454">
               <list_id>213</list_id>
               <value>Черный</value>
               <sorting>50</sorting>
               <description></description>
               <active>1</active>
               <user_id>19</user_id>
            </list_item>
         </list>
      </property>
   </shop_item_properties>
   <shop_item id="338">
      <shortcut_id>0</shortcut_id>
      <shop_tax_id>0</shop_tax_id>
      <shop_seller_id>0</shop_seller_id>
      <shop_group_id>1452</shop_group_id>
      <shop_currency_id>4</shop_currency_id>
      <shop_id>21</shop_id>
      <shop_producer_id>283</shop_producer_id>
      <shop_measure_id>0</shop_measure_id>
      <type>0</type>
      <name>Olympus OM-D E-M10 Kit</name>
      <marking></marking>
      <vendorcode></vendorcode>
      <description></description>
      <text>Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?</text>
      <image_large>shop_items_catalog_image338.png</image_large>
      <image_small>small_shop_items_catalog_image338.png</image_small>
      <weight>0</weight>
      <active>1</active>
      <siteuser_group_id>-1</siteuser_group_id>
      <sorting>0</sorting>
      <path>olympus-om-d-e-m10-kit</path>
      <seo_title></seo_title>
      <seo_description></seo_description>
      <seo_keywords></seo_keywords>
      <indexing>1</indexing>
      <image_small_height>194</image_small_height>
      <image_small_width>270</image_small_width>
      <image_large_height>503</image_large_height>
      <image_large_width>701</image_large_width>
      <yandex_market>1</yandex_market>
      <yandex_market_bid>0</yandex_market_bid>
      <yandex_market_cid>0</yandex_market_cid>
      <manufacturer_warranty>0</manufacturer_warranty>
      <country_of_origin></country_of_origin>
      <yandex_market_sales_notes></yandex_market_sales_notes>
      <user_id>19</user_id>
      <siteuser_id>0</siteuser_id>
      <modification_id>0</modification_id>
      <guid>36C3A45B-579B-BCF3-631B-CABF40C52D74</guid>
      <showed>0</showed>
      <length>0</length>
      <width>0</width>
      <height>0</height>
      <deleted>0</deleted>
      <url>/shop/tsifrovye-fotoapparaty/olympus-om-d-e-m10-kit/</url>
      <date>11.07.2018</date>
      <datetime>11.07.2018 23:48:19</datetime>
      <start_datetime>0000-00-00 00:00:00</start_datetime>
      <end_datetime>0000-00-00 00:00:00</end_datetime>
      <dir>/upload/shop_21/3/3/8/item_338/</dir>
      <rest>999</rest>
      <reserved>0</reserved>
      <price>33291.00</price>
      <discount>3699.00</discount>
      <tax>0.00</tax>
      <price_tax>33291.00</price_tax>
      <currency>руб.</currency>
      <rate likes="0" dislikes="0">0</rate>
      <shop_discount id="26">
         <shop_id>21</shop_id>
         <name>Скидка</name>
         <description></description>
         <start_datetime>2008-04-21 14:50:00</start_datetime>
         <end_datetime>2025-09-29 14:50:04</end_datetime>
         <active>1</active>
         <value>10.00</value>
         <type>0</type>
         <user_id>19</user_id>
         <percent>10.00</percent>
      </shop_discount>
      <shop_producer id="283">
         <shop_producer_dir_id>0</shop_producer_dir_id>
         <shop_id>21</shop_id>
         <name>Olympus</name>
         <active>1</active>
         <default>0</default>
         <description></description>
         <image_large></image_large>
         <image_small></image_small>
         <sorting>90</sorting>
         <path>olympus</path>
         <user_id>19</user_id>
         <address></address>
         <phone></phone>
         <fax></fax>
         <site></site>
         <email></email>
         <tin></tin>
         <kpp></kpp>
         <psrn></psrn>
         <okpo></okpo>
         <okved></okved>
         <bik></bik>
         <current_account></current_account>
         <correspondent_account></correspondent_account>
         <bank_name></bank_name>
         <bank_address></bank_address>
         <seo_title></seo_title>
         <seo_description></seo_description>
         <seo_keywords></seo_keywords>
         <dir>/upload/shop_21/producers/</dir>
      </shop_producer>
   </shop_item>
   <shop_item id="348">
      <shortcut_id>0</shortcut_id>
      <shop_tax_id>0</shop_tax_id>
      <shop_seller_id>0</shop_seller_id>
      <shop_group_id>1451</shop_group_id>
      <shop_currency_id>4</shop_currency_id>
      <shop_id>21</shop_id>
      <shop_producer_id>277</shop_producer_id>
      <shop_measure_id>0</shop_measure_id>
      <type>0</type>
      <name>LG GA-B379 SEQA</name>
      <marking></marking>
      <vendorcode></vendorcode>
      <description></description>
      <text></text>
      <image_large>shop_items_catalog_image348.png</image_large>
      <image_small>small_shop_items_catalog_image348.png</image_small>
      <weight>0</weight>
      <active>1</active>
      <siteuser_group_id>-1</siteuser_group_id>
      <sorting>0</sorting>
      <path>lg-ga-b379-seqa</path>
      <seo_title></seo_title>
      <seo_description></seo_description>
      <seo_keywords></seo_keywords>
      <indexing>1</indexing>
      <image_small_height>270</image_small_height>
      <image_small_width>137</image_small_width>
      <image_large_height>365</image_large_height>
      <image_large_width>184</image_large_width>
      <yandex_market>1</yandex_market>
      <yandex_market_bid>0</yandex_market_bid>
      <yandex_market_cid>0</yandex_market_cid>
      <manufacturer_warranty>0</manufacturer_warranty>
      <country_of_origin></country_of_origin>
      <yandex_market_sales_notes></yandex_market_sales_notes>
      <user_id>19</user_id>
      <siteuser_id>0</siteuser_id>
      <modification_id>0</modification_id>
      <guid>901E83F9-9DA1-137A-9C79-5BE2269A81F0</guid>
      <showed>0</showed>
      <length>0</length>
      <width>0</width>
      <height>0</height>
      <deleted>0</deleted>
      <url>/shop/kholodilniki/lg-ga-b379-seqa/</url>
      <date>11.07.2018</date>
      <datetime>11.07.2018 23:48:19</datetime>
      <start_datetime>0000-00-00 00:00:00</start_datetime>
      <end_datetime>0000-00-00 00:00:00</end_datetime>
      <dir>/upload/shop_21/3/4/8/item_348/</dir>
      <rest>999</rest>
      <reserved>0</reserved>
      <price>25485.30</price>
      <discount>2831.70</discount>
      <tax>0.00</tax>
      <price_tax>25485.30</price_tax>
      <currency>руб.</currency>
      <rate likes="0" dislikes="0">0</rate>
      <shop_discount id="26">
         <shop_id>21</shop_id>
         <name>Скидка</name>
         <description></description>
         <start_datetime>2008-04-21 14:50:00</start_datetime>
         <end_datetime>2025-09-29 14:50:04</end_datetime>
         <active>1</active>
         <value>10.00</value>
         <type>0</type>
         <user_id>19</user_id>
         <percent>10.00</percent>
      </shop_discount>
      <shop_producer id="277">
         <shop_producer_dir_id>0</shop_producer_dir_id>
         <shop_id>21</shop_id>
         <name>LG</name>
         <active>1</active>
         <default>0</default>
         <description></description>
         <image_large></image_large>
         <image_small></image_small>
         <sorting>50</sorting>
         <path>lg</path>
         <user_id>19</user_id>
         <address></address>
         <phone></phone>
         <fax></fax>
         <site></site>
         <email></email>
         <tin></tin>
         <kpp></kpp>
         <psrn></psrn>
         <okpo></okpo>
         <okved></okved>
         <bik></bik>
         <current_account></current_account>
         <correspondent_account></correspondent_account>
         <bank_name></bank_name>
         <bank_address></bank_address>
         <seo_title></seo_title>
         <seo_description></seo_description>
         <seo_keywords></seo_keywords>
         <dir>/upload/shop_21/producers/</dir>
      </shop_producer>
   </shop_item>
   <shop_item id="346">
      <shortcut_id>0</shortcut_id>
      <shop_tax_id>0</shop_tax_id>
      <shop_seller_id>0</shop_seller_id>
      <shop_group_id>1454</shop_group_id>
      <shop_currency_id>4</shop_currency_id>
      <shop_id>21</shop_id>
      <shop_producer_id>274</shop_producer_id>
      <shop_measure_id>0</shop_measure_id>
      <type>0</type>
      <name>Sony NWZ-A17</name>
      <marking></marking>
      <vendorcode></vendorcode>
      <description></description>
      <text></text>
      <image_large>shop_items_catalog_image346.png</image_large>
      <image_small>small_shop_items_catalog_image346.png</image_small>
      <weight>0</weight>
      <active>1</active>
      <siteuser_group_id>-1</siteuser_group_id>
      <sorting>0</sorting>
      <path>sony-nwz-a17</path>
      <seo_title></seo_title>
      <seo_description></seo_description>
      <seo_keywords></seo_keywords>
      <indexing>1</indexing>
      <image_small_height>270</image_small_height>
      <image_small_width>122</image_small_width>
      <image_large_height>452</image_large_height>
      <image_large_width>204</image_large_width>
      <yandex_market>1</yandex_market>
      <yandex_market_bid>0</yandex_market_bid>
      <yandex_market_cid>0</yandex_market_cid>
      <manufacturer_warranty>0</manufacturer_warranty>
      <country_of_origin></country_of_origin>
      <yandex_market_sales_notes></yandex_market_sales_notes>
      <user_id>19</user_id>
      <siteuser_id>0</siteuser_id>
      <modification_id>0</modification_id>
      <guid>69B0E0DF-EF7E-89D6-F65C-F43BB00122F4</guid>
      <showed>1</showed>
      <length>0</length>
      <width>0</width>
      <height>0</height>
      <deleted>0</deleted>
      <url>/shop/tsifrovye-pleery/sony-nwz-a17/</url>
      <date>11.07.2018</date>
      <datetime>11.07.2018 23:48:19</datetime>
      <start_datetime>0000-00-00 00:00:00</start_datetime>
      <end_datetime>0000-00-00 00:00:00</end_datetime>
      <dir>/upload/shop_21/3/4/6/item_346/</dir>
      <rest>999</rest>
      <reserved>0</reserved>
      <price>11241.00</price>
      <discount>1249.00</discount>
      <tax>0.00</tax>
      <price_tax>11241.00</price_tax>
      <currency>руб.</currency>
      <rate likes="0" dislikes="0">0</rate>
      <shop_discount id="26">
         <shop_id>21</shop_id>
         <name>Скидка</name>
         <description></description>
         <start_datetime>2008-04-21 14:50:00</start_datetime>
         <end_datetime>2025-09-29 14:50:04</end_datetime>
         <active>1</active>
         <value>10.00</value>
         <type>0</type>
         <user_id>19</user_id>
         <percent>10.00</percent>
      </shop_discount>
      <shop_producer id="274">
         <shop_producer_dir_id>0</shop_producer_dir_id>
         <shop_id>21</shop_id>
         <name>Sony</name>
         <active>1</active>
         <default>0</default>
         <description></description>
         <image_large></image_large>
         <image_small></image_small>
         <sorting>20</sorting>
         <path>sony</path>
         <user_id>19</user_id>
         <address></address>
         <phone></phone>
         <fax></fax>
         <site></site>
         <email></email>
         <tin></tin>
         <kpp></kpp>
         <psrn></psrn>
         <okpo></okpo>
         <okved></okved>
         <bik></bik>
         <current_account></current_account>
         <correspondent_account></correspondent_account>
         <bank_name></bank_name>
         <bank_address></bank_address>
         <seo_title></seo_title>
         <seo_description></seo_description>
         <seo_keywords></seo_keywords>
         <dir>/upload/shop_21/producers/</dir>
      </shop_producer>
   </shop_item>
   <shop_currency id="4">
      <name>руб.</name>
      <code>RUR</code>
      <exchange_rate>1.000000</exchange_rate>
      <date>0000-00-00</date>
      <default>1</default>
      <sorting>10</sorting>
      <user_id>19</user_id>
   </shop_currency>
   <size_measure>
      <name>мм</name>
   </size_measure>
   <shop_warehouse id="18">
      <shop_id>21</shop_id>
      <name>Основной</name>
      <sorting>0</sorting>
      <active>1</active>
      <default>1</default>
      <shop_country_id>0</shop_country_id>
      <shop_country_location_id>0</shop_country_location_id>
      <shop_country_location_city_id>0</shop_country_location_city_id>
      <shop_country_location_city_area_id>0</shop_country_location_city_area_id>
      <address></address>
      <user_id>19</user_id>
      <guid>72CE36D0-47D2-3911-FE19-45C35FB41420</guid>
   </shop_warehouse>
</shop>

   $Shop_Controller_Show
      ->shopItems()
      ->queryBuilder()
      ->join('shop_item_discounts', 'shop_item_discounts.shop_item_id', '=', 'shop_items.id')
      ->join('shop_discounts', 'shop_discounts.id', '=', 'shop_item_discounts.shop_discount_id')
      ->where('shop_discounts.active', '=', 1)
      ->where('shop_discounts.start_datetime', '<', Core_Date::timestamp2sql(time()))
      ->where('shop_discounts.end_datetime', '>', Core_Date::timestamp2sql(time()))
      ->where('shop_discounts.deleted', '=', 0)
      ->where('shop_items.modification_id', '=', 0)
      ->groupBy('shop_items.id')
      ->clearOrderBy()
      ->orderBy('RAND()');