Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) AS 'times', userid, name
- FROM main
- WHERE comedate <= DATE_SUB(CURDATE(),
- INTERVAL 5 DAY)
- GROUP BY userid ORDER BY times DESC LIMIT 0,2;
- SELECT * FROM details WHERE 1;
- select x.times,
- x.userid,
- x.name,
- d.age,
- d.location
- from
- (
- SELECT COUNT(*) AS 'times', userid, name
- FROM main
- WHERE comedate <= DATE_SUB(CURDATE(),
- INTERVAL 5 DAY)
- GROUP BY userid
- ) x
- left join details d
- on x.userid = d.userid
- select x.times,
- x.userid,
- x.name,
- d.age,
- d.location
- from
- (
- SELECT COUNT(*) AS 'times', userid, name
- FROM main
- WHERE comedate <= DATE_SUB(CURDATE(),
- INTERVAL 5 DAY)
- GROUP BY userid
- ORDER BY times DESC
- LIMIT 0,2
- ) x
- left join details d
- on x.userid = d.userid
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement