FIX:
1052: Column 'products_id' in group statement is ambiguous; select count(*) as total from

I hope this is final

More...