סל קניות
סגור

אנא המתן...

סוללת התנעה לרכב

    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 = 145246 AND a.SiteID = 34;
    99213-008-00 סוללת חירום 8000mAH להתנעת הרכב MIRACASE
    ₪ 255
    במלאי
    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 = 145247 AND a.SiteID = 34;
    99213-005-01 סוללת חירום 12000mAH להתנעת הרכב MIRACASE
    ₪ 339
    במלאי