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,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,19,20,161,162,163,164,165,166,167,6,184,196,197,198,185,199,200,201,202,203,186,264,188,213,214,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
(
[72] => Bally
[38] => Boss
[47] => Circolo
[79] => Dondup
[80] => Eleventy
[4] => Escada
[5] => Escada Sport
[71] => Escada/Sport
[6] => Fay
[53] => Hetrego
[39] => Hogan
[113] => Lanvin
[74] => Lino 120%
[111] => Liviana Conti
[115] => Milva
[99] => Milva Mi
[35] => Missoni
[110] => MMJ
[40] => Panicale
[45] => PAULSHARK
[33] => Poustovit
[104] => SEMICOUTURE
[11] => Seventy
[12] => Trussardi
[73] => VITTORIO VIRGILI
[119] => Voile Blanche
[84] => Woolrich
)