Карта бара
- Array ( [29225] => 1 )сборные чаи
- Array ( [29225] => 1 [29226] => 1 )апперитив
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 )водка
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 )джин
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 )текила
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 )ром
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 )виски
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 )бренди
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 )коньяк
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 )ликеры
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 )разливное пиво
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 )свежевыжатые соки
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 )безалкогольные напитки
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 [29240] => 1 )чайная страничка
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 [29240] => 1 [29241] => 1 )кофе
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 [29240] => 1 [29241] => 1 [29242] => 1 )прочее
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 [29240] => 1 [29241] => 1 [29242] => 1 [29243] => 1 )безалкогольные коктейли
- Array ( [29225] => 1 [29226] => 1 [29229] => 1 [29230] => 1 [29231] => 1 [29232] => 1 [29233] => 1 [29234] => 1 [29235] => 1 [29236] => 1 [29237] => 1 [29238] => 1 [29239] => 1 [29240] => 1 [29241] => 1 [29242] => 1 [29243] => 1 [29244] => 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 = '29210' 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
