SELECT points,
       transactions,
       reputacao,
       medalha,
       main_cat,
       ticket_medio,
       ranking_vendas,
       ranking_faturamento,
       (SELECT Count(*) + 1
        FROM   apiuser
        WHERE  main_cat = main.main_cat
               AND vendas_mes > main.vendas_mes)   ranking_vendas_categoria,
       (SELECT Count(*) + 1
        FROM   apiuser
        WHERE  main_cat = main.main_cat
               AND fat_mes > main.fat_mes)         ranking_faturamento_categoria
       ,
       reclamacao,
       (SELECT Avg(reclamacao)
        FROM   apiuser
        WHERE  id IN (SELECT id
                      FROM   apiuser
                      WHERE  main_cat = main.main_cat
                      ORDER  BY ranking_vendas ASC
                      LIMIT  1000)
               AND reclamacao IS NOT NULL)         reclamacao_categoria,
       (SELECT Avg(reclamacao)
        FROM   apiuser
        WHERE  reclamacao IS NOT NULL
               AND ranking_vendas < 1000)          reclamacao_ml,
       registrationdate,
       cancelamentos,
       fat_rep,
       vendas_rep,
       (SELECT Extract('epoch' FROM media_envios)) media_envios,
       (SELECT Extract('epoch' FROM ((SELECT Sum(vendas_mes * media_envios) /
                                             Sum(
                                             vendas_mes)
                                      FROM   apiuser
                                      WHERE  main_cat = main.main_cat
                                             AND media_envios > '00:00:00'))))
                                                   media_envios_categorias,
       (SELECT Extract('epoch' FROM (SELECT Sum(vendas_mes * media_envios) / Sum
                                            (
                                            vendas_mes)
                                     FROM   apiuser
                                     WHERE  media_envios > '00:00:00')))
                                                   media_envios_ml
FROM   (SELECT *
        FROM   apiuser
        WHERE  id = '161480535') AS main;