Карта бара
- Array ( [29305] => 1 )Вино
- Array ( [29305] => 1 [29306] => 1 )Апперитив
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 )Настойки
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 )Водка
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 )Джин
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 )Текила
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 )Ром
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 )Виски
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 )Бренди
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 )Коньяк
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 )Ликеры
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 )Пиво бутилированное
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 [29317] => 1 )Пиво разливное
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 [29317] => 1 [29318] => 1 )Безалкогольные напитки
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 [29317] => 1 [29318] => 1 [29319] => 1 )Чайная страничка
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 [29317] => 1 [29318] => 1 [29319] => 1 [29320] => 1 )Кофейная страничка
- Array ( [29305] => 1 [29306] => 1 [29307] => 1 [29308] => 1 [29309] => 1 [29310] => 1 [29311] => 1 [29312] => 1 [29313] => 1 [29314] => 1 [29315] => 1 [29316] => 1 [29317] => 1 [29318] => 1 [29319] => 1 [29320] => 1 [29321] => 1 )Коктейли
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 = '29286' 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
