Please refrain from posting animated GIFs, memes, joke videos and so on in discussions other than those in the off topic area.
Dismiss this message to confirm your acceptance of this additional forum term of use.
You must be 16 or over
to participate in the Brickset Forum. Please read the announcements and rules
before you join.
Recent discussions • Categories
Is there a way to write custom queries directly in SQL?
I'm trying to build a fairly complex query from the the https://brickset.com/queries/add
page, but I can't seem to do it using the interface. As such, is it possible for me to write the query directly in SQL and then run it?
Specifically, I want to run a query like the following:
SELECT * FROM Sets WHERE (NumericSetNumber >= num-1 AND NumericSetNumber <= num-2)
OR (NumericSetNumber >= num-3 AND NumericSetNumber <= num-4) OR (NumericSetNumber >= num-5 AND NumericSetNumber <= num-6)
ORDER BY SortKey ASC;