MySQL不常用语句

。。。
GROUP BY

    nutr_scheme.id

ORDER BY

nutr_scheme.id NOT IN (SELECT scheme_id FROM nutr_user_default_scheme where user_id = 10036 AND is_delete = 0),

    drink_count DESC,

    nutr_scheme.id ASC

SELECT
    GROUP_CONCAT(NAME) AS ALL_NAME,
    `name`
FROM
    base_basedata
GROUP BY
    pid

COUNT(DISTINCT id) AS `count`

create_time >= UNIX_TIMESTAMP(now()-interval 120 second)

FROM_UNIXTIME(time_stamp, ‘%Y-%m-%d %H:%i:%S‘)