{"version":"1.0","provider_name":"\u05e4\u05d5\u05e8\u05d5\u05dd \u05e4\u05e8\u05d9\u05d5\u05e8\u05d9\u05d8\u05d9","provider_url":"https:\/\/priority-forums.com\/he","title":"Insert Select order by - \u05e4\u05d5\u05e8\u05d5\u05dd \u05e4\u05e8\u05d9\u05d5\u05e8\u05d9\u05d8\u05d9","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"8II5eWKBB8\"><a href=\"https:\/\/priority-forums.com\/he\/forums\/topic\/insert-select-order-by\/\">Insert Select order by<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/priority-forums.com\/he\/forums\/topic\/insert-select-order-by\/embed\/#?secret=8II5eWKBB8\" width=\"600\" height=\"338\" title=\"&#8220;Insert Select order by&#8221; &#8212; \u05e4\u05d5\u05e8\u05d5\u05dd \u05e4\u05e8\u05d9\u05d5\u05e8\u05d9\u05d8\u05d9\" data-secret=\"8II5eWKBB8\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/priority-forums.com\/he\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"\u05d4\u05d9\u05d9 \u05d0\u05e0\u05d9 \u05de\u05e0\u05e1\u05d4 \u05dc\u05d1\u05e6\u05e2 Insert Select \u05e2\u05dd \u05ea\u05e0\u05d0\u05d9 \u05e9\u05dc Order by INSERT INTO SHMR_ORDERLOAD (ORDI,LINE,RECORDTYPE,PARTNAME, SHMR_MPARTNAME, DUEDATE,SPHERE,CYL,AXIS ,ADDITION,HPRISEM,ISIN,VPRISEM,ISUP,DIAMETER,SPECIALBASE,TEXT ,FARPD,FITINGH,SIDE,PANOANG,PANTOANG,COATCUST,MINCENTTHICK ,MINEDGETHICK,POLARPRISEM,POLARPRISEMD,COATING,PAINTING ,DECENTRATION,SHMR_MINOR,SHMR_EALLOWANCE,SHMR_CUSTHEIGHT,COLOR ,UNCUTDIA, SHMR_TQUANT) SELECT O.ORDI,SQL.LINE + :KLINE,'2',PART.PARTNAME,P1.PARTNAME ,O.DUEDATE ,O.SMIR_SPHERE,O.SMIR_CYL,O.SMIR_AXIS,O.SMIR_ADD ,O.SMIR_HORZPRISM,O.SMIR_ISIN,O.SMIR_VERTPRISM,O.SMIR_ISUP ,SHMR_DIAMETER.DIAMETER,O.SMIR_SPECIALBASE ,OA.REMARK1,O.SMIR_FARPD,O.SMIR_FITTHGHT,SHMR_SIDES.SIDECODE ,O.SMIR_ANGPANO,O.SMIR_ANGPANTOS,O.SHMR_CLISOLDER ,O.SHMR_MINCENTTHICK,O.SHMR_MINEDGETHICK,O.SHMR_POLARPRISM ,O.SHMR_POLARPRISMD,SHMR_COATING.CODE,SHMR_PAINTING.CODE ,O.SHMR_DESENTRATION,O.SHMR_MINOR,O.SHMR_ALLOWANCE ,O.SHMR_CUSTHEIGHT,SMIR_COLOR.CODE,O.SMIR_UNCUTDIAMETER ,O.TQUANT FROM ORDERS,PART,PART P1,SHMR_SIDES,ORDERITEMS O,ORDERITEMSA OA ? ,SHMR_DIAMETER,SHMR_COATING, SHMR_PAINTING,SMIR_COLOR WHERE O.ORD = ORDERS.ORD AND O.ORDI = OA.ORDI AND..."}