［SQL语句］

SELECT title,url,description,catid,id FROM `qdnzzb_2020` . `yzm_article` WHERE status = '1' AND FIND_IN_SET(2,flag) AND id not in (0) ORDER BY inputtime DESC LIMIT 1;

SELECT title,url,thumb,catid,id FROM `qdnzzb_2020` . `yzm_article` WHERE thumb <> '' AND FIND_IN_SET(4,flag) AND `status`=1 AND id not in (0,20228) ORDER BY id DESC LIMIT 5;

SELECT title,url,description,catid,id,inputtime FROM `qdnzzb_2020` . `yzm_article` WHERE `status` = 1 AND id not in (0,20228,20326,20295,20291,20234,20233) ORDER BY inputtime DESC LIMIT 9;

SELECT catid,catname FROM `qdnzzb_2020` . `yzm_category` WHERE `status`=1 AND `display`=1 AND catdir = "tongzhigonggao" LIMIT 1;

SELECT title,url,description,catid,id,inputtime FROM `qdnzzb_2020` . `yzm_article` WHERE `status`=1 AND id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327) AND catid = 16 ORDER BY inputtime DESC LIMIT 9;

SELECT catid,catname,arrchildid FROM `qdnzzb_2020` . `yzm_category` WHERE `status`=1 AND `display`=1 AND parentid = 0 ORDER BY listorder asc LIMIT 6;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (1,2,3,8,9,10,23,156,157,158,159,160,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (15,16,17,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,48,49,50,51,77,78,79,80,81,82,83,84,85,86,87,88,89,120,121,122,123,125,126,127,128,129,130,131,132,133,134,135,162,163,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (161,7,11,12,13,14,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,70,72,73,74,75,76,100,101,102,103,104,152,153,154,155,164,165,166,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (67,68,69,71,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT a.title,a.url,a.id,a.catid,a.inputtime,c.catname FROM `qdnzzb_2020` . `yzm_article` a LEFT JOIN yzm_category as c ON c.catid = a.catid WHERE a.`status`=1 AND a.id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) AND a.catid in (90,18,19,24,25,26,91,92,93,94,0) ORDER BY a.inputtime DESC LIMIT 7;

SELECT title,url,thumb,catid,id FROM `qdnzzb_2020` . `yzm_article` WHERE thumb <> '' AND FIND_IN_SET(4,flag) AND `status`=1 AND id not in (0,20228,20326,20295,20291,20234,20233,20344,20343,20341,20340,20339,20337,20336,20330,20327,20262,20167,20160,20087,19700,19167,18428,18752,18129) ORDER BY id DESC LIMIT 7;

SELECT catid,catname,catdir FROM `qdnzzb_2020` . `yzm_category` WHERE (parentid = '0' AND status = '1' AND display = '1') ORDER BY listorder asc;

SELECT title,image,url,typeid,status FROM `qdnzzb_2020` . `yzm_banner` WHERE `status` = 1 AND typeid=3 ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT typeid FROM `qdnzzb_2020` . `yzm_link` GROUP BY typeid;

SELECT url,logo,name FROM `qdnzzb_2020` . `yzm_link` WHERE typeid=0;

SELECT url,logo,name FROM `qdnzzb_2020` . `yzm_link` WHERE typeid=1;

SELECT url,logo,name FROM `qdnzzb_2020` . `yzm_link` WHERE typeid=2;

［其他信息］

服务器信息：Microsoft-IIS/7.5

会话ID：

框架版本：2.2 查看新版