tinytown sql 2

SELECT blocked_users.username
FROM blocked_users
WHERE blocked_users.username IN (?, ?);
--('testuser', '127.0.0.1')

SELECT
    items.id AS items_id,
    items.project_id AS items_project_id,
    items.lower_sequence_num AS items_lower_sequence_num,
    items.upper_sequence_num AS items_upper_sequence_num,
    items.datetime_claimed AS items_datetime_claimed,
    items.tamper_key AS items_tamper_key,
    items.username AS items_username,
    items.ip_address AS items_ip_address
FROM items JOIN projects ON projects.name = items.project_id
WHERE items.username IS NULL
    AND NOT (EXISTS (SELECT 1
        FROM items, items AS items_1
        WHERE
            items.project_id = items_1.project_id AND items_1.ip_address = ?
    ))
    AND projects.enabled = 1
    AND projects.min_version <= ?
    AND projects.min_client_version <= ?
ORDER BY random()
 LIMIT ? OFFSET ?;
--('127.0.0.1', 10, 4, 1, 0)

SELECT
    projects.name AS projects_name,
    projects.min_version AS projects_min_version,
    projects.min_client_version AS projects_min_client_version,
    projects.alphabet AS projects_alphabet,
    projects.url_template AS projects_url_template,
    projects.request_delay AS projects_request_delay,
    projects.redirect_codes AS projects_redirect_codes,
    projects.no_redirect_codes AS projects_no_redirect_codes,
    projects.unavailable_codes AS projects_unavailable_codes,
    projects.banned_codes AS projects_banned_codes,
    projects.body_regex AS projects_body_regex,
    projects.method AS projects_method,
    projects.enabled AS projects_enabled,
    projects.autoqueue AS projects_autoqueue,
    projects.num_count_per_item AS projects_num_count_per_item,
    projects.max_num_items AS projects_max_num_items,
    projects.lower_sequence_num AS projects_lower_sequence_num,
    projects.autorelease_time AS projects_autorelease_time,
    anon_1.queue_size AS anon_1_queue_size
FROM projects
LEFT OUTER JOIN (
    SELECT
        items.project_id AS project_id,
        COUNT(items.id) AS queue_size
    FROM items GROUP BY items.project_id
    ) AS anon_1 ON projects.name = anon_1.project_id
WHERE
    projects.autoqueue = 1
    AND projects.enabled = 1
    AND projects.min_version <= ?
    AND projects.min_client_version <= ?
    AND COALESCE(anon_1.queue_size, ?) < projects.max_num_items
    AND NOT (EXISTS (SELECT 1
        FROM items
        WHERE
            items.ip_address = ?
            AND items.project_id = projects.name))
ORDER BY random()
 LIMIT ? OFFSET ?;
--(10, 4, 0, '127.0.0.1', 1, 0)

SELECT EXISTS (SELECT 1
    FROM items
WHERE items.ip_address = ?) AS anon_1;
--('127.0.0.1',)