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 = 789404
SELECT * FROM {{article_post}} WHERE tid = 789404
SELECT DISTINCT oid,noessence FROM {{article_destination_relation}} WHERE tid = 789404
SELECT id,title,theorder FROM {{column}} WHERE id in (100004)
SELECT DISTINCT a.tagid,a.name FROM {{article_tag}} a,{{article_tag_relation}} b WHERE b.tid = 789404 AND a.tagid = b.tagid
SELECT destination,expire, islisttop FROM {{article_top}} WHERE tid = 789404 AND expire > 1722050341 ORDER BY ctime DESC
SELECT count(*) FROM {{follows}} WHERE uid=1418676 AND `status` = 1
SELECT count(*) FROM {{follows}} WHERE fuid=1418676 AND `status` = 1
SELECT * FROM {{article_operation}} WHERE tid = 789404 ORDER BY ctime DESC
SELECT uid,mid FROM {{medal_relation}} WHERE uid IN(1418676) ORDER BY id DESC
SELECT * FROM {{article_attachments}} WHERE logid=789404 AND status=1
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 789404
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 <= 1722050341 AND l.endtime > 1722050341 AND lc.cid IN (100004) ORDER BY l.`order`, l.starttime DESC
SELECT related FROM {{article_related}} WHERE tid = 789404
SELECT DISTINCT oid FROM {{article_destination_relation}} WHERE tid = 789404
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 <= 1722050341 AND l.endtime > 1722050341 AND lc.cid IN (100004) 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 = 100004 AND cia.`type`='wenda' AND cia.`status` = 1
出海港城优惠券 - 3Kkkkkk - 十六番
此文章暂无评论