Custom Designed Misc Gallery

2SELECT COUNT(*) FROM gallerymaster WHERE CDel='n' AND Category='misc' and CDel='n'Select CCode, Category, SCategory, CJlryImage, CJlryImage2, CJlryImage3, CJlryImage4, CJlryImage5, CJlryImage6, CJlryImage7, CJlryVideo, CJlryVideo2, CJlryVideo3, CJlryVideo4, CJlryVideo5, CDel from gallerymaster where CDel='n' and Category='misc' order by CCode desc OFFSET 0 ROWS FETCH NEXT 12 ROWS ONLY
 Misc - main
 Misc - view 1
 Misc - view 2
 Misc - view 3
 Misc - view 4
2SELECT COUNT(*) FROM gallerymaster WHERE CDel='n' AND Category='misc' and CDel='n'Select CCode, Category, SCategory, CJlryImage, CJlryImage2, CJlryImage3, CJlryImage4, CJlryImage5, CJlryImage6, CJlryImage7, CJlryVideo, CJlryVideo2, CJlryVideo3, CJlryVideo4, CJlryVideo5, CDel from gallerymaster where CDel='n' and Category='misc' order by CCode desc OFFSET 0 ROWS FETCH NEXT 12 ROWS ONLY
 Misc - main