Лекарства онлайн в Санкт-Петербурге, доставка медикаментов и препаратов на дом, поиск лекарств в интернете в Санкт-Петербурге
Санкт-Петербург
  • Москва
  • Санкт-Петербург
  • Тверь
Вы в городе Санкт-Петербург?
Да, верно
Корзина
пуста

Лекарства
[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: Unknown column 'a5_site_entity_element_offer_property.PROPERTY_344' in 'on clause' (400)
SELECT 
	`a5_site_entity_element_offer`.`ID` AS `ID`,
	`a5_site_entity_element_offer`.`NAME` AS `NAME`,
	`a5_site_entity_element_offer`.`XML_ID` AS `XML_ID`,
	`a5_site_entity_element_offer`.`IBLOCK_ID` AS `IBLOCK_ID`,
	`a5_site_entity_element_offer`.`PREVIEW_TEXT` AS `PREVIEW_TEXT`,
	`a5_site_entity_element_offer_city_property`.`PRICE` AS `PRICE`,
	`a5_site_entity_element_offer_city_property`.`OLD_PRICE` AS `OLD_PRICE`,
	`a5_site_entity_element_offer_city_property`.`URL` AS `URL`,
	`a5_site_entity_element_offer_city_property`.`CAN_BUY` AS `CAN_BUY`,
	`a5_site_entity_element_offer_city_property`.`IS_ACTIVE` AS `IS_ACTIVE`,
	`a5_site_entity_element_offer_city_property`.`DISCOUNT_PRICE` AS `DISCOUNT_PRICE`,
	`a5_site_entity_element_offer_city_property`.`DISCOUNT_QUANTITY` AS `DISCOUNT_QUANTITY`,
	`a5_site_entity_element_offer_city_property`.`DISCOUNT_PERCENT` AS `DISCOUNT_PERCENT`,
	`a5_site_entity_element_offer_city_property`.`IS_GIFT` AS `IS_GIFT`,
	`a5_site_entity_element_offer_city_property`.`IS_BEST_PRICE` AS `IS_BEST_PRICE`,
	`a5_site_entity_element_offer_property`.`PROPERTY_275` AS `IS_EXPIRED`,
	CONCAT('<a href="', CONCAT("/spb/goods/manufacturer/", `a5_site_entity_element_offer_manufacturer`.`CODE`, "/") , '">', CONCAT(`a5_site_entity_element_offer_manufacturer`.`NAME`, ", ", `a5_site_entity_element_offer_manufacturer`.`COUNTRY`), '</a>') AS `MANUFACTURER_DISPLAY_VALUE`,
	CONCAT(`a5_site_entity_element_offer_manufacturer`.`NAME`, ", ", `a5_site_entity_element_offer_manufacturer`.`COUNTRY`) AS `MANUFACTURER_NAME`,
	`a5_site_entity_element_offer_property`.`PROPERTY_265` AS `COUNTRY`,
	`a5_site_entity_element_offer_property`.`PROPERTY_282` AS `MEDADS_IDS`,
	`a5_site_entity_element_offer_property`.`PROPERTY_269` AS `STATUS_ID`,
	`a5_site_entity_element_offer_property`.`PROPERTY_270` AS `RATING`,
	`a5_site_entity_element_offer_property`.`PROPERTY_271` AS `REVIEWS_COUNT`,
	`a5_site_entity_element_offer_property`.`PROPERTY_272` AS `STARS_COUNT`,
	`a5_site_entity_element_offer_property`.`PROPERTY_273` AS `SHORT_NAME`,
	`a5_site_entity_element_offer_property`.`PROPERTY_274` AS `FORM_NAME`,
	`a5_site_entity_element_offer_city_property`.`EXPIRATION_DATE` AS `EXPIRATION_DATE`,
	`a5_site_entity_element_offer_city_property`.`DELIVERY_DATE` AS `DELIVERY_DATE`,
	`a5_site_entity_element_offer_property`.`PROPERTY_261` AS `PRODUCT_ID`,
	`a5_site_entity_element_offer_property`.`PROPERTY_277` AS `KEEP_IN_COLD`,
	`a5_site_entity_element_offer_property`.`PROPERTY_284` AS `COURSE_QUANTITY`,
	`a5_site_entity_element_offer_property`.`PROPERTY_332` AS `TYPE`
FROM `b_iblock_element` `a5_site_entity_element_offer` 
LEFT JOIN `a5_city_offer_property` `a5_site_entity_element_offer_city_property` ON `a5_site_entity_element_offer`.`ID` = `a5_site_entity_element_offer_city_property`.`OFFER_ID`
LEFT JOIN `b_iblock_element_prop_s34` `a5_site_entity_element_offer_property` ON `a5_site_entity_element_offer`.`ID` = `a5_site_entity_element_offer_property`.`IBLOCK_ELEMENT_ID`
LEFT JOIN `a5_manufacturer` `a5_site_entity_element_offer_manufacturer` ON `a5_site_entity_element_offer_property`.`PROPERTY_344` = `a5_site_entity_element_offer_manufacturer`.`XML_ID`
WHERE `a5_site_entity_element_offer_city_property`.`STORE_ID` = 7
AND `a5_site_entity_element_offer`.`XML_ID` = '250366'
AND `a5_site_entity_element_offer`.`ACTIVE` = 'Y'
AND `a5_site_entity_element_offer`.`IBLOCK_ID` = 34
ORDER BY `a5_site_entity_element_offer_property`.`PROPERTY_275` ASC
/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/lib/db/mysqlconnection.php:104
#0: Bitrix\Main\DB\MysqlConnection->queryInternal(string, array, NULL)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/lib/db/connection.php:332
#1: Bitrix\Main\DB\Connection->query(string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/lib/entity/query.php:1735
#2: Bitrix\Main\Entity\Query->query(string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/lib/entity/query.php:450
#3: Bitrix\Main\Entity\Query->exec()
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/lib/entity/datamanager.php:230
#4: Bitrix\Main\Entity\DataManager::getList(array)
	/home/bitrix/ext_www/eapteka.ru/local/modules/a5.site/lib/Entity/Element/ElementTable.php:214
#5: A5\Site\Entity\Element\ElementTable::getList(array)
	/home/bitrix/ext_www/eapteka.ru/local/modules/a5.site/lib/Entity/Element/OfferTable.php:87
#6: A5\Site\Entity\Element\OfferTable::getList(array)
	/home/bitrix/ext_www/eapteka.ru/local/components/a5/catalog.offer/class.php:68
#7: A5\Component\Catalog\Offer->executeComponent()
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component.php:506
#8: CBitrixComponent->includeComponent(string, array, object)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/main.php:1011
#9: CAllMain->IncludeComponent(string, string, array, object)
	/home/bitrix/ext_www/eapteka.ru/local/templates/adaptive/components/a5/catalog/.default/offer.php:81
#10: include(string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component_template.php:505
#11: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component_template.php:588
#12: CBitrixComponentTemplate->IncludeTemplate(array)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component.php:593
#13: CBitrixComponent->showComponentTemplate()
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component.php:542
#14: CBitrixComponent->includeComponentTemplate(string)
	/home/bitrix/ext_www/eapteka.ru/local/components/a5/catalog/class.php:24
#15: A5\Component\Catalog->executeComponent()
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/component.php:506
#16: CBitrixComponent->includeComponent(string, array, boolean)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/classes/general/main.php:1011
#17: CAllMain->IncludeComponent(string, string, array, boolean)
	/home/bitrix/ext_www/eapteka.ru/local/ajax/catalog/goods.php:215
#18: include(string)
	/home/bitrix/ext_www/eapteka.ru/local/modules/a5.ajax/lib/Handler/Provider.php:23
#19: A5\Ajax\Handler\Provider->includeHandler(string)
	/home/bitrix/ext_www/eapteka.ru/include/catalog/goods.php:22
#20: include(string)
	/home/bitrix/ext_www/eapteka.ru/spb/goods/index.php:11
#21: include_once(string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/modules/main/include/urlrewrite.php:159
#22: include_once(string)
	/home/bitrix/ext_www/eapteka.ru/bitrix/urlrewrite.php:2