סל קניות
סגור

אנא המתן...

רמקולים אלחוטיים

    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173910 AND a.SiteID = 34;
    99216-005-05 שעון דיגיטלי, רדיו ורמקול BLUETHOOTH דגם MSRW10`
    ₪ 125
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173919 AND a.SiteID = 34;
    99317-705-18 רמקול בלוטות´ בצבע שחור דגם MBTS919 מבית MIRACASE
    ₪ 138
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173923 AND a.SiteID = 34;
    99317-705-14 רמקול בלוטות´ בצבע אדום דגם MBTS322 מבית MIRACASE
    ₪ 125
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173922 AND a.SiteID = 34;
    99317-705-19 רמקול בלוטות´ בצבע אפור דגם MBTS919 מבית MIRACASE
    ₪ 130
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173924 AND a.SiteID = 34;
    99317-705-17 רמקול בלוטות´ בצבע תכלת דגם MBTS923 מבית MIRACASE
    ₪ 125
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173925 AND a.SiteID = 34;
    99317-705-15 רמקול בלוטות´ בצבע שחור דגם MBTS923 מבית MIRACASE
    ₪ 109
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173921 AND a.SiteID = 34;
    99317-705-20 רמקול בלוטות´ בצבע אדום דגם MBTS919 מבית MIRACASE
    ₪ 138
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173920 AND a.SiteID = 34;
    99317-705-16 רמקול בלוטות´ בצבע אדום דגם MBTS923 מבית MIRACASE
    ₪ 125
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144932 AND a.SiteID = 34;
    99317-705-12 רמקול בלוטוס MIRACASE MBTS868 שחור
    ₪ 113
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144924 AND a.SiteID = 34;
    98000-091-20 מתאם bluetooth אלחוטי לרמקולים Logitech
    ₪ 172
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144933 AND a.SiteID = 34;
    99317-705-07 רמקול בלוטוס MIRACASE MBTS601 1200mAh
    ₪ 109
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 150590 AND a.SiteID = 34;
    2D799AA רמקול HP Nala Black Bluetooth
    ₪ 146
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144928 AND a.SiteID = 34;
    99317-705-10 רמקול בלוטות´ מבית MIRACASE דגם MBTS636 בצבע שחור
    ₪ 113
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 173927 AND a.SiteID = 34;
    99317-705-13 רמקול בלוטות´ בצבע שחור דגם MBTS322 מבית MIRACASE
    ₪ 125
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144930 AND a.SiteID = 34;
    99700-535-48 רמקול בלוטוס שחור 0MBTS100 מבית Miracase
    ₪ 280
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144927 AND a.SiteID = 34;
    99700-900-30 רמקול MBTS900 IP67 12W TWS BT אדום
    ₪ 267
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 150588 AND a.SiteID = 34;
    2D802AA רמקול אלחוטי HP Simba Bluetooth שחור
    ₪ 190
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144934 AND a.SiteID = 34;
    99700-900-10 רמקול MBTS900 IP67 12W TWS BT שחור
    ₪ 260
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 175818 AND a.SiteID = 34;
    99700-110-03 רמקול בלוטות` איכותי MIRACASE MBTS1100 שחור
    ₪ 210
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 144929 AND a.SiteID = 34;
    99700-537-14 רמקול בלוטות´ MBTS450 בתוספת תאורת פנס וסוללת גיבוי MIRACASE
    ₪ 177
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 150586 AND a.SiteID = 34;
    2D804AA רמקול אלחוטי HP Simba Bluetooth כסוף
    ₪ 190
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 175817 AND a.SiteID = 34;
    99700-110-02 רמקול בלוטות` איכותי MIRACASE MBTS1100 אפור-כסף
    ₪ 210
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 175819 AND a.SiteID = 34;
    99700-110-04 רמקול בלוטות` איכותי MIRACASE MBTS1100 שחור-כסף
    ₪ 210
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 175816 AND a.SiteID = 34;
    99700-110-01 רמקול בלוטות` איכותי MIRACASE MBTS1100 אפור-שחור
    ₪ 210
    במלאי
    SELECT TOP 1 ISNULL(b.IconID,0) AS F1Icon,ISNULL(b.Background,'') AS F1BG,ISNULL(b.FieldValue,'') AS F1Value ,ISNULL(c.IconID,0) AS F2Icon,ISNULL(c.Background,'') AS F2BG,ISNULL(c.FieldValue,'') AS F2Value ,ISNULL(d.IconID,0) AS F3Icon,ISNULL(d.Background,'') AS F3BG,ISNULL(d.FieldValue,'') AS F3Value ,ISNULL(e.IconID,0) AS F4Icon,ISNULL(e.Background,'') AS F4BG,ISNULL(e.FieldValue,'') AS F4Value ,ISNULL(f.IconID,0) AS F5Icon,ISNULL(f.Background,'') AS F5BG,ISNULL(f.FieldValue,'') AS F5Value ,ISNULL(g.IconID,0) AS F6Icon,ISNULL(g.Background,'') AS F6BG,ISNULL(g.FieldValue,'') AS F6Value ,ISNULL(h.IconID,0) AS F7Icon,ISNULL(h.Background,'') AS F7BG,ISNULL(h.FieldValue,'') AS F7Value ,ISNULL(i.IconID,0) AS F8Icon,ISNULL(i.Background,'') AS F8BG,ISNULL(i.FieldValue,'') AS F8Value ,ISNULL(j.IconID,0) AS F9Icon,ISNULL(j.Background,'') AS F9BG,ISNULL(j.FieldValue,'') AS F9Value ,ISNULL(k.IconID,0) AS F10Icon,ISNULL(k.Background,'') AS F10BG,ISNULL(k.FieldValue,'') AS F10Value ,ISNULL(l.IconID,0) AS F11Icon,ISNULL(l.Background,'') AS F11BG,ISNULL(l.FieldValue,'') AS F11Value ,ISNULL(m.IconID,0) AS F12Icon,ISNULL(m.Background,'') AS F12BG,ISNULL(m.FieldValue,'') AS F12Value ,ISNULL(n.IconID,0) AS F13Icon,ISNULL(n.Background,'') AS F13BG,ISNULL(n.FieldValue,'') AS F13Value ,ISNULL(o.IconID,0) AS F14Icon,ISNULL(o.Background,'') AS F14BG,ISNULL(o.FieldValue,'') AS F14Value ,ISNULL(p.IconID,0) AS F15Icon,ISNULL(p.Background,'') AS F15BG,ISNULL(p.FieldValue,'') AS F15Value ,ISNULL(q.IconID,0) AS F16Icon,ISNULL(q.Background,'') AS F16BG,ISNULL(q.FieldValue,'') AS F16Value FROM FilterData a LEFT JOIN FilterSelectData b ON b.ID = a.Filter1 LEFT JOIN FilterSelectData c ON c.ID = a.Filter2 LEFT JOIN FilterSelectData d ON d.ID = a.Filter3 LEFT JOIN FilterSelectData e ON e.ID = a.Filter4 LEFT JOIN FilterSelectData f ON f.ID = a.Filter5 LEFT JOIN FilterSelectData g ON g.ID = a.Filter6 LEFT JOIN FilterSelectData h ON h.ID = a.Filter7 LEFT JOIN FilterSelectData i ON i.ID = a.Filter8 LEFT JOIN FilterSelectData j ON j.ID = a.Filter9 LEFT JOIN FilterSelectData k ON k.ID = a.Filter10 LEFT JOIN FilterSelectData l ON l.ID = a.Filter11 LEFT JOIN FilterSelectData m ON m.ID = a.Filter12 LEFT JOIN FilterSelectData n ON n.ID = a.Filter13 LEFT JOIN FilterSelectData o ON o.ID = a.Filter14 LEFT JOIN FilterSelectData p ON p.ID = a.Filter15 LEFT JOIN FilterSelectData q ON q.ID = a.Filter16 WHERE a.ProductID = 150587 AND a.SiteID = 34;
    2D803AA רמקול אלחוטי HP Simba Bluetooth כחול
    ₪ 190
    במלאי