SELECT d.`comic_id`,d.`title`,d.`title2`,d.`comic_market_id`,d.`remark`, d.`cover_version` , ii.`ext` ,  d.`score` as score ,  d.`turnout` as turnout , d.`num_fav` as favorite FROM `comic` d  `image_info` ii , `author2_comic` ac where  d.`status` ='1'  and d.`comic_id` = ii.`comic_id` and ( ac.`author_id` = '12895' and ac.`comic_id` = d.`comic_id` )  ORDER BY d.`sort_order`  DESC  LIMIT 0,20;