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='Athletic '
Athletic - : , , , , .
athletic.ru
9 "Athletic " -:
-
Athletic
. , . 19, , 207
-
Athletic
. . 5, , 408
-
Athletic
-, . 119, , 2
-
Athletic
- . 19, , 22
-
Athletic
. , .14, , 11
-
Athletic
., . 17, , 19
-
Athletic
- 18/2, , 10
-
Athletic
., 2, . , , 206
-
Athletic
- 67, " ", 73
Ati -.
Atelier de Courcelles .
.