Charcoal HQ

ArtOfCode

3:00 PM

@Rubiksmoose not quite

if there's a spam domain in review with the same ID as a post, you'll get that joined

Rubiksmoose

shucks

hmmm ok...

ArtOfCode

you want LEFT JOIN p_review_items r ON p.id = r.reviewable_id AND r.reviewable_type = 'Post'

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in answer (1): How to add float or decimal field using declarative schema in magento 2? by Matías on magento.SE

Rubiksmoose

@ArtOfCode ah I see. so if there was a post 176 and also a post with metasmoke.erwaysoftware.com/domains/176 they would be mistakenly joined and it would appear as a row in my output?

metasmoke

naa- feedback received

ArtOfCode

3:04 PM

@Rubiksmoose kinda

Rubiksmoose

XD well good enough I guess. I don't expect you to have to teach me SQL101.

thesecretmaster

guides.rubyonrails.org/…

Nice picture of what's happening ^^

ArtOfCode

you're expecting to only get review_items joined where they're for a post, but you never specified that, so you could get two review_items joined - one for a post with ID 176, and one for a spam domain with ID 176

Rubiksmoose

@ArtOfCode oh so there would be two rows output on my table then? I think?

@thesecretmaster I think this helps. I appreciate it! I'm trying to digest it at least

metasmoke

fp feedback received on [MS] tooltip box not showing using css

fp feedback received on [MS] Difference between control plane, data plane and management plane?

Rubiksmoose

3:09 PM

oh ignore doesn't count as completing a review item alone?

I guess it wouldn't given 2 feedbacks needed

metasmoke

naa feedback received on [MS] Java Fx Splash screen with spring boot

fp feedback received on [MS] laravel 5.4 upload image

fp feedback received on [MS] What is the regex to extract all the emojis from a string?

fp feedback received on [MS] ModuleNotFoundError: No module named 'readline'

fp feedback received on [MS] How to install Generic / Text Only printer on Raspberry pi 4 with Windows 10

naa feedback received on [MS] Italian keyboard: entering the tilde (~) and backtick (Italian keyboard: entering the tilde (~) and backtick () characters without changing keyboard layout

naa feedback received on [MS] Android Studio Image Asset Editor missing after update

fp feedback received on [MS] How can I mining a lot of bitcoins?

fp feedback received on [MS] How to learn dynamic web designing and animations with animated images?

Makyen/EC2-num02: Executing automatic scheduled reboot.

[ SmokeDetector ] SmokeDetector started at rev 309b3dd (Makyen: The metasmoke user needs to not be doing autoflagged FP, for now.) (running on Makyen/EC2-num02, Python 3.6.12)

naa feedback received on [MS] Converting Domain name to Company Name?

naa feedback received on [MS] How to add icon to AppBar in Flutter

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in title (1): What is digital marketing agency? by Digital Marketer on codegolf.SE

metasmoke

tp feedback received on [MS] How to add icon to AppBar in Flutter

tpu- feedback received

naa feedback received on [MS] Can not generate signed apk

fp feedback received on [MS] How to convert small areacodes into lat and longitude or vice versa

fp feedback received on [MS] C# Need to convert a Zebra Image ^GFA String to PNG

fp feedback received on [MS] iphone UISearchBar Done button always enabled

fp feedback received on [MS] Assistace with validating data before inserting to DB

fp feedback received on [MS] Fatal error: cannot create 'R_TempDir' when starting Linux R as user but not as root

fp feedback received on [MS] is staff is not updating in Django-allauth custom signup form

naa feedback received on [MS] How to use pagination in laravel 5?

fp feedback received on [MS] how to avoid damaging controller during UART communication

fp feedback received on [MS] C# Need to convert a Zebra Image ^GFA String to PNG

tp feedback received on [MS] Reverse engineer a javascript website with Python

naa feedback received on [MS] Best way to save trip histor/lat/long for a fleet management company?

tp feedback received on [MS] easter_date() in JavaScript

fp feedback received on [MS] Fluid Measurements when using z-index

tp feedback received on [MS] Fixed page header overlaps in-page anchors

Rubiksmoose

!!/bisect monetizingonline.com

SmokeDetector

@Rubiksmoose 'monetizingonline.com' is not caught by a blacklist or watchlist item.

metasmoke

3:23 PM

tp feedback received on [MS] How do I learn to trade stocks?

fp feedback received on [MS] Open a partition of disk in c

naa feedback received on [MS] Open a partition of disk in c

fp feedback received on [MS] How to show the id of the button when hover over it

fp feedback received on [MS] Razor Pages Page Handler not passing ID with POST method

SmokeDetector

[ SmokeDetector | MS ] Potentially problematic ns configuration in body (1): Как авторизоватся на сайте с вордпресс с помощю python? by Ahmedov Temir on stackoverflow.com

Rubiksmoose

@SmokeDetector "Authorization on the site is implemented with the help of WP Recall. How do I log into the site nspi.uz with requests? How to implement it?"

SmokeDetector

[ SmokeDetector | MS ] Link at end of answer (61): Como ejecutar cron con phantomjs? by Luciano Rodriguez on es.stackoverflow.com

metasmoke

fp- feedback received on [MS] Как авторизоватся на сайте с вордпресс с помощю python?

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): How to calculate quantity with product price in cognito forms? by Parth Patel on stackoverflow.com

