COMENZI TELEFONICE
0722.660.856
Cosul de cumparaturi
Produse pentru gravide si mamici Accesorii bebelusi Camera copilului Imbracaminte si Incaltaminte Jocuri/Jucarii Ora mesei Igiena si sanatate Cadouri Pachete promotionale

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.