Купить недвижимость
[PommProject\Foundation\Exception\SqlException] 

SQL error state '42712' [ERROR]
====
ERROR:  table name "elite" specified more than once

====
«PREPARE ===

        select
            count(DISTINCT(o.id)) as id
        from
            public.realty_objects o
            JOIN public.realty_types_cat c ON (c.id=o.cat_id)
             JOIN realty_fields_values elite ON (o.id=elite.element_id AND elite.field_id=1184)  
  JOIN realty_fields_values elite ON (o.id=elite.element_id AND elite.field_id=1184) 
            LEFT JOIN public.geo_cities city ON (city.id=o.city_id)
            LEFT JOIN public.geo_regions region ON (region.id=city.region_id)
            LEFT JOIN public.realty_object_types ot ON (ot.id=o.object_type)
            LEFT JOIN public.geo_streets s ON (s.id=o.street)
 WHERE  o.active=1  AND  ( o.is_sold <> true OR (o.is_sold=true AND o.modified > '2019-06-15 00:00:00'))  AND  c.deal LIKE $1  AND  ( ot.type LIKE $2) AND  elite.value = $3 
 ===». (0)
/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/Session/Connection.php:327
#0: PommProject\Foundation\Session\Connection->getQueryResult(string)
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/Session/Connection.php:450
#1: PommProject\Foundation\Session\Connection->sendPrepareQuery(string, string)
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/PreparedQuery/PreparedQuery.php:173
#2: PommProject\Foundation\PreparedQuery\PreparedQuery->prepare()
	/home/bitrix/www/vendor/pomm-project/foundation/sources/lib/PreparedQuery/PreparedQuery.php:124
#3: PommProject\Foundation\PreparedQuery\PreparedQuery->execute(array)
	/home/bitrix/www/vendor/pomm-project/model-manager/sources/lib/Model/Model.php:165
#4: PommProject\ModelManager\Model\Model->query(string, array)
	/home/bitrix/www/local/lib/Intrumnet/Entity/Objects.php:967
#5: Redramka\Intrumnet\Entity\Objects->getCount(boolean)
	/home/bitrix/www/local/lib/Intrumnet/Entity/Objects.php:1149
#6: Redramka\Intrumnet\Entity\Objects->get(integer, integer, NULL)
	/home/bitrix/www/local/components/redramka/realty.section/class.php:584
#7: CRedramkaRealtySection->getItemsList(array, integer, integer, integer)
	/home/bitrix/www/local/components/redramka/realty.section/class.php:723
#8: CRedramkaRealtySection->executeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:638
#9: CBitrixComponent->includeComponent(string, array, object)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1043
#10: CAllMain->IncludeComponent(string, string, array, object)
	/home/bitrix/www/local/templates/alatartsev/components/redramka/catalog/.default/section.php:87
#11: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:720
#12: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:815
#13: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:735
#14: CBitrixComponent->showComponentTemplate()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:683
#15: CBitrixComponent->includeComponentTemplate(string)
	/home/bitrix/www/local/components/redramka/catalog/component.php:153
#16: include(string)
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:594
#17: CBitrixComponent->__includeComponent()
	/home/bitrix/www/bitrix/modules/main/classes/general/component.php:653
#18: CBitrixComponent->includeComponent(string, array, NULL)
	/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1043
#19: CAllMain->IncludeComponent(string, string, array)
	/home/bitrix/www/catalog/index.php:7
#20: include_once(string)
	/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#21: include_once(string)
	/home/bitrix/www/bitrix/urlrewrite.php:2