metasmoke

3:26 PM

fp- feedback received on [MS] Como ejecutar cron con phantomjs?

Rubiksmoose

@SmokeDetector "It depends on the system you use, if you use linux / unix systems, the command to list a cron is probably crontab -l and contab -e respectively, and to generate the line you could use something like"

metasmoke

fp- feedback received

naa feedback received on [MS] angular 9, not load chunk file in ie11

fp feedback received on [MS] I want the follower key to be true too... in my mutual friend query

fp feedback received on [MS] How to read files from a partition and access to different tables in FAT32

naa feedback received on [MS] Is there anyway of converting c# function to sql server stored procedure?

fp feedback received on [MS] 2D array will not print correctly, the x value prints but the y value doesn't

fp feedback received on [MS] How to make a basic Media player to play a video in avi format?

tp feedback received on [MS] JQuery Datatables Ajax dynamic columns

tp feedback received on [MS] How to show zero rate value of shipping class in cart page "WooCommerce"

Rubiksmoose

!!/bisect talkforweb.com.au

SmokeDetector

@Rubiksmoose Matched by talkforweb\.com\.au on line 3670 of blacklisted_websites.txt

Rubiksmoose

excellente

metasmoke

3:32 PM

fp feedback received on [MS] This is a dynamically allocated 2d array, I can't figure out why the column won't print but the row does?

fp feedback received on [MS] My dynamically allocated 2d array will print the row but not the column value

fp feedback received on [MS] How do I print the the response from Chrome Developer Tools onto my UI?

fp feedback received on [MS] How to read files from a partition and access to different tables in FAT32

fp feedback received on [MS] Page Redirection after Form submit

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): Startup and Shutdown order of WSO2 Components by Saah on stackoverflow.com

metasmoke

naa feedback received on [MS] How to setup sub domain like blogspot or shopify with docker architecture?

fp- feedback received

fp feedback received on [MS] Dynamic Value for Pinterest Tag for Conversion from WooCommerce

fp feedback received on [MS] How to scrape bandcamp album description in python?

tp feedback received on [MS] how can i increment variable by 1 each time in php?

fp feedback received on [MS] Update PWA with firebase

fp feedback received on [MS] How do I count the number of divs with a specific class using selenium

fp feedback received on [MS] My dynamically allocated 2d array will print the row but not the column value

fp feedback received on [MS] Page Redirection after Form submit

fp feedback received on [MS] Detecting finger type with mantra fingerprint sensor

fp feedback received on [MS] My dynamically allocated 2d array will print the row but not the column value

naa feedback received on [MS] Displaying Windows command prompt output and redirecting it to a file

fp feedback received on [MS] Trying to create a virtualenv in python and activate it

fp feedback received on [MS] C# Change A Button's Background Color

fp feedback received on [MS] Deploy gMSA account as task scheduler user account

fp feedback received on [MS] selenium library not recognize by docker while it is added by poetry

fp feedback received on [MS] My published app on google play shows an android file when users download it. How can i fix this?

naa feedback received on [MS] Uipath(RPA) : swap the two columns in excel

fp feedback received on [MS] how to scramble words in sentence using C# and put in into array

fp feedback received on [MS] CUDA Compatibility for GPU

fp feedback received on [MS] Creating a single scatter plot with data from multiple data sets

fp feedback received on [MS] django form.as_p no longer rendering for seemingly no reason

fp feedback received on [MS] check if user has already installed PWA to homescreen on Chrome?

fp feedback received on [MS] Woocommerce product addon (how to limit checkbox selections?)

fp feedback received on [MS] How to align a logo to right in WordPress?

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in username (1): Inserting something using ajax in PHP by Jack Sparrow on stackoverflow.com

metasmoke

fp- feedback received

