info@hermes-gifts.ru (499)517-94-22 | (495)973-25-57 Статьи Новости Условия сотрудничества Контакты
  • Отправка сообщения

  • Нанесение
111action index
3333333333
SELECT SQL_CALC_FOUND_ROWS DISTINCT a.`Message_ID`, a.`User_ID`, a.`IP`, a.`UserAgent`, a.`LastUser_ID`, a.`LastIP`, a.`LastUserAgent`, a.`Priority`, a.`Parent_Message_ID`, a.`ncTitle`, a.`ncKeywords`, a.`ncDescription`, a.`ncSMO_Title`, a.`ncSMO_Description`, a.`ncSMO_Image`, sub.`Subdivision_ID`, CONCAT('', sub.`Hidden_URL`) AS `Hidden_URL`, cc.`Sub_Class_ID`, cc.`EnglishName`, a.`Checked`, a.`Created`, a.`Keyword`, a.`LastUpdated` + 0 AS LastUpdated, a.Name, a.Vendor, a.VariantName, a.Article, a.Type, a.Description, a.Details, a.Image, a.Image_mini, a.SuperBigImage, a.PriceDiscount, a.Price, tbl234.ShopCurrency_Name AS Currency, tbl234.ShopCurrency_ID AS Currency_id, tbl234.`Value` AS Currency_value , a.PriceMinimum, tbl235.ShopCurrency_Name AS CurrencyMinimum, tbl235.ShopCurrency_ID AS CurrencyMinimum_id, tbl235.`Value` AS CurrencyMinimum_value , tbl236.ShopUnits_Name AS Units, tbl236.ShopUnits_ID AS Units_id, tbl236.`Value` AS Units_value , a.Weight, a.StockUnits, a.TopSellingMultiplier, a.TopSellingAddition, a.VAT, a.SalesNotes, a.ItemID, a.ImportSourceID, a.RateTotal, a.RateCount, a.Id1c, a.Size, a.Material, a.Color, a.base_id, a.Applications, a.Categories, a.FullDescription, tbl450.dating_Name AS dating, tbl450.dating_ID AS dating_id, tbl450.`Value` AS dating_value , tbl451.Sex_Name AS sex, tbl451.Sex_ID AS sex_id, tbl451.`Value` AS sex_value , a.Tag, a.BigImage, a.Stock FROM (`Message31` AS a ) LEFT JOIN `Subdivision` AS sub ON sub.`Subdivision_ID` = a.`Subdivision_ID` LEFT JOIN `Sub_Class` AS cc ON cc.`Sub_Class_ID` = a.`Sub_Class_ID` LEFT JOIN `Classificator_ShopCurrency` AS tbl234 ON a.`Currency` = tbl234.ShopCurrency_ID LEFT JOIN `Classificator_ShopCurrency` AS tbl235 ON a.`CurrencyMinimum` = tbl235.ShopCurrency_ID LEFT JOIN `Classificator_ShopUnits` AS tbl236 ON a.`Units` = tbl236.ShopUnits_ID LEFT JOIN `Classificator_dating` AS tbl450 ON a.`dating` = tbl450.dating_ID LEFT JOIN `Classificator_Sex` AS tbl451 ON a.`sex` = tbl451.Sex_ID LEFT JOIN `Categories` AS cat ON a.`Message_ID` = cat.`Message_ID` WHERE 1 AND a.`Parent_Message_ID` = '0' AND 1 and ((a.Subdivision_ID IN ('73','97','98','99','100','101','219','331','381','357') ) or cat.Subdivision_ID IN ('73','97','98','99','100','101','219','331','381','357') ) AND sub.`Catalogue_ID` = '1' AND a.`Checked` = 1 ORDER BY Price ASC LIMIT 180,20

Сувениры для дома – универсальные подарки для всех поводов

    widget_itemArray ( [Class_ID] => 31 [Message_ID] => 35724 [sub] => 95 [base_id_log] => [base_id] => 115553 [auth_user_id] => 0 )
    • 750руб.
    • Артикул: 17621.30
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 9173 [sub] => 95 [base_id_log] => [base_id] => 000012261 [auth_user_id] => 0 )
    • 770руб.
    • Артикул: 1537.01
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 34249 [sub] => 95 [base_id_log] => [base_id] => 118359 [auth_user_id] => 0 )
    • 770руб.
    • Артикул: 110111.03
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 38554 [sub] => 95 [base_id_log] => [base_id] => 135052 [auth_user_id] => 0 )
  • Новинка
    • 790руб.
    • Артикул: 110504.60
    • Нет в наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 38550 [sub] => 95 [base_id_log] => [base_id] => 135041 [auth_user_id] => 0 )
  • Новинка
    • 790руб.
    • Артикул: 110499.60
    • Нет в наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 29419 [sub] => 95 [base_id_log] => [base_id] => 000013637 [auth_user_id] => 0 )
    • 790руб.
    • Артикул: 319105
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 38539 [sub] => 95 [base_id_log] => [base_id] => 135027 [auth_user_id] => 0 )
  • Новинка
    • 790руб.
    • Артикул: 110494.60
    • Нет в наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 34224 [sub] => 95 [base_id_log] => [base_id] => [auth_user_id] => 0 )
    • 790руб.
    • Артикул: 110027
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 6440 [sub] => 95 [base_id_log] => [base_id] => 000000833 [auth_user_id] => 0 )
    • 796руб.
    • Артикул: 1Z2419
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 40400 [sub] => 95 [base_id_log] => [base_id] => 1-000030650 [auth_user_id] => 0 )
  • Новинка
    • 804руб.
    • Артикул: 4539808
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 29424 [sub] => 95 [base_id_log] => [base_id] => 000014208 [auth_user_id] => 0 )
    • 820руб.
    • Артикул: 319102
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 35729 [sub] => 95 [base_id_log] => [base_id] => 115580 [auth_user_id] => 0 )
    • 840руб.
    • Артикул: 17941.60
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 38530 [sub] => 95 [base_id_log] => [base_id] => 134992 [auth_user_id] => 0 )
  • Новинка
    • 850руб.
    • Артикул: 110478.00
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 3023 [sub] => 95 [base_id_log] => [base_id] => 000001442 [auth_user_id] => 0 )
    • 890руб.
    • Артикул: 16375
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 38556 [sub] => 95 [base_id_log] => [base_id] => 135059 [auth_user_id] => 0 )
  • Новинка
    • 890руб.
    • Артикул: 110507.11
    • Нет в наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 35257 [sub] => 95 [base_id_log] => [base_id] => 113126 [auth_user_id] => 0 )
    • 890руб.
    • Артикул: 17445.00
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 35258 [sub] => 95 [base_id_log] => [base_id] => 113128 [auth_user_id] => 0 )
    • 890руб.
    • Артикул: 17446.00
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 34410 [sub] => 95 [base_id_log] => [base_id] => 120984 [auth_user_id] => 0 )
    • 900руб.
    • Артикул: 110240.60
    • Нет в наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 40402 [sub] => 95 [base_id_log] => [base_id] => 1-000030654 [auth_user_id] => 0 )
  • Новинка
    • 906руб.
    • Артикул: 4539816
    • В наличии
  • widget_itemArray ( [Class_ID] => 31 [Message_ID] => 27396 [sub] => 95 [base_id_log] => [base_id] => 000023174 [auth_user_id] => 0 )
    • 930руб.
    • Артикул: 17568.10
    • В наличии