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='Simpatika'
Simpatika , , , , .
simpatika-shop.ru
6 "Simpatika" -:
-
Simpatika
. . 19, , 2 , 207
-
Simpatika
. , . 18, , 2 , 2-55
-
Simpatika
. , . 8, , 3 , 17
-
Simpatika
., . 67/2, , 1 , 1-9
-
Simpatika
., . 128, , 3 , 342
-
Simpatika
. . 41, , D27
SimperialS -.
Simba .
.