Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
select top 10 com.id, Text, reputation from comments com LEFT JOIN users u on u.id = com.id where reputation > 1000;