 Good morning, everyone. Hello. How are you, Alesh? Fine. Fine. Good afternoon. Sorry, in Aleshland over there. It's afternoon in Europe. Afternoon in Europe, yes. Alesh owns all of Europe, so that's Aleshland. Anyway, so we have a beautiful sunny day here in my little corner of Ontario, Canada. Is it sunny over there? No, it's cloudy. It's preparing to rain, but it just doesn't start. It was forecasted, but probably later. Yeah, I see. Well, good morning to everyone who is here live and in the chat. So we've got Julie Ann and Vicky from Chile. Tricia, Stephanie, Susie, Azure's here. Excellent. Oh, and Stephanie's sunny in the Guernsey, in the Channel Islands. Very cool. Very cool. So, and hello, oh, now we're up to 11 people all together and hopefully we'll get a few more. And hello to everyone who's watching this after the fact on Replay. So, welcome to you all. Before we start with, we actually had some answers to the questions this month, which is excellent. Before we get to those, though, Julie was the first one in and she asked a question and I think I kind of need to, if Julie, if you're still here, she said she had some weak internet, so she may not be still with us. She may have had to drop off. But her first question is, is it an app, a tool to help save my research on computer devices? How does it work? How do I get it? So it sounds like Julie Ann might be a first time watcher. So if you are Julie or if anyone who is here for the first time, this monthly segment that we do, Ask Alesh Anything, Alesh is basically the brains behind the servers at WikiTree and keeps everything running smoothly. And in particular, he has created this platform called WikiTree Plus, which allows you to dig deep into the data that is in WikiTree. And any of the profiles that are public, you can actually query them and find specific ones. And if you watched some of the previous ones, we went through some of the basics of using the tabs along the left side there, so you can see suggestions on profiles that need improvements. Or if you're just doing a general search, that's the second tab, the Alesh has opened his screen sharing right now. And there's so much power there, you can search by many different criteria. And we'll be going through different examples of that today as well. So you're welcome. It's not a standalone app that works in your browser. There is not an app version of it, but it does work in any browser, mobile or desktop, laptop, computer. It's a, it's, as you can see, the displays are our table. So, you know, on a phone, that may not show up nice as nice, unless you maybe if you put your phone in landscape portion, you can use it. But it's probably more comfortable to use it on a tablet or an actual laptop or desktop computer. Anyways, that's, you just need to replace the www into plus in front of wikitree.com. That's right. Yes. That's the easiest way to get there. Yes. If you see, if you're on any page that has this wikitree plus symbol on it, so like in the left hand corner, top left of the screen that you see right now, that's the wikitree plus symbol. So any page on that will take you to here, but you're right. The easiest way to get to it is just type plus dot wikitree.com and that'll take you right there. So that's, that's sort of that in a nutshell. And Vicky has asked a question and maybe, do we want to handle Vicky's question first or do you want to go through some of the work? You can. Yeah. Okay. That's one of the advantages of being here live. You get to, you get to ask your question first because what if Vicky had to go somewhere, you know, and then she missed the answer, that wouldn't be fair. So we'll start with Vicky's question and other people, if you have questions in the chat, please put them here and we will answer them. So Vicky's question is, good morning, Alessia and Greg. Good morning, Vicky. I've always wondered, I'm guessing it's wondered, not wondered, but unless her, I mean, she and her ancestors may be wandering the hills, but she's, I've wondered which of my ancestors connected all of us to the big tree. Is there a timestamp for the connection to the tree so that we can get in and in wiki tree plus? So she's just like me. Like I remember, I think I remember, which great, great grandfather it was that connected me to the tree because all of a sudden I went to Adam and said he was there and he was and then boom, there I was connected. So I kind of, that was a memorable moment for me. But if you got connected, if you got connected or someone else did the connecting and you didn't actually realize how or why that happened, this would be an interesting question. Is there any way to tell? No. I mean, until you are poorly connected, so you have only one link to the global tree, there you can actually see by which path you are connected because it's not necessary the ancestor, it can be a spouse or someone from your uncle or whatever. But until you have only one connection, you can kind of trace it and see up to where you did the tree and from where on it was the existing one. But you can, once you have more connections, then some are from through on one, done on one path, some on the other. So you can really tell where you get connected. So and this would be, I mean, you had to monitor this while you were, before you were connected. And once you connect, you will see that first path to the tree. And afterwards it can get kind of messy. It's hard to tell which one is right, which one was sooner and so on. But you can get disconnected like I did. Yes. Yes. Are you still disconnected? No, no, I'm already connected. They were quick. So did you make it? No, connectors did on Monday already. I was connected again through on another path. So a group of volunteers on which tree connected for you. Yeah. Isn't that great? Well, that's fantastic news. Fans. You have a lot of fans. Fans. Yes, you do. Well, I'm very glad to hear that. Well, because that would have been very sad if you have remained unconnected to the global tree. So I hope that answers your question, Vicki, as much as it can. So depending on how well connected you are, if you only have a single line, then there might be a way to follow the timestamps for that. But if you're well connected, then it's trickier. And let's see. Did you take a quick scan of the chat? People are sharing the weather, mostly nice weather, it looks like. Here's a question from Trisha. I want to know what Alessia's been working on and thinking about as far as apps go. Now, that sounds like a best question. Yeah. And I was just yesterday, I was going through the browser extension and I got I got 10 ideas of what to do. I shared them in this court. So I don't know if someone else will try to do some of those. I will probably make a few, a few do require collaboration between me and a developer. We'll see what will be done. But I did actually yesterday go through the extension and see what could be improved. So if you are on this court, you can see that or probably I will prepare a document and you can also look it on Hacktoberfest Hangouts. Right. And speaking of Hacktoberfest, starting tomorrow, every Thursday during the month of Hacktober, I'll be hosting a live cast starting at 1 p.m. Eastern Standard Time, which would be, what would that be? Five for you or six? I think six or seven. It was quite late last year. I usually did it from home. Right. Yeah. So, well, let's see. This is not, what time is it there? Right now. Now it's three o'clock. Okay. So it's four hours later. So it'd be seven. So seven. Yeah. Anyways, one of the things, so this first Thursday, because we've just started the month and many of us were involved in the sourceathon. So we haven't started an earnest and program release. I haven't started an earnest in the programming. So this first week, we're going to be basically talking about what things we are planning on working on. And if Alessia's there, then he can share some of those 10 ideas. And if he's not, I've got the discord. So I will share his, and we'll talk more about that too. So Trisha, join us tomorrow. One o'clock Eastern time or what would that be? Five used UTC in 20, 28 hours, right? Yes, in 28 hours. What a timer for 28 hours. I usually use a relative time to now because that way I can make all those calculate 20. Okay. So Trisha question, what skills are needed? Oh, for, for using WikiTree Plus or for Hacktoberfest? For Hacktoberfest, you can be a programmer and help out with that. Or you can be a tester and WikiTree user. And because we need, we need people to test out things that we do because they might make sense to us in our brains, but they may not make sense to or you can just express your wishes or just live and someone will write it maybe. That's right. Yeah. It could be an idea that none of us, once you say it out loud with that, oh, why didn't I think of that? That's an X. I can program that. And then it takes five times longer than you think I will take and it'll be done. Good at wishing. Excellent. Okay, then. Well, let's, you've got the page right up there for Ask Alesh. Why don't we tackle those? Okay. So first question was how to, was how to find all project, all profiles managed by the project that don't have additional project manager. So again, it's done, it can be done on WikiTree Plus. So you can search for WikiTree 9, which is their WikiTree ID. And we get 3000 profiles that are managed by the project. And then we can simply add the SQL statement. So this is a special, the new type of querying, WikiTree. And here, this expression limits, oh, actually, this is the, here we have to put equals one. So where the, we have only one manager on the profile. So now we got 900 profiles that are managed by WikiTree 9 and have only one manager. Now we could also here put equals two, and we will get, we would get the profiles with two managers and so on. So, or that have more than five managers, for instance. That's awesome. We have four managers. Yeah, of course. Wow. Here you have the list. There's a list. Wow. Talk about too many cooks in the kitchen. Equals one was, this was the original question. I can post the, on WikiTree Plus, when you find a query that is actually what you want, the URL always changes to represent that. So now if I take this URL and open a new type, paste this query, it will open the WikiTree Plus and pre-fill the edit boxes on the left. So you just need to click get profiles and you will get the same result. So this can be used wherever you need. So let's If you have a clipboard and you had a section in the clipboard just for SQL queries, you could once you find one that works, yeah, save them there. That would be a good, you know what, I'm thinking that would be a good free space page to just store some of these SQL queries that we highlight on this live cast so that people can come back. Well, I can get from my log files all SQL queries that I've ever done on WikiTree Plus. Wow. Because there's so, I mean, I'm sure it's a long list, yeah. But some of the, I mean, I would never, you would never guess or I would never guess the syntax for that, like with the fact that you have a, yeah, well, this SQL part is here, you could directly do whatever my program can do on the fields, but we have a lot of fields in this table. So if I can actually show it. So for instance, this is the layer and okay, this is just, okay, all these are the fields. So this is just the base dataset. And then you have a list for children, all the data for spouses, marriage. So we have several hundred fields are in this layer. So here we were looking at the manager part. So now we use this little section of all the fields. So, and I don't, I have no intention of documenting. No, no, no, no, that's just so much. So you can always ask and I will prepare the SQL, provide the SQL query for that. Sounds good. Excellent. Okay, that was the first question. That was the first one. Good one. Good question. So, oh, I do, I had a question. So the person who asked the question, who was that? Bobby? Yes, question, Bobby. Bobby knew that the Mayflower Projects wiki tree ID was wiki tree 9. How would you, how would you, how do you know the wiki tree ID for a project? How would you find that out? It's usually on the project page. Oh, I've never even noticed that before. Okay. So data doc doctors. Oh, there's a, if you hover, if you go up the top there, you know, it has the scissors for the ID and stuff. Yes. Now this is just for the page, not the associated account. I don't know. Usually it is somewhere on the project page where actually we can search for mine. It's minute. Okay. But I have a list of all projects. So if you are on the list, if you are on data doctors page, you can go to, for instance, here would be the best in project reports. Here are actually all the wiki tree ID and projects listed that do manage the profiles. So wiki tree nine is number nine. So here is there. So on this page, you will get, you can get all the wiki tree IDs for all projects. Okay. And the data doc is interesting. Okay. That's good to know. Very cool. Okay. Then next one was, was, was. So the next one, let me, okay, let me, so is this the one from Alan? Alan, yes. Yeah. Okay. So what's the total number of unidentified, unsourced profiles on wiki tree and how many of those profiles as a percentage represent persons who were definitely born after 1700 and who are now deceased? So this is the question that he asked last time. So you, or you provided some SQL last time to help him solve it. He'd like to further, and he gave you the original unsourced country and then with an SQL there. He wants to improve it by receiving only profiles where both parents are named to aid in the census lookups and the possible baptism. So he doesn't want ones where the parents aren't named. So they have unnamed name or they don't have parents? Probably. Both parents are names. I guess that means they have both parents. Not just with names. With names. Okay. Well, we can, I think, okay, let's go with what we found last time. Yeah, start with that. So starting with that. Un sourced countries, England, region is Cheshire. And no date. Well, he, the example he gave was 1820. So he was going specific. Aha, with specific date. Okay. So we have 15. Okay. Just 35 profiles, but one possibility would be to show, to here select show relatives and you will get for each profile all the relatives. So you can see first, this is the first result. He has a spouse and five children. So no parents. So no parents. Here is the same. And this one has a mother and mother with Jonathan and Hannah. So this would be the easy solution to see immediately in the list. This one has only mother and so on. So I guess I would go with this. Yeah, I've never hit that box before because this looks beautiful. This is the way you set this up, this page. Yeah. I mean, it shows the, it's the same as, so these are the results and for each profile, then you get a new family. So yeah, perfect. If you need to check something, search the ones without children or so on, you can do. It's wonderful here easily. Okay. So that's one way of doing it. Is there? Yeah. Well, you could again do the extend the query. Right. But again, I have to check for that. So here I would search for, I think I have something like parents, siblings, father, mother. Okay, we could go father. If he, if the profile has a father, so we can, we can use this bigger than zero. Okay, this would be Roots, Berry. Let's go back. So here in SQL, we would help to put an end. Okay. Father, it has a father. So let's and it's only, actually we can leave this on and you will see they all have a father. And I could put the same similar query for the mother. And with, yeah. So mother, user ID and we are down to 15 profiles. So these 15 profiles would have father and mother. Both parents set and a specific date in the birth date is a birth date. Okay. Let's answer him with this URL. Okay. Stay recorded as an example. Oh, good. Yes. That's an excellent idea. Because it's pretty hard to copy and paste from a YouTube screenshot. Yeah. You can write it down. But yeah. Okay. So this was the first part, right? Then he had additional questions. Yes. Yes. Biocheck is, I mean, Biocheck is designed to work with up to 10,000 profiles and that's really a lot. So I think it has some limits. So it's not possible to just use Biocheck for all unsourced profiles to check that. So you can do that in chunks, in small chunks or and, but Biocheck is connected to wiki3 plus. Yes. So once you create a query. So now with this query, I can send this 15 profiles to Biocheck. Look at that. To log in. Of course you have to log in. That is neat. The link to Biocheck is right there. And now it's checked the profiles. But I don't know why only 10, but once I have to once see why it doesn't check everything. Were they private? No, this is 17th century. So that's interesting. Okay. But look at all of those are unsourced. So all of those would be fodder for the sourceathon. Right. We could use. Excellent. I think Alan has been benefiting from these wiki3 plus sessions because he was one of the high high scorers on the sourceathon this past weekend. He's using your magic, Aleš. But for the power of good, not evil. Well, it's it was done for that. That's good. No, this is all very good news. Yes. Okay. So this would be the second part. Bill in the chat said that we should mark check all profiles. Did we not in a bio check? Okay, cool. Let's try that. So let's try that again. Thanks, Bill. Let's see. Mark check all profiles here. Where's that? Report all profiles probably this one. Maybe that's what it means. Yeah. Okay. Yep. Look at that. Check them all, but only reported the ones that had issues. So yes. Okay, cool. For our sake, we wanted to verify that. Okay. Now I know why all the profiles are missing Q and I'm looking at this. That's right. The ones you don't see are the ones that don't have problems. So, you know, why waste the time. Why? Because I wanted to, even on these profiles, you have some useful info like number of inline references and so on. Okay, so this is the report all profiles. Yes. Magic key. Magic. Yes. Yeah, that's right. Okay. So remove the unsourced sticker. So these are automated actions are not possible. So this those things can have to be done manually. And then we want a live person to make sure that that's a valid thing. Second question is what was that? Okay. The second question. Can you this with multiple centuries? Right. So no, if you written like this 18 19 20, each space is treated as ant operator. So this means that the person has to be born in 18th century and has to be born in 19th century and in 20th century. So a result will be most likely empty here. That's too long a labor for anyone. So and you're born only once. So yeah, you're only born once. Yeah. So yeah. So this is not the solution. Can you do an or some? Yes, you have you have to do the sentence. So but it has to be. So here we have the 18th century query. And then you have to add at the end, you add our operator and repeat complete query with corrected century to 19. So here we put 19 at profiles and this would then add also the 19th century profiles and are another are and for the 20th century. So this would be the correct query. What did I do wrong? Something. You miss a semicolon somewhere. I don't think so. It doesn't matter if or is all caps or. Oh, it doesn't. It shouldn't. We could replace this completely case in sense. Yeah, which is nice because I had two space. Oh, okay. I had two spaces before in front of the sentence two spaces. That was enough to throw it up like that. Well, it was and and yep. That was okay. Wow. That I can fix. That's very picky. Wow. As for the no, here it doesn't matter if you put more spaces, but or is kind of made. It's a special word. Yeah, it's especially and so it treats when it comes across or it what happens next is treated like a completely new type of query. Completely new. Yes. Not completely new query and it performs it and then just merges the results with the previous one. Wow. Now, can you use bracket? Like if you wanted to, if you started no, you can't use bracket. You don't. I don't have the priority order. It would help in some cases, but maybe someday in the future, we will write the parser. That's smart that all of this will work. Yeah. Well, yeah, because if if you could do that, then you could just put that essentially inside of the link for the in. Yeah, but but this is working. This is work. This will work. You know, if you're if you're intuitive enough to be able to use an SQL query that you can handle doing a little copying and pasting and editing to add these ores on there. So that's not gonna. So that's not gonna slow or you can actually do three different queries. And once you're done with one center, you go to the next one. Exactly. Yeah, that's you could do it. I mean, it's not unless you are preparing some list. There is really no need to if you're doing directly on by this list, then you don't need you don't really need to concatenate the queries like this. Right. Yeah. That's right. I can see this type of query if you're say trying to follow one family line across a certain region and a certain cross centuries or something like that. Or if you or if you want to export the results into Excel or something like that, or such think it would be logical to use such queries. That's right. Yeah. So let's also give him this URL. Oh, excellent. Good idea. While you're doing that, I'm just gonna say yay to Vicky for signing up for Hacktober. Anyone else signed up for Hacktoberfest while we're on this live cast? I'm always glad to have more people. So yes. And let's see. There's some other comments that came through here. Okay. Let's see Patty. Yeah, Patty figured out while we were flailing there wondering why we only saw 10 out of the five Patty figured it out. The other five must have a story. Yeah. No, the Patty does have a question though that text box is way too small when you're seeing it. Is there a way to make it expand or wrap or anything? Yeah, I was thinking about that. Actually, that was one of the ideas for the Hackathon. Hacktoberfest to actually write a full query where you could actually do you would be able to at end and our sentences and queries with indexes and so on that you would kind of build the query and send it to me. Oh, that sounds neat. Well, I like that idea. If I didn't have this other app I'm planning on working on that would be very, oh man. Well, okay, actually that's something I should do. Yeah, you should probably do. But it is a cool idea. But even if you could change it from a text field to a text box, then in most browsers, the text box has that little corner that you can drag and make a little wider. Yeah, to make it multi-line, right? Yeah, even that alone, because then it doesn't need to be multi-line for simple. Yeah, it's a problem because it's in a narrow column because usually these queries are long. That's right. But you could make it a text box that the default rows and columns, like run row and only 20 columns or whatever however many it is. I will try to change the... That would be my initial short, you know, cheating solution. Because then if you could just sort of drag it down. Oh, look at these. Oh my goodness. He's going to do it right on the spot. Wow, folks. You're seeing history made live here. I'm just testing this area. Text area. It's area, right. It's text area. Yeah. Okay. Now I hope this doesn't screw up all the rest of this code. Oh, and at the back, it says text box still because... Okay, you can do that. Oh my goodness. Does that work already? Yeah, it's just the type of control. So it can be changed. I will correct this. So it will be expandable. Oh, you have to get... Is it live? No, this is Inspector. It's the bugging tool where you can actually try and change control into something else. Okay, so it's not going live, folks. But he's testing it live, but it's not... Well, I can also put it live if you want, but it will take me a minute. No, no, no, no. Let's not go... No. We'll give you time to do it nice and make it work. So I don't want to be responsible for making a suggestion that then brings down Wikitree Plus for a day or so. Yeah, right. It wouldn't take that long for you to make that sure. Okay, so... There we go. So where are we? We're done. We're getting through. Thank you, Patty, for that question, by the way. That's good. And there we go. Okay. What's preferred method and format of sending editbot requests? Well, editbot is not automated, I always... So, okay, it does it does certain actions on templates and on profiles that connect it to templates and categories and deletion or rename of the category, those are automatically ran each day. But now I also started it both with certain commands where I can change one domain to another or something like that when such a change is needed. And I do... I mean, it's not something that I would just write a command and it would be executed. I always go and check if it's really... How many profiles will be changed if it will work on everything and so on. So it's not... It's a manual process to check a few things before I start the editbot. So it's not something that you would request and it would be done automatically. Right. But if Mike had... If he came across a scenario that he thought editbot might be the solution for, if he should just contact you directly. Yes, I even think he already did, but he sent me 15 changes and I didn't have the time at time and now his email is somewhere lost in my... Oh, no. Okay, so fine. I know I had to return to it, but I'm not sure where it is anymore. Yeah. But it makes sense. I mean, the editbot does all this stuff automatically once you've got it set up, but you've got to really test that because there's so many things that could go wrong when you set an automation in place that you have to really... Yeah, yeah. I mean, at the end, it's a simple command, but... Yeah. And those are the most dangerous, the simple commands. Yes, but you always do a typo, so even I do... I often check... Okay, so here are examples of such statements that I call, but... Oh, my. I mean, it's possible to do a lot of things. Some are simple. I just inserted one end between OOP and IMG and so on. Some are simple, some are complex, but it's something I have to do for each replacement. And before I actually run it, I check also what the scope of the operation. So I know approximately how many profiles will be changed, and if everything is actually what we want because undoing such corrections is terrible. Oh, yeah. Yeah, that's right. So there, yeah, good point. So here's the next question from Patty, who's in our chat. I had in the back of my mind these such... Ask Lesh anything. I came here with a question which is not about Wikitree Plus. Strange things have been happening in the connection finder in the immediate aftermath of major edits like changing the last name at birth or parents. Specifically, the first connection becomes white, even if she is or was a sister or a mother. Will you answer, Greg, or since you're dressed to us? Oh, yeah. This is something that only Lesh or Greg can get to the bottom. I have no connection to the connection finder and I have no clue what's going on. But I did wrote the connection finder and I know exactly what's going on. Okay, there you go. The connection finder runs on a separate server and it's not directly connected with SQL server where all the data is stored. I just do every half an hour a quick update of data to... So if you add a new profile, that connection is already shown in connection finder. And once a day I do fully import with all 30 million of profiles and all their relations and everything. Now the case you are described is with the quick update, I cannot delay profiles. And here there was a change in last name at birth which actually creates a new profile and kind of deletes the old one. So here it becomes then the double connection and it doesn't actually work. So until the next fully import will be in place. But the half an hour update, I only check if there are any new profiles or if any profile was edited in that time. And the deletion kind of... If a profile is deleted, it just disappears from the database and I have no way to know that that profile was deleted until I do a fully import. So that's the reason and I don't think we can correct that unless the database is changed significantly to actually keep the record in and just mark it, delete it. Then I could quickly get... Oh, this record was deleted in the last half an hour and so on. But the way it is now, that can't be done. So with last name at birth change, the profile is duplicated and there are then two possible paths through that. But it will correct the next morning. Right, okay. So if we come across those anomalies, we just need to have a little bit of patience and some of them will sort themselves out within half an hour and all things should be resolved within 24 hours. Okay, that makes sense. Thanks for that explanation. That would make a lot of sense and I don't... I mean, there's a little bit of short-term pain there possibly if you're making changes at that level, laughing at birth. But unless you're on a timeline, you have to get this fan chart out for Christmas, which is closing in 20 minutes. I don't think we're doing fan charts by using connection finder. Yeah, that's right. That's right. You probably... So, there we go. Anyways, we'll be a little patient and I don't think it warrants rewriting all of that back end for this. But now that we know why, that makes sense. Okay, this one is... Patty is giving us a very wiki tree plus related question. If I click on a link in the name column or the second column, he's saying, the wiki tree profile opens within my wiki tree plus tab and displays as if I'm logged into wiki tree as if the wiki tree browser extension is not installed. If I click on a link in the wiki tree, do you know what he's talking about here? Yes, I know. So, here we have two links to a profile, this one and this one. And this one did open in a new tab like this, while this one opened within this tab. And once it started from within the tab, it doesn't get the same security credentials because it's a different domain and so on. So, that's the reason you had to log in. It's just replaced here. It just opened here in the right part. For instance, like... Nope, this one is also in new window. I think there's another one that's... Nope, I corrected all now. I corrected all of them. Yeah. This one is... So, here this one was changed within the tab in the page and that was the same with this link. So, it wasn't... Well, actually here in the past, I had a link to the variations of Victoria Island name. At one point, I changed... A lot of people were clicking that and thinking they will come to a profile, but they actually came to the name and analysis. And it was... I just changed it to... So, that this link also goes to the profile, but I left it in place. I didn't add the code to open in new tab. So, now it is and it will open. Okay. Okay, good. So, here it was fixed. It was fixed. There we go. 33 minutes ago by Aleš. 33 minutes ago. Is it really 33 minutes? Okay. Oh, we have a new question. Wait a second. A new question just 12 minutes ago from Frank Santoro. Okay, that's refresh. And I think you've answered this. Is there a list somewhere of the field names you can use for text SQL queries? No. But we could put together a free space page of some of the ones that have been featured on this livecast. Or Aleš said that he could query all of them from the database, but I don't know if we want to publish those or not. Some of them were... In G2G, there are some cases where some of them were already shown or explained. So, they can be used. But it's... I mean, it's really... So, it's so many possibilities that ask and I will tell you what exactly to use. I think just in the last few months since you've added this feature, just from our monthly sessions, we've gone through and we've seen a number of different possibilities. So, it's... But I don't get asked about it otherwise. So, I think this were the only cases that I... That are used. I can check the database if someone else is playing with it, but I don't think that they are. I can check the logs, but maybe. So, Frank, my question to you, and I don't know if you're watching, I don't haven't seen Frank's name pop up here in the chat, but if you're watching, if there's something specific that you're thinking about asking that you haven't seen yet, maybe something about specific places in Italy or regions or, I don't know, something to do with the Italy project, I don't know what you're thinking about that you might be querying. Yes, because it's not just the field names. I mean, there are so many... Yeah, it's here. We can use like operator. Oh, there it is. Smaller, regular expressions, math. We can actually calculate query all the profiles that have a father older than 40 years at the time of birth or whatever. I mean, there are endless possibilities. Yeah, that's true. I don't think I can write that. Yeah, that's right. It would be crazy. We need you making sure the servers are up and running. Frank is here, by the way. I forgot his alter ego, Vinny the body. That's right. So, and here he sometimes searching on a place name catches profiles where the surname has that place name. Well, you can do that by simple... Well, here in search you have a question mark. Palermo, Palermo is an example because there's a place called Palermo in Sicily, but Palermo is also a common last name in Italian. Yes, and you have a possibility to use indexes. They are documented here in tick search. So, if you write the... You can limit it to location index and just write location equals Palermo, and you will get only where the Palermo is used in location field, not any field. Because here, maybe you don't know this, you can just write a word like Palermo, and you will get endless results. But you can also say location equals Palermo. That means that the only location index will be searched for the word Palermo. Now, we've most likely got less results. It's hard to see there, yeah. Yeah, just searching for Palermo returns 56,000. Location equals Palermo equals 55,000. So, we removed 1,500 profiles that used Palermo, or in category name, or in last name, or whatever. So, you can... Or we can even reduce it to birth location equals Palermo. Now, we will get only those that have Palermo in birth place. Excellent, great. And so, you don't need to use SCL syntax for such things. You can just do it by querying, by simply querying with use of indexes. So, now can we... Now he's throwing it. Now he's helping the ante. So, Palermo is a province as well as a town. So, what if we only wanted those in the town of Palermo? So, Palermo, Sicily, and where... How is the town? What town is Palermo? Palermo, Sicily, or what? How is this the town? So, the town there is... Oh, actually, we can analyze birth. We can analyze birth location now. Okay, let's look at that. And we will see all 50,000 instances. So, we have Carleone, Palermo. Okay, Palermo, Palermo. It's always... It seems always as a region. Oh, there's a Palermo, Palermo down there. Where? About two-thirds down. There we go. Palermo, Palermo, Sicily, yeah. Okay. So, you can click here the all link and you will get all that have Palermo, Palermo, Sicily. I actually hear program Tescoel sentence in the query. So, it's automatically done for you. So, could you do both Palermo, Palermo? Yeah, yes, you can. Well, actually, now if we would search for double Palermo, we can put it like this. I was just saying, if you just did Palermo, Palermo, because then, whether they wrote it in Italian, Sicily, Italia, or in English, Sicily, Italy, if you just did the Palermo, Palermo part, then both would match. Do you know what I mean? Palermo, Palermo. They are both written the same. But no, I will show you. So, we first have to put the query birth location equals Palermo to get to limit the results. Right. And then we can run SQL query over it and say that location must equals. So, we should use the like operator and we can say Asterix, Palermo, Palermo, and Asterix. Yes, there we go. Okay. Now what are we going to get? And we would get 500 locations that have double Palermo in it. Double Palermo. Or we could actually use the Asterix also in between if there is a case without a comma, maybe. Yeah, there are. We have 140s with double Palermo in location. And now we can explicitly see those locations with group by operation. Birth location. Double heaping of Palermo. Nice. So, these are the variants that appear in the database. Oh, look at that. You can get the chart. So, in some of those locations, like San Marco and Vezionista. So, that would be the church probably where a marriage took place. I don't know. No, it's a birth location only. It's a town, I think. Is it a town? It could be. Interesting. I don't think it's this garage. Probably not that garage. I mean, I know some churches are, you know, running out of funds, but they're not running out of garages, though. No, it says parochia San Marco. Okay, it's not really a garage. It's a big building. Could be. I don't know. Oh, yeah. See, look. No, that's a church in there. Yeah, it's San Marco. Yeah, it's a church. Oh, maybe they put, maybe they got the information from a baptismal record. Yeah, maybe it was, the baptism was in this church or something. Yeah, that makes, that's our guess. Wow. Well, that's great. Well, that, you know what, that's taken us right to the, pretty much to the end of the hour. We've got through the questions here. I don't think there's any more new questions here. Julie Ann is, she's having some tech issues and stuff. But anyways, and some questions, some other genealogy questions. So Julie Ann, if you are new to WikiTree, I would suggest you reach out on the GGG forum and ask some of those questions there. None of these are specifically specific to WikiTree Plus, so I can't really answer them right here, but there's lots of people on WikiTree who are happy to help you out. So please check in and someone will help you with some of that. And the other, I was just going to say, well, if some of you hopefully will see you tomorrow on Thursday, but before I go, I'm turning it back over to Aless for a final update on news and updates for this month. Yeah. Okay. I don't think we had a lot of new things this month. So, okay, I slightly changed some back algorithms to reduce the number of false suggestions. One of the new things were in the category navigator. I added the, here you can, so in category navigator, you can get the hierarchy of the categories and you can, here on the right, you can write, so okay, by default, you get the stats, so it's a number of profiles in categories and subcategories, but you can also then extract info from the category info boxes with some details so you can see if all the cemeteries have necessary information and so on. And the new one that was added is the editing, which displays who did the last edit on the category when it was done, how many times the category was displayed, if it's top level, the size of a category, with some basic info of the category, so it can be helpful if you are getting a whole category structure in order, so you can check that all were correctly edited and so on. So, this is one of the new things. That's pretty cool. Yeah. Then, okay, some location, in the location table was slightly improved on the, on the 403 suggestion with single sex marriage. I added the, I also checked the LGBTQ plus category and remove those members from the suggestions, so members of those categories, so if you also put a profile in that category, it will not show this suggestion. But now it's not necessary, no, it's not necessary to put it, you will just get the suggestion and you can also mark it then as false suggestions. It will also be right. And how long something is a false suggestion? How long does that hold off, does that hold off the suggestion? Well, the first one are seven, eight years old. Oh, okay. From the beginning. I mean, I don't, I have a table with all the suggestions that were marked false and I, it doesn't bug you again. Yeah. It doesn't ask whether you're, are you sure, are you sure, are you sure? Yeah, even occasionally I did, I changed the idea of some suggestions and I also changed the false suggestions tax to be visible on the new one. So it's not lost if it's possible. Okay, external links. I did finish finally after a few months the external link re-scan because so all before 2022 that I initially scanned now the re-scan was done and we got around 200,000 new suggestions based on that. So a lot, it's the internet is very unstable. I mean, the lifespan of a link is not something that will work forever unless the site dedicates it to it. So if it's important that it works. Okay, so this I think, and I improved the group by field which I already showed before, but I think that was already in in August. So we did see this on the previous escalash. Good. So that's what's new on Victory Plus. Excellent, great. Okay, so Azure who's in the chat with us, thank you, has posted a link to one of the other things that's coming up this week is on Thursday evening, Betsy Cole has a new member question and answer and there's a link direct link there to the post for that. So Julianne, if that may be something you want to check out as well is joining that if you're having questions and or anyone who has questions and is a new member. But thanks to everyone who's here and hopefully I'll see some of you tomorrow at the Hacktoberfest livecast which is one o'clock Eastern time for me and it is 24 plus three hours from now. Okay, it's 27 hours from now. I'll be live and hoping to see some of you, my friends as well. And if not, we'll see you all. Oh, what is it now a month from now will be like the day before we go into the Wiccantree Symposium? Are we going to do Ask Alesha the day before? Yeah, most likely. Actually, I'm not sure I will be free because I'm going to Portugal for the holidays. Oh, I will see. Okay, stay tuned. It may have to be postponed a week for the second Wednesday. Yeah, it could be the second Wednesday. We did the second Wednesday for me once. So, you know, we can do the second Wednesday for you once a week. Okay, okay. Anyways, have a great day, everyone. Bye. And we'll see you around. Ciao.