סל קניות
סגור

אנא המתן...

נגני מוזיקה MP3

    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 = 140405 AND a.SiteID = 34;
    MVJ52BT/A iPod Touch 128GB
    ₪ 1,340
    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 = 144960 AND a.SiteID = 34;
    38170-016-20 נגן MP3 אלחוטי SanDisk Clip Sport 16GB Bluetooth – שחור
    ₪ 299
    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 = 144959 AND a.SiteID = 34;
    38172-016-20 נגן SanDisk Clip Sport Go 16GB בצבע כחול
    ₪ 226
    במלאי
    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 = 144963 AND a.SiteID = 34;
    38172-032-10 נגן SanDisk Clip Sport Go 32GB בצבע שחור
    ₪ 238
    במלאי
    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 = 144965 AND a.SiteID = 34;
    38172-032-30 נגן SanDisk Clip Sport Go 32GB בצבע אדום
    ₪ 238
    במלאי
    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 = 144967 AND a.SiteID = 34;
    38172-016-30 נגן SanDisk Clip Sport Go 16GB בצבע אדום
    ₪ 226
    במלאי
    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 = 144966 AND a.SiteID = 34;
    38172-016-10 נגן SanDisk Clip Sport Go 16GB בצבע שחור
    ₪ 226
    במלאי
    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 = 144964 AND a.SiteID = 34;
    38172-032-20 נגן SanDisk Clip Sport Go 32GB בצבע כחול
    ₪ 238
    במלאי
    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 = 147964 AND a.SiteID = 34;
    38169-018-22 נגן SanDisk Clip Jam MP3 8GB מבית SANDISK
    ₪ 185
    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 = 147962 AND a.SiteID = 34;
    38169-018-20 נגן SanDisk Clip Jam MP3 8GB מבית SANDISK
    ₪ 185
    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 = 147963 AND a.SiteID = 34;
    38169-018-21 נגן SanDisk Clip Jam MP3 8GB מבית SANDISK
    ₪ 185
    במלאי
    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 = 147965 AND a.SiteID = 34;
    38169-018-30 נגן SanDisk Clip Jam MP3 8GB מבית SANDISK
    ₪ 185
    במלאי
    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 = 144961 AND a.SiteID = 34;
    38170-016-10 נגן MP3 אלחוטי SanDisk Clip Sport 16GB Bluetooth – בצבע כחול
    ₪ 299
    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 = 175750 AND a.SiteID = 34;
    38169-018-10 נגן SanDisk Clip JAM 8GB
    ₪ 185
    במלאי