Okay, this is how to clean up the, this is how to clean up the WordPress database. I'm David Greenwald. I am a freelance developer and performance engineer here in sunny Portland, Oregon. You can check me out on DavidGreenwald.com and also on GitHub. And actually if you have some Wi-Fi, you might want to check that out. I have a cheat sheet of code over there that you can take home and run on your databases and get some good information. So there's that link. This is a 15-minute talk, so we're not going to teach you SQL today. The goal is just to give you a good foundation to look at these issues and diagnose them, understand the problems that we face with WordPress databases. So this is Passion of the Weiss. This is a music blog down at LA run by my friend Jeff. You may have heard of it. It's a pretty well-known site. He's been doing it for years. It gets a good amount of traffic. I think about a hundred thousand visitors a month, which is solid traffic, very respectable, not enough to break the internet. Jeff should not have any problems with his website if he gets 3,000 people on it for days. And yet Jeff's website was crashing pretty consistently. This was something that was happening to him all the time going on for years and years. So he tried a bunch of different methods to fix it. The first thing he did was move from his cheap share hosting to a faster virtual private server. Not so great. He was told he was being hacked, so he set up ClioQlare and DVOS protection and all that good stuff. This is the progress form. Finally, he ran the WP Optimize plugin and thought he was cleaning his database. And continued to have site crashing. So finally, Jeff got in touch with me and I took a look and discovered it was actually the database.  He had deleted in like 2012 or 2013 that had been sitting there. He left all of its data in the database and just sat there. I was crashing his site for years and years. So before I... Right? I actually got these stats back. I was just checking my notes for this and it was actually 282 gigabytes, I think. So basically it left almost 300 megs of stuff sitting in his database. I went in about five minutes and cleaned it up and saved his website. It was great. So the options table... The options table, if you don't know it, it loads your settings for WordPress. So anytime someone goes to any page in your site, it's loading the options table. So it's super important to not have 300 megabytes of stuff in there that has to load every time. Jeff's VPS has one gigabyte of RAM. So if he would tweet the link to his website and five people click that at the same time, he would crash his website. So these are the kinds of problems that you can get with the database that we are trying to avoid. So what we learned from Jeff's story is that database problems are sneaky. They're hard to diagnose if you're not looking for them. They're expensive. You're probably going to upgrade your server thinking that's the actual thing. You should do that anyway, but no it's not. And it's bad for business and traffic because your website's going to be slow. It doesn't crash. It's going to be unreliable. Google hates that, so will your users. So these are important problems to know about and if you can fix them for clients, then they will be very impressed.  Raise your hand. That's good. That's great. Okay. So just to reveal a little, all your WordPress content lives in the database. Essentially, what happens is when someone visits your website, WordPress goes to talk to the MySQL database and says, hey, I need the content that goes on this page. The database hands it back over. WordPress says, cool. Now I can use my theme and generate an HTML document. They hand over to the user. Basically, it looks like this. That one in the back is WordPress. It's just going to keep looping over and over. But imagine you have 100,000 people on your website. This is going on all the time. So these database requests or queries take time and data. These are the two things that we really want to optimize. It should be as fast as possible and as light as possible. So what is a database? Every WordPress site has one. It stores your information. Like we said, they have tables which are ways of organizing this information. So you can think of them as a spreadsheet if you've never looked into a database before. Basically, it has rows and columns. It's a way of organizing information. So WordPress tables have rows for each item. So post one, post two, post three, and then those are broken up by the columns, which would be, you know, your post title, content, excerpt, etc. So we can sort by all of these things and the number of rows tells us how much information is in our database. So here's the WordPress, the WordPress tables that come with your site. We're not going to do a whole tour. But just to give you an example, posts are where you store your posts. Users have your users. Terms are for categories and tags. Post meta is where you would have extra information, so custom fields and things that aren't in the ordinary columns for your post table. Your site may not say WP underscore. It might be something else that can be customized just in case you run into something else on your site. Here's a couple good links to learn a little bit more about the database deliciousbrains.com and premium.wpmu.deb. Those are both really nice and you can just Google repressed database article to find some good stuff. So plugins also add their own tables. This is actually really good because it means the data is organized well. It's going to look faster. It's not all sitting in your post meta table, which is what used to happen and was bad. So WordPress is one that adds a ton of tables, Yoast SEO, WooCommerce, a lot of common plugins will add them. So that's totally fine. We just want to keep an eye out for bad actors that are really inflating your database or for plugins You've deleted that left their old tables. They're sitting there for five years and that can also be a problem. So what actually causes these database problems? Basically a large number of rows and then the data size of the row content. So let's look at that. If you had a blog post with pride and prejudice, that's 700 kilobytes of data. If you have a blog post of my tweet, it's 0.09. So if you have 5,000 blog posts and all of them are pride and prejudice versus all of them are tweets, it's going to dramatically change the size of your database and the amount of data that gets loaded and has to be searched through. So I actually think the data size, the megabyte size is a little bit more important to optimize for. My SQL is really good at looking through thousands of rows. That's what it's job is. It is less good at loading 300 megabytes of stuff into your RAM. So that's what we really want to make sure we're looking at that and optimizing. How can we tell if the database is slow? Speed test. So here's a couple of good tools, bytecheck.com, tools.pingdom, GT metrics. What we're looking for is something called time-to-first byte and that's the amount of time it takes. Somebody clicks on your website. The page actually starts loading. That's called time-to-first byte. And what we want is a little subsection of that called wait. And what wait is is the actual time on the server when WordPress and MySQL are doing that little dance that we saw. Where WordPress is asking for the information and then it can complete the page and hand it over. So this test result has 29 milliseconds. That's great. Wait, sometimes you'll see it as waiting. Time should be under 200 milliseconds. That's what Google says. That's very attainable in real world use. You should absolutely be going for that number. Anything under 500 I think is acceptable. You have to remember that the more traffic you have on your site, the more your server will work and it's going to raise that time. So you really want to make sure you are optimizing for ideal conditions. So that when you do have 100,000 people on your site that you're not getting these 10 second low times. So slow wait times are caused by not just the database but also old PHP versions. We should all be on 7, 7.1, 7.2, 7.3 just came out. Or it could be a slow server. It could be old hardware, not an SSD, all kinds of things. So in Jeff's case, he had already upgraded his server. He was on a VPS. We knew it had good hardware. We knew he was on PHP 7.0. So that allowed me to do process of elimination. And when I got the slow wait time, that told me, OK, his database is the issue. So this is something you can do when you're doing your tests to make sure you make sure you're not, you know, if you're testing on, I don't want to say godaddy.com or something else, but if you're testing on some hosting that you know is slow, that can be a problem to fix, then you can address the database as well. Caching is going to be a bandaid for your database because it skips over the database because the page is already made. So that is not going to actually help us with the database. Make sure you are optimizing it.  Of course you should use caching, but it is not actually a fix for database issues. So the most important tables for cleanup, in my opinion, you never know, the options table because that looks everywhere, post meta because that's where plugins go to die, WP, post table is really easy to get cluttered and comments, and then plugin tables we want to keep an eye out for. So some good database detective tools, some plugins we're going to look at, and then SQL queries. You can put those in PHP MyAdmin. Your C panel, your server almost certainly has this installed already. Pretty easy to use. If you can go in on the command line, you can log into MySQL and just run them directly from there as well. So it works in both places. That's Sherlock Holmes. So always back up your database first. I use WP MigrateDB. It's free. It's super reliable. There's lots of ways you can migrate or you can back up your database, but this takes two seconds and really easy to use. But make sure you're backing things up before you go in and delete something accidentally. That's the opposite of what we want to do. So WP Optimize, we mentioned, it can't do everything, but there are some things it can do. In your table information, you get the records, which is what I call the rows, the number of rows you have, and then the data size. So these are the two things we're looking at. And you can use some common sense here and say, wow, I have 300 posts in my database. Why are there 30,000 rows? Or I know my WP options table should be two megabytes. Why is it 300? So you can look at what your top tables are, the biggest tables, and that can give you a place to start looking to really drill down and find out what's taking up space, what's the real problem. So what this plugin can do is clean your post revisions. Every time you hit save or save draft or publish on WordPress, it makes a copy of that post. So if you have 5,000 pride and prejudice posts, all of them are saved 30 times. That's a lot of fluff in your database that you can delete. That's great. Removing spam and trash comments, of course, is great. We used to worry about transients, but now WordPress cleans them automatically as a version of 4.4, so make sure you're on the current version of WordPress. And you're always going to want to check the optimized database tables at the end that just cleans things out. So it doesn't get the optimize as good for the posts and comments table. I like to call this spring cleaning. You should do it every few months because these things do tend to fill up, but it's not going to solve your bigger problems in the option table and elsewhere. So for advanced cleanup, we're looking at options, post meta, plugin tables. We're just going to go real quick here because we're running out of time. What you're looking for are bad active plugins currently on your site, abandoned data from old plugins like Jeff's situation, and then import data that might be hiding in your post meta from Blogger or Tumblr. I moved my site to WordPress about 10 years ago, and not only did it copy everything into posts, it copied it into post meta as well. So I was sitting there for no reason and I found this on some other client sites, and that's something really funky that you can look for as well. So some problem plugins, social media share counters, popular posts counters, anything that is counting on all of your posts, terrible for the database.  A search program or a search plugin like Relevancy creates a database inside your database. Obviously that takes up space, so I'm going to tell you not to use these things, but if you are, be aware of what they're doing. Maybe it is a reason to upgrade your server, get some more RAM, make sure you have enough space, but those are some things to be watching out for. Let your plugins do a test install, make sure you know what it's doing, WordPress for instance, you have to check a box for it to delete stuff when you delete it. So make sure you look at those options, you know what these plugins are doing. You're going to be using them on your site for years, so take 15 minutes and understand if they are taking a dump in your database or not. So we're just going to look at one quick code example, and I'm going to refer you off to my GitHub for a bunch more. So basically if you've never looked at SQL before, what we're doing here from WP underscore options at the bottom, that's the table we're looking at. We're going to select the count of all, basically we're going to count of all the rows where the autoload column is equal to yes. So any information in your options table that's autoloading, which should be most of it. And then we're going to do that whole big function in the middle, which is giving us a megabyte value. And this is like the secret to inspecting your database. If you can get the megabyte value of what you're looking for, then you can see how much room it's taking out. And that allows you to really break down from the information we got already, from PHP My Admin or whatever. You can go deeper than what the table size is and actually find out, oh, this Facebook page is taking up this percent or taking up this much data. So you would run this SQL statement and this would tell me, here's how many rows are autoloading and here's how much data they take up. And from there I can keep drilling down. I can delete things. I can get more good information. So what your mission is, you really want to get that options table under two megabytes if you can.  Okay, that's it. Thanks a lot.


