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=' '
-. , : bmx, , , , , , .
www.trial-sport.ru
6 " " -:
-
, .27, .,
.+7 (812) 449-52-32
-
, .85, .,
.+7 (812) 333-02-85
-
, .154,
.+7 (812) 332-55-45
-
. , . 11
.+7 (812) 644-44-00
-
, .86,
.+7 (812) 702-66-16
-
, .2, .1, .
.+7 (812) 360-14-90
-.
.
.