CRT Queries: Difference between revisions
Create Advanced Queries page with SMW query examples (via create-page on MediaWiki MCP Server) |
No edit summary Tag: Manual revert |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__{{DISPLAYTITLE:Advanced CRT Queries}}'''This page showcases advanced queries''' powered by [https://www.semantic-mediawiki.org/ Semantic MediaWiki] (SMW). Every CRT model in the wiki stores its specs — screen size, brand, inputs, outputs, mods, and more — as structured semantic properties. That means we can ask the wiki surprisingly specific questions and get live, always-up-to-date answers. | ||
{{DISPLAYTITLE:Advanced CRT Queries}} | |||
'''This page showcases advanced queries''' powered by [https://www.semantic-mediawiki.org/ Semantic MediaWiki] (SMW). Every CRT model in the wiki stores its specs — screen size, brand, inputs, outputs, mods, and more — as structured semantic properties. That means we can ask the wiki surprisingly specific questions and get live, always-up-to-date answers. | |||
These queries run against real data in the wiki, so as new models are added and existing ones are updated, the results here update automatically. | These queries run against real data in the wiki, so as new models are added and existing ones are updated, the results here update automatically. | ||
| Line 8: | Line 5: | ||
''Want to learn more about writing your own queries? See the [https://www.semantic-mediawiki.org/wiki/Help:Inline_queries SMW inline queries documentation].'' | ''Want to learn more about writing your own queries? See the [https://www.semantic-mediawiki.org/wiki/Help:Inline_queries SMW inline queries documentation].'' | ||
== | == Running your own queries == | ||
You can play around with SMW queries using the built-in query interface at [[Special:Ask]], or try copying the below example queries to [[Special:MyPage/Sandbox|your sandbox]]. | |||
== Example Queries == | |||
=== S-Video over RCA cables === | |||
Forget about [[Mini-DIN-4]] - which CRTs let you do [[S-Video (Y/C)]] over two [[RCA (connector)|RCA]] cables? | |||
{{#ask: | |||
[[Has video signal format::S-Video (Y/C)]] | |||
[[Has connector type::RCA (connector)]] | |||
[[Has CRT model::+]] | |||
|?Has CRT model.Has image#100px;x100px=Photo | |||
|?Has CRT model.Has brand = Brand | |||
|?Has CRT model.Has model code=Model | |||
|?Has CRT model.Has screen size inches = Screen Size | |||
|format=broadtable | |||
|headers=plain | |||
}} | |||
=== Largest PAL widescreen === | |||
What's the largest widescreen (16:9) CRT that can decode PAL? | |||
{{#invoke:SMWUtils|findAllWithMax | |||
|conditions=[[Has aspect ratio::16:9]][[AV system::PAL]] | |||
|maxProperty=Has screen size inches | |||
|mainlabel=Model | |||
|printouts=Has image#100px, Has brand, Has screen size inches, AV system | |||
|headers=Photo, Brand, Screen Size, AV Systems | |||
}} | |||
=== Smallest with component video === | |||
Which CRT with a component video (YPbPr) input has the smallest screen? Useful for finding compact sets that still accept higher-quality analog signals. | Which CRT with a component video (YPbPr) input has the smallest screen? Useful for finding compact sets that still accept higher-quality analog signals. | ||
| Line 15: | Line 46: | ||
|conditions=[[Has video signal format::Component (YPbPr)]] | |conditions=[[Has video signal format::Component (YPbPr)]] | ||
|minProperty=Has CRT model.Has screen size inches | |minProperty=Has CRT model.Has screen size inches | ||
|printouts=Has CRT model, Has CRT model.Has brand | |printouts=Has CRT model.Has image#100px, Has CRT model, Has CRT model.Has brand | ||
|headers=Model, Brand | |headers=Photo, Model, Brand | ||
}} | }} | ||
== Largest | === Largest with S-Video === | ||
On the flip side — what's the biggest screen you can get with an S-Video input? Great for finding large-format sets for retro gaming. | On the flip side — what's the biggest screen you can get with an S-Video input? Great for finding large-format sets for 🚨 retro gaming 🚨. | ||
{{#invoke:SMWUtils|findAllWithMax | {{#invoke:SMWUtils|findAllWithMax | ||
|conditions=[[Has video signal format::S-Video (Y/C)]] | |conditions=[[Has video signal format::S-Video (Y/C)]] | ||
|maxProperty=Has CRT model.Has screen size inches | |maxProperty=Has CRT model.Has screen size inches | ||
|printouts=Has CRT model, Has CRT model.Has brand | |printouts=Has CRT model.Has image#100px, Has CRT model, Has CRT model.Has brand | ||
|headers=Model, Brand | |headers=Photo, Model, Brand | ||
}} | }} | ||
Hold on. Well, ''of course'' the world's largest CRT would show up for that query. 🤦♂️ Let's try it again, this time excluding that specific model: | |||
{{#invoke:SMWUtils|findAllWithMax | |||
|conditions=[[Has video signal format::S-Video (Y/C)]][[Has CRT model::!Sony PVM-4300]] | |||
|maxProperty=Has CRT model.Has screen size inches | |||
|printouts=Has CRT model.Has image#100px, Has CRT model, Has CRT model.Has brand | |||
|headers=Photo, Model, Brand | |||
}} | |||
That's better! Models that are actually obtainable. 👍 | |||
[[Category:Special pages]] | [[Category:Special pages]] | ||
