SELECT id, name, family, mobile, COUNT(mobile) as tt FROM `user_login` where deleted=0 GROUP BY `mobile` HAVING tt > 1; SELECT user_id, COUNT(user_id) as tt FROM `tarh` WHERE finished = 1 GROUP BY `user_id` HAVING tt > 1 ORDER BY `tt` DESC
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter