CF Puzzle Quest

Query Builder & Execution

Combine filters with: AND (all must match) OR (any can match)

Limit results: Order by NFT Number

SQL Query (SELECT only):

nft_number

name

image_filename

accessories

artifacts

background

body

coins

expression

eyes

hieroglyphs

keyword

mouth

has_transparency

is_burned

created_at

updated_at

Show NFT images in results (requires nft_number in query)

SELECT * FROM chia_friends ORDER BY nft_number;

SELECT * FROM chia_friends WHERE body LIKE '%Cactus%' AND eyes = 'Purple' ORDER BY nft_number LIMIT 10;

SELECT * FROM chia_friends WHERE artifacts IS NOT NULL AND artifacts != '' ORDER BY nft_number;

SELECT * FROM chia_friends WHERE background = 'Nighttime' OR background = 'Aurora & Stars' ORDER BY nft_number;

SELECT * FROM chia_friends WHERE body LIKE '%Timelord%' ORDER BY nft_number;

SELECT body, COUNT(*) as count FROM chia_friends GROUP BY body ORDER BY count DESC;

SELECT * FROM chia_friends WHERE has_transparency = TRUE ORDER BY nft_number LIMIT 20;

SELECT DISTINCT background FROM chia_friends WHERE background IS NOT NULL ORDER BY background;

SELECT * FROM chia_friends WHERE artifacts = 'XCH' ORDER BY nft_number;