SELECT * FROM {{column_relation}} WHERE colid IN (100004) AND classify IN ('belongx','belongd','belongs') SELECT * FROM {{column_relation}} WHERE colid IN (100511,100513,100515,100518,100521,100522,100523,100524,100525,100526,100527,100528,100533,100535,100538,100540,100543,100544,100545,100546,100548,100553,100554,100555,100556,100557,100558,100559,100560,100561,100570,100571,100569,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653) AND classify IN ('belongx','belongd','belongs') SELECT * FROM {{column_relation}} WHERE colid IN (100518,100521,100522,100523,100524,100525,100526,100527,100528,100533,100535,100538,100540,100543,100544,100545,100546,100548,100553,100554,100555,100556,100557,100558,100559,100560,100561,100569,100570,100571,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653,100533,100535,100538,100540,100543,100544,100545,100546,100548,100570,100571,100569,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653) AND classify IN ('belongx','belongd','belongs') SELECT * FROM {{column_relation}} WHERE colid IN (100533,100535,100538,100540,100543,100544,100545,100546,100548,100569,100570,100571,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653) AND classify IN ('belongx','belongd','belongs') SELECT count(DISTINCT tid) as count FROM {{article_destination_relation}} WHERE draft = 0 AND status = 1 AND oid IN (100004,100511,100513,100515,100518,100521,100522,100523,100524,100525,100526,100527,100528,100533,100535,100538,100540,100543,100544,100545,100546,100548,100553,100554,100555,100556,100557,100558,100559,100560,100561,100570,100571,100569,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653) SELECT DISTINCT tid,(fave * 10 + (view + views_android + views_ios + views_web) / 10 + zan * 20) AS hot FROM {{article_destination_relation}} WHERE draft = 0 AND status = 1 AND oid IN (100004,100511,100513,100515,100518,100521,100522,100523,100524,100525,100526,100527,100528,100533,100535,100538,100540,100543,100544,100545,100546,100548,100553,100554,100555,100556,100557,100558,100559,100560,100561,100570,100571,100569,100572,100573,100574,100575,100576,100577,100578,100579,100580,100581,100582,100583,100584,100585,100586,100587,100588,100589,100590,100591,100592,100593,100595,100596,100614,100616,100618,100619,100621,100646,100649,100653) ORDER BY ctime DESC LIMIT 0,30 SELECT a.dynamicyear, a.tid,a.attachment,a.count_reply,a.ctime,a.essence,a.fave,a.`from`,a.imgurl,a.lasttime,a.`subject`,a.type,a.uid,a.zan,(a.views_android+a.views_ios+a.views_web) as `view`,left(b.message,2500) as message ,(a.fave * 10 + (a.views_android + a.views_ios + a.views_web) / 10 + a.zan * 20) AS hot FROM {{article_subject}} a,{{article_post}} b WHERE a.tid IN(742117,789901,789761,789404,789151) AND b.tid = a.tid ORDER BY ctime DESC SHOW FULL COLUMNS FROM `pre_user_avatar` SHOW CREATE TABLE `pre_user_avatar` SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1 SELECT * FROM `pre_user_avatar` `t` WHERE uid=:uid LIMIT 1 SELECT l.id, lc.cid FROM {{ad_launch}} l RIGHT JOIN {{ad_launch_cid}} lc ON l.id = lc.launch_id WHERE (l.classify = 'article' OR l.classify = 'flowandarticle') AND l.starttime <= 1722054346 AND l.endtime > 1722054346 AND lc.cid = 100004 ORDER BY l.`order`, l.starttime DESC SHOW FULL COLUMNS FROM `pre_column` SHOW CREATE TABLE `pre_column` SELECT * FROM `pre_column` `t` WHERE `t`.`id`='100004' LIMIT 1 关于香港的游记/文章 - 十六番
登录 注册

游记/文章

写游记/文章
下载十六番手机客户端
返回顶部
下载App APP二维码
提交反馈
发送给十六番

用微信扫描此二维码即可联系16番

在微信中搜索“baume002”也可找到我们

微信反馈