SELECT ad_id, seller_id, manuf_model, image_name, sold_date, post_date from adsdetail WHERE (status = 'P' or status = 'A') and style = 'TAB' and tr_sw = 'N' ORDER BY sold_date DESC, time_stamp DESC