fp feedback received on [MS] check if user has already installed PWA to homescreen on Chrome?

fp feedback received on [MS] Fluid player shortcode not working in my wordpress dooplay theme 2.4.1

SmokeDetector

[ SmokeDetector | MS ] Potentially problematic ns configuration in answer (1): How do audio engineers (physically) treat rooms for studios? by Polka1 on sound.SE

metasmoke

3:43 PM

fp- feedback received

fp feedback received on [MS] php script using too much memory and returning fatal error

fp feedback received on [MS] Button on Wordpress with Elementor Builder

fp feedback received on [MS] Is there any way to clear Local storage Using Server side code such as c# etc

naa feedback received on [MS] Can any body able to see offline sqlite db data from apk using android studio in flutter?

fp feedback received on [MS] Install packages behind proxy using saltatack

fp feedback received on [MS] Changing slave address of mlx90614 with bcm2835 via SMBus / I2C

fp feedback received on [MS] Nginx and php authentication with m3u hls

fp feedback received on [MS] GUI for linux c

fp feedback received on [MS] How to get resource ID and dump file in Adroid Project from assets in C++ builder

fp feedback received on [MS] Install packages behind proxy using saltatack

naa feedback received on [MS] C# Selenium Web driver: Not able to select value from dropdown

fp feedback received on [MS] How can I save my data from textbox to database?

fp feedback received on [MS] How to download video from M3u8 file?

SmokeDetector

[ SmokeDetector | MS ] Blacklisted username (90): Finding the radius of a sphere plus volume by 96 94 on math.SE

metasmoke

tpu- feedback received

Rubiksmoose

@SmokeDetector network troll

I put a custom flag up, so others can feel free to redflag it if they wish

metasmoke

fp feedback received on [MS] Remove specific part of the file Name for all files from the all windows drive. Using Windows 10 || Command Line

SmokeDetector

[ SmokeDetector | MS ] Link at end of answer, potentially bad asn for hostname in answer, potentially bad keyword in answer (63): Infinite Gradle Build Running Java 8 by KIRA OFFICIAL on stackoverflow.com

Spevacus

3:55 PM

@SmokeDetector k Translates to: "mine is also loading in the build grandle infinite and it takes too long to install android studio today. (link)" Link leads a website advertising online TV show streaming, presumably.

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): What do I need to buy for this turntable to work in UK? by Eleanor on travel.SE

[ SmokeDetector | MS ] Bad ip for hostname in body, blacklisted website in body, potentially bad ns for domain in body (200): What are best tips for playing dungeons and dragons role-playing game by Niku Jena on rpg.SE

metasmoke

tpu- feedback received

fp- feedback received on [MS] What do I need to buy for this turntable to work in UK?

SmokeDetector

[ SmokeDetector | MS ] Shortened url in answer, blacklisted user (127): Is sous vide better for lean meat or fatty meat? by Best Review Review on cooking.SE

[ SmokeDetector | MS ] Potentially bad keyword in body, potentially bad keyword in title (2): Digital Marketing and Project Management by Luna on workplace.SE

metasmoke

fp- feedback received on [MS] Digital Marketing and Project Management

tpu- feedback received

SmokeDetector

[ SmokeDetector | MS ] Potentially bad ns for domain in body, potentially bad keyword in body (2): Any suggestion for a SharePoint based CMS are welcomed by Nancy R. Vinci on sharepoint.SE

metasmoke

4:06 PM

tp feedback received

fp feedback received on [MS] How do you call on an attribute of a class, as if its a variable (in python)?

naa feedback received on [MS] How to hide div in a re usable component in react js?

fp feedback received on [MS] integrate an external website to be opened in my subdomain

fp feedback received on [MS] attachment field in MS Access

fp feedback received on [MS] why does my binary search is not working properly

tp feedback received on [MS] Cannot open xls file with C# service

fp feedback received on [MS] Get Local Machine IP Address in PHP

fp feedback received on [MS] Trouble Displaying a Binary Image From Node to Angular to Browser

fp feedback received on [MS] SignalR does not work in Firefox and IE but Chrome

fp feedback received on [MS] App Store Connect Operation error. App Icon Xcode swift

fp feedback received on [MS] about Artifactory license update

fp feedback received on [MS] jdbc.SQLServerException: The "variant" data type is not supported

fp feedback received on [MS] How to integrate stripe payment gateway to asp.net mvc

fp feedback received on [MS] Best Practice how to fetch data initially and update it later on using React Hooks etc.?

tp feedback received on [MS] Listing all possible combination without repetition,VBA

tp feedback received on [MS] Agent Xps getting disabled automatically

