{"id":1990,"date":"2022-10-27T09:53:30","date_gmt":"2022-10-27T01:53:30","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2022\/10\/27\/smart3d-0466\/"},"modified":"2026-08-20T18:19:34","modified_gmt":"2026-08-20T10:19:34","slug":"smart3d-0466","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/2022\/10\/27\/smart3d-0466\/","title":{"rendered":"Smart3D\u4e2d\u7b49\u7ea7\u6570\u636eSQL\u67e5\u8be2\uff08\uff09"},"content":{"rendered":"<div class=\"content\">\n<p><\/p>\n<p>select * from XPipeSpecContainsPartSpecs<\/p>\n<p>select * from JDPipeSpec<\/p>\n<p>select * from JDPipePartSpec<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-ratio=\"0.4844995571302037\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0000.png\" data-type=\"png\" data-w=\"1129\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0000.png\" \/><\/p>\n<p>select * from JDPipeSpec j1<\/p>\n<p>join XPipeSpecContainsPartSpecs j2 on j2.oidorigin\u00a0 = j1.oid<\/p>\n<p>join JDPipePartSpec j3 on j3.Oid=j2.OidDestination<\/p>\n<p><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-ratio=\"0.4169611307420495\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0001.png\" data-type=\"png\" data-w=\"1132\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0001.png\" style=\"text-align: center;white-space: normal\" \/><\/p>\n<p>select j1.SpecName,j3.ShortCode,j3.OptionCode,j3.FirstSizeFrom,j3.FirstSizeTo,j3.SecondSizeFrom,j3.SecondSizeTo,j3.CommodityCode from JDPipeSpec j1<\/p>\n<p>join XPipeSpecContainsPartSpecs j2 on j2.oidorigin\u00a0 = j1.oid<\/p>\n<p>join JDPipePartSpec j3 on j3.Oid=j2.OidDestination<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-ratio=\"0.3462857142857143\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0002.png\" data-type=\"png\" data-w=\"875\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0466_img_0002.png\" \/><\/p>\n<p><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>select * from XPipeSpecContainsPartSpecs select * from  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1987,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[9,15],"tags":[],"class_list":["post-1990","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-15"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/posts\/1990","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/comments?post=1990"}],"version-history":[{"count":4,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/posts\/1990\/revisions"}],"predecessor-version":[{"id":7582,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/posts\/1990\/revisions\/7582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/media\/1987"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/media?parent=1990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/categories?post=1990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/wp-json\/wp\/v2\/tags?post=1990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}