SQl query to extract data

[tiptop]

what query to extract customer name and customer email in two columns for active customers with group ID 16 and 15

whmcs support gave me , but it returning empty http://prntscr.com/i4g1cg

select concat(firstname, ' ', lastname) as name, email from tblclients where status = 'Active' and groupid in (15,16);

 

[Ben_H]

I have tested the SQL Query in my install of WHMCS and it works fine when I change the group IDs to be mine so the query is valid. Are you sure that the IDs you are specifying are correct for your groups? These can be found at the end of the URL when editing a group or alternatively you can see the group IDs in the "tblclientgroups" table in the database.

[tiptop]

sorry I mean product group ID ,  not client group ID. How to fix it ?