tp feedback received on [MS] SQL Agent shows "SQL Agent XPs Disabled" but they are not

Rubiksmoose

!!/bisect itsedupoint.com

SmokeDetector

@Rubiksmoose 'itsedupoint.com' is not caught by a blacklist or watchlist item.

Rubiksmoose

!!/watch itsedupoint\.com

SmokeDetector

@Rubiksmoose You don't have blacklist manager privileges, but I've created PR#4847 for you.

metasmoke

PR#4847 ("Rubiksmoose: Watch itsedupoint\.com") opened by SmokeDetector

tp feedback received on [MS] Automate Magento Image Optimization

fp feedback received on [MS] JS screen record and live on localhost

fp feedback received on [MS] Uncaught TypeError: Cannot read property 'length' of undefinedhttp://localhost:3000/search/ on chrome

SmokeDetector

4:16 PM

[ SmokeDetector | MS ] Potentially problematic ns configuration in body (1): Как авторизоватся с помощю python? by Ahmedov Temir on ru.stackoverflow.com

metasmoke

fp feedback received on [MS] I got Syntax Error but ALL My Syntax in right?

fp- feedback received

Rubiksmoose

@SmokeDetector "Website nspi.uz authorization is implemented using wp recall. just with requests I can't write a bot that visits the site every day with my data help !!!"

metasmoke

fp feedback received on [MS] Deserialize OData Response

fp feedback received on [MS] how use tqdm with loop lines file

naa feedback received on [MS] Arduino Analog pins interrupt

Mast

!!/watch- melhorsite\.xyz

SmokeDetector

[ SmokeDetector ] Blacklists reloaded at rev 90567b6 (SmokeDetector: Auto watch of melhorsite\.xyz by Mast) (running on teward/Osiris)

metasmoke

4:21 PM

fp feedback received on [MS] I have an issue in my website learnmitra.com, dropdown menu not working

fp feedback received on [MS] Error with Plumber API deployment in Digital Ocean via R | Authentication with ssh server failed

fp feedback received on [MS] Access issues within the same package?

fp feedback received on [MS] PHP blocking website access by country

SmokeDetector

[ SmokeDetector | MS ] Bad keyword with email in answer, messaging number in answer, pattern-matching email in answer (275): How to find most commented article (using disqus) by Coa on stackoverflow.com

[ SmokeDetector | MS ] Link at beginning of body, mostly non-latin body, mostly non-latin title (211): شركة القيصر لتكنولوجيا المعلومات by alkaysarcom on meta.SE

metasmoke

tpu- feedback received on [MS] How to find most commented article (using disqus)

naa feedback received on [MS] Mongoose: How do I run a collection.find() for multiple TYPES of queries, one of which includes keyword searching?

tpu- feedback received

Robert Columbia

@SmokeDetector k

Rubiksmoose

@SmokeDetector "t is an official company with a legal entity holding a commercial registration No. 16705. The Caesar Company was established to be the leader in the field of information technology, hence the name of the Caesar, due to its leadership in the field of information technology. The company was established and its divisions increased with a team of qualified engineers ..."

metasmoke

fp feedback received on [MS] How To Increment Values in Java

naa feedback received on [MS] ESP8266, Client connect via Ticker

fp feedback received on [MS] How to get traceid details in Kafka(2.3.3 verison) Batch Listener in Spring Boot

naa feedback received on [MS] Displaying Windows command prompt output and redirecting it to a file

fp feedback received on [MS] Unable to access the table header data

fp feedback received on [MS] sending input values to controller using @url.action method

fp feedback received on [MS] is it possible to combine two apis from different .net core solutions under the same swagger portal as different documentation entries?

fp feedback received on [MS] PHP Api Curl post fields problem with authentication

fp feedback received on [MS] What is the difference between a Relational and Non-Relational Database?

tp feedback received on [MS] How do I protect my software with licenses?

Robert Columbia

4:41 PM

@SmokeDetector k

metasmoke

naa feedback received on [MS] Using Pynput to type into discord

fp feedback received on [MS] i am facing error while running uipath bot related to Excel

fp feedback received on [MS] Conditional html element only displaying temporarily

fp feedback received on [MS] Dynamic PHP Pagination Mysqli

fp feedback received on [MS] How to update RSS Feed update every 5 seconds in Python using Flask

SmokeDetector

[ SmokeDetector | MS ] Mostly non-latin answer (49): click links though javascript by عبدالكريم حيص on stackoverflow.com

metasmoke

naa- feedback received

Rubiksmoose

