cdateadded desc--select catalogid,ccode,cname,cprice,ccategory,cdescurl,features,cimageurl,cstock,weight,mfg,pother1,pother2,pother3,subcategoryid,retailprice,specialoffer,category,buttonimage,cdateavailable,allowusertext,pother4,pother5,userid,keywords,template,extendedimage,selectlist,level3,level4,level5,minimumquantity,supplierid,crossselling,hide,productmatch,customermatch,excustomermatch,orderattachment,orderdownload,groupfordiscount,clanguage,points,pointstobuy,price2,price3,billprice,billinstallments,billinstallmenttype,billinterval,maximumquantity,frontpage,inventoryproducts,taxfree,freeshipping,highercatalogid,spdisplaytype,hassubproduct_v9,impressions,cdateadded,cdateupdated,templatelisting,extraimage1,extraimage2,extraimage3,extraimage4,extraimage5,featuredflag,featuredflagorder,customerimage,rmadays,producttype,youtube,movie,productmetatitle,variants,smfrequency,smpriority,gsmincluded,loggedin,proprocatdisplaycategoryid,bundleproidqty,featuredflag2,featuredflagorder2,cdateend,largeextendedimage,largeextraimage1,largeextraimage2,largeextraimage3,largeextraimage4,largeextraimage5,displayproducttab,tapcaption,ccost,gtin,gpf_variant_color,gpf_variant_size,gpf_variant_pattern,gpf_variant_material,gpf_variant_brand,gpf_variant_agegroup,gpf_variant_gender,gpf_category,gpf_variant_color_manual,gpf_variant_size_manual,gpf_variant_pattern_manual,gpf_variant_material_manual,gpf_variant_brand_manual,has_variant,parent_product_id,variant_show_individual,option1_value,option2_value,option3_value,layout_type_id,sub_product,variant_sku,product_label,variant_default,mpncode,brandname,sd_headline,sd_sku,sd_mpn,sd_brand,upsell,pstfree,s_fb_pub,realstock,loc_uae,loc_us,loc_pak,hassubproduct, cast(productmetakeyword as ntext) as productmetakeyword, cast(productmetadescription as ntext) as productmetadescription, cast(cdescription as ntext) as cdescription, cast(extendeddesc as ntext) as extendeddesc, cast(tapdescription as ntext) as tapdescription, cast(sd_message as ntext) as sd_message from products where CatalogId In (9990,9983,9967,9944,9955,9930,9931,9905,9916,9865,9859,9841,9850,9833,9832) order by cdateadded desc