Integrating COUNT() into a nested MySQL query
I'm working on Glowbug's admin side. One of the features I've wanted to add is for it to recommend existing tags which are similar to ones I've already entered into a post. I'm working on the query which will pull this info up and decided to turn to StackOverflow to see if there is a better way to do it than I am currently. We'll see what the responses say.
Update 9:15am - StackOverflow comes through and gives me the answer.
Jan. 6 committee concludes Trump violated multiple laws in effort to overturn election
The Jan. 6 select committee says its evidence has shown that then-President Donald Trump and his campaign tried to illegally obstruct Congress' counting of electoral votes and "engaged in a criminal conspiracy to defraud the United States."
In a major release of its findings, filed in federal court late Wednesday, the committee suggested its evidence supported findings that Trump himself violated multiple laws by attempting to prevent Congress from certifying his defeat.
"The Select Committee also has a good-faith basis for concluding that the President and members of his Campaign engaged in a criminal conspiracy to defraud the United States," the committee wrote in a filing submitted in U.S. District Court in the Central District of California.
As I posted this morning, I had began work on a feature for the admin panel on Glowbug. I now have a first implementation of suggested tags for posts on the blog. As I add a tag to a post the system looks for tags used on other posts which have that tag, and then suggests them as possible tags for the post I'm working on.
It's rudimentary, but it's a start. Eventually I'll improve the system with some smarter logic.
Sure sounds like Russia is in for a world of hurt
Fascinating thread from Prof. Maxim Mironov on what sanctions are likely to mean for the Russian economy.
— Dmitry Grozoubinski (@DmitryOpines) March 2, 2022
"My scientific conclusion... is that the Russian economy is fucked. Double fucked, because most Russians don't know what's coming."
Image is my amateurish translation. https://t.co/VHyIfveC9a pic.twitter.com/wdmGDQHegY