- — - , c , .

"Soho"

SELECT s.*, s_tm.name nameTm, s_tm.logo logoTm, s_tm.description, s_tm.url urlTm, s_tm.close closeTm, s.close close FROM shops2 s LEFT JOIN shops2_tm s_tm ON s.id_tm=s_tm.id WHERE s_tm.name='Soho'

Soho

SOHO premium, .

, Soho: casual, classic, sport. Soho 4 : Soho Original, Soho White, Soho Bags, Soho Discount. Soho Kids Soho Black. Soho , , . 16 , : Tommy Hilfiger, Gant, Marc O'Polo.

1 "Soho" -:

Solid -.
SoFrench .
.