Oferte speciale
Dupa categorie
Produse pentru gravide si mamici
Accesorii bebelusi
Camera copilului
Imbracaminte si Incaltaminte
Jocuri/Jucarii
Ora mesei
Igiena si sanatate
Cadouri
Pachete promotionale
Dupa valoare
Sub 10 lei
Intre 10 si 20 lei
Intre 20 si 30 lei
Intre 30 si 40 lei
Intre 40 si 50 lei
Intre 50 si 100 lei
Intre 100 si 200 lei
Peste 200 lei
Transport gratuit
Dupa brand
Oferte speciale - produse din categoria Igiena si sanatate
select *,
CASE currency
WHEN 1 THEN ROUND(price+price*(1-vat_included)*vat/100,2)
WHEN 2 THEN ROUND((price+price*(1-vat_included)*vat/100)*4.5162,2)
WHEN 3 THEN ROUND((price+price*(1-vat_included)*vat/100)*4.2616,2) END as price_shown,
CASE currency
WHEN 1 THEN ROUND(old_price+old_price*(1-vat_included)*vat/100,2)
WHEN 2 THEN ROUND((old_price+old_price*(1-vat_included)*vat/100)*4.5162,2)
WHEN 3 THEN ROUND((old_price+old_price*(1-vat_included)*vat/100)*4.2616,2) END as old_price_shown
from shop_items where IDbrand="" and type=1 and visible=1
and old_price>price and price>0
and IDboss in (343, 517, 523, 524, 518, 519, 520, 528, 529, 16701, 14292, 522, 526, 527, 533, 14293, 14304, 525, 6649, 14274, 14275, 14276, 14618, 14291)
and IDreal=0 and IDboss in (1, 377, 378, 341, 338, 339, 340, 342, 343, 331, 333, 335, 336, 370, 372, 373, 379, 362, 363, 364, 368, 385, 492, 387, 390, 417, 461, 468, 467, 465, 466, 470, 471, 472, 473, 474, 475, 476, 479, 478, 481, 482, 484, 487, 488, 490, 491, 493, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 506, 507, 509, 14994, 514, 517, 518, 519, 520, 14292, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 15152, 538, 541, 542, 543, 6646, 6647, 6649, 6650, 6651, 6652, 6653, 6654, 6655, 6656, 6657, 6658, 6659, 6660, 6661, 6662, 14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14257, 14258, 14260, 14262, 14263, 14264, 14265, 14266, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278, 14279, 14280, 14281, 14291, 14293, 15153, 14296, 14297, 14298, 14299, 14303, 14304, 14448, 15150, 15151, 14618, 14962, 14993, 15025, 15178, 15756, 16101, 16206, 16274, 16391, 16701)
order by price_shown asc Nu exista produse.