G8able - Quarry

SQL

SET @username = 'Lapablo';
SET @actorId = (select actor_id from actor where actor_user=@username);

/*
SELECT *
FROM actor
WHERE actor_name = @userName
LIMIT 1;
*/

SELECT
    CASE
    	WHEN pt.ptrp_reviewed IS NULL THEN 'enqueue'
        ELSE 'unreview'
    END AS 'Action to take',
	/* COUNT(l.log_page) AS 'count', GROUP_CONCAT(l.log_page) AS 'page ids' /**/
    l.log_page /**/
FROM logging_userindex l
LEFT JOIN pagetriage_page pt
	ON pt.ptrp_page_id = l.log_page
WHERE l.log_actor = @actorId
AND l.log_type = 'pagetriage-curation'
AND l.log_action = 'reviewed'
AND EXISTS (
  SELECT 1
  FROM page pg
  WHERE pg.page_id = l.log_page /* Not deleted */
  LIMIT 1
)
/*
GROUP BY CASE WHEN pt.ptrp_reviewed IS NULL THEN 'enqueue' ELSE 'unreview' END /**/
SQL

Checking query status...
