Query - DeiUmTempo

Query.SQL

SELECT 
       PROFILES.ID AS profile_id,
       USUARIO.ID AS ID_USER,
       USUARIO.NICKNAME,
	     USUARIO.BIRTHDAY,
       USUARIO.GENDER,
       DATE(USUARIO.CREATED_AT)      AS CREATED_AT,
       USUARIO.EMAIL,
       USUARIO.NAME                  AS NOME_USR,
       PLANO.DURATION,
       PLANO.NAME                    AS PLAN_NAME,
       PLANO.STATUS                  AS PLAN_STATUS,
       JORNADA.ID                    AS JOURNEY_ID,
       JORNADA.NAME                  AS VERTICAL,
       DATE(JORNADA_USER.STARTED_AT) AS STARTED_AT,
       MERITO.ACTIONABLE_TYPE,
       MERITO.NAME                   AS TIPO_MERITO,  
       MERITO.AMOUNT                 AS MERITO,
       ODS.STATUS                    AS STATUSORDER,
       PROFILES.AGE,
       PROFILES.CITY,
       PROFILES.DESCRIPTION,
       PROFILES.OCCUPATION,
       PROFILES.BIRTHDAY             AS PROFILES_BIRTHDAY,
	   ROUNDS.TITLE AS ROUND_TITLE,
	   PR.completed_at,
	   PR.completed_at_day,
	   PR.STEP_ID,
	   PR.STATUS,
	   PR.day_id
	   	   
FROM   USERS USUARIO -- TABELA DE USUARIOS
      
INNER JOIN JOURNEYS_USERS JORNADA_USER -- JORNADA DO USUARIO
             ON USUARIO.ID = JORNADA_USER.USER_ID
      
INNER JOIN PLANS PLANO -- PLANO DO USUARIO
             ON JORNADA_USER.PLAN_ID = PLANO.ID
     
INNER JOIN JOURNEYS JORNADA -- NOME DA JORNADA
             ON PLANO.JOURNEY_ID = JORNADA.ID
      
LEFT JOIN ORDERS ODS
             ON USUARIO.ID = ODS.USER_ID   

LEFT JOIN MERITS MERITO
             ON USUARIO.ID = MERITO.USER_ID
	         AND  JORNADA_USER.JOURNEY_ID = MERITO.JOURNEY_ID

INNER JOIN PROFILES
             ON USUARIO.ID = PROFILES.USER_ID 
			  
INNER JOIN ROUNDS
			ON JORNADA.ID = ROUNDS.JOURNEY_ID
			AND JORNADA_USER.JOURNEY_ID = ROUNDS.JOURNEY_ID
			
INNER JOIN PROGRESSES PR
			ON ROUNDS.ID = PR.ROUND_ID
			AND USUARIO.ID = PR.USER_ID
              
WHERE USUARIO.NICKNAME IS NOT NULL
AND USUARIO.CREATED_AT >=  CURRENT_DATE - INTERVAL '6 months'

Query_RedeSocial.SQL

SELECT

DATE(USUARIO.CREATED_AT)  AS CREATED_AT,
USUARIO.NICKNAME,
USUARIO.EMAIL,
P.TITLE  AS TITULO_POST,
P.STATUS AS STATUS_POST,
P.CONTENT,
C.BODY CORPO_COMENTARIO,
C.REACTIONS_COUNT QTD_REACTIONS,
C.COMMENTABLE_TYPE TIPO_COMENTARIO,
R.INTERACTABLE_TYPE TIPO_INTERACTION,
P.CREATED_AT AS DATA_POST

FROM USERS  USUARIO
	
	LEFT JOIN POSTS P	
			ON USUARIO.ID = P.USER_ID
	
	LEFT JOIN COMMENTS 	C
			ON P.USER_ID = C.USER_ID
	
	LEFT JOIN REACTIONS R
			ON P.USER_ID = R.USER_ID


WHERE USUARIO.NICKNAME IS NOT NULL