סל קניות
סגור

אנא המתן...

אביזרים למצלמות אקסטרים

    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 = 144678 AND a.SiteID = 34;
    99999-006-32 PGYTECH מגן זכוכית למסך OSMO POCKET P-18C-028
    ₪ 37
    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 = 144679 AND a.SiteID = 34;
    99999-006-60 PGYTECH מגן זכוכית P-11B-015 למצלמת OSMO ACTION
    ₪ 60
    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 = 144680 AND a.SiteID = 34;
    99999-006-69 PGYTECH כיסוי סיליקון ל- OSMO ACTION אדום
    ₪ 95
    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 = 144627 AND a.SiteID = 34;
    99999-006-70 PGYTECH מגן שמש קצר לטאבלט עד "7.9 P-GM-109
    ₪ 88
    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 = 145340 AND a.SiteID = 34;
    99999-006-29 זכוכית לשלט חכם מאביק PGYTECH 2
    ₪ 37
    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 = 145336 AND a.SiteID = 34;
    99999-006-34 מגן סטיקים לשלט MAVIC 2
    ₪ 50
    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 = 145352 AND a.SiteID = 34;
    99999-006-40 PGYTECH סט 3 כיסויים בעיצוב זוהר OSMO POCKET
    ₪ 55
    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 = 145343 AND a.SiteID = 34;
    99999-006-66 PGYTECH תיק קטן וקשיח P-GM-127 ל-OSMO ACTION
    ₪ 95
    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 = 145357 AND a.SiteID = 34;
    99999-006-05 PGYTECH מגן גימבל OSMO POCKET P-18C-026
    ₪ 60
    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 = 145368 AND a.SiteID = 34;
    99213-070-53 מוט סלפי MWSS750 BT
    ₪ 80
    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 = 145347 AND a.SiteID = 34;
    99999-006-31 PGYTECH קיט מתאמי חיבורים OSMO POCKET P-18C-033
    ₪ 90
    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 = 145339 AND a.SiteID = 34;
    99999-006-35 זכוכית לשלט חכם מאביק PGYTECH 2
    ₪ 115
    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 = 144677 AND a.SiteID = 34;
    99999-006-08 PGYTECH סט 3 כיסויים בעיצוב צבאי OSMO POCKET
    ₪ 70
    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 = 145358 AND a.SiteID = 34;
    99999-006-59 PGYTECH כיסוי סיליקון ל- OSMO ACTION שחור
    ₪ 90
    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 = 144717 AND a.SiteID = 34;
    99999-006-65 PGYTECH כבל P-GM-115 USB Lighthing אדום
    ₪ 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 = 144718 AND a.SiteID = 34;
    99999-006-63 P-GM-123 PGYTECH כבל Lighthing Type-C אדום
    ₪ 140
    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 = 145345 AND a.SiteID = 34;
    99999-006-52 PGYTECH רצועת יד עם תושבת למצלמות אקסטרים P-18C-024
    ₪ 120
    במלאי
    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 = 145353 AND a.SiteID = 34;
    99999-006-04 PGYTECH מחזיק טלפון אוניברסלי P-18C-023
    ₪ 115
    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 = 145346 AND a.SiteID = 34;
    99999-006-27 PGYTECH רצועת חזה למצלמות אקסטרים P-18C-025
    ₪ 220
    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 = 145328 AND a.SiteID = 34;
    99999-006-64 סלפי וחצובה עם מתקן לפלאפון PGYT
    ₪ 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 = 145309 AND a.SiteID = 34;
    99999-006-03 מוט סלפי וחצובה אקסטרים PGYTECH
    ₪ 220
    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 = 145322 AND a.SiteID = 34;
    99999-006-20 פנסי תאורה לפאנטום PGYTECH 4
    ₪ 150
    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 = 145323 AND a.SiteID = 34;
    99999-006-11 ערכת לדים למאביק אייר PGYTECH
    ₪ 150
    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 = 145330 AND a.SiteID = 34;
    99999-006-23 סט 4 פילטרים ל PGYT OSMO POCKET
    ₪ 230
    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 = 145344 AND a.SiteID = 34;
    99999-006-53 PGYTECH תושבת חיבור מצלמות אקסטרים P-18C-019
    ₪ 150