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='CENTRO'
CENTRO .
Fast Fashion .
Fast Fashion - .
, CENTRO .
centrofashion.ru
8 "CENTRO" -:
-
CENTRO
. , . 20, ""
-
CENTRO
, . 41, ""
-
CENTRO
., . 141, ""
-
CENTRO
, 12 ,
-
CENTRO
. , . 3,
-
CENTRO
, 114 . 1
-
CENTRO
- ,
-
CENTRO
, 30,
Cerruti -.
Celynb .
.