Hello, hello, writers. I'm Christine Kiefer, author of fantasy fiction and creative writing resources and you are listening to the well-sturried podcast where I share insights, encouragement and actionable advice designed to help you craft sensational novels and build your best writing life. Always in 30 minutes or less, so you can get back to writing, of course. Ready for the show? Let's get talking. Hello, hello, once again, writers, and thank you for joining me for today's episode of the podcast. Today we are talking all about how to set truly effective writing goals. This is a topic that I am super excited to cover as a very type A person. I love my goals, to-do lists, etc. And if you are one in the same, I think you're really going to enjoy this episode. But even if you aren't someone who typically thrives on goal setting, definitely give this episode a listen because goals are powerful and today I am going to show you how to set them and then actually achieve them. Today's topic was actually recommended to me by the wonderful Jen LaSalle, who is a fellow writer and also one of the beta readers who provided feedback for me on my upcoming non-fiction book, Build Your Best Writing Life. More on that in the weeks and months to come. But it's taken me a few weeks to get around to covering this topic. I actually started to write this article several weeks back and then realized that I couldn't really talk about goals without talking about writing practices. And so that's why one of our most recent episodes here on the podcast was all about how you can build a sustainable writing practice. If you haven't listened to that episode yet, make sure to go ahead and give it a listen. You can definitely still listen to this episode first, but this episode works much better within the larger context of writing practices as a whole. But nevertheless, let's dive into this episode's kind of teaser here. Today's episode on how to set truly effective writing goals will share with you why you so often fail to achieve your writing goals in the past, the role that goals should play on both a micro and macro scale in your writing life, and the exact steps you can take to set truly effective writing goals that will help you both find creative focus and avoid the spiral into shame and frustration that I don't know about you, but has so often plagued my writing life in the past when I've failed to achieve the goals that I've set. But before we dive into today's episode, a quick behind-the-scenes update at Well-Storied. Most excitingly, the new tools page on the Well-Storied website is now live. I am often asked about what my favorite tools and resources are for writers, so finally I got my act together and created one whole resource, one webpage that you can go and visit to find all of my favorite apps and services for writers, all of my favorite courses and online workshops, and even all of my favorite writing books. This webpage, like I said, is now live and it's available at well-storied.com slash tools. So make sure to go check that out. Also exciting news to share this week is that it is the final day. Well, let me take a step back. If you are listening in on the day that this episode is premiering or on the weekend after it has premiered, then we are in the final hours of being able to purchase C.S. Lakin's new e-course, Emotional Mastery for Fiction Writers for 50% off. This is a super incredible deal that I have been just so excited to share with you guys all month. I first mentioned it in a few episodes back, but in case you haven't heard of this before and it's not yet September 1st, 2019, here's the deal. C.S. Lakin is a freelance editor and author with more than 20 years of experience in the industry and she has created many online courses and workshops for writers over the years, but her most recent course, which will be premiering on September 1st, 2019, is Emotional Mastery for Fiction Writers and this course is a masterclass in both writing and helping readers work through the emotional cycles that our characters undergo throughout their journeys, but also creating a strong emotional connection between our characters and our readers, really helping readers get invested in our characters and their stories. So if you would like to check out this course, I will leave a link for you below. Just a heads up that it is an affiliate link, which means if you choose to enroll, I will make a small commission on your enrollment at no extra cost to you and that really helps keep the lights on here while storied and helps keep this podcast rolling. So thank you for supporting the podcast in this way. If it is before September 1st, 2019, you can also use the code Early Bird at checkout to enroll in the course for 50% off. Alright, now on to the podcast proper. Today's episode of the podcast translates the latest article from the well-stoyed blog Into Audio titled How to Set Truly Effective Writing Goals. You can find the article that also serves as the episode transcript at www.well-stoyed.com slash goals. Now let's dive in. Sitting down to write isn't always easy. When creative work proves difficult, many writers turn to goal setting to motivate themselves to action, only to experience shame and frustration as they fail to fulfill their goals. Sound familiar? You aren't alone. Goal setting often proves an ineffective productivity hack for one simple reason. A goal is an aim, not an action plan. In his book Atomic Habits, author James Clear poses an interesting question.  Clear defines a system as a plan for achieving consistent progress, in other words, a habit. If you ignored your goal to finish your first draft and instead made a habit out of writing, would you still finish your first draft? If you stopped dwelling on your goal to sell 5,000 copies and instead made a habit out of marketing your work, would you still improve your sales? A goal may show you where you want to be in your writing life, but it cannot help you get there, not on its own. But when you pair a writing goal with an established writing habit, you empower yourself to make the progress you seek. To learn how to build a personal and sustainable writing practice, make sure to check out the episode of the podcast Two Episodes Back. What do effective writing goals look like? The purpose of a goal is to provide focus in your practice. On a macro scale, a goal is the outcome you wish will result from the habit you've created. The first step in setting an effective goal is therefore to understand what you want from your writing life. Ask yourself, what does writing success mean to me? If you're unsure how to answer this question, make sure to check out the article I've linked for you in today's episode transcript at well-storied.com. When you can answer this question with honesty and clarity, it's time to determine the first significant milestone in your path to success. Do you need to finish your first draft? Get your latest revision to your editor? Finally set up your author website? Whatever the case, your big picture goal should drive your writing sessions. Avoid the temptation to add a deadline to this goal. Though a deadline may inspire a short-term spike in productivity, it also introduces an unhealthy pressure to succeed. This pressure frequently pushes writers to work beyond their limits, leading to creative burnout and broken writing practices. Such long-term creative turbulence simply isn't worth the short-term gain. Speaking of the short-term, many writers fail to achieve their everyday writing goals as surely as the significant milestones in their journeys. Why? Because they're focused on productivity over progress. An effective everyday writing goal is one you can easily achieve, especially one that honors input over output. If you're putting in focused time and effort, the volume of work you produce shouldn't matter. You're making progress and effective goals value long-term progress over short-term productivity. Again, if you're ready to build a writing practice around an everyday micro goal you can actually sustain, make sure to check out the article I've linked for you in today's episode transcript or our podcast episode on this topic from two episodes back. Setting Flexible Goals to Avoid Writing Burnout Big picture goals can help you find focus in your writing practice, while an achievable everyday goal is the foundation on which your practice will thrive. But hitting your goals with consistency isn't always possible. Life is messy, and your creative energies ebb and flow over time. If you're too rigid in your goals and expectations, your writing practice may not survive the turbulence. Having tiered writing goals in place helps me remain flexible in my practice and avoid the burnout that can so easily smash a writing habit to smithereens. What do these tiered goals look like? Let's take a look together. First up, I create a maintenance goal. This goal is the foundation of your writing habit, and achieving it helps you maintain the practice you've established. A good maintenance goal is one you can easily achieve on an average day when you're feeling neither drained nor overly inspired. Every writer's maintenance goal will be unique based on their personal writing practice, and it can also change over time. My current maintenance goal is 30 minutes of revision as I work on the fourth draft of my debut fantasy novel, Lady Legacy. The second goal I set is a stretch goal. Some days you'll find that your creative will runneth over and you create in a flurry of inspiration, but when you're high on creative energy, it's easy to push too far, running straight into writing burnout. Because of this, I like to set a specific stretch goal rather than writing until I run out of steam. When I reach my stretch goal, I take a moment to evaluate my creative energy levels. If I feel I'm pushing myself too hard, I call my session complete, but if I'm doing fine, I write until I reach my stretch goal a second time. I then evaluate my creative energy levels once again. This mindful approach helps me maximize my creative energy while avoiding writing burnout. My current stretch goal is an extra 15 minutes of revision. When drafting, it's usually an additional 250 words. And finally, the third goal I set is a recovery goal. Just because your writing practice is sustainable doesn't mean you won't experience a low creative energy level from time to time. When you do, it's helpful to have a recovery goal in place. Rebuilding a broken writing habit is far more difficult than simply asking a bit less of your writing practice on any given day. By necessity, a recovery goal should be less demanding than your maintenance goal. My own is currently 15 minutes of revision rather than my typical 30. Every day, when I sit down to write, I take a moment to consider where my creative energy level stands. I don't want to run into writing burnout true enough. But having tiered writing goals in place also helps me avoid the shame and frustration that can come with failing to flawlessly execute my writing practice every single day. As you set out to build the writing life you long to lead, don't hinge your hopes and dreams on goal setting. Instead, use writing goals as a tool to focus your creative efforts. By harnessing goals as part of a larger system, you can't fail to make meaningful progress toward your personal definition of writing success. And I can't wait to celebrate with you in all that you achieve. Thank you for listening to today's episode of The Podcast Writer. I hope you found it helpful to your writing journey. If so, make sure to subscribe to the podcast so you never miss a new episode. And to give the podcast a quick rating and review. Doing so goes a long way toward helping the podcast reach new writers and lets me know that you're enjoying what I'm creating. You can also give me a shout out directly on Twitter at Kristen underscore keeper. For additional guidance as you work to craft sensational novels and build your best writing life, be sure to head on over to www.well-storied.com where I share blog posts, workbooks, e-courses, and other helpful resources for writers. Again, that's w-e-l-l-s-t-o-r-i-e-d.com. Thank you again for tuning in to today's episode my friend. Until next time, happy writing!


