Полезные запросы для HostCMS v.6

update shop_items set name = concat('Пицца ', name) where shop_group_id = 746

update shop_items set name = concat('Пицца ', name) where shop_group_id IN (746, 747, 748)

update shop_items set name = concat(name, ' ', marking) where shop_group_id IN (746, 747, 748)

UPDATE shop_items SET deleted = 1 WHERE modification_id > 0 AND shop_id = 123;

$oQB = Core_QueryBuilder::select('shop_items.id')
   ->from('shop_items')
    ->join('shop_warehouse_items', 'shop_warehouse_items.shop_item_id', '=', 'shop_items.id')
    ->join('shop_warehouses', 'shop_warehouses.id', '=', 'shop_warehouse_items.shop_warehouse_id')
    ->where('shop_items.active', '=', 1)
    ->where('shop_items.deleted', '=', 0)
    ->where('shop_items.shop_id', '=', 3)
    ->where('shop_warehouses.active', '=', 1)
    ->where('shop_warehouses.deleted', '=', 0)
    ->groupBy('shop_items.id')
    ->having(Core_QueryBuilder::expression('SUM(shop_warehouse_items.count)'), '>', 0);


$oCore_QueryBuilder_Select = Core_QueryBuilder::select(array(Core_QueryBuilder::raw('COUNT(*)'), 'count'))
    ->from(array($oQB, 'x'));

$row = $oCore_QueryBuilder_Select->execute()->asObject()->current();

echo 'Сегодня в продаже ' . $row->count . ' ' . Core_Str::declensionNumber($row->count, 'товар', 'товара', 'товаров');