Выброшено исключение: 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