- — - , c , .

CODE 7

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 shops_stock s LEFT JOIN shops_stock_tm s_tm ON s.id_tm=s_tm.id WHERE s_tm.name='CODE 7'

CODE 7CODE7- , , , - . , , , , . , . CODE7 , , , . , . , . : Pierrepont Hicks, Spiewak, Eastpak, Tellason, Fidelity Sportswear, Lavenham, Red Wing, Superga, Bundstone

www.code7.ru

1 "CODE 7" -:

Colin-s.
City brands.
-.