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=' '
- .
vic-spb.ru
13 " " -:
-
., . 14
-
. . 8
-
. , . 29,
-
.., 6- , . 29
-
., . 56
.+7 (812) 764-59-72
-
., . 14
.+7 (812) 294-70-92
-
., . 31
.+7 (812) 297-06-03
-
12- , . 20-28
-
., . 26
.+7 (812) 300-36-21
-
., . 23
.+7 (812) 528-00-06
-
- ., . 41
.+7 (812) 252-57-27
-
., . 8
.+7 (812) 430-94-70
-
. , . 12
.+7 (812) 365-07-33
-.
.
.