QUERIES ARE WONDERFUL!! I was wondering how to reference a series of cells from a different worksheet into a series of cells in a different worksheet without copy-pasting a formula a million times. This is the answer. You don't have to type it all out manually, just as expected. Thanks for these tutorials, I looked for google spreadsheet tutorials and this series is what I came across, which is helpful.
and here's a tip: to select only one column, enter this range: A: A or whatever column you want, with its name on both sides of the ":" symbol. The left side of the column is the start point and left side is end point, so you could do something like A12:A too.
I don't have enough words to appreciate you putting out all this amazingly explained information for free on RUclips... Thank you...!!!! Thank you....!!!!! Thank you....!!!
Thank you!!!, I was banging my head against the wall previously because IMPORTRANGE wasn't working for importing multiple sheets into a single query, you sir are awesome!! thanks again
Wow, the subquery part is something I was looking for a long time. Since Google Sheet doesn't offer the "HAVING" SQL clause, this subquery is essentially the substitute for the "HAVING" clause.
Thanks for all your tutoring. Your videos are just what I needed as I needed to brush up on my accounting reporting skills not utilised since I retired years ago. The software environment has changed a lot and the advantages of Google sheets offers as a way of communicating and collaborating is significant. I used to use Visual dBase which had an SQL like query language so the syntax is familiar. What was great about VdB was that you could input data in a user friendly form and see the code come out on a "Command Screen". It was a great way for a novice to write and learn to code. In addition you could copy and paste the code and incorporate into larger programs. Wouldn't it be great if Google Sheets could come up with something similar?
This is very fruitful and productive video that I have ever seen on RUclips. I want to to do the same thing you did but Instead of just taking the same info from sheet 1 to the master list, I need to cut the information form sheet one to sheet two while I apply query. Why I need this and ask you that because I have an Google sheet and there is a column which is just for the status of the projects in which I have pending and completed. So, whenever it is going to be completed in the sheet 1, then I want it to automatically delete the completed project in sheet one and transfer it to the master list. I will appreciate that if you can help me in this regard, not only me need this but all most all of us need to have it. A huge thnx for you and your amazing and productive videos. Best RUclips channel ever.
Thanks so much for posting this video! any tips on using importrange where the source file has URLs in multiple columns that you would like to show & work in the destination file?
Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!
@ExcelGoogleSheets What if I have it more dynamic, referencing each of the importrange in 4 cells, one each. If one is blank (as it may be), is there a way to handle the error (similar to what iferror does)? My sheet still imports the same data (or behaves funny) when I delete one of the ranges... thanks for the help! Your videos are always very good and didactic!
Thanks so much for these videos! What I have yet to find is a video that addresses querying the same tab/sheet from hundreds of different worksheets. So, my situation is such that I have a running list of reports for a calendar year. By the end of the year, there are 400 or so reports. Within the reports, there is a equipment2 sheet that I am trying to query with a range from B4:E28, where the results can be either 1 row, or all 25, depending on how much equipment was used for that given incident (potentially no rows, if no equipment was used). I have a script that imports all the URLs from the reports into a tab/sheet that is called ReportURLs. Column D houses the URLs. So, how can I query ReportURLs!D2:D dynamically to pull out all the data? Thanks!
Its a great Video and help alot in my reporting... i have too much data like 15000 line with Columns goes upto BS. getting error Result too large how to rectify this?
Thank you so much sir, thank you so much, sir. Your tutorials ones of the best because of being halpful and very clear explanation (English is not my native) ! My questions is: do you need to do subquery because there is no 'having' statement in the 'google sql' ?
I'm running into the same problem. "At 18:49-18:50 in the video, there is an error message that pops up saying "In ARRAY_LITERAL, an Array was missing values for one or more rows." Are you able to explain what that means, and how to fix it?"
No, according to my knowledge. because query function needs its next lines to be empty. when you'll write the second query function, first one will give you an error: "Array result was not expanded because it would overwrite data in A249". A249 just for the example.
!!!! I used importrange function to copy a range from one sheet to another and I made some column in that sheet which were filled manually. how can i fix the manually/static filled data with the automatic/dynamic filled data?
While pulling data from another spreadsheet with multiple tabs, can I specify the number of the tab instead of the name of the tab in the importance function? Basically, the source sheet from where I need to pull data from will have multiple tabs but I want to keep the first tab as the default source of the data, no matter what the name of the tab is. Data needs to be pulled from just one specific cell, say A1.
Great vid... thx. I can't find the limit of the number of tabs you can query with { }. I think I'll have to look at some scripts since my file will keep growing daily with new tabs that will need to be referenced. Thx again.
Your video is really amazing. But I have a questions. I'd like to set up on Google Sheet where I can search just typing initials, such as "P" in a cell and them query makes the information in my sheet appear. Such as you've done with Shirt. Could you help with the funcion formula?
Given a column of spreadsheet URLs and possibly next to each a range I. E. Transactions!A2:b30, is it possible to automatically pull and join the data from all those sheets?
I had to use google script so that when a new URL and range is added, it builds the formula to join all the importrange formulas inside a query formula based on the URL list
Thank you for nice series on Google query and other advanced techniques. I have a problem regarding Google Finance. Hope you can give me proper guidance. The problem is that I wish to compute Weekly, Bi-weekly and Monthly gains by a list of stocks. Google finance gives 'changepct' for daily data. But for weekly data it doesn't. I have made a formula using query to compute weekly percent change. But for Bi-weekly I have not yet succeeded. Can you suggest any formula for bi-weekly and monthly gains of stock prices. May be I am missing some where some thing.....
@@ExcelGoogleSheets Thanks for your quick response. As you asked, let me explain. There is a provision in GoogleFinance to list the weekly prices of a stock. With that I made a formula using queries, which gives the desired result. The process is a bit cumbersome. Here how i did it. Using query from GoogleFinance weekly price list - sorted in desc order, i) I extracted the first price (using Limit 1)-say A, II) extracted sum of first two prices (using Limit 2)-say A+B. Knowing price A and sum A+B, it is just use of algebra to get A-B [2A-(A+B)]. This will give latest weekly price change. Then computing % change is easy. This resulted in a large formula. And let me inform you that I have also computed the bi-weekly and monthly percent changes. But these all are large formulae and prone to make mind boggling mistakes while constructing it. Hence I wanted to know how to select the price using the GoogFinance output where the first column is date. I have seen your video on extraction of data based on date limits. But that is not working with in line Google Finance data, neither as a date or number. This would have made the life easier. Can you suggest something on this problem? The answer is a bit long, but then I have to explain any way.
Hi there, seems excellent and what I need but it doesn't work for me as my "IL" criteria is more diverse.. I need to look within the celle for one word (people answered paragraphs) can we please exchange on this issue? that would be very kind . Dave
These video are super helpful as the steps are explained very well. I have tried various formulas to meet what I need and while I can make each formula work on it's own, i'm having trouble finding the right combo. I have two workbooks. I need one workbook to vlookup / match a name in a column that is on another workbook. Example, John Doe appears in Coulmn H in 1 workbook named WRAP. I need the formula to search column B in another workbook Named Assets, to see if that name is true. If it is True, then it should highlight the name in WRAP workbook a color, using conditional formatting. Ideally, once John Doe has been removed from Assets workbook the Wrap workbook will remove the highlight. Sorry for the long comment. Is there another way to submit this. Would love your help!
This was so helpful. But when i'm using query(importrange) function to get data from one sheet to another sheet data is not fetching all the time. some times it is given error like #value. May i know solution here with google script or something. Thank you so much in advance!🙂
because if we enter data in linked sheets than master sheet shown the data in between sheet and sequence will be disturb. i want all updated data should be shown at the last.. is there any option please let me know.
@@ExcelGoogleSheets I was also wondering because it wasn’t picking up the right match. It was refereeing to the row number instead of match. I guess it was because I used rang names when referencing to range and gave name to the whole colum not some rows as I wanted to make the names range dynamic. But somehow it is picking up right not sure what happened but problem solved. I did =index(importrange),match(importrange)
This is very helpful, but I another question. I have used the Query ImportRange function to move data from one sheet to another but my SELECT WHERE is referring to a specific date. I.e. I want to move all data where the date is 5/1/2020 and later. When I use the formula you suggested it works but all of my information is showing up on one cell block. How do I fix this?
Could you please say what word to use when I need to query information not from a column (Col1/Col2/...), but from a line (which are designated as '1', '2', '3'). I have a page with columns often changing their positions, so I need to query a value from (line2) if (line1) contains 'specific-word'
So Very Helpful and Succinct! I would appreciate knowing if there is a way to use an item on a Dropdown List (MASTER BEDROOM), as the QUERY? As in.... =QUERY(SELECTIONS!$A$1:$N$201,"SELECT A, B, C, D, E, F WHERE D = 'MASTER BEDROOM'",1) but replace 'MASTER BEDROOM' with the cell reference $A$3 that is a Dropdown List Also is there a way to "SELECT all columns, so complete rows of data are returned if they contain MASTER BEDROOM in column D? Cheers!
hi, my sheet have merge 10 cells, when using query function it only read the first line correctly than the second line staright away jump to data which is line 21. how can i solve this issue.
Fantastic! Quick question, what If i want the query for more than one option. So in your example I want to show for IL and CA at the same time. How would you do that?
This entire series is amazingly helpful. It is THE definitive guide to using Sheets like a pro. Thank you!
Agree! I wish this was in my search results 2 years ago
QUERIES ARE WONDERFUL!! I was wondering how to reference a series of cells from a different worksheet into a series of cells in a different worksheet without copy-pasting a formula a million times. This is the answer. You don't have to type it all out manually, just as expected.
Thanks for these tutorials, I looked for google spreadsheet tutorials and this series is what I came across, which is helpful.
and here's a tip: to select only one column, enter this range:
A: A
or whatever column you want, with its name on both sides of the ":" symbol. The left side of the column is the start point and left side is end point, so you could do something like A12:A too.
I don't have enough words to appreciate you putting out all this amazingly explained information for free on RUclips...
Thank you...!!!! Thank you....!!!!! Thank you....!!!
Your videos are the best. I have been able to build an entire database in multiple sheets because of your awesome tutorials. THANK YOU!
I’ve searched months and found this great video to solve my problem.
Thank you!!!, I was banging my head against the wall previously because IMPORTRANGE wasn't working for importing multiple sheets into a single query, you sir are awesome!! thanks again
Awesome my main man. Had a bit of panic at first not working but I had forgot the QUERY at the beginning. All great.
Sir, you are the Best, your videos have contributed too much in me gaining respect in my office
This is amazing and your talent of explaining the steps inspires me!
Thank you SO much - been having so much trouble sorting text data and this finally solved my problem at work!!
Thank you so much! I have been able via your videos to minimize manual updates. Thanks again.
I'm learning new tricks...This tricks also helpful for learning SQL queries..Thank you brad, very concise and clear..
Thank you so much for this informative video. I have been looking for this for a long time. it solved my biggest problem.
Greetings from Brazil. I would like to thank you for this serie, it was very helpful
Esse é o melhor professor do RUclips!!!
This is what I have been looking for. Thank you very much. Easy to understand and follow.
Wow, the IMPORTRANGE explanation at 9:58 is going to be a game changer!
That is an amazing lesson, and you are Talent online teacher.
pretty awesome helpful and useful to the highest levelz
great job with your channel, data is king
Wow, the subquery part is something I was looking for a long time. Since Google Sheet doesn't offer the "HAVING" SQL clause, this subquery is essentially the substitute for the "HAVING" clause.
Correct 👍
@@ExcelGoogleSheets this is so useful that I have enhanced my spreadsheets in multiple places today. Thank a lot brother!
Thanks for all your tutoring. Your videos are just what I needed as I needed to brush up on my accounting reporting skills not utilised since I retired years ago.
The software environment has changed a lot and the advantages of Google sheets offers as a way of communicating and collaborating is significant.
I used to use Visual dBase which had an SQL like query language so the syntax is familiar. What was great about VdB was that you could input data in a user friendly form and see the code come out on a "Command Screen". It was a great way for a novice to write and learn to code. In addition you could copy and paste the code and incorporate into larger programs.
Wouldn't it be great if Google Sheets could come up with something similar?
This video solved my biggest problem. Thanks and more power!
:)
@@ExcelGoogleSheets what if you need to filter more than 1 state, instead of just IL, how do you do that?
Covered in part one of these series.
Helpful 👍
This was so helpful. Literally the only place I found such a clear answer. Great video
Excellent. Well done
This is very fruitful and productive video that I have ever seen on RUclips. I want to to do the same thing you did but Instead of just taking the same info from sheet 1 to the master list, I need to cut the information form sheet one to sheet two while I apply query. Why I need this and ask you that because I have an Google sheet and there is a column which is just for the status of the projects in which I have pending and completed. So, whenever it is going to be completed in the sheet 1, then I want it to automatically delete the completed project in sheet one and transfer it to the master list. I will appreciate that if you can help me in this regard, not only me need this but all most all of us need to have it. A huge thnx for you and your amazing and productive videos. Best RUclips channel ever.
Could you please answer my question?
VERY USEFUL FOR BOTH BEGINNERS AND PROS
Thanks for the tutorial on using QUERY with IMPORTRANGE. Really helped me!
thank you , for great sharing
Thank you very much sir. Your video has helped me a lot.....
This is great. Many thanks.
Wonderful! I knew there had to be a way to query from multiple sheets, I just didn't know about the bracket for the array.
Awesome tutorial! Loved it. Thanks for putting in such efforts to educate folks.
Glad you liked it!
Excellent video, thank you!
Thanks so much for posting this video! any tips on using importrange where the source file has URLs in multiple columns that you would like to show & work in the destination file?
you explain it so well. thank you.
Ty for this video GOD BLESS U😊
Thank you so much, exactly what I am looking for 😊👍👍👍
Thank you its really helps me in query function.
Pure gold!!!
I like the way you teach about google sheet and its functions, please help me to pulldata from one google sheet to other tik by tik
You are a great teacher. These videos are super helpful.
Good evening,
First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it.
I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible?
Thanks in advance!
@ExcelGoogleSheets What if I have it more dynamic, referencing each of the importrange in 4 cells, one each. If one is blank (as it may be), is there a way to handle the error (similar to what iferror does)? My sheet still imports the same data (or behaves funny) when I delete one of the ranges... thanks for the help! Your videos are always very good and didactic!
Thanks for your help
Thanks so much for these videos! What I have yet to find is a video that addresses querying the same tab/sheet from hundreds of different worksheets. So, my situation is such that I have a running list of reports for a calendar year. By the end of the year, there are 400 or so reports. Within the reports, there is a equipment2 sheet that I am trying to query with a range from B4:E28, where the results can be either 1 row, or all 25, depending on how much equipment was used for that given incident (potentially no rows, if no equipment was used). I have a script that imports all the URLs from the reports into a tab/sheet that is called ReportURLs. Column D houses the URLs. So, how can I query ReportURLs!D2:D dynamically to pull out all the data? Thanks!
You all are awesome. Thank you for the great videos you create and share!
hi..can u pls help me coz, after i the formula when i enter doesnt extract my data only showwd is the headers..thanku
Amazing. Thanks. Is there a short cut for chromebook to use the Dollar $ to lock the cell?
No F4 on Chromebook?
@@ExcelGoogleSheets unfortunately, nope. Even if I try to use an external keyboard, it does not work with the same functionality
Its a great Video and help alot in my reporting... i have too much data like 15000 line with Columns goes upto BS. getting error Result too large how to rectify this?
Thank you so much sir, thank you so much, sir. Your tutorials ones of the best because of being halpful and very clear explanation (English is not my native) ! My questions is: do you need to do subquery because there is no 'having' statement in the 'google sql' ?
yes.
Thanks.. it really help very much..
Hi Great videos, the explanation is clear, but can I do the editiing on the data that I have imported to new spreadsheet?
No.
I'm running into the same problem.
"At 18:49-18:50 in the video, there is an error message that pops up saying "In ARRAY_LITERAL, an Array was missing values for one or more rows." Are you able to explain what that means, and how to fix it?"
Is it possible to filter both IL & CA at the same time during query and importrange?
can i have a query function on the upper part of the sheet and a different query function on the lower part of the same sheet?
No, according to my knowledge.
because query function needs its next lines to be empty.
when you'll write the second query function, first one will give you an error: "Array result was not expanded because it would overwrite data in A249".
A249 just for the example.
You can, so long as the first function has enough space for expected results.
Thank you for your sharing. I learn a lot from this video.
Really good, very clear tutorial
Hi there. Using this formula,Is it possible to do multiple filter in the same column?
Thank you!!!! So easy to follow and understand :D
Glad it was helpful!
7:50
What if the 2 tables (transactions and transactions previous) have different columns/different number of columns?
How would the Col8 thing work?
Watch my Pivot Table from multiple sheets video for a solution.
level 40 google sheets! Thank you.
Thanks, with the query how do we add the TAB "name" to each row so we know which TAB the match came from
Does it in effect do a join on a common field in, both sheets?
No. Google Sheets QUERY doesn't support SQL like join. Use VLOOKUP to get something similar to join.
Wow Brother, thanks for making life Easy
Great video, extremely useful! Thanks!
Very useful mate, your video helps me a lots
Wow amazed.. thanks again man.
!!!!
I used importrange function to copy a range from one sheet to another and I made some column in that sheet which were filled manually.
how can i fix the manually/static filled data with the automatic/dynamic filled data?
i have the same probleme bro
While pulling data from another spreadsheet with multiple tabs, can I specify the number of the tab instead of the name of the tab in the importance function? Basically, the source sheet from where I need to pull data from will have multiple tabs but I want to keep the first tab as the default source of the data, no matter what the name of the tab is. Data needs to be pulled from just one specific cell, say A1.
You are a WONDERFUL teacher, Thank You!😊
Awesome TUT man
Great vid... thx. I can't find the limit of the number of tabs you can query with { }. I think I'll have to look at some scripts since my file will keep growing daily with new tabs that will need to be referenced.
Thx again.
Great demo. Is there a way to retain the formatting from your Master sheet onto your new sheet so it looks like the Master Sheet?
Your video is really amazing. But I have a questions. I'd like to set up on Google Sheet where I can search just typing initials, such as "P" in a cell and them query makes the information in my sheet appear. Such as you've done with Shirt. Could you help with the funcion formula?
Appreciate the examples!
Very clearly explained - thank you!
What is the boundary limit you mentioned? Could I use 50-60 import ranges for example
ThanQ alot 😘
Thank you, this was so helpful!
Great Presentations. Would you share the sheets data so we can practice?
Given a column of spreadsheet URLs and possibly next to each a range I. E. Transactions!A2:b30, is it possible to automatically pull and join the data from all those sheets?
I had to use google script so that when a new URL and range is added, it builds the formula to join all the importrange formulas inside a query formula based on the URL list
Thank you for nice series on Google query and other advanced techniques.
I have a problem regarding Google Finance. Hope you can give me proper guidance. The problem is that I wish to compute Weekly, Bi-weekly and Monthly gains by a list of stocks. Google finance gives 'changepct' for daily data. But for weekly data it doesn't. I have made a formula using query to compute weekly percent change. But for Bi-weekly I have not yet succeeded. Can you suggest any formula for bi-weekly and monthly gains of stock prices. May be I am missing some where some thing.....
How did you do the formula for weekly percent change?
@@ExcelGoogleSheets Thanks for your quick response. As you asked, let me explain.
There is a provision in GoogleFinance to list the weekly prices of a stock. With that I made a formula using queries, which gives the desired result. The process is a bit cumbersome.
Here how i did it. Using query from GoogleFinance weekly price list - sorted in desc order, i) I extracted the first price (using Limit 1)-say A, II) extracted sum of first two prices (using Limit 2)-say A+B. Knowing price A and sum A+B, it is just use of algebra to get A-B [2A-(A+B)]. This will give latest weekly price change. Then computing % change is easy.
This resulted in a large formula. And let me inform you that I have also computed the bi-weekly and monthly percent changes. But these all are large formulae and prone to make mind boggling mistakes while constructing it. Hence I wanted to know how to select the price using the GoogFinance output where the first column is date. I have seen your video on extraction of data based on date limits. But that is not working with in line Google Finance data, neither as a date or number. This would have made the life easier. Can you suggest something on this problem?
The answer is a bit long, but then I have to explain any way.
Yea, I'm afraid my solution wouldn't be simple either.
Awesome!!
Hi there, seems excellent and what I need but it doesn't work for me as my "IL" criteria is more diverse.. I need to look within the celle for one word (people answered paragraphs)
can we please exchange on this issue? that would be very kind . Dave
These video are super helpful as the steps are explained very well. I have tried various formulas to meet what I need and while I can make each formula work on it's own, i'm having trouble finding the right combo. I have two workbooks. I need one workbook to vlookup / match a name in a column that is on another workbook. Example, John Doe appears in Coulmn H in 1 workbook named WRAP. I need the formula to search column B in another workbook Named Assets, to see if that name is true. If it is True, then it should highlight the name in WRAP workbook a color, using conditional formatting. Ideally, once John Doe has been removed from Assets workbook the Wrap workbook will remove the highlight. Sorry for the long comment. Is there another way to submit this. Would love your help!
This was so helpful. But when i'm using query(importrange) function to get data from one sheet to another sheet data is not fetching all the time. some times it is given error like #value. May i know solution here with google script or something. Thank you so much in advance!🙂
Hi, great tutorial. Can this query syntax be used from a script? Have you got some examples to indicate? Thanks
9:59 QUERY + IMPORTRANGE
20:07 SUBQUERY
Thank You!
@@ExcelGoogleSheets are you kidding?! Thank YOU! 👍👍
because if we enter data in linked sheets than master sheet shown the data in between sheet and sequence will be disturb. i want all updated data should be shown at the last.. is there any option please let me know.
Great tutorials!
If pulling from another URL, should it still be A2:H or can it be A1:H? Thanks for the great videos.
Thanks for the awesome video. How can we overwrite importange spreadsheet data from destination sheet so source sheet data will be changed ?
Any video to use query function with index match, or any alternative for this
I don't understand why you would need that.
@@ExcelGoogleSheets I was also wondering because it wasn’t picking up the right match. It was refereeing to the row number instead of match.
I guess it was because I used rang names when referencing to range and gave name to the whole colum not some rows as I wanted to make the names range dynamic.
But somehow it is picking up right not sure what happened but problem solved.
I did =index(importrange),match(importrange)
This is very helpful, but I another question. I have used the Query ImportRange function to move data from one sheet to another but my SELECT WHERE is referring to a specific date. I.e. I want to move all data where the date is 5/1/2020 and later. When I use the formula you suggested it works but all of my information is showing up on one cell block. How do I fix this?
Could you please say what word to use when I need to query information not from a column (Col1/Col2/...), but from a line (which are designated as '1', '2', '3'). I have a page with columns often changing their positions, so I need to query a value from (line2) if (line1) contains 'specific-word'
So Very Helpful and Succinct!
I would appreciate knowing if there is a way to use an item on a Dropdown List (MASTER BEDROOM), as the QUERY?
As in.... =QUERY(SELECTIONS!$A$1:$N$201,"SELECT A, B, C, D, E, F WHERE D = 'MASTER BEDROOM'",1) but replace 'MASTER BEDROOM' with the cell reference $A$3 that is a Dropdown List
Also is there a way to "SELECT all columns, so complete rows of data are returned if they contain MASTER BEDROOM in column D?
Cheers!
ruclips.net/video/nLW8SerwnJo/видео.html
hi, my sheet have merge 10 cells, when using query function it only read the first line correctly than the second line staright away jump to data which is line 21. how can i solve this issue.
Thanks a lot, great learning..so how I getting this files , its better to practice.
What if more than 2 things to be filter in the single column
Fantastic! Quick question, what If i want the query for more than one option. So in your example I want to show for IL and CA at the same time. How would you do that?
ruclips.net/video/bW6P2YvLyZg/видео.html