- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
select orderheader.orderno, companyname, jobheader.jobdesc, section.title, orderheader.coverpagination, orderheader.textpagination, section.depth, section.width, sourcingbrands.branddesc, section.papertype, orderheader.completedate, CASE WHEN iscover = 1 THEN papergsm else '0' END AS [cover weight], CASE WHEN iscover = 0 THEN papergsm else '0' END AS [text weight] from section inner join orderheader on section.orderno = orderheader.orderno inner join customers.dbo.company on orderheader.customer = customers.dbo.company.coid inner join jobheader on orderheader.orderno = jobheader.orderno inner join binding on jobheader.orderno = binding.orderno inner join sourcingrequest on jobheader.jobno = sourcingrequest.jobno left outer join sourcingrequestxref on sourcingrequest.sourcingid = sourcingrequestxref.sourcingid left outer join sourcingpapermaster on sourcingrequestxref.paperid = sourcingpapermaster.paperid left outer join sourcingbrands on sourcingpapermaster.pbid = sourcingbrands.brandid where section.recordtype = 'ppe' and binding.recordtype = 'ppe' and orderheader.completedate > '2008-01-01' and binding.description not like '%guillotine%' and binding.description not like '%folder%' and binding.description not like '%sitma%'and binding.description not like '%pre stitch%' and jobheader.jobno = '7005' order by orderheader.completedate
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.