@SmokeDetector "This site looks a little good but it is beautiful and wonderful"

sd n

Daniel Widdis

beautiful and wonderful.

Rubiksmoose

4:44 PM

hahaha how nice!

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body (1): if statement for scanner inputs in java by Moe on stackoverflow.com

Rubiksmoose

@DanielWiddis but only a little good

metasmoke

fp- feedback received

tp feedback received on [MS] Etymology of 急須

Rubiksmoose

@metasmoke tpu-

metasmoke

fp feedback received on [MS] 'Invalid Column Name' Error After Upgrading from Asp.net core 2.0 to 2.1

naa feedback received on [MS] How do you convert a DataTable into a generic list?

fp feedback received on [MS] Passing variables rather than hard coded data to paypal buy now button

fp feedback received on [MS] Don't know how to deobfuscate this part

fp feedback received on [MS] Stripe how to cancel other recurring charges when user buys new one

naa feedback received on [MS] Video Poker probability

fp feedback received on [MS] network connection with ip adress from a vm

fp feedback received on [MS] How can I stop my kid uninstall parental control app from her iphone?

fp feedback received on [MS] Displaying Windows command prompt output and redirecting it to a file

fp feedback received on [MS] Want to validate if a element text in selenium test ng matches a particular patter

fp feedback received on [MS] Getting the appid included in the Record URL(Dynamic) in a Dynamics 365 email workflow

naa feedback received on [MS] gorm`gorm get id for update

tp feedback received on [MS] How does $e^x\cdot e^X$ equal $e^{x+X}$?

fp feedback received on [MS] Converting text to speech using Python

fp feedback received on [MS] Snowflake migration issues -- schema, indexing, etc

fp feedback received on [MS] Calling a function that requires a parameter in a for loop overwrites the parameter in python

fp feedback received on [MS] Cross section of two cones

naa feedback received on [MS] How does the Fourier Series relate to Orthogonality?

fp feedback received on [MS] Selenium ChromeDriver - Run in background but not headless

fp feedback received on [MS] How does the equation $15x^2-7y^2=1$ give $y^2 \equiv 2 \, (\textup{mod}n\,)$

fp feedback received on [MS] How do I unit test a controller that is decorated with the ServiceFilterAttribute, custom ActionFilter implementation

fp feedback received on [MS] Is it haram to accidentally "masturbate"?

tp feedback received on [MS] Xcode 10, Command CodeSign failed with a nonzero exit code

tp feedback received on [MS] is it possible to recover deleted photos from Android (internal memory)? without root permissions

tp feedback received on [MS] Sitemap generators-unable to generate sitemap

tp feedback received on [MS] Design site map page

tp feedback received on [MS] Is our death decided before our birth?

SmokeDetector

4:53 PM

[ SmokeDetector | MS ] Link at beginning of answer (32): Can you link an audio track to a video track in iMovie? by WROCLOVE87 on video.SE

Robert Columbia

@SmokeDetector k

SmokeDetector

teward/Osiris: Executing automatic scheduled reboot.

Rubiksmoose

!!/bisect shopefe.blogspot.com

metasmoke

naa- feedback received

SmokeDetector

[ SmokeDetector ] SmokeDetector started at rev 90567b6 (SmokeDetector: Auto watch of melhorsite\.xyz by Mast) (running on teward/Osiris, Python 3.6.9)

Restart: API quota is 9807.

Rubiksmoose

4:55 PM

hey, don't ignore me :P

!!/bisect shopefe.blogspot.com

SmokeDetector

@Rubiksmoose Matched by shopefe\.blogspot on line 21832 of watched_keywords.txt

metasmoke

naa feedback received on [MS] Nested ifs or ands?

Spevacus

You asked Smokey to do something while it was taking a catnap. If anything, you shouldn't disturb it while it sleeps!

Rubiksmoose

My sincere apologies Smokey! I didn't realize that I interrupted the few seconds of napping you get.

metasmoke

fp feedback received on [MS] bower generates es6 export format Uncaught ReferenceError: angular is not defined

fp feedback received on [MS] How can i upload images without waiting user to upload images Laravel

naa feedback received on [MS] How to convert a Python library from Python2 to Python3

fp feedback received on [MS] TikTok: Chinese app may be banned in US, says Pompeo

fp feedback received on [MS] Angular 7 - *ngFor not iterating properly and not considering de-structured object

fp feedback received on [MS] Which BI tools can easily generate correct queries when combining multiple fact tables on shared dimensions?

fp feedback received on [MS] Stripe how to cancel other recurring charges when user buys new one

Transcript for