Как найти товары у которых не заполнено допсвойство?
nikolajgromkov
22 апреля 2018 г.
Здравствуйте!
Пытаюсь найти товары, у которых не заполнено одно из дополнительных свойств:
Думал что всё очень просто - найду все товары с пустыми свойствами в property_value_strings
$oInvents = Core_Entity::factory('Shop_item');
$oInvents
->queryBuilder()
->select('shop_items.*')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', '=', '');
$aInvents=$oInvents->findAll();
Однако там пустых значений просто нет.
На ум приходит только получить все уникальные id из property_value_strings и потом сделать выборку товаров за исключением найденных idшников. Однако даже если я это сделаю то находить и вычитать 180000 товаров очень проблематично - хостинг просто не даёт столько памяти.
Копал в сторону ->having('COUNT(property_value_strings.value)', '=', 0), но это не помогло.
Как сделать лучшим образом? Как найти товары с незаполненным опредленным допсвойством?
Пытаюсь найти товары, у которых не заполнено одно из дополнительных свойств:
Думал что всё очень просто - найду все товары с пустыми свойствами в property_value_strings
$oInvents = Core_Entity::factory('Shop_item');
$oInvents
->queryBuilder()
->select('shop_items.*')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', '=', '');
$aInvents=$oInvents->findAll();
Однако там пустых значений просто нет.
На ум приходит только получить все уникальные id из property_value_strings и потом сделать выборку товаров за исключением найденных idшников. Однако даже если я это сделаю то находить и вычитать 180000 товаров очень проблематично - хостинг просто не даёт столько памяти.
Копал в сторону ->having('COUNT(property_value_strings.value)', '=', 0), но это не помогло.
Как сделать лучшим образом? Как найти товары с незаполненным опредленным допсвойством?
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
nikolajgromkov
24 апреля 2018 г.
Ап. Никто не знает
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
hostcms
Модератор
24 апреля 2018 г.
nikolajgromkov,
если вы ищите незаполненное свойство, почему проверяете на пустоту значения?
данная проверка подразумевает наличие значения свойства и его пустое значение, а не отсутствие значение.
Нужно
если вы ищите незаполненное свойство, почему проверяете на пустоту значения?
->where('property_value_strings.value', '=', '')
данная проверка подразумевает наличие значения свойства и его пустое значение, а не отсутствие значение.
Нужно
->where('property_value_strings.value', 'IS', NULL);
nikolajgromkov
24 апреля 2018 г.
Мне кажется я вполне чётко объяснил причину такой ошибки:
Цитата:
Спасибо больше за помощь. Про 'IS', NULL можно где-то почитать на сайте, чтобы не задавать больше подобных вопросов?
Цитата:
Думал что всё очень просто - найду все товары с пустыми свойствами в property_value_strings
Однако там пустых значений просто нет.
Однако там пустых значений просто нет.
Спасибо больше за помощь. Про 'IS', NULL можно где-то почитать на сайте, чтобы не задавать больше подобных вопросов?
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
hostcms
Модератор
24 апреля 2018 г.
nikolajgromkov,
это скорее относится к объединениям и MySQL, вот первый попавшийся пример с объяснениями:
1.https://explainextended.com/2009/09/18/not-in-vs-not-exists-vs-left-join-is-null-mysql/
2. коротко и на русскомhttp://www.mysql.ru/docs/man/JOIN.html
это скорее относится к объединениям и MySQL, вот первый попавшийся пример с объяснениями:
1.
2. коротко и на русском
nikolajgromkov
25 апреля 2018 г.
Дополнительные 3 вопроса:
1. Почему данный код возвращает не товары, а объект Shop_Item_Model Object, хотя стоит в конце findAll? Как вытащить оттуда товары? Делал другие запросы через query builder и возвращались товары.
$oInvents = Core_Entity::factory('Shop_item');
$oInvents
->queryBuilder()
->select('shop_items.*')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', 'IS', NULL);
$aInvents=$oInvents->findAll();
2. Пока жду вашего ответа попробовал вывести через Core_QueryBuilder::select(). Товары появились в массиве, однако кроме них в массиве присутствуют доставкиhttp://prntscr.com/j9yyxs и группы товаров http://prntscr.com/j9yzd6, может и еще что-то есть. Почему так получилось? Я дальше не стал лимит увеличивать.
$oCore_QueryBuilder_Select = Core_QueryBuilder::select()
->from('shop_items')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', 'IS', NULL)
->limit(20);
$aRows = $oCore_QueryBuilder_Select->execute()->asAssoc()->result();
3. Как правильно удалить найденные товары? Метод delete(), deleteAll? или использовать код по примеру ниже? Но как тогда туда left outer join поставить?
$delete = Core_QueryBuilder::delete('tableName')
->lowPriority()
->quick()
->ignore()
->where('column1', '=', '17')
->where('column2', '!=', '19')
->orderBy('field1', 'DESC')
->limit(10)
->execute();
1. Почему данный код возвращает не товары, а объект Shop_Item_Model Object, хотя стоит в конце findAll? Как вытащить оттуда товары? Делал другие запросы через query builder и возвращались товары.
$oInvents = Core_Entity::factory('Shop_item');
$oInvents
->queryBuilder()
->select('shop_items.*')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', 'IS', NULL);
$aInvents=$oInvents->findAll();
2. Пока жду вашего ответа попробовал вывести через Core_QueryBuilder::select(). Товары появились в массиве, однако кроме них в массиве присутствуют доставки
$oCore_QueryBuilder_Select = Core_QueryBuilder::select()
->from('shop_items')
->leftJoin('shop_item_properties', 'shop_items.shop_id', '=', 'shop_item_properties.shop_id')
->leftJoin('property_value_strings', 'shop_items.id', '=', 'property_value_strings.entity_id',
array(
array('AND' => array('shop_item_properties.property_id', '=', Core_QueryBuilder::expression('`property_value_strings`.`property_id`')))
)
)
->where('shop_item_properties.property_id', '=', 219)
->where('property_value_strings.value', 'IS', NULL)
->limit(20);
$aRows = $oCore_QueryBuilder_Select->execute()->asAssoc()->result();
3. Как правильно удалить найденные товары? Метод delete(), deleteAll? или использовать код по примеру ниже? Но как тогда туда left outer join поставить?
$delete = Core_QueryBuilder::delete('tableName')
->lowPriority()
->quick()
->ignore()
->where('column1', '=', '17')
->where('column2', '!=', '19')
->orderBy('field1', 'DESC')
->limit(10)
->execute();
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
hostcms
Модератор
25 апреля 2018 г.
1. nikolajgromkov писал(а):
так это и есть товары.
2. Непонятно что это за скриншоты, в представленном коде какого-либо вывода не наблюдается.
3. Для удаления объекта используете метод ->delete(), для пометки на удаление метод ->markDeleted()
удалять сложные сущности просто через базу нельзя, т.к. тогда всё связанное останется в базе, нужно использовать приведенные выше методы.
а объект Shop_Item_Model Object
так это и есть товары.
2. Непонятно что это за скриншоты, в представленном коде какого-либо вывода не наблюдается.
3. Для удаления объекта используете метод ->delete(), для пометки на удаление метод ->markDeleted()
удалять сложные сущности просто через базу нельзя, т.к. тогда всё связанное останется в базе, нужно использовать приведенные выше методы.
nikolajgromkov
26 апреля 2018 г.
1. Хм не похоже на товары. Нет никаких свойств товара. Я к тому, может я забыл добавить в конце что-то типа $oInvents->Shop_items->findAll()
Shop_Item_Model::__set_state(array(
'_modelName' => 'shop_item',
'related' => 1,
'modifications' => 1,
'discounts' => 1,
'reviews' => 1,
'key' => NULL,
'count' => NULL,
'absolute_price' => NULL,
'adminRest' => NULL,
'_hasMany' =>
array (
'shop_cart' =>
array (
),
'comment' =>
array (
'through' => 'comment_shop_item',
),
'shop_bonus' =>
array (
'through' => 'shop_item_bonus',
),
'shop_discount' =>
array (
'through' => 'shop_item_discount',
),
'shop_item_bonus' =>
array (
),
'shop_item_discount' =>
array (
),
'shop_item_digital' =>
array (
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
),
'shop_price' =>
array (
'through' => 'shop_item_price',
),
'shop_item_price' =>
array (
),
'item_associated' =>
array (
'through' => 'shop_item_associated',
'through_table_name' => 'shop_item_associated',
'model' => 'Shop_Item',
'dependent_key' => 'shop_item_associated_id',
),
'shop_item_associated' =>
array (
),
'shop_item_associated_second' =>
array (
'model' => 'Shop_Item_Associated',
'foreign_key' => 'shop_item_associated_id',
),
'shop_item_set' =>
array (
),
'shop_item_set_second' =>
array (
'model' => 'Shop_Item_Set',
'foreign_key' => 'shop_item_set_id',
),
'shop_specialprice' =>
array (
),
'shop_item_reserved' =>
array (
),
'tag' =>
array (
'through' => 'tag_shop_item',
),
'tag_shop_item' =>
array (
),
'shop_warehouse' =>
array (
'through' => 'shop_warehouse_item',
),
'shop_warehouse_item' =>
array (
),
'vote' =>
array (
'through' => 'vote_shop_item',
),
'shop_item_delivery_option' =>
array (
),
'shop_favorite' =>
array (
),
),
'_preloadValues' =>
array (
'shortcut_id' => 0,
'siteuser_id' => 0,
'weight' => 0,
'price' => 0,
'sorting' => 0,
'image_small_height' => 0,
'image_small_width' => 0,
'image_large_height' => 0,
'image_large_width' => 0,
'yandex_market' => 1,
'yandex_market_bid' => 0,
'yandex_market_cid' => 0,
'active' => 1,
'indexing' => 1,
'modification_id' => 0,
'shop_measure_id' => 0,
'length' => 0,
'width' => 0,
'height' => 0,
'apply_purchase_discount' => 1,
'showed' => 0,
'deleted' => 0,
'user_id' => 0,
'guid' => '27E1008D-F82F-6918-FE7A-4EBFA21E704F',
'datetime' => '2018-04-26 05:41:04',
'pickup' => 1,
'delivery' => 1,
),
'_belongsTo' =>
array (
'shop_measure' =>
array (
),
'shop_tax' =>
array (
),
'siteuser_group' =>
array (
),
'shop_seller' =>
array (
),
'shop_group' =>
array (
),
'shop_currency' =>
array (
),
'shop' =>
array (
),
'shop_producer' =>
array (
),
'siteuser' =>
array (
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
),
'user' =>
array (
),
),
'_forbiddenTags' =>
array (
'price' => 'price',
'datetime' => 'datetime',
'start_datetime' => 'start_datetime',
'end_datetime' => 'end_datetime',
),
'_shortcodeTags' =>
array (
'description' => 'description',
'text' => 'text',
),
'_propertyValues' => NULL,
'_showXmlBonuses' => false,
'_showXmlComments' => false,
'_commentsActivity' => 'active',
'_showXmlAssociatedItems' => false,
'_showXmlModifications' => false,
'_showXmlSpecialprices' => false,
'_showXmlTags' => false,
'_showXmlWarehousesItems' => false,
'_showXmlSiteuser' => false,
'_showXmlVotes' => false,
'_showXmlSiteuserProperties' => false,
'_showXmlProperties' => false,
'_cartQuantity' => 1,
'_aComments' =>
array (
),
'_tagName' => 'shop_item',
'_allowedTags' =>
array (
),
'_typicalForbiddenTags' =>
array (
'price' => 'price',
'datetime' => 'datetime',
'start_datetime' => 'start_datetime',
'end_datetime' => 'end_datetime',
),
'_xmlTags' =>
array (
),
'_childrenEntities' =>
array (
),
'_marksDeleted' => 'deleted',
'_clearEntitiesAfterGetXml' => true,
'_check' => false,
'_nameColumn' => 'name',
'_changeCopiedName' => false,
'_primaryKey' => 'id',
'_modelColumns' =>
array (
'id' => NULL,
),
'_tableName' => 'shop_items',
'_tableColumns' =>
array (
),
'_skipColumns' =>
array (
),
'_changedColumns' =>
array (
),
'_relations' =>
array (
'shop_carts' =>
array (
'type' => 'many',
'model' => 'shop_cart',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'comments' =>
array (
'through' => 'comment_shop_item',
'type' => 'many',
'model' => 'comment',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'comment_shop_items',
'dependent_key' => 'comment_id',
),
'shop_bonuses' =>
array (
'through' => 'shop_item_bonus',
'type' => 'many',
'model' => 'shop_bonus',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_bonuses',
'dependent_key' => 'shop_bonus_id',
),
'shop_discounts' =>
array (
'through' => 'shop_item_discount',
'type' => 'many',
'model' => 'shop_discount',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_discounts',
'dependent_key' => 'shop_discount_id',
),
'shop_item_bonuses' =>
array (
'type' => 'many',
'model' => 'shop_item_bonus',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_discounts' =>
array (
'type' => 'many',
'model' => 'shop_item_discount',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_digitals' =>
array (
'type' => 'many',
'model' => 'shop_item_digital',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_items' =>
array (
'foreign_key' => 'shortcut_id',
'type' => 'many',
'model' => 'shop_item',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'modifications' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_prices' =>
array (
'through' => 'shop_item_price',
'type' => 'many',
'model' => 'shop_price',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_prices',
'dependent_key' => 'shop_price_id',
),
'shop_item_prices' =>
array (
'type' => 'many',
'model' => 'shop_item_price',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'item_associateds' =>
array (
'through' => 'shop_item_associated',
'through_table_name' => 'shop_item_associated',
'model' => 'Shop_Item',
'dependent_key' => 'shop_item_associated_id',
'type' => 'many',
'foreign_key' => 'shop_item_id',
),
'shop_item_associateds' =>
array (
'type' => 'many',
'model' => 'shop_item_associated',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_associated_seconds' =>
array (
'model' => 'Shop_Item_Associated',
'foreign_key' => 'shop_item_associated_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_sets' =>
array (
'type' => 'many',
'model' => 'shop_item_set',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_set_seconds' =>
array (
'model' => 'Shop_Item_Set',
'foreign_key' => 'shop_item_set_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_specialprices' =>
array (
'type' => 'many',
'model' => 'shop_specialprice',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_reserveds' =>
array (
'type' => 'many',
'model' => 'shop_item_reserved',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'tags' =>
array (
'through' => 'tag_shop_item',
'type' => 'many',
'model' => 'tag',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'tag_shop_items',
'dependent_key' => 'tag_id',
),
'tag_shop_items' =>
array (
'type' => 'many',
'model' => 'tag_shop_item',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_warehouses' =>
array (
'through' => 'shop_warehouse_item',
'type' => 'many',
'model' => 'shop_warehouse',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_warehouse_items',
'dependent_key' => 'shop_warehouse_id',
),
'shop_warehouse_items' =>
array (
'type' => 'many',
'model' => 'shop_warehouse_item',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'votes' =>
array (
'through' => 'vote_shop_item',
'type' => 'many',
'model' => 'vote',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'vote_shop_items',
'dependent_key' => 'vote_id',
),
'shop_item_delivery_options' =>
array (
'type' => 'many',
'model' => 'shop_item_delivery_option',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_favorites' =>
array (
'type' => 'many',
'model' => 'shop_favorite',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_measure' =>
array (
'type' => 'belong',
'model' => 'shop_measure',
'primary_key' => 'id',
'foreign_key' => 'shop_measure_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_tax' =>
array (
'type' => 'belong',
'model' => 'shop_tax',
'primary_key' => 'id',
'foreign_key' => 'shop_tax_id',
'through' => NULL,
'through_table_name' => NULL,
),
'siteuser_group' =>
array (
'type' => 'belong',
'model' => 'siteuser_group',
'primary_key' => 'id',
'foreign_key' => 'siteuser_group_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_seller' =>
array (
'type' => 'belong',
'model' => 'shop_seller',
'primary_key' => 'id',
'foreign_key' => 'shop_seller_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_group' =>
array (
'type' => 'belong',
'model' => 'shop_group',
'primary_key' => 'id',
'foreign_key' => 'shop_group_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_currency' =>
array (
'type' => 'belong',
'model' => 'shop_currency',
'primary_key' => 'id',
'foreign_key' => 'shop_currency_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop' =>
array (
'type' => 'belong',
'model' => 'shop',
'primary_key' => 'id',
'foreign_key' => 'shop_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_producer' =>
array (
'type' => 'belong',
'model' => 'shop_producer',
'primary_key' => 'id',
'foreign_key' => 'shop_producer_id',
'through' => NULL,
'through_table_name' => NULL,
),
'siteuser' =>
array (
'type' => 'belong',
'model' => 'siteuser',
'primary_key' => 'id',
'foreign_key' => 'siteuser_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
'type' => 'belong',
'model' => 'shop_item',
'primary_key' => 'id',
'through' => NULL,
'through_table_name' => NULL,
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
'type' => 'belong',
'primary_key' => 'id',
'through' => NULL,
'through_table_name' => NULL,
),
'user' =>
array (
'type' => 'belong',
'model' => 'user',
'primary_key' => 'id',
'foreign_key' => 'user_id',
'through' => NULL,
'through_table_name' => NULL,
),
),
'_hasOne' =>
array (
),
'_relationCache' =>
array (
),
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_queryBuilder' =>
Core_QueryBuilder_Select::__set_state(array(
'_distinct' => false,
'_highPriority' => NULL,
'_straightJoin' => NULL,
'_sqlCalcFoundRows' => NULL,
'_select' =>
array (
0 =>
array (
0 => 'COUNT(*)',
1 => 'count',
),
),
'_from' =>
array (
0 => 'shop_items',
1 => 'shop_items',
),
'_groupBy' =>
array (
),
'_having' =>
array (
),
'_union' =>
array (
),
'_unionLimit' => NULL,
'_unionOffset' => NULL,
'_queryType' => 0,
'_offsetPostgreSQLSyntax' => true,
'_where' =>
array (
0 =>
array (
'AND' =>
array (
0 => 'shop_item_properties.property_id',
1 => '=',
2 => 219,
),
),
1 =>
array (
'AND' =>
array (
0 => 'property_value_strings.value',
1 => 'IS',
2 => NULL,
),
),
2 =>
array (
'AND' =>
array (
0 => 'shop_items.deleted',
1 => '=',
2 => 0,
),
),
3 =>
array (
'AND' =>
array (
0 => 'shop_items.deleted',
1 => '=',
2 => 0,
),
),
),
'_operator' => 'AND',
'_defaultOperator' => 'AND',
'_join' =>
array (
0 =>
array (
0 => 'LEFT OUTER JOIN',
1 => 'shop_item_properties',
2 => 'shop_items.shop_id',
3 => '=',
4 => 'shop_item_properties.shop_id',
5 => NULL,
),
1 =>
array (
0 => 'LEFT OUTER JOIN',
1 => 'property_value_strings',
2 => 'shop_items.id',
3 => '=',
4 => 'property_value_strings.entity_id',
5 =>
array (
0 =>
array (
'AND' =>
array (
0 => 'shop_item_properties.property_id',
1 => '=',
2 =>
Core_QueryBuilder_Expression::__set_state(array(
'_expression' => '`property_value_strings`.`property_id`',
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_unbuffered' => false,
)),
),
),
),
),
),
'_orderBy' =>
array (
),
'_limit' => NULL,
'_offset' => NULL,
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_unbuffered' => false,
)),
'_bSetPreloadValues' => false,
'_loaded' => false,
'_saved' => false,
'_init' => true,
'_sorting' =>
array (
),
))
2. Понятно же что там был print_r или его аналог. Извинияюсь, надо было добавить. Вы имеете ввиду, что вы с учётом команды вывода не понимаете откуда там это взялось?
Shop_Item_Model::__set_state(array(
'_modelName' => 'shop_item',
'related' => 1,
'modifications' => 1,
'discounts' => 1,
'reviews' => 1,
'key' => NULL,
'count' => NULL,
'absolute_price' => NULL,
'adminRest' => NULL,
'_hasMany' =>
array (
'shop_cart' =>
array (
),
'comment' =>
array (
'through' => 'comment_shop_item',
),
'shop_bonus' =>
array (
'through' => 'shop_item_bonus',
),
'shop_discount' =>
array (
'through' => 'shop_item_discount',
),
'shop_item_bonus' =>
array (
),
'shop_item_discount' =>
array (
),
'shop_item_digital' =>
array (
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
),
'shop_price' =>
array (
'through' => 'shop_item_price',
),
'shop_item_price' =>
array (
),
'item_associated' =>
array (
'through' => 'shop_item_associated',
'through_table_name' => 'shop_item_associated',
'model' => 'Shop_Item',
'dependent_key' => 'shop_item_associated_id',
),
'shop_item_associated' =>
array (
),
'shop_item_associated_second' =>
array (
'model' => 'Shop_Item_Associated',
'foreign_key' => 'shop_item_associated_id',
),
'shop_item_set' =>
array (
),
'shop_item_set_second' =>
array (
'model' => 'Shop_Item_Set',
'foreign_key' => 'shop_item_set_id',
),
'shop_specialprice' =>
array (
),
'shop_item_reserved' =>
array (
),
'tag' =>
array (
'through' => 'tag_shop_item',
),
'tag_shop_item' =>
array (
),
'shop_warehouse' =>
array (
'through' => 'shop_warehouse_item',
),
'shop_warehouse_item' =>
array (
),
'vote' =>
array (
'through' => 'vote_shop_item',
),
'shop_item_delivery_option' =>
array (
),
'shop_favorite' =>
array (
),
),
'_preloadValues' =>
array (
'shortcut_id' => 0,
'siteuser_id' => 0,
'weight' => 0,
'price' => 0,
'sorting' => 0,
'image_small_height' => 0,
'image_small_width' => 0,
'image_large_height' => 0,
'image_large_width' => 0,
'yandex_market' => 1,
'yandex_market_bid' => 0,
'yandex_market_cid' => 0,
'active' => 1,
'indexing' => 1,
'modification_id' => 0,
'shop_measure_id' => 0,
'length' => 0,
'width' => 0,
'height' => 0,
'apply_purchase_discount' => 1,
'showed' => 0,
'deleted' => 0,
'user_id' => 0,
'guid' => '27E1008D-F82F-6918-FE7A-4EBFA21E704F',
'datetime' => '2018-04-26 05:41:04',
'pickup' => 1,
'delivery' => 1,
),
'_belongsTo' =>
array (
'shop_measure' =>
array (
),
'shop_tax' =>
array (
),
'siteuser_group' =>
array (
),
'shop_seller' =>
array (
),
'shop_group' =>
array (
),
'shop_currency' =>
array (
),
'shop' =>
array (
),
'shop_producer' =>
array (
),
'siteuser' =>
array (
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
),
'user' =>
array (
),
),
'_forbiddenTags' =>
array (
'price' => 'price',
'datetime' => 'datetime',
'start_datetime' => 'start_datetime',
'end_datetime' => 'end_datetime',
),
'_shortcodeTags' =>
array (
'description' => 'description',
'text' => 'text',
),
'_propertyValues' => NULL,
'_showXmlBonuses' => false,
'_showXmlComments' => false,
'_commentsActivity' => 'active',
'_showXmlAssociatedItems' => false,
'_showXmlModifications' => false,
'_showXmlSpecialprices' => false,
'_showXmlTags' => false,
'_showXmlWarehousesItems' => false,
'_showXmlSiteuser' => false,
'_showXmlVotes' => false,
'_showXmlSiteuserProperties' => false,
'_showXmlProperties' => false,
'_cartQuantity' => 1,
'_aComments' =>
array (
),
'_tagName' => 'shop_item',
'_allowedTags' =>
array (
),
'_typicalForbiddenTags' =>
array (
'price' => 'price',
'datetime' => 'datetime',
'start_datetime' => 'start_datetime',
'end_datetime' => 'end_datetime',
),
'_xmlTags' =>
array (
),
'_childrenEntities' =>
array (
),
'_marksDeleted' => 'deleted',
'_clearEntitiesAfterGetXml' => true,
'_check' => false,
'_nameColumn' => 'name',
'_changeCopiedName' => false,
'_primaryKey' => 'id',
'_modelColumns' =>
array (
'id' => NULL,
),
'_tableName' => 'shop_items',
'_tableColumns' =>
array (
),
'_skipColumns' =>
array (
),
'_changedColumns' =>
array (
),
'_relations' =>
array (
'shop_carts' =>
array (
'type' => 'many',
'model' => 'shop_cart',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'comments' =>
array (
'through' => 'comment_shop_item',
'type' => 'many',
'model' => 'comment',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'comment_shop_items',
'dependent_key' => 'comment_id',
),
'shop_bonuses' =>
array (
'through' => 'shop_item_bonus',
'type' => 'many',
'model' => 'shop_bonus',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_bonuses',
'dependent_key' => 'shop_bonus_id',
),
'shop_discounts' =>
array (
'through' => 'shop_item_discount',
'type' => 'many',
'model' => 'shop_discount',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_discounts',
'dependent_key' => 'shop_discount_id',
),
'shop_item_bonuses' =>
array (
'type' => 'many',
'model' => 'shop_item_bonus',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_discounts' =>
array (
'type' => 'many',
'model' => 'shop_item_discount',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_digitals' =>
array (
'type' => 'many',
'model' => 'shop_item_digital',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_items' =>
array (
'foreign_key' => 'shortcut_id',
'type' => 'many',
'model' => 'shop_item',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'modifications' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_prices' =>
array (
'through' => 'shop_item_price',
'type' => 'many',
'model' => 'shop_price',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_item_prices',
'dependent_key' => 'shop_price_id',
),
'shop_item_prices' =>
array (
'type' => 'many',
'model' => 'shop_item_price',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'item_associateds' =>
array (
'through' => 'shop_item_associated',
'through_table_name' => 'shop_item_associated',
'model' => 'Shop_Item',
'dependent_key' => 'shop_item_associated_id',
'type' => 'many',
'foreign_key' => 'shop_item_id',
),
'shop_item_associateds' =>
array (
'type' => 'many',
'model' => 'shop_item_associated',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_associated_seconds' =>
array (
'model' => 'Shop_Item_Associated',
'foreign_key' => 'shop_item_associated_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_sets' =>
array (
'type' => 'many',
'model' => 'shop_item_set',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_set_seconds' =>
array (
'model' => 'Shop_Item_Set',
'foreign_key' => 'shop_item_set_id',
'type' => 'many',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_specialprices' =>
array (
'type' => 'many',
'model' => 'shop_specialprice',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_item_reserveds' =>
array (
'type' => 'many',
'model' => 'shop_item_reserved',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'tags' =>
array (
'through' => 'tag_shop_item',
'type' => 'many',
'model' => 'tag',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'tag_shop_items',
'dependent_key' => 'tag_id',
),
'tag_shop_items' =>
array (
'type' => 'many',
'model' => 'tag_shop_item',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_warehouses' =>
array (
'through' => 'shop_warehouse_item',
'type' => 'many',
'model' => 'shop_warehouse',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'shop_warehouse_items',
'dependent_key' => 'shop_warehouse_id',
),
'shop_warehouse_items' =>
array (
'type' => 'many',
'model' => 'shop_warehouse_item',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'votes' =>
array (
'through' => 'vote_shop_item',
'type' => 'many',
'model' => 'vote',
'foreign_key' => 'shop_item_id',
'through_table_name' => 'vote_shop_items',
'dependent_key' => 'vote_id',
),
'shop_item_delivery_options' =>
array (
'type' => 'many',
'model' => 'shop_item_delivery_option',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_favorites' =>
array (
'type' => 'many',
'model' => 'shop_favorite',
'foreign_key' => 'shop_item_id',
'through' => NULL,
'through_table_name' => NULL,
'dependent_key' => NULL,
),
'shop_measure' =>
array (
'type' => 'belong',
'model' => 'shop_measure',
'primary_key' => 'id',
'foreign_key' => 'shop_measure_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_tax' =>
array (
'type' => 'belong',
'model' => 'shop_tax',
'primary_key' => 'id',
'foreign_key' => 'shop_tax_id',
'through' => NULL,
'through_table_name' => NULL,
),
'siteuser_group' =>
array (
'type' => 'belong',
'model' => 'siteuser_group',
'primary_key' => 'id',
'foreign_key' => 'siteuser_group_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_seller' =>
array (
'type' => 'belong',
'model' => 'shop_seller',
'primary_key' => 'id',
'foreign_key' => 'shop_seller_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_group' =>
array (
'type' => 'belong',
'model' => 'shop_group',
'primary_key' => 'id',
'foreign_key' => 'shop_group_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_currency' =>
array (
'type' => 'belong',
'model' => 'shop_currency',
'primary_key' => 'id',
'foreign_key' => 'shop_currency_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop' =>
array (
'type' => 'belong',
'model' => 'shop',
'primary_key' => 'id',
'foreign_key' => 'shop_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_producer' =>
array (
'type' => 'belong',
'model' => 'shop_producer',
'primary_key' => 'id',
'foreign_key' => 'shop_producer_id',
'through' => NULL,
'through_table_name' => NULL,
),
'siteuser' =>
array (
'type' => 'belong',
'model' => 'siteuser',
'primary_key' => 'id',
'foreign_key' => 'siteuser_id',
'through' => NULL,
'through_table_name' => NULL,
),
'shop_item' =>
array (
'foreign_key' => 'shortcut_id',
'type' => 'belong',
'model' => 'shop_item',
'primary_key' => 'id',
'through' => NULL,
'through_table_name' => NULL,
),
'modification' =>
array (
'model' => 'Shop_Item',
'foreign_key' => 'modification_id',
'type' => 'belong',
'primary_key' => 'id',
'through' => NULL,
'through_table_name' => NULL,
),
'user' =>
array (
'type' => 'belong',
'model' => 'user',
'primary_key' => 'id',
'foreign_key' => 'user_id',
'through' => NULL,
'through_table_name' => NULL,
),
),
'_hasOne' =>
array (
),
'_relationCache' =>
array (
),
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_queryBuilder' =>
Core_QueryBuilder_Select::__set_state(array(
'_distinct' => false,
'_highPriority' => NULL,
'_straightJoin' => NULL,
'_sqlCalcFoundRows' => NULL,
'_select' =>
array (
0 =>
array (
0 => 'COUNT(*)',
1 => 'count',
),
),
'_from' =>
array (
0 => 'shop_items',
1 => 'shop_items',
),
'_groupBy' =>
array (
),
'_having' =>
array (
),
'_union' =>
array (
),
'_unionLimit' => NULL,
'_unionOffset' => NULL,
'_queryType' => 0,
'_offsetPostgreSQLSyntax' => true,
'_where' =>
array (
0 =>
array (
'AND' =>
array (
0 => 'shop_item_properties.property_id',
1 => '=',
2 => 219,
),
),
1 =>
array (
'AND' =>
array (
0 => 'property_value_strings.value',
1 => 'IS',
2 => NULL,
),
),
2 =>
array (
'AND' =>
array (
0 => 'shop_items.deleted',
1 => '=',
2 => 0,
),
),
3 =>
array (
'AND' =>
array (
0 => 'shop_items.deleted',
1 => '=',
2 => 0,
),
),
),
'_operator' => 'AND',
'_defaultOperator' => 'AND',
'_join' =>
array (
0 =>
array (
0 => 'LEFT OUTER JOIN',
1 => 'shop_item_properties',
2 => 'shop_items.shop_id',
3 => '=',
4 => 'shop_item_properties.shop_id',
5 => NULL,
),
1 =>
array (
0 => 'LEFT OUTER JOIN',
1 => 'property_value_strings',
2 => 'shop_items.id',
3 => '=',
4 => 'property_value_strings.entity_id',
5 =>
array (
0 =>
array (
'AND' =>
array (
0 => 'shop_item_properties.property_id',
1 => '=',
2 =>
Core_QueryBuilder_Expression::__set_state(array(
'_expression' => '`property_value_strings`.`property_id`',
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_unbuffered' => false,
)),
),
),
),
),
),
'_orderBy' =>
array (
),
'_limit' => NULL,
'_offset' => NULL,
'_dataBase' =>
Core_DataBase_Pdo::__set_state(array(
'_result' =>
PDOStatement::__set_state(array(
'queryString' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
)),
'_quoteColumnNameCache' =>
array (
'constants' => '`constants`',
'constants.*' => '`constants`.*',
'active' => '`active`',
'deleted' => '`deleted`',
'constants.deleted' => '`constants`.`deleted`',
'value' => '`value`',
'sessions' => '`sessions`',
'id' => '`id`',
'time' => '`time`',
'modules' => '`modules`',
'modules.*' => '`modules`.*',
'modules.deleted' => '`modules`.`deleted`',
'sorting' => '`sorting`',
'modules.sorting' => '`modules`.`sorting`',
'site_aliases' => '`site_aliases`',
'site_aliases.*' => '`site_aliases`.*',
'sites' => '`sites`',
'site_id' => '`site_id`',
'site_aliases.site_id' => '`site_aliases`.`site_id`',
'sites.id' => '`sites`.`id`',
'name' => '`name`',
'site_aliases.name' => '`site_aliases`.`name`',
'sites.deleted' => '`sites`.`deleted`',
'site_aliases.deleted' => '`site_aliases`.`deleted`',
'ipaddresses' => '`ipaddresses`',
'ipaddresses.*' => '`ipaddresses`.*',
'deny_access' => '`deny_access`',
'ipaddresses.deny_access' => '`ipaddresses`.`deny_access`',
'ipaddresses.deleted' => '`ipaddresses`.`deleted`',
'structures' => '`structures`',
'structures.site_id' => '`structures`.`site_id`',
'path' => '`path`',
'parent_id' => '`parent_id`',
'structures.deleted' => '`structures`.`deleted`',
'templates' => '`templates`',
'templates.id' => '`templates`.`id`',
'templates.deleted' => '`templates`.`deleted`',
'cdn_sites' => '`cdn_sites`',
'cdn_sites.site_id' => '`cdn_sites`.`site_id`',
'default' => '`default`',
'cdn_sites.default' => '`cdn_sites`.`default`',
'template_sections' => '`template_sections`',
'template_id' => '`template_id`',
'template_sections.template_id' => '`template_sections`.`template_id`',
'alias' => '`alias`',
'template_sections.alias' => '`template_sections`.`alias`',
'template_sections.deleted' => '`template_sections`.`deleted`',
'template_sections.sorting' => '`template_sections`.`sorting`',
'template_section_libs' => '`template_section_libs`',
'template_section_id' => '`template_section_id`',
'template_section_libs.template_section_id' => '`template_section_libs`.`template_section_id`',
'template_section_libs.deleted' => '`template_section_libs`.`deleted`',
'template_section_libs.sorting' => '`template_section_libs`.`sorting`',
'libs' => '`libs`',
'libs.id' => '`libs`.`id`',
'libs.deleted' => '`libs`.`deleted`',
'shops' => '`shops`',
'shops.id' => '`shops`.`id`',
'shops.deleted' => '`shops`.`deleted`',
'structures.id' => '`structures`.`id`',
'xsls' => '`xsls`',
'xsls.deleted' => '`xsls`.`deleted`',
'COUNT(*)' => 'COUNT(*)',
'count' => '`count`',
'shop_purchase_discounts' => '`shop_purchase_discounts`',
'shop_id' => '`shop_id`',
'shop_purchase_discounts.shop_id' => '`shop_purchase_discounts`.`shop_id`',
'position' => '`position`',
'start_datetime' => '`start_datetime`',
'end_datetime' => '`end_datetime`',
'shop_purchase_discounts.deleted' => '`shop_purchase_discounts`.`deleted`',
'shop_currencies' => '`shop_currencies`',
'shop_currencies.id' => '`shop_currencies`.`id`',
'shop_currencies.deleted' => '`shop_currencies`.`deleted`',
'companies' => '`companies`',
'companies.id' => '`companies`.`id`',
'companies.deleted' => '`companies`.`deleted`',
'shop_warehouses' => '`shop_warehouses`',
'shop_warehouses.shop_id' => '`shop_warehouses`.`shop_id`',
'shop_warehouses.deleted' => '`shop_warehouses`.`deleted`',
'shop_items' => '`shop_items`',
'shop_items.shop_id' => '`shop_items`.`shop_id`',
'shop_group_id' => '`shop_group_id`',
'shop_items.shop_group_id' => '`shop_items`.`shop_group_id`',
'shop_items.deleted' => '`shop_items`.`deleted`',
'shop_groups' => '`shop_groups`',
'shop_groups.shop_id' => '`shop_groups`.`shop_id`',
'shop_groups.deleted' => '`shop_groups`.`deleted`',
'shortcodes' => '`shortcodes`',
'shortcodes.*' => '`shortcodes`.*',
'shortcodes.active' => '`shortcodes`.`active`',
'shortcodes.deleted' => '`shortcodes`.`deleted`',
'shortcodes.sorting' => '`shortcodes`.`sorting`',
'directory_addresses' => '`directory_addresses`',
'directory_addresses.*' => '`directory_addresses`.*',
'company_directory_addresses' => '`company_directory_addresses`',
'directory_address_id' => '`directory_address_id`',
'company_directory_addresses.directory_address_id' => '`company_directory_addresses`.`directory_address_id`',
'directory_addresses.id' => '`directory_addresses`.`id`',
'company_id' => '`company_id`',
'company_directory_addresses.company_id' => '`company_directory_addresses`.`company_id`',
'directory_phones' => '`directory_phones`',
'directory_phones.*' => '`directory_phones`.*',
'company_directory_phones' => '`company_directory_phones`',
'directory_phone_id' => '`directory_phone_id`',
'company_directory_phones.directory_phone_id' => '`company_directory_phones`.`directory_phone_id`',
'directory_phones.id' => '`directory_phones`.`id`',
'company_directory_phones.company_id' => '`company_directory_phones`.`company_id`',
'directory_emails' => '`directory_emails`',
'directory_emails.*' => '`directory_emails`.*',
'company_directory_emails' => '`company_directory_emails`',
'directory_email_id' => '`directory_email_id`',
'company_directory_emails.directory_email_id' => '`company_directory_emails`.`directory_email_id`',
'directory_emails.id' => '`directory_emails`.`id`',
'company_directory_emails.company_id' => '`company_directory_emails`.`company_id`',
'directory_websites' => '`directory_websites`',
'directory_websites.*' => '`directory_websites`.*',
'company_directory_websites' => '`company_directory_websites`',
'directory_website_id' => '`directory_website_id`',
'company_directory_websites.directory_website_id' => '`company_directory_websites`.`directory_website_id`',
'directory_websites.id' => '`directory_websites`.`id`',
'company_directory_websites.company_id' => '`company_directory_websites`.`company_id`',
'directory_address_types' => '`directory_address_types`',
'directory_address_types.id' => '`directory_address_types`.`id`',
'directory_address_types.deleted' => '`directory_address_types`.`deleted`',
'directory_phone_types' => '`directory_phone_types`',
'directory_phone_types.id' => '`directory_phone_types`.`id`',
'directory_phone_types.deleted' => '`directory_phone_types`.`deleted`',
'directory_email_types' => '`directory_email_types`',
'directory_email_types.id' => '`directory_email_types`.`id`',
'directory_email_types.deleted' => '`directory_email_types`.`deleted`',
'shop_groups.*' => '`shop_groups`.*',
'siteuser_group_id' => '`siteuser_group_id`',
'shop_groups.siteuser_group_id' => '`shop_groups`.`siteuser_group_id`',
'shop_groups.active' => '`shop_groups`.`active`',
'shop_groups.sorting' => '`shop_groups`.`sorting`',
'properties' => '`properties`',
'properties.*' => '`properties`.*',
'shop_item_properties' => '`shop_item_properties`',
'property_id' => '`property_id`',
'shop_item_properties.property_id' => '`shop_item_properties`.`property_id`',
'properties.id' => '`properties`.`id`',
'shop_item_property_for_groups' => '`shop_item_property_for_groups`',
'shop_item_properties.id' => '`shop_item_properties`.`id`',
'shop_item_property_id' => '`shop_item_property_id`',
'shop_item_property_for_groups.shop_item_property_id' => '`shop_item_property_for_groups`.`shop_item_property_id`',
'shop_item_properties.shop_id' => '`shop_item_properties`.`shop_id`',
'shop_item_property_for_groups.shop_id' => '`shop_item_property_for_groups`.`shop_id`',
'shop_item_property_for_groups.shop_group_id' => '`shop_item_property_for_groups`.`shop_group_id`',
'properties.deleted' => '`properties`.`deleted`',
'properties.sorting' => '`properties`.`sorting`',
'property_dirs' => '`property_dirs`',
'property_dirs.*' => '`property_dirs`.*',
'shop_item_property_dirs' => '`shop_item_property_dirs`',
'property_dir_id' => '`property_dir_id`',
'shop_item_property_dirs.property_dir_id' => '`shop_item_property_dirs`.`property_dir_id`',
'property_dirs.id' => '`property_dirs`.`id`',
'shop_item_property_dirs.shop_id' => '`shop_item_property_dirs`.`shop_id`',
'property_dirs.deleted' => '`property_dirs`.`deleted`',
'property_dirs.sorting' => '`property_dirs`.`sorting`',
'shop_items.*' => '`shop_items`.*',
'property_value_strings' => '`property_value_strings`',
'entity_id' => '`entity_id`',
'property_value_strings.entity_id' => '`property_value_strings`.`entity_id`',
'shop_items.id' => '`shop_items`.`id`',
'property_value_strings.value' => '`property_value_strings`.`value`',
),
'_config' =>
array (
'driver' => 'pdo',
'host' => 'localhost',
'username' => 'u0475679_default',
'password' => 'dk6F1_!h',
'database' => 'u0475679_default',
'storageEngine' => 'MyISAM',
'charset' => 'UTF8',
'newlink' => false,
'attr' =>
array (
),
'driverName' => 'mysql',
),
'_connection' =>
PDO::__set_state(array(
)),
'_lastQuery' => 'SELECT
COUNT(*) AS `count`
FROM `shop_items`
LEFT OUTER JOIN `shop_item_properties` ON `shop_items`.`shop_id` = `shop_item_properties`.`shop_id`
LEFT OUTER JOIN `property_value_strings` ON `shop_items`.`id` = `property_value_strings`.`entity_id` AND `shop_item_properties`.`property_id` = `property_value_strings`.`property_id`
WHERE `shop_item_properties`.`property_id` = 219 AND `property_value_strings`.`value` IS NULL AND `shop_items`.`deleted` = 0 AND `shop_items`.`deleted` = 0',
'_queryType' => 0,
'_asObject' => false,
'_separator' =>
array (
0 => '.',
1 => ' + ',
2 => ' - ',
3 => ' / ',
4 => ' * ',
),
'_unbuffered' => false,
)),
'_unbuffered' => false,
)),
'_bSetPreloadValues' => false,
'_loaded' => false,
'_saved' => false,
'_init' => true,
'_sorting' =>
array (
),
))
2. Понятно же что там был print_r или его аналог. Извинияюсь, надо было добавить. Вы имеете ввиду, что вы с учётом команды вывода не понимаете откуда там это взялось?
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
hostcms
Модератор
26 апреля 2018 г.
1. Вы печатаете объект и ждете там свойства? Свойства в отдельных таблицах и получаются через отдельные связи. Чтобы распечатать объект делайте просто echo объекта, а не print_r, так выведется более читаемая информация, чем эти простыни.
Работа со свойствами:https://www.hostcms.ru/documentation/modules/properties/introduction/
2. Во первых я не понимаю ЧТО ИМЕННО вы там печатали, во вторых КАК вы это печатали. Судя по атрибутам на скриншоте с доставкой, это вовсе не доставка, а товар, у которого указано такое странное название.
Работа со свойствами:
2. Во первых я не понимаю ЧТО ИМЕННО вы там печатали, во вторых КАК вы это печатали. Судя по атрибутам на скриншоте с доставкой, это вовсе не доставка, а товар, у которого указано такое странное название.
nikolajgromkov
26 апреля 2018 г.
Всё, окей. Разобрался. Спасибо вам.
однако объясните как сделать правильно удаление?
Я сделал просто так, но при удалении и пометке нескольких тысяч может просто сработать ограничение на выполнение скрипта.
foreach ($aInvents as $shopitem) {
$shopitem->markDeleted();
}
Есть ли какой-то менее затратный способ удаления, кроме как перебор в цикле?
однако объясните как сделать правильно удаление?
Я сделал просто так, но при удалении и пометке нескольких тысяч может просто сработать ограничение на выполнение скрипта.
foreach ($aInvents as $shopitem) {
$shopitem->markDeleted();
}
Есть ли какой-то менее затратный способ удаления, кроме как перебор в цикле?
Ускорение сайтов / Любые работы по сайту / Обращайтесь в nivaks-studio.ru
Авторизация