Running a small 3D Print business as a newbie
[Go]
SELECT a.VideoAttachID,m.Slug as MSlug,z.Name,z.Slug as ZSlug,a.AttachType FROM VideoAttach AS a JOIN Accessory AS z ON a.AttachType='Accessory' AND z.AccessoryID=a.AttachLink JOIN Manufacturer AS m on ManufacturerID=z.ManufacturerLink WHERE VideoLink=483 ORDER BY a.EditTime
SELECT a.VideoAttachID,m.Slug as MSlug,z.Name,z.Slug as ZSlug,a.AttachType FROM VideoAttach AS a JOIN Part AS z ON a.AttachType='Part' AND z.PartID=a.AttachLink JOIN Manufacturer AS m on ManufacturerID=z.ManufacturerLink WHERE VideoLink=483 ORDER BY a.EditTime
SELECT a.VideoAttachID,z.Name,z.Slug as ZSlug,a.AttachType FROM VideoAttach AS a JOIN Specs AS z ON a.AttachType='Specs' AND z.SpecsID=a.AttachLink WHERE VideoLink=483 ORDER BY a.EditTime
SELECT a.VideoAttachID,v.Slug as VSlug,v.Name,a.AttachType FROM VideoAttach AS a JOIN Video AS v ON a.AttachType='Video' AND v.VideoID=a.AttachLink WHERE VideoLink=483 ORDER BY a.EditTime
[Add Video]
Manufacturer List