{"id":73,"date":"2006-04-05T23:12:28","date_gmt":"2006-04-06T05:12:28","guid":{"rendered":"http:\/\/georgeandshannon.com\/blog\/2006\/04\/sql-smeshql\/"},"modified":"2006-04-06T07:05:02","modified_gmt":"2006-04-06T13:05:02","slug":"sql-smeshql","status":"publish","type":"post","link":"http:\/\/blueeyedzoo.com\/blog\/2006\/04\/sql-smeshql","title":{"rendered":"SQL, SmeshQL"},"content":{"rendered":"<p>In helping George with his current coding project I have had to write lots of several simple SQL queries. There&#8217;s a piece of the project that will eventually be available for the client to manage themselves. But in the meantime, it is only accessible through the database. So anytime they find a mistake in the data they gave us, I get to go change it in the database. It was fun for a time, but now it&#8217;s getting old. Things would be easier if I&#8217;d just take the time to re-figure out how to use JOINS instead of going back and forth between querying table a and table b. But it&#8217;s not all bad. I still get to feel geeky &#8211; and get to write geeky posts like this one. <\/p>\n<p>By the way, someone needs to start calling me at 10:30pm and demanding that I go to bed right away. I am up way too late&#8230;again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In helping George with his current coding project I have had to write lots of several simple SQL queries. There&#8217;s a piece of the project that will eventually be available for the client to manage themselves. But in the meantime, it is only accessible through the database. So anytime they find a mistake in the [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/posts\/73"}],"collection":[{"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":0,"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"wp:attachment":[{"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blueeyedzoo.com\/blog\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}