Dgirth
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
Thanks for the warning. In fact, these tables are not actually articles and comments, it's about things that I don't ever reach the 100_000'nds. Thank you very much Angelelz, taken down all your answers as reference notes 🙂 You're brilliant!
24 replies
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
I'll check that out, thanks! I suppose it might not be outrageous to add some boolean flag or count on the articles table for when there are comments perhaps. Making this query filter even easier
24 replies
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
oH, how would I do that?
24 replies
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
Alright, just feels wierd fetching articles from comments.
24 replies
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
yep
24 replies
DTDrizzle Team
•Created by Dgirth on 10/24/2023 in #help
Filter for articles with at least one comment
Thanks a lot, the first simple option worked fantasticly! I have a follow up question concerning the subquery option. When would this be a better option? Is it perhaps in conjunction with prepared statements or something? Having serveral options is fantastic but even better if I would get an understanding of when 🙂
24 replies