ctc-catalogue: pencil_puzzles: 8 rows where Constraints contains "Star Battle" and Solver contains "Simon" sorted by Id descending

Pencil puzzle-solving (excluding sudoku) videos from CTC.

Data source: Cracking the Cryptic Catalogue · About: View on GitHub

8 rows where Constraints contains "Star Battle" and Solver contains "Simon" sorted by Id descending

descending

Id ▲	Puzzle Title	Date	Solver	Type	Setter	Constraints	Video	Video Length	Video Length (Minutes)
6416	3 in 1	2024-09-28	Simon	Fillomino	Peter Veenis	LITS, Multi-Stage, Star Battle	Three Puzzles In One 9x9 Grid	00:44:53	45 min
6190	LITS Battle	2024-07-19	Simon	LITS	Kyle McCormick	Star Battle	The Return Of Star Battle!	01:07:00	67 min
5988	Snake Egg/Star Battle	2024-05-18	Simon	Snake Egg	JinHoo Ahn	Star Battle	The Art Of Puzzles	00:52:42	53 min
3292	Star Battle (Fillomino Construction)	2022-06-22	Simon	Fillomino	au voleur!	Star Battle	To Infinity And Beyond!	00:38:27	39 min
2641	Star Nurikabe?	2022-01-07	Simon	Nurikabe	BenceJoful	Star Battle	The Perfect Pencil Puzzle	00:28:59	29 min
1784	Pentominous Star Battle	2021-03-09	Simon	Pentominous	Jesper Josefsson	Star Battle	A Staggering Puzzle Mash-Up	01:00:57	61 min
1410	Moon, Sun or Star?	2020-09-12	Simon	Moon-or-Sun	Volatility	Star Battle	The Puzzle Of The Popular Vote	00:38:12	39 min
1297	A Birthday Present	2020-07-21	Simon	Skyscrapers	Prasanna Seshadri	Cipher, Gaps, O/E, Star Battle	A Birthday Present Puzzle	00:37:30	38 min

Advanced export and query

This data as json, CSV

JSON shape: default, array, newline-delimited, object

✎ View and edit SQL