src/main/resources/mapper/flower/FlowerMarkupSpCgMapper.xml

@@ -17,7 +17,7 @@
        <if test="condition.weight != null">
            AND q.weight = #{condition.weight}
        </if>
        ORDER BY q.sort_by
        ORDER BY CASE WHEN q.parent_id IS NULL THEN 1 ELSE 2 END,q.sort_by, spcg.create_time
    </select>