Карта бара

    select a.Subdivision_ID, a.Subdivision_Name, a.Hidden_URL, a.ExternalURL, a.descr, SUBSTRING_INDEX(a.img,':',-1) as img, b.Sub_Class_ID, b.Class_ID from Subdivision as a, Sub_Class as b where a.Parent_Sub_ID = '29246' AND a.Subdivision_ID = b.Subdivision_ID AND a.Checked=1 AND (b.Class_ID=182 OR b.Class_ID=2001 OR b.Class_ID=2003 OR b.Class_ID=2009 OR b.Class_ID=2010 OR b.Class_ID=2021 OR b.Class_ID=2012 OR b.Class_ID=244 OR b.Class_ID=2020 OR b.Class_ID=2030) AND (a.citytarget LIKE '%,0,%' OR a.citytarget = ',,' OR a.citytarget IS NULL OR a.citytarget = '') order by a.Priority GROUP BY a.Subdivision_ID
  • Array ( [29264] => 1 )
    Вино
  • Array ( [29264] => 1 [29265] => 1 )
    Водка
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 )
    Текила
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 )
    Ром
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 )
    Бренди
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 )
    Виски
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 )
    Коньяк
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 )
    Ликеры
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 )
    Пиво разливное
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 [29273] => 1 )
    Пиво в бутылках
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 [29273] => 1 [29274] => 1 )
    Минеральные воды
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 [29273] => 1 [29274] => 1 [29275] => 1 )
    Безалкогольные напитки
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 [29273] => 1 [29274] => 1 [29275] => 1 [29276] => 1 )
    Сигареты
  • Array ( [29264] => 1 [29265] => 1 [29266] => 1 [29267] => 1 [29268] => 1 [29269] => 1 [29270] => 1 [29271] => 1 [29272] => 1 [29273] => 1 [29274] => 1 [29275] => 1 [29276] => 1 [29277] => 1 )
    Кальянное меню
из

Дорогой наш Клиент!

Извините, в это время уже доставка не работает, поэтому не сможем принять Ваш заказ. Заказ в корзину можно сделать с 12.00 до 23.00 (пн-сб), с 12.00 до 22.00 (вс)