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 , `category` c where  d.`status` ='1'  and d.`comic_id` = ii.`comic_id` and ( ac.`author_id` = '3393                  ' and ac.`comic_id` = d.`comic_id` ) and (c.`comic_id` = d.`comic_id` and c.`category_id` = '3' )  ORDER BY d.`sort_order`  DESC  LIMIT 0,20;