{"body":"            my $data = $sql->select_list_of_lists(\n               'SELECT (cover_art_url ~ \\'^https?://.*.images-amazon.com\\')::int AS is_amazon, COUNT(*) FROM release_coverart\n                  WHERE cover_art_url IS NOT NULL\n                    AND NOT EXISTS (\n                      SELECT TRUE FROM cover_art_archive.cover_art ca\n                        JOIN cover_art_archive.cover_art_type cat ON ca.id = cat.id\n                      WHERE ca.release = release_coverart.id AND cat.type_id = 1)\n                GROUP BY is_amazon'\n            );\n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/VMxjrDIx","modified":1627926071,"id":"VMxjrDIx","size":551,"lines":9,"own_paste":false,"theme":"","date":1627926071}