- — - , c , .
?
, ,
"Aurus"
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='Aurus'
.
1 "Aurus" -:
Aurus ., . 158
.+7(911) 980-35-89
Aventi! -
.
Atlantic
.
.
:
:
, .