+7-981-149-16-30 Санкт-Петербург
Ваша корзина пуста

Каталог

Apple Meizu Oneplus Xiaomi

Apple

 
AirPods
AirPods
 
13 200р.
Детали
 

Meizu

select s.productID, s.name, s.Price, s.enabled, t.filename FROM cnjh_products AS s LEFT JOIN cnjh_product_pictures AS t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE (s.categoryID='' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) ORDER BY s.date_added DESC LIMIT 3
 
AirPods
AirPods
 
13 200р.
Детали
 

Oneplus

select s.productID, s.name, s.Price, s.enabled, t.filename FROM cnjh_products AS s LEFT JOIN cnjh_product_pictures AS t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE (s.categoryID='' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) ORDER BY s.date_added DESC LIMIT 3
 
AirPods
AirPods
 
13 200р.
Детали
 

Xiaomi

select s.productID, s.name, s.Price, s.enabled, t.filename FROM cnjh_products AS s LEFT JOIN cnjh_product_pictures AS t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE (s.categoryID='' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) OR (s.categoryID = '2' AND s.enabled=1) OR (s.categoryID = '3' AND s.enabled=1) OR (s.categoryID = '36' AND s.enabled=1) OR (s.categoryID = '38' AND s.enabled=1) OR (s.categoryID = '39' AND s.enabled=1) OR (s.categoryID = '40' AND s.enabled=1) OR (s.categoryID = '41' AND s.enabled=1) OR (s.categoryID = '42' AND s.enabled=1) OR (s.categoryID = '43' AND s.enabled=1) OR (s.categoryID = '44' AND s.enabled=1) OR (s.categoryID = '45' AND s.enabled=1) OR (s.categoryID = '46' AND s.enabled=1) ORDER BY s.date_added DESC LIMIT 3
 
AirPods
AirPods
 
13 200р.
Детали