It seems that I am not the only person who sometimes writes "Jeff Attwood" instead of "Jeff Atwood" by mistake. stackexchange.com/search?q=attwood chat.stackexchange.com/search?q=attwood

Is this a mistake which a native English speaker wouldn't do?

The Wikipedia page Atwood (surname) does mention both forms, although Attwood is less frequent.

In particular, I am not really sure what you mean when you're asking whether you can access comments to that deleted question.

I assume you see this comment: math.stackexchange.com/questions/3695691/…

> Note that contra your title, $\omega_{\bf Set}$ is not a category but a functor.

Hi!

Yes. I have a problem I have asked some question which had comment below it in this sense "user122424 has 3000+ reputations so this seems possible" I'm not sure about the exact wording of the first part but I'm sure that there was the word "possible" I have visited all occurrences from your link, but none is the right one. I thought for a moment that that mine question has been deleted but this is also not the case. So I'm a bit confused where that question has gone.

You're sure that it was on Mathematics (on the main site)?

Did you check the recent comments in the responses tab of your profile?

@user122424 If you're entirely sure that the comment was posted on the main site and that it contained the word possible, this shows that either the comment was deleted, or the question was deleted. (Since it cannot be found through SEDE.)

Of course, if the word possible was misspelled, then we can only guess what to search for.

But since you say that it was definitely in June or July, the easiest way to check whether such comment still exists on the main site is, in my opinion, to check your responses tab.

Maybe you might have luck in checking your global inbox, but I am not really sure whether the comments which were later deleted stay there.

Just in case: Does global inbox have a separate url and page? This should be the link to the global inbox: stackexchange.com/users/current?tab=inbox

But, as I said, I am not really sure whether deleted comments stay there.

Yes, I have checked the first 12 pages of my comments from your link. There are in total 43 of them. But I'm also checked all results from your other link which searched for id 122424 and the word "possible". None is the right one. I believe that the word was not misspelled. Could you please create form me a link which searches through tex.stackexchange.com comments for the id 122424 and the word possible ? This is the only idea I have. I cannot create that link by myslef, I do n

ot know how to do that. Thank you for your patience.

You can simply use the same link but change the site.

But keep in mind that your user id on TeX - LaTeX is different from Mathematics. Do you use a the same username there?

I have there user2925716 but now I'm sure that this is not the right thing to do: I do not have 3k+ reps there anyway.

No results for 122424+possible or 2925716+possible.

Yes I thought so. That's strange where that comment has disappeared.

If you want to use any queries for TeX rather than Math, you can simply change /math/ to /tex/ directly in the url. Or you can use the box called "Switch sites" and put the site there.

this mathstackexchange is the only site which is possible, I have no idea now and I have to give up the search for now.

There instances of the word possible under your posts on TeX - LaTeX: data.stackexchange.com/tex/query/1261691/…

Ok.

As far as I can tell, the comment you describe (under your post + containing the word possible) no longer exists. (And if it does, it's under a deleted post.)

Of course, it is possible that I might have dones something wrong in those queries.

But still, when you check the results, you can see that they really return the comments which fulfill the given requirements.

Yes, I think that the Only possibility is that the comment itself has been deleted!

It was an interesting way to try to search in the comments, BTW. can I create my own Sql query? OR where is the list of the possible queries to search in comments ?

Yes, you can create your own queries.

The tag-info for data-explorer contains some useful links, for example, a tutorial.

And you can see some existing queries to search in comments in the posts I linked to.

> This was suggested also in older similar posts on this meta such as: Searching comments or How to browse or search comments?. You can also check some posts on Meta Stack Exchange, such as: How can I search for specific comments? pr Can I search my comments using some keyword(s)?

And you can search among the existing queries: data.stackexchange.com/tex/queries?q=comments

the number 8297 ?

If you use the query without parameters it will use UserId=8297 and Word=chat: data.stackexchange.com/math/query/1261691/…

In the other words, I included 8297 as the default value of UserId - of course, it can be changed to other value as you have seen.

8297 is my UserId on Mathematics.

The condition (p.OwnerUserId=##UserId##) simply means to look only at posts where the Owner (posted) has the given Id.

So with UserId=8297 it only searches in the comments under my posts. With UserId=122434 only in the comments under your posts.

Please, can you have a look at this and tell me how do I search for WordB being from the string CreationDate instead of from the text of the comment?

@user122424 I am not really sure what you mean. CreationDate is not really a string, it's type is dateime.

Do you want to restrict somehow CreationDate when the comment was posted?

I need it that it contains 2020 as a substring.

yes

If you want to restrict the date, you can simply use lower and upper bound.

Like this: AND (c.CreationDate >= '##Date1?2019-01-01##') AND (c.CreationDate <= '##Date2?2020-01-01##')

Here is an example of such query: data.stackexchange.com/math/query/1262170

So in your case you probably want that it was posted in 2020.

You can use (c.CreationDate >= '##Date1##) AND (c.CreationDate <= ##Date2##) and simply use Date1=2020-01-01 and Date2=20201-01-01.

Of course, you probably could somehow convert CreationDate to string and then use it as a string. But this seems to be a more natural way.

Probably I should add a disclaimer that I do not know much about SQL. I have only learned a bit while using Mathematics - which lead to looking at various SEDE queries.

Time to get some sleep - it's getting late here.

Sorry that finding the comment you wanted did not work out.

Enjoy the rest of the weekend!

But I've learned a lot today, Thank you!