SELECT * FROM `i_brand` WHERE (`name`!='' AND `name` IS NOT NULL) AND `id` in (SELECT `brand` FROM `i_cat_elements` WHERE (`id_section` in (263,8,153,228,154,269,232,233,5,170,177,178,172,179,180,181,175,176,150,220,221,222,151,223,224,3,12,10,13,152,226,227,155,235,236,156,237,238,239,240,245,159,4,18,20,161,162,163,164,165,166,6,184,197,185,199,200,201,202,203,186,187,264,188,213,190,215,216,7,252,253,255)) AND `active`=1 AND (`outlet`=0 OR `outlet` IS NULL) AND `version`='ru') GROUP BY `name` ORDER BY `name` ASC
Array
(
[133] => Anfiny
[72] => Bally
[38] => BOSS
[112] => Briglia
[47] => Circolo
[79] => Dondup
[80] => Eleventy
[4] => Escada
[71] => Escada/Sport
[6] => Fay
[53] => Hetrego
[39] => Hogan
[128] => Kilesa
[113] => Lanvin
[117] => Lavi
[74] => Lino 120%
[111] => Liviana Conti
[115] => Milva
[99] => Milva Mi
[35] => Missoni
[110] => MMJ
[131] => Morgano
[132] => MOU
[40] => Panicale
[126] => Paul & Shark
[45] => PAULSHARK
[116] => Pearlwood
[33] => Poustovit
[125] => Roberto Cavalli
[104] => SEMICOUTURE
[11] => Seventy
[12] => Trussardi
[73] => VITTORIO VIRGILI
[136] => Vlab
[119] => Voile Blanche
[84] => Woolrich
)