Назад

МАТЕРИАЛЫ

    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 = '16850' 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 OR b.Class_ID=2073) 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 ( [14309] => 1 )
    ЛДСП
  • Array ( [14309] => 1 [16472] => 1 )
    Массив дерева
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 )
    Акриловый пластик
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 )
    Пленка ПВХ
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 )
    Эмаль
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 )
    Пластик HPL
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 [20768] => 1 )
    Шпон натуральный
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 [20768] => 1 [20770] => 1 )
    Шпон файн-лайн
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 [20768] => 1 [20770] => 1 [22416] => 1 )
    Экокожа уголки кухонные
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 [20768] => 1 [20770] => 1 [22416] => 1 [43706] => 1 )
    Тимберика варианты цветов
  • Array ( [14309] => 1 [16472] => 1 [20766] => 1 [20764] => 1 [20765] => 1 [20767] => 1 [20768] => 1 [20770] => 1 [22416] => 1 [43706] => 1 [110502] => 1 )
    Тимберика варианты обивки