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='GALARY'
. GROUP , GALARY.
, .
, .
, .
www.galary.spb.ru
15 "GALARY" -:
-
, 10
-
., 5, .5,
-
., 67/2, 1
-
, 114
-
. ., 88
-
, 90
-
., 71, 2
-
, 2
-
, 197
-
, 20
-
., 20,
-
. , 101, . ,
-
, 78
-
, 33
-
, 14
Galle
-.
GaGaGames .
.