蚂蚁cms 微信小程序 列表文章过期 文章最后信息

原始全显示
SELECT a.id, a.title, a.ifred, a.ifbold, a.begintime, a.catname, a.dir_typename, a.img_path, a.tel, a.contact_who, a.mappoint
               FROM `" . $db_mymps . "information` AS a
               WHERE " . $where . " AND a.upgrade_type != 2
               ORDER BY a.begintime DESC
               LIMIT " . $offset . "," . ($pagesize - $top_count);

原 排除0和2

1. SELECT a.id, a.title, a.ifred, a.ifbold, a.begintime, a.catname, a.dir_typename, a.img_path, a.tel, a.contact_who, a.mappoint
   
2.                FROM `" . $db_mymps . "information` AS a
   
3.                WHERE " . $where . " AND a.upgrade_type != 2
   
4.                AND NOT (a.activetime = 0 OR a.info_level = 2)
   
5.                ORDER BY a.begintime DESC
   
6.                LIMIT " . $offset . "," . ($pagesize - $top_count);

复制代码

1. SELECT a.id, a.title, a.ifred, a.ifbold, a.begintime, a.catname, a.dir_typename, a.img_path, a.tel, a.contact_who, a.mappoint
   
2.                FROM `" . $db_mymps . "information` AS a
   
3.                WHERE " . $where . " AND a.upgrade_type != 2
   
4.                ORDER BY
   
5.                    CASE
   
6.                        WHEN a.activetime = 0 OR a.info_level = 2 THEN 1
   
7.                        ELSE 0
   
8.                    END ASC,
   
9.                    a.begintime DESC
   
10.                LIMIT " . $offset . "," . ($pagesize - $top_count);

复制代码