Does the Bible teach the Trinity? Well in today's video we're going to uncover how the Bible absolutely does teach this triune existence of God starting from Genesis going all the way through. So this is going to be a couple of parts so that this won't be too long of a video but we're going to show not just in the New Testament but also the Old Testament that the Bible indeed teaches that Jesus is God, that God exists as God the Father, God the Son, and God the Holy Spirit. Hey my friends I want to thank you once again for joining us. My name is Cory Miner and if you haven't done so already please please hit the subscribe button that way you'll be notified of any future videos. Also hit the bell notification button and be so kind as to hit a like if you do indeed like the video and if the video is a blessing or a benefit please remember to share it with someone. From the very beginning the Bible teaches this concept of this triune God this God who exists in this if you will this plural form. Now depending upon your theology your belief in this the very first portion of the Bible may give it indication that God in fact does exist as God the Father, God the Son, and God the Holy Spirit. Though the Bible doesn't use the exact word trinity we do know that the trinity does exist. So what I mean by that is that the Bible says that in the beginning God well the word that's used is the word Elohim and now depending upon what your belief is you'll take that word to be the very first illusion in the Bible that God exists in this plural sense in this in this triune fashion because the word Elohim with the Yadmim the in part that you hear typically in Hebrew refers to a plurality. There are three ways that you number in Hebrew one there's a singular then there's a dual and then there's the plurality or the plural which is three four five five million what have you. Well why would we say that this Elohim refers to that because the Yadmim in Hebrew tends to refer to the plural so so the example that that so the example that I may use or that I typically use is that of the word horse, Seuss. Seuss means horse, Susayim means horses meaning two horses dual and then Seussim is plural three or more horses and so the word Elohim means or could mean the plurality. Now there are some that would say that this this Yadmim may not necessarily refer to a plural existence but it only refers to the singular God. Now I won't go too far grammatically as to why that may or may not be but suffice to say depending upon your theology will determine which way you want to see it. However if you go forward in the Bible because if all we have was Genesis 1 1 and all we had was Elohim then then it'd be hard to to make the the case that there is this triune existence of God but we have more than just Elohim we have more than just Genesis 1 1 as a matter of fact if we just go a little further in Genesis 1 we see the Bible saying something that might be a little odd for those who don't accept God as having this this triune existence. In chapter 1 verse 26 he says let us make man in our image well there's a problem then if you don't believe that that God exists in this triune fashion because who's the us in the hour that God is referring to now and I don't want to get too far into that because I've got a long way to go and a lot of verses to cover but it seems to say if all we have was Genesis chapter 1 that something doesn't quite sound right who speaks in these ways and who speaks in this in this fashion let us make man in our image and of course you see that again in other in other parts of the Bible where he refers to himself in this plurality such as in Isaiah he says who will who will go for us but so the question is not so much could God exist in this triune fashion could could God exist as God the Father God the Son God the Holy Spirit the question is not could he the question is would he well then so let's see if the scripture kind of opens the door for us still so that we can see that more clearly I think it does God wants to interact with man the only problem is he can't because of the fall of man because of sin God can't interact with us the way he did let's say with Adam and Eve in the very beginning whereas they were the only ones who could see the fullness of God why because at at one point they didn't have sin and so they can be in his presence and we know that man can't be in the fullness of in God's full presence because of sin Moses lets us know that as a matter of fact we'll actually get to that that verse later on but if God wants to interact with us how can he do so well what if he did so in a veiled form well what do you mean veiled form well there's this term that you may have heard before called theophany or christophany what that is is it is an appearance of deity in human physical form the first time that we see Jesus on the scene is not in the gospel during his incarnation the first time the first time that we see Jesus uh who I believe is Jesus and I believe you go to once we go forward is early on these appearances of God in human form and we're going to see him called by many different names or titles now I'll start off with one of the weakest examples and I'll say this the weakest example because you can't really point to a whole lot of definite scriptural scriptural basis to say that this is definitively Jesus or the incarnate Christ the pre-incarnate Christ in Genesis chapter 3 verse 8 after Adam and Eve had both eaten of their fruit we read this and they heard the sound of the Lord God walking in the garden in the cool on the day and the man and his wife hid themselves from the presence of the Lord God among the trees of the garden it seems to be saying that they are hiding from a physical person walking who is physically walking they hear this sound and they hide themselves from as they said as the Bible says the presence of the Lord God well is it possible that they just heard his voice and hid from it that's possible also uh is it also possible that they heard this physical walking that's possible also that's why I said this is my weakest example but let's move a little further and see if I can make the point even more conclusively we're going to see throughout Genesis ex this numbers you'll see it in Deuteronomy in Judges Joshua all throughout the Old Testament this God showing up and interacting with man remember these are what's called these theophanies or Christophanies these appearances of Christ or God in human physical form one such example is in Genesis chapter 16 verse 9 let's go there this is where the angel of the Lord is speaking with Hagar well why would you say that's God when he clearly says the angel of the Lord well let's read and see if we can glean from it he says return to your mistress and submit yourself under her hand then the angel of the Lord said to her I will multiply your descendants exceedingly so that they shall not be counted for multitude and the angel of the Lord said to her now forward who speaking the angel of the Lord and notice what he says he's going to do behold you are with child and you shall bear a son and you should call his name Ishmael because the Lord has heard your affliction but look at verse 13 then Hagar she's called the name of the Lord who spoke to her you are the God who sees for she said I have also seen I have also here seen him who sees me so look what Hagar calls him she says she calls the angel of the Lord says that you are the God who sees and she says that I have also seen him who sees me so Hagar calls this the angel of the Lord she calls him God well is she confused well let's look at some more verses and see if it's just her in Genesis 22 verse 11 Abraham who probably is not confused as to who God is because remember God has been speaking to him he told Abraham to leave out of his father's land into a land that he will show him so he's fully aware of who God is and recognizes him and his voice and look at chapter 22 verse 11 but the angel of the Lord called to him from heaven and said Abraham Abraham so it's the angel of the Lord calling to Abraham from heaven verse 12 he said do not lay a hand on the lad or do anything to him for now I know that you fear God since you since you have not withheld your son your only son from me wait a second he uses the personal pronoun me the angel of the Lord does the angel of the Lord calls from heaven and says that you have not withheld your only son from me but in verse 14 Abraham called the name of the place the Lord will provide as it is said to this day in the mount of the Lord it's provided look at verse 15 then the angel of the Lord called to Abraham a second time out of heaven and said by myself I have sworn says the Lord so the angel of the Lord is also called the Lord now think about this for a second as we go forward I want you to remember all these different titles all these different names of descriptions of God who is the Lord the Lord not a Lord there are many people who might be a Lord over this town over this household but who is the Lord there's only one person that's ever been given the title the Lord right that's being God God is the Lord but we get to the New Testament and Eden Jesus called the Lord well let's just stick here in the Old Testament but right here the angel of the Lord is called the Lord he's also called God as well so we see the angel of the Lord being called God and the Lord so let's keep going to Genesis chapter 31 verse 13 the angel of God says I am the God of Bethel where you anointed the pillar and and where you made a vow to me so here the angel of God is called God well is the angel of God the same as the angel of the Lord the same as the Lord well the angel of God is also called God the angel of the Lord is also called the Lord is also called God so the angel of the Lord and the angel of God seem to be one of the same so now let's go look a little further one page over in chapter 32 many of you are familiar with this verse this particular famous passages where Jacob wrestles with a man but let's see if it's just a man in verse 24 then Jacob was left alone and a man wrestled with him until the breaking of day well who was this man we'll see now when he saw that he did not prevail against him that is the man that was wrestling with Jacob he touched the socket of Jacob's hip and the socket of Jacob's hip was out of joint as he wrestled with him and he said the man did to Jacob let me go for the day breaks but he that is Jacob said I will not let you go until you bless me so he said to him what is your name Jacob and he said your name shall no longer be Jacob but Israel for you have look at this struggled with God and with men and had prevailed then Jacob said or answered or asked saying tell me your name I pray and he said why is it that you ask about my name and he blessed so Jacob called the name of the place pinion for I have seen God face to face and my life is preserved so here we see Jacob wrestling with this man and the man says that your name should be Israel why because you have wrestled with God and prevailed Jacob calls the place pinion because he says I have seen God face to face and have lived so here we see another example of God showing up in the form of a man wrestling with Jacob and Jacob identifies this person that he's wrestling with as God because he says so does Jacob know who God is well I think he does he's been interacting you're talking with God and God is the one who changed his name from Jacob to Israel and so here's another example of God in the form of flesh wrestling with man in this case so now let's move a little further we're going to skip Exodus and I want to go to numbers and give another example numbers chapter 22 speaks about bomb and and this donkey and the angel of the Lord and look what it says then God's anger was aroused because he went and the angel of the Lord took his stand in the way as an adversary against him so we see the angel of the Lord here standing and as we read first I don't want to go too far into it because it's for just for lack of time but we keep seeing what the angel of the Lord is saying and what the angel of the Lord is doing and let's go down further so the angel of the Lord is who's talking verse 34 and my lamb said to the angel of the Lord I have sinned for I did not know you stood in the way against me now therefore if it depletes you I will return back keep going down further 35 then the angel of the Lord said so we still see it's the angel of the Lord speaking verse 38 and the lamb said to black look I have come to you now have I any power at all to say anything the word that God puts in my mouth that I must speak what way to say I thought this was the angel of the Lord but here the man testifies that this was God more examples let's go to judges in chapter 6 verse 12 we see Gideon coming in contact with the Lord let's look and the angel of the Lord appeared to him and said to him the Lord is with you here it is again the angel of the Lord the Lord and then dropped down to verse 20 the angel of God so now it departs from the angel of the Lord and the Lord took the angel of God and verse 20 said to him take the meat and unleavened bread and lay them on the rock verse 21 then the angel of the Lord put out the end of his staff so and I'm just jumping around because it's for lack of time but I want to see I want you to see all the different names and titles that are being used here then go to verse 22 and here we see now Gideon perceived that he was the angel of the Lord so Gideon said alas oh Lord God for I have seen the angel of the Lord face to face so here we see these examples with Gideon with Balaam with Jacob with Abraham with Hagar of God interacting with him as a man physical form was as a man who had flesh we know because he wrestled with Jacob and his name is called the angel of the Lord the angel of God the Lord and God okay so you might be wondering how in the world does that even mean that that's Jesus what we'll see in a second recall who led the children of Israel out of captivity so go back to Exodus now verse 17 and 18 then it came to pass when Pharaoh had let the people go that God did not lead them by the way of the land of the Philistines although that was near for God said less perhaps the people changed their mind verse 18 so God led the people so who's leading the people God is leading the people right just want to make sure that's clear God is the one that's leading the children of Israel out of captivity right and then in verse 21 look what he says and the Lord that makes sense went before them in a pillar of cloud to lead them by the way and by night in a pillar of fire he did not take away the pillar of cloud by day or the pillar of fire by night from before the people so we see God leading them in this form this fire and this cloud that's kind of important because I want you to see the elements that God is also showing up in it's the Lord who's leading them as a pillar of fire by night and a pillar of cloud by day right so now let's go to chapter 14 verse 19 and the angel of God who went before the camp of Israel moved between them and behind them this was this was happening when the when the the Egyptians were getting close to the children of Israel and so God goes from being in front of them to move behind them but look what he's called this time the angel of God now let's go to chapter 23 of Exodus verse 20 behold I've seen an angel before you to keep you in the way now all angels simply means is just in the Hebrew word for this is just the word for messenger right or also angel but is this a particular messenger well let's see 21 beware of him and obey his voice do not provoke him for he this angel this messenger will not pardon your transgressions if you if you provoke him this messenger will not pardon your transgressions you mean tell me there's an angel a messenger who will be able to pardon your sins your transgressions some kind of angel huh for my name is in him but if you indeed obey his voice and do all that I speak then I will be an enemy to your enemies verse 23 for my angel will go before you and bring you into the Amorites and Hittites and so forth so now but he says my name will be in him wait a second you mean to tell me God you are going to put your name into someone else's that wait a second how could that be God because you don't share your glory with anyone else oh I might be getting ahead of myself because I don't want to I want to use that passage those passages for next week God doesn't share his glory with anyone and his name is his and his alone so why does he seem to be sharing that with somebody else unless he's not sharing with sharing it with somebody else remember in the beginning of Exodus chapter three this is when Moses was tending the flock and he sees something and let's just read the passage that I want you to make note of who is who and what's what verse two the angel of the Lord appeared to him appeared to who the angel of the Lord appeared to Moses in a flame of fire from the midst of the bush so he looked and behold the bush not burning then verse three Moses said I will now turn aside to see this great sight while the bush is not burned so it's the angel of the Lord appearing in this bush in this flame verse four so when the Lord saw that he turned aside to look God called to him from the midst of the bush appearing in this bush in this flame verse four so when the Lord saw that he turned aside to look God called to him from the midst of the bush wait a second I thought this was the angel of the Lord then it says the Lord saw but then God called so we've got again the angel of the Lord the Lord and God calling out from Moses to Moses out of this burning bush out of this fire because God shows up in the form in this fire also he shows up we'll see later as Moses meets with him in this cloud and remember who led the children of Israel out of Egypt God in the form of this cloud and this fire and so we'll see him interacting with Moses in both in both of these forms and so clearly God can take on the form of fire if he so chooses because he does right here right but notice what he's called he's called the angel of the Lord he's called the Lord and he's called God but then later on when Moses says to him when you when people ask who shall I say sent me what does God say we all know this I am so we've got the angel of the Lord the Lord God and I am okay well so well the so is and we'll just go ahead just just just briefly um we all remember the passage in John chapter 8 when Jesus said before Abraham was ego eme which is I am and the Jews knew exactly what that meant because they took up stones to kill him because he's calling himself God so even early on we see God taking on this form of man of flesh because again the question is not could God but would God is it possible for God to be in heaven picture this God is in heaven he's also here on earth in this case in Exodus 3 he's in the form of this fire so is it possible that God can be in the fire while at the same time still be in heaven well sure because that's exactly what's happening here is it possible that God can be in the fire speaking of Moses his presence still be in heaven but also his presence because he's out in the present still being Africa Asia Europe North America is it possible that God can be all over the world his presence his spirit all over the world at the same time that's possible matter of fact not only is it possible that's where that's what David even says where can I go that you're not your presence so his presence his spirit is on earth his fullness dwells in heaven while at the same time he can take on flesh because he did he took on fire he wrapped himself in fire but he can wrap himself in flesh and come and die for us my friends that is the definition of the Trinity and so there's more passages for us to see because I want to make this not just clear I want to make it abundantly clear but for this video suffice it to say we see some examples of God showing up in physical form as God


Good morning cyber traders. Happy Friday on the third of August has everybody doing good to see you can get to see you John Jody Neil This time who's great names can you see a Benito? Collins Dave Steven all you guys chatting away. Well listen. Good morning everyone. Hopefully everyone's having exciting Friday I'm telling I'm all up. I think I'm done Trading already this morning. I mean this WM LP, you know, I keep saying it early bird gets the money You know and just want to kind of bring it up over here and just show you on the you know on on the account manager You could see it right here. I never sold it. I was just upset. I'm just really upset at myself that I only got 2000 shares of it That's the only thing I was really really upset, but you could see the WMP. I got a 257 and Right now it's at 550. The thing is just been an animal. You could see that pop now I just want to kind of bring this up a little bit. Also, you could see in the chat I'm just gonna bring up the chat here Just kind of show you on my screen and show you what we're looking at right here And you could see we started trading this thing. I'm gonna go up all the way to the top You know obviously the room opens up at 8 a.m And you could see right here all the the times when we started it And you could see right here when the traders are already in it look listen and learn from from Grant Benito is trading the IQ but then here nice pop in WM LP that was at 818 Early bird gets the money and then all of a sudden here comes the winners plus 52 plus 32 Okay, everyone out there is just basically trading Just boom boom boom wish I bought more at 825 what times it right now 907 I mean you could just just go right down the list up $2 and 15 minutes boom boom boom So anyway just wanted to kind of show that really quick because I'm gonna have a lot of people are gonna be watching this On YouTube and Facebook and Twitter and they just don't understand how important it is to trade in pre-market It is just really really important to make to do that And just want to kind of bring up one person Neil was asking me a question He says Fausto what is the cyber trading news feed regarding the WM LP because Deb was saying Fausto It's all over Twitter, you know regarding about this trade. What is the news feed? The news feed is being in the cyber group room when we open at 8 a.m. That's the news feed All right listen, I deal with the I got you know here at cyber trade adversity I have you know several different platforms that we use that will help scan it and find it But it's not just scanning it it doesn't just because we find it doesn't mean it's going to move You know what you're getting here being in the cyber group room You're getting the experience of me you're getting the experience of the students that I trained in there And the team effort and that's where that came in. So hopefully Neil that answers your question And the same thing for you Deb Deb Stack asks Stack actually say the other question stack X to save the other question. All right, anyway, so we got that stock right on our watch list. That one is doing just fine and doing great. So we're gonna keep a close eye on that one. Now regarding about, there are a couple of the ones if you missed out, we're gonna check them out. There are a few more on my list. I'm gonna look at them and check them out and tell you which ones they are. But I wanna talk about what happened yesterday because yesterday also was a great, great day. And where do we made all our money? Sono. Let's go bring up that one. S-O, oops, spelled the wrong, S-O-N-O. Sono was just a killer profit yesterday. What did I do? So some of you guys are asking me, I bought up the stock early in the morning at 9.30 and I said, let's keep an eye on the IPO ones. Keep an eye on Sono and everybody's typing in. So it was not even a stock. I said, of course not a stock and it didn't go public yet. So we had to put it on our watch screen and watch what happens when it opened up. And cause we've been doing great on IPOs. And look at Sono. It started at $16. Look where it went. Boom, all the way to about one, right to the close. It popped even in the last 30 minutes. We're into 21.  A couple of round of applause. Andrea, he made four bucks on that trade.  He was probably the biggest winner out of all of us. He even made more money than me on that, Andrea. Lisa made a buck 50, Steve made over a buck. I mean, a lot of people did money. That was our really nice, nice big winner. There were a couple of the ones that did pretty well.  Obviously, you know all the great news about US Steel with President Trump, but obviously it's not really working out too well. Looks like stock is down, actually, but it's at good support levels. You know, that's a good thing right there, but US Steel, you made a lot of money with US Steel, but obviously when it came out, obviously it didn't work out. I don't know why they got crushed. So anyway, that one did pretty well. On the short side, TEVA was also another one. It was a great little short yesterday, too. So overall, it's been so far. I've been a great, great trade. Fast and 2K is better than one share. Right, Ken?  You know, and the reason why I say trade one share of stock is because if you can't trade one share, you can't trade a thousand. It comes a time when you gotta get off and stop trading on demo mode and stop being a deer in the headlights.  Listen, that's it, you hit it. If you're worrying about ticket charges, trading is not for you. You're never gonna make money in this, you know? And I told everybody that's in the room. You'd be part of the room. You see what it costs to be a student and to be part of the team.  And how do I know that? Because I know what I can do. And you know what? With the newsfeed this morning on the WMLP, paid for itself right then and there, everybody should have made a lot of money on the WMLP. And the stock market didn't even open up and the stock's up 176% today. So you're gonna see a lot of people just like jumping on the bandwagon and everything else. Just remember, you heard it here first, 8 a.m. in the morning, boom, WMLP, you made money.  What's gonna happen? I'm not kidding.  AWX, right? What happened to AWX yesterday last week? AWX, I had people says, well, how'd you find AWX? You know, stock, you can see it went all the way to about over $20, $30 actually, $20. People like, why did the stock go up? How did you find it? That's what we do here. So when I say we get it every week, people like that, I don't believe that. I never even been in one. You're finding them every week? Well, we just found another one, you know, in the WLMP. All right, so anyway, let me go through the watch list. So we got that one on our list, WLMP. I want to get ready for the open. There's a few others that I did find. I saw this one. I don't know if I was too crazy about it, but the SWIR, she's trade about 50,000 shares. She's gapping up a little bit. I wasn't too crazy about the pre-market.   What else we had? You know, the TTWO, take two, that one you could see, but it's expensive, you know, it came back, took a big hit, but it's expensive. You really want to spend that much money? I don't know. So-no is definitely going to stay on our watch list, keeping that one on our list, S-O-N-O. That one, it looks like it's still piggybacking from yesterday, you know, from yesterday. And there are a couple of stocks are taking some nasty hits. I am going to kind of focus on some of the, maybe bottom fishing, WRXT. By the way, yesterday's YouTube video that I did, I was talking about bottom fishing. I don't want to, you know, get off what we're looking at, but I did talk about bottom fishing, the big bottom fish that I spoke about was race. You know, look what happened to race guys. Race got crushed, you know, went from 135 down to 117, and look what ended up happening. Stock had a huge rally, went from $17. It was a great, great bounce. Even from yesterday, 122 to 128. Now look where it is back to 130. Great, great, great bounce back on that one.  There was the one of the stock, the PBR, which Josh brought up this morning. PBR looks pretty strong. It's got a nice little move right now. The PBR, let me put the race on my watch list. I got to write that one down. That one's not terrible, but you could, by the way, races. You know, the third biggest percentage caterer on the New York Stock Exchange. Now overall, that's it guys. If you missed the pop on the WMLP, listen, that's okay. You know, that's okay because there's gonna be more like it. They're always out there every day. We always got new ones every single day. Just hopefully it's a wake up call and tells you guys, you got to get in the room early.  People are like, you know, I got a second job, or I don't know if I can make it, or maybe your West Coast is too early for me. You know what, you could have just woke up for 15 minutes, jumped in here and went back to sleep, or definitely could have went get ready and go to work. So that's what's great about this job. That's why we love it. But you know what, this is what we train for. This is what we do. And this is why we love being day traders. So anyway, not a big list guys. We got one, two, three, four, five stocks. It's a typical Friday. It is a going to be a scorching, hot summer day here in New York City. I already spoke to a bunch of my friends yesterday. They already left for the Hamptons. They're already going there some home. They're gonna be gone for about two days.  So, you know, one thing we learned about Fridays, you know, if news comes out from yesterday, the stocks are gonna basically, you know, they're a lot easier to trade. A lot easier to move when it comes to the market. But don't expect it to be very volatile on like the typical hump days of Tuesdays, Wednesdays and Thursdays. All right, guys, anything I missed, I did not call out before we get ready for the open. All right, so with that said, listen, I have a lot of appointments with you guys today. Look forward to talking to a lot of you. Hopefully a lot of you that I'm gonna be talking to today to kind of do your consultation to see if trading is for you or not and see if we think you're, you know, if this is for something for you to do, look forward to talking to you. And then also, 12 o'clock today, open house, we're gonna be inviting a bunch of new traders coming in here. We're gonna talk a little bit about, hopefully we can put some light into their eyes and let them know of trading for them. And then hopefully it can do a trial here. So go out there. If you didn't register or you need to tell anyone 12 o'clock today, we're gonna be doing an open house here in the trading room. And by the way, if you're on YouTube or Facebook or Twitter, you can register for free right on the homepage of our website. All right guys, listen, good luck today. Happy trading. Great day so far this morning. And don't worry, markets didn't even open up yet. So we're definitely gonna find a bunch more coming out. All right guys, good luck today. Happy trading everyone.


Life is good all this month at Appalachian Wireless. Get the LG G5 for just one penny with sign up or renewal of a two year service agreement. That's almost $100 off the regular price. Better service, bigger savings. That's today's Appalachian Wireless. Eric C. Kahn wherever he may be remains in the hot seat with federal officials. Now others may be in the hot seat as well. The FBI revealed this morning that alleged co-conspirators in Kahn's escape may face charges as early as Monday. The FBI also updated the case this morning during a press conference in Louisville. We've been pursuing all investigative leads to include conducting interviews of Mr. Kahn's family, friends and associates, reviewing emails and social media posts purportedly originating from Mr. Kahn and we've been talking with his attorney in an effort to convince Mr. Kahn to turn himself in and yesterday the FBI, KSP and Social Security Administration personnel executed a search warrant at the residence of Mr. Kahn's mother in Pikeville. His law office and a vehicle were also searched and currently we're examining all of the items that were seized and on Monday we will undertake further action with the expectation that charges against additional co-conspirators including family members and associates of Eric Kahn will likely follow. We continue to narrow the focus of our investigation into Mr. Kahn's whereabouts and will bring all available resources to bear until he's found. When defendants violate the terms of their plea agreement, it's the common practice of the prosecution to reconsider certain aspects of the agreement. This case is no different and all options are being discussed and anyone with information regarding the whereabouts of Mr. Kahn is asked to call the Louisville FBI office at<PHONE_NUMBER>. This is an important case. This is probably one of the most important cases that we are working today. There are currently no plans to increase the reward offered for Kahn's arrest. Reporting from the FBI headquarters in Louisville, Chris Anderson, EKB News.