SELECT DISTINCT `table-id` , `date` , `raw-name` , `amount`…

SELECT DISTINCT `table-id` , `date` , `raw-name` , `amount`, `label` FROM `transactions` LEFT JOIN labels ON `transactions`.`table-id` = `labels`.`transactionId` WHERE (`label` IS NULL OR `label` <> ‘_archived’) AND `table-id` NOT IN ( SELECT DISTINCT `ta

^