Выброшено исключение: Not unique table/alias: 'cr'
JDatabaseExceptionExecuting Object
(
    [query:JDatabaseExceptionExecuting:private] => SELECT prod.product_id, 
        pr_cat.category_id, 
        prod.`name_ru-RU` as name, 
        prod.`short_description_ru-RU` as short_description, 
        prod.product_ean, 
        prod.manufacturer_code, 
        prod.image, 
        prod.product_price, 
        prod.currency_id, 
        prod.product_tax_id as tax_id, 
        prod.product_old_price, 
        prod.product_weight, 
        prod.average_rating, 
        prod.reviews_count, 
        prod.hits, 
        prod.weight_volume_units, 
        prod.basic_price_unit_id, 
        prod.label_id, 
        prod.product_manufacturer_id, 
        prod.min_price, 
        prod.product_quantity, 
        prod.different_prices, prod.delivery_times_id, prod.`extra_field_4` , prod.`extra_field_203` , prod.`extra_field_5` , prod.`extra_field_6` , prod.`extra_field_7` , prod.`extra_field_214` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_10` , prod.`extra_field_11` , prod.`extra_field_101` , prod.`extra_field_17` , prod.`extra_field_18` , prod.`extra_field_19` , prod.`extra_field_20` , prod.`extra_field_21` , prod.`extra_field_22` , prod.`extra_field_48` , prod.`extra_field_23` , prod.`extra_field_24` , prod.`extra_field_25` , prod.`extra_field_26` , prod.`extra_field_27` , prod.`extra_field_28` , prod.`extra_field_36` , prod.`extra_field_58` , prod.`extra_field_59` , prod.`extra_field_60` , prod.`extra_field_62` , prod.`extra_field_63` , prod.`extra_field_64` , prod.`extra_field_65` , prod.`extra_field_66` , prod.`extra_field_67` , prod.`extra_field_68` , prod.`extra_field_70` , prod.`extra_field_71` , prod.`extra_field_72` , prod.`extra_field_74` , prod.`extra_field_75` , prod.`extra_field_76` , prod.`extra_field_77` , prod.`extra_field_78` , prod.`extra_field_79` , prod.`extra_field_80` , prod.`extra_field_81` , prod.`extra_field_82` , prod.`extra_field_83` , prod.`extra_field_84` , prod.`extra_field_86` , prod.`extra_field_85` , prod.`extra_field_87` , prod.`extra_field_89` , prod.`extra_field_90` , prod.`extra_field_92` , prod.`extra_field_93` , prod.`extra_field_94` , prod.`extra_field_95` , prod.`extra_field_97` , prod.`extra_field_98` , prod.`extra_field_99` , prod.`extra_field_100` , prod.`extra_field_102` , prod.`extra_field_103` , prod.`extra_field_104` , prod.`extra_field_106` , prod.`extra_field_107` , prod.`extra_field_108` , prod.`extra_field_109` , prod.`extra_field_112` , prod.`extra_field_113` , prod.`extra_field_114` , prod.`extra_field_115` , prod.`extra_field_116` , prod.`extra_field_117` , prod.`extra_field_118` , prod.`extra_field_119` , prod.`extra_field_120` , prod.`extra_field_121` , prod.`extra_field_128` , prod.`extra_field_132` , prod.`extra_field_133` , prod.`extra_field_137` , prod.`extra_field_139` , prod.`extra_field_140` , prod.`extra_field_141` , prod.`extra_field_142` , prod.`extra_field_143` , prod.`extra_field_144` , prod.`extra_field_145` , prod.`extra_field_146` , prod.`extra_field_147` , prod.`extra_field_148` , prod.`extra_field_149` , prod.`extra_field_150` , prod.`extra_field_151` , prod.`extra_field_153` , prod.`extra_field_154` , prod.`extra_field_155` , prod.`extra_field_157` , prod.`extra_field_159` , prod.`extra_field_166` , prod.`extra_field_167` , prod.`extra_field_168` , prod.`extra_field_172` , prod.`extra_field_173` , prod.`extra_field_174` , prod.`extra_field_176` , prod.`extra_field_177` , prod.`extra_field_193` , prod.`extra_field_191` , prod.`extra_field_192` , prod.`extra_field_195` , prod.`extra_field_196` , prod.`extra_field_197` , prod.`extra_field_198` , prod.`extra_field_199` , prod.`extra_field_200` , prod.`extra_field_201` , prod.`extra_field_204` , prod.`extra_field_205` , prod.`extra_field_206` , prod.`extra_field_202` , prod.`extra_field_216` , prod.product_bonus_add, prod.product_bonus_sub, IF(prod.product_quantity>0,1,0) as qflag, IF(prod.product_manufacturer_id=1318,1,0) as mflag FROM `j25_jshopping_products` AS prod
                  LEFT JOIN `j25_jshopping_products_to_categories` AS pr_cat USING (product_id)
                  LEFT JOIN `j25_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id
                   LEFT JOIN `j25_jshopping_currencies` AS cr USING (currency_id)  LEFT JOIN `j25_jshopping_currencies` AS cr USING (currency_id) 
                  WHERE prod.product_publish=1 AND cat.category_publish=1  AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (835,1347,834,833,832,831,902,1440,1465) AND prod.product_manufacturer_id in (337,1006) AND ( prod.product_price*1 / cr.currency_value ) >= 100 AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (835,1347,834,833,832,831,902,1440,1465) AND prod.product_manufacturer_id in (337,1006) AND ( prod.product_price*1 / cr.currency_value ) >= 100
                  GROUP BY prod.product_id ORDER BY qflag DESC, mflag DESC,  qflag DESC,  prod.product_price/cr.currency_value  ASC LIMIT 0, 40
    [message:protected] => Not unique table/alias: 'cr'
    [string:Exception:private] => 
    [code:protected] => 1066
    [file:protected] => /var/www/prospec/data/www/pro-spec.ru/libraries/joomla/database/driver/mysqli.php
    [line:protected] => 665
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/joomla/database/driver.php
                    [line] => 1701
                    [function] => execute
                    [class] => JDatabaseDriverMysqli
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [1] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/tables/product.php
                    [line] => 1111
                    [function] => loadObjectList
                    [class] => JDatabaseDriver
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [2] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/tables/product.php
                    [line] => 1139
                    [function] => getAllProducts
                    [class] => jshopProduct
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [categorys] => Array
                                        (
                                            [0] => 835
                                            [1] => 1347
                                            [2] => 834
                                            [3] => 833
                                            [4] => 832
                                            [5] => 831
                                            [6] => 902
                                            [7] => 1440
                                            [8] => 1465
                                        )

                                    [manufacturers] => Array
                                        (
                                            [0] => 337
                                            [1] => 1006
                                        )

                                    [price_from] => 100
                                    [price_to] => 0
                                    [labels] => Array
                                        (
                                        )

                                    [vendors] => Array
                                        (
                                        )

                                    [extra_fields] => Array
                                        (
                                        )

                                    [extra_fields_t] => Array
                                        (
                                        )

                                )

                            [1] => prod.hits
                            [2] => DESC
                            [3] => 
                            [4] => 40
                        )

                )

            [3] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/models/productlist.php
                    [line] => 213
                    [function] => getProducts
                    [class] => jshopProduct
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [categorys] => Array
                                        (
                                            [0] => 835
                                            [1] => 1347
                                            [2] => 834
                                            [3] => 833
                                            [4] => 832
                                            [5] => 831
                                            [6] => 902
                                            [7] => 1440
                                            [8] => 1465
                                        )

                                    [manufacturers] => Array
                                        (
                                            [0] => 337
                                            [1] => 1006
                                        )

                                    [price_from] => 100
                                    [price_to] => 0
                                    [labels] => Array
                                        (
                                        )

                                    [vendors] => Array
                                        (
                                        )

                                    [extra_fields] => Array
                                        (
                                        )

                                    [extra_fields_t] => Array
                                        (
                                        )

                                )

                            [1] => prod.hits
                            [2] => DESC
                            [3] => 
                            [4] => 40
                        )

                )

            [4] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/controllers/products.php
                    [line] => 35
                    [function] => load
                    [class] => jshopProductList
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [5] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/MVC/Controller/BaseController.php
                    [line] => 733
                    [function] => display
                    [class] => JshoppingControllerProducts
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [6] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/jshopping.php
                    [line] => 25
                    [function] => execute
                    [class] => Joomla\CMS\MVC\Controller\BaseController
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/Component/ComponentHelper.php
                    [line] => 402
                    [args] => Array
                        (
                            [0] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/jshopping.php
                        )

                    [function] => require_once
                )

            [8] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/Component/ComponentHelper.php
                    [line] => 377
                    [function] => executeComponent
                    [class] => Joomla\CMS\Component\ComponentHelper
                    [type] => ::
                    [args] => Array
                        (
                            [0] => /var/www/prospec/data/www/pro-spec.ru/components/com_jshopping/jshopping.php
                        )

                )

            [9] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/Application/SiteApplication.php
                    [line] => 194
                    [function] => renderComponent
                    [class] => Joomla\CMS\Component\ComponentHelper
                    [type] => ::
                    [args] => Array
                        (
                            [0] => com_jshopping
                        )

                )

            [10] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/Application/SiteApplication.php
                    [line] => 233
                    [function] => dispatch
                    [class] => Joomla\CMS\Application\SiteApplication
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [11] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/libraries/src/Application/CMSApplication.php
                    [line] => 196
                    [function] => doExecute
                    [class] => Joomla\CMS\Application\SiteApplication
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [12] => Array
                (
                    [file] => /var/www/prospec/data/www/pro-spec.ru/index.php
                    [line] => 67
                    [function] => execute
                    [class] => Joomla\CMS\Application\CMSApplication
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
)
/var/www/prospec/data/www/pro-spec.ru/index.php 74/var/www/prospec/data/www/pro-spec.ru/index.php 75