请在这里录入广告位信息

［SQL语句］

SELECT title,url,color,inputtime FROM `mjjz_gde3f_com` . `wxy_article` WHERE status=1 AND FIND_IN_SET('4',flag) ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT title,description,url,color,thumb FROM `mjjz_gde3f_com` . `wxy_article` WHERE status=1 ORDER BY listorder ASC,id DESC LIMIT 4;

SELECT title,updatetime,url,color FROM `mjjz_gde3f_com` . `wxy_article` WHERE status=1 AND catid IN (1,2,3) ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT title,updatetime,url,color FROM `mjjz_gde3f_com` . `wxy_article` WHERE status=1 AND catid=2 ORDER BY listorder ASC,id DESC LIMIT 10;

SELECT title,thumb,url,color FROM `mjjz_gde3f_com` . `wxy_article` WHERE status=1 AND thumb != '' ORDER BY listorder ASC,id DESC LIMIT 8;

SELECT id,tag,total,remarks FROM `mjjz_gde3f_com` . `wxy_tag` ORDER BY listorder DESC LIMIT 27;

SELECT FROM_UNIXTIME(inputtime, '%Y年%m月') AS pubtime, count(*) AS total,inputtime FROM `mjjz_gde3f_com` . `wxy_article` WHERE `status`=1 GROUP BY FROM_UNIXTIME(inputtime, '%Y年%m月') ORDER BY pubtime DESC LIMIT 10;

SELECT url,logo,name,isnofw FROM `mjjz_gde3f_com` . `wxy_link` WHERE status = 1 ORDER BY listorder ASC, id DESC LIMIT 20;

［其他信息］

服务器信息：nginx/1.22.1

路由信息：模块( index )，控制器( index )，方法( index )，参数( 无 )

框架版本：2.0 查看新版