SELECT YouIcons_cn.id,YouIcons_cn.icon_name,YouIcons.id,YouIcons.icon_type,YouIcons.icon_path FROM YouIcons LEFT JOIN YouIcons_cn ON YouIcons_cn.id = YouIcons.id WHERE icon_type like "monocolor" AND icon_path like "test/%" limit -62, 62

单色 : 测试

80 图标