SELECT cs_status, uid,tid,imgurl,attachment,`from`,ctime,lasttime,lastuid,subject,`status`,draft,essence,view,zan,old,count_reply,views_android,views_ios,views_web,fave,ordertime,comment,third_party_type,third_party_nameid,mark,score1 as score,textlength, dynamicyear, defaultscore FROM {{article_subject}} WHERE tid = 759663
SELECT * FROM {{article_post}} WHERE tid = 759663
SELECT DISTINCT oid,noessence FROM {{article_destination_relation}} WHERE tid = 759663
SELECT id,title,theorder FROM {{column}} WHERE id in (100718)
SELECT DISTINCT a.tagid,a.name FROM {{article_tag}} a,{{article_tag_relation}} b WHERE b.tid = 759663 AND a.tagid = b.tagid
SELECT destination,expire, islisttop FROM {{article_top}} WHERE tid = 759663 AND expire > 1722085191 ORDER BY ctime DESC
SELECT count(*) FROM {{follows}} WHERE uid=1379820 AND `status` = 1
SELECT count(*) FROM {{follows}} WHERE fuid=1379820 AND `status` = 1
SELECT * FROM {{article_operation}} WHERE tid = 759663 ORDER BY ctime DESC
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(1379820) ORDER BY id DESC
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 759663
SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE (l.classify = 'articleinfoimage' OR l.classify = 'articleandliveinfoimage') AND l.starttime <= 1722085191 AND l.endtime > 1722085191 AND lc.cid IN (100718) ORDER BY l.`order`, l.starttime DESC
SELECT related FROM {{article_related}} WHERE tid = 759663
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 759663
SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE l.classify = 'articlerelated' AND l.starttime <= 1722085191 AND l.endtime > 1722085191 AND lc.cid IN (100718) ORDER BY l.`order`, l.starttime DESC
SELECT lc.id as tagid, lc.name as tagname, lc.synopsis as tag_dcp, '' as tag_img FROM {{city_index_associated}} cia INNER JOIN {{inode}} lc ON cia.aid=lc.id WHERE cia.cid = 100718 AND cia.`type`='wenda' AND cia.`status` = 1
此文章暂无评论