Skip to content

Instantly share code, notes, and snippets.

@double-beep

double-beep/post.js

Created July 15, 2020 13:19
Show Gist options
  • Save double-beep/029e446eff55605c74bbff10741cf1c4 to your computer and use it in GitHub Desktop.
Save double-beep/029e446eff55605c74bbff10741cf1c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
post.js
$.post(`/data/sql/queries/run?statement=SELECT+domain_id%2C+domain%2C+tp_count%2C+fp_count%2C+naa_count%2C+post_id+FROM+(%0D%0A++++SELECT%0D%0A++++++++spam_domains.id+AS+domain_id%2C%0D%0A++++++++spam_domains.domain+AS+domain%2C%0D%0A++++++++COUNT(DISTINCT+IF(posts.is_tp+%3D+1%2C+posts.id%2C+NULL))+AS+tp_count%2C%0D%0A++++++++COUNT(DISTINCT+IF(posts.is_fp+%3D+1%2C+posts.id%2C+NULL))+AS+fp_count%2C%0D%0A++++++++COUNT(DISTINCT+IF(posts.is_naa+%3D+1%2C+posts.id%2C+NULL))+AS+naa_count%0D%0A++++FROM+p_spam_domains+AS+spam_domains%0D%0A++++INNER+JOIN+p_posts_spam_domains+ON+spam_domains.id+%3D+p_posts_spam_domains.spam_domain_id%0D%0A++++INNER+JOIN+p_posts+AS+posts+ON+p_posts_spam_domains.post_id+%3D+posts.id%0D%0A++++GROUP+BY+spam_domains.id%0D%0A)+AS+domain_stats%0D%0AINNER+JOIN+p_posts_spam_domains+AS+posts+ON+domain_stats.domain_id+%3D+posts.spam_domain_id%0D%0AWHERE+posts.post_id+IN+(253196%2C+253197%2C+250317)&data_source=main`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment