hackernews_dashboard_ask_and_show_by_hourhackernews_dashboard_ask_counthackernews_dashboard_avg_ask_scorehackernews_dashboard_avg_scorehackernews_dashboard_avg_show_scorehackernews_dashboard_max_scorehackernews_dashboard_mentionshackernews_dashboard_show_counthackernews_dashboard_stories_by_hourhackernews_dashboard_user_with_greater_than_50_scorehackernews_dashboard_user_with_greater_than_5_posthackernews_jobs_by_dayshackernews_jobs_by_technologyhackernews_jobs_by_typehackernews_jobs_searchhackernews_sources_detailhackernews_sources_domain_inputhackernews_sources_domainshackernews_sources_top_10_domains_by_counthackernews_sources_top_10_domains_by_max_scorehackernews_stories_avg_commentshackernews_stories_detailshackernews_stories_max_comments
Query: hackernews_sources_detail
Usage
powerpipe query hackernews_insights.query.hackernews_sources_detailSteampipe Tables
SQL
with stories as (  select * from hackernews_new where $1 = 'New'  union  select * from hackernews_top where $1 = 'Top'  union  select * from hackernews_best where $1 = 'Best')select  h.id as "ID",  h.by as "By",  to_char(h.time::timestamptz, 'YYYY-MM-DD HH24:MI:SS') as "Time",  h.score as "Score",  h.descendants as "Comments",  h.title as "Title",  h.url as "URL"from  stories hwhere  h.url ~ $2order by  h.score desc
Params
| Args | Name | Default | Description | Variable | 
|---|---|---|---|---|
| $1 | story_type | |||
| $2 | domain | 
Dashboards
The query is used in the dashboards: