联系官方销售客服
1835022288
028-61286886
模板标签里面
标签解析:{list action=module module=news thumb=1 IN_glyx=1,12,13,14 order=updatetime} 查询解析: SELECT * FROM `dr_1_news` WHERE `dr_1_news`.`thumb`<>'' AND FIND_IN_SET (1, `dr_1_news`.`glyx`) AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC
glyx 为联动菜单格式,字段类型为 txt ,我手动改 int 出来结果也是一样
而 IN_id 出来的 SQL是这样的
标签解析:{list action=module module=news thumb=1 IN_id=1,12,13,14 order=updatetime} 查询解析: SELECT * FROM `dr_1_news` WHERE `dr_1_news`.`thumb`<>'' AND `dr_1_news`.`id` IN (1,12,13,14) AND `dr_1_news`.`status` = 9 ORDER BY `dr_1_news`.`updatetime` DESC