Skip to main content

sql


#阅读时间问题排查
SELECT * FROM reward_log WHERE tal_id = 'TalowMniCMV4EiiHXjT6XdqbXA' and action = 'reading-time' ORDER BY `id` DESC

SELECT * FROM xes_reading_plat.xes_ebook_user_reading_behavior WHERE tal_id = 'TalowMniCMV4EiiHXjT6XdqbXA' and reading_create_time <= '1723710999' and reading_create_time >= '1723710699' ORDER BY `id` DESC

,SUM(reading_time)