http://www.youtube.com/v/bT1c8J7G0_g&hl=en&fs=1
http://www.youtube.com/v/YE6VucDVAnM&hl=en&fs=1
http://www.youtube.com/v/JXXiWP3nSII&hl=en&fs=1
http://www.youtube.com/v/RdYD9d0YiBA&hl=en&fs=1
ตอนที่1 - http://www.youtube.com/watch?v=bT1c8J7G0_g
ตอนที่2 - http://www.youtube.com/watch?v=YE6VucDVAnM
ตอนที่3 - http://www.youtube.com/watch?v=JXXiWP3nSII
ตอนที่4 - http://www.youtube.com/watch?v=RdYD9d0YiBA
Credit...http://phoenix-29.hi5.com
select T2.*,T3.RawName,T4.*,T5.* from dbo.CMSJobsProduction T1
inner join dbo.CMSJobDetailsProduction T2 ON T1.JobId = T2.JobId
inner join CMSRaw T3 ON T2.RawId = T3.RawId
inner join dbo.CMSJobDetailsListProduction T4 ON T4.JobDetailId = T2.JobDetailId
inner join CMSCookFile T5 ON T5.FileTypeQualityId = T4.FileTypeQualityId AND T5.RawId = T3.RawId
where
ListStatus = 0 AND T5.CONTENT_CODE = T2.CONTENT_CODE and T5.CookFileSize > 0
and CookFileDescription is not null and T5.ModifiedByUserId = 10