SELECT eis_brand_thread.*,eis_brand_goods.*,`eis_goods_images`.thumb as cover FROM eis_brand_thread LEFT JOIN `eis_goods_images` on `eis_goods_images`.good_id=`eis_brand_thread`.tid AND `eis_goods_images`.`sort_id`=127 ,eis_brand_goods WHERE eis_brand_thread.cid ='3' AND eis_brand_goods.tid =eis_brand_thread.tid ORDER BY eis_brand_thread.dateline DESC LIMIT 0,20
