SELECT tscustomcontentid,owner,tsaccount,tscontent,tspubuser,tsstate,tsdate FROM tscustomcontent WHERE (((owner=99) and (tsteatreeid=1042023)) and (tsstate=1)) and (tsstate<>-10) ORDER BY tscustomcontentid DESC