|
|
||||
|
Wednesday, November 5, 2008
My neighborhood went nuts last night. A street party spontaneously combusted as the reports came in of Obama’s win. Whoops, whistles, howls of joy. And pots and pans! Love it when people bang on pots and pans. On New Year’s Eve it happens too, but this was way better. Congo drums in the streets of Read More >> Picture lightning striking a sturdy old clock tower. The cataclysmic Saturn-Uranus opposition gave us the perfect modern symbol of this ancient tarot card image, when the most reputable banks in the world (Saturn) collapsed (Uranus) like a house of cards at the Full Moon in September. Read More >> |
 Jessica Murray
ASTROLOGER ~ AUTHOR
Jessica Murray trained as a fine artist before graduating in 1973 from Brown University, where she studied traditional psychology and linguistics. Read More >>
Loading...
SKYWATCH SUBSCRIPTION
Read Jessica's Skywatch for an overview of each month's important themes.
When you purchase a subscription you will have access to the Skywatch at the beginning of every month. ANNOUNCEMENTSLATEST INTERVIEWSSoul-Sick Nation:
An Astrologer's View of America
Republished by Jessica Murray MotherSky Press
  FEATURED ARTICLESBLOG ARCHIVEMySQL server version: 5.0.89-community-log
collapsArch options:
Array
(
[title] => BLOG ARCHIVE
[noTitle] =>
[inExcludeCat] =>
[inExcludeCats] =>
[inExcludeYear] =>
[inExcludeYears] =>
[showPages] =>
[sort] => DESC
[linkToArch] =>
[showYearCount] =>
[expandCurrentYear] => 1
[expandMonths] => 1
[expandYears] => 1
[expandCurrentMonth] => 1
[showMonthCount] =>
[showPostTitle] => 1
[expand] => 0
[showPostDate] =>
[debug] => 1
[postDateFormat] => m/d
[animate] => 0
[postTitleLength] =>
[showPostCount] =>
[archSortOrder] => DESC
[showPosts] =>
[showMonths] =>
[customExpand] =>
[customCollapse] =>
)
POST QUERY:
SELECT wp_terms.slug, wp_posts.ID, wp_posts.post_name, wp_posts.post_title,
wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
MONTH(wp_posts.post_date) AS 'month'
FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
wp_term_relationships.object_id
LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
wp_term_relationships.term_taxonomy_id
LEFT JOIN wp_terms ON wp_terms.term_id =
wp_term_taxonomy.term_id
WHERE post_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND post_type = 'post' AND wp_terms.slug IN ('blog')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
POST QUERY RESULTS
Array
(
[0] => stdClass Object
(
[slug] => blog
[ID] => 3337
[post_name] => imagine
[post_title] => Imagine
[post_date] => 2010-02-13 09:26:07
[year] => 2010
[month] => 2
)
[1] => stdClass Object
(
[slug] => blog
[ID] => 3238
[post_name] => monsters
[post_title] => Monsters
[post_date] => 2010-01-23 17:36:03
[year] => 2010
[month] => 1
)
[2] => stdClass Object
(
[slug] => blog
[ID] => 3116
[post_name] => cry-uncle
[post_title] => Cry Uncle
[post_date] => 2010-01-10 17:24:40
[year] => 2010
[month] => 1
)
[3] => stdClass Object
(
[slug] => blog
[ID] => 2579
[post_name] => show-biz-politics
[post_title] => Show Biz Politics
[post_date] => 2009-12-12 23:57:02
[year] => 2009
[month] => 12
)
[4] => stdClass Object
(
[slug] => blog
[ID] => 2029
[post_name] => whose-tradition
[post_title] => Whose Tradition?
[post_date] => 2009-11-23 12:33:26
[year] => 2009
[month] => 11
)
[5] => stdClass Object
(
[slug] => blog
[ID] => 2024
[post_name] => open-the-window
[post_title] => Open the Window
[post_date] => 2009-11-10 12:28:53
[year] => 2009
[month] => 11
)
[6] => stdClass Object
(
[slug] => blog
[ID] => 854
[post_name] => pumpkins-and-pagans
[post_title] => Pumpkins and Pagans
[post_date] => 2009-10-22 20:59:00
[year] => 2009
[month] => 10
)
[7] => stdClass Object
(
[slug] => blog
[ID] => 853
[post_name] => laying-down-the-law
[post_title] => Laying Down the Law
[post_date] => 2009-10-11 18:46:00
[year] => 2009
[month] => 10
)
[8] => stdClass Object
(
[slug] => blog
[ID] => 851
[post_name] => guns-and-butter
[post_title] => Guns and Butter
[post_date] => 2009-09-26 08:17:00
[year] => 2009
[month] => 9
)
[9] => stdClass Object
(
[slug] => blog
[ID] => 850
[post_name] => brothers-under-the-skin
[post_title] => Brothers Under the Skin
[post_date] => 2009-09-15 10:11:00
[year] => 2009
[month] => 9
)
[10] => stdClass Object
(
[slug] => blog
[ID] => 849
[post_name] => trigger-transits
[post_title] => Trigger Transits
[post_date] => 2009-09-09 09:04:00
[year] => 2009
[month] => 9
)
[11] => stdClass Object
(
[slug] => blog
[ID] => 848
[post_name] => sick-as-a-dog
[post_title] => Sick as a Dog
[post_date] => 2009-08-24 09:54:00
[year] => 2009
[month] => 8
)
[12] => stdClass Object
(
[slug] => blog
[ID] => 847
[post_name] => mob-rule
[post_title] => Mob Rule
[post_date] => 2009-08-16 11:00:00
[year] => 2009
[month] => 8
)
[13] => stdClass Object
(
[slug] => blog
[ID] => 844
[post_name] => bad-dads
[post_title] => Bad Dads
[post_date] => 2009-08-03 18:50:00
[year] => 2009
[month] => 8
)
[14] => stdClass Object
(
[slug] => blog
[ID] => 843
[post_name] => idiot-box
[post_title] => Idiot Box
[post_date] => 2009-07-26 11:37:00
[year] => 2009
[month] => 7
)
[15] => stdClass Object
(
[slug] => blog
[ID] => 840
[post_name] => this-is-the-dawning
[post_title] => This is the Dawning
[post_date] => 2009-07-19 16:29:00
[year] => 2009
[month] => 7
)
[16] => stdClass Object
(
[slug] => blog
[ID] => 839
[post_name] => eclipse-of-the-heart
[post_title] => Eclipse of the Heart
[post_date] => 2009-07-15 12:44:00
[year] => 2009
[month] => 7
)
[17] => stdClass Object
(
[slug] => blog
[ID] => 838
[post_name] => love-and-pain
[post_title] => Love and Pain
[post_date] => 2009-06-27 18:05:00
[year] => 2009
[month] => 6
)
[18] => stdClass Object
(
[slug] => blog
[ID] => 837
[post_name] => cant-tell-the-players-without-a-scorecard
[post_title] => Can't Tell the Players Without a Scorecard
[post_date] => 2009-06-20 19:38:00
[year] => 2009
[month] => 6
)
[19] => stdClass Object
(
[slug] => blog
[ID] => 836
[post_name] => boom
[post_title] => Boom
[post_date] => 2009-06-06 17:51:00
[year] => 2009
[month] => 6
)
[20] => stdClass Object
(
[slug] => blog
[ID] => 835
[post_name] => the-surrealism-of-size
[post_title] => The Surrealism of Size
[post_date] => 2009-05-25 17:18:00
[year] => 2009
[month] => 5
)
[21] => stdClass Object
(
[slug] => blog
[ID] => 834
[post_name] => deceit-on-capitol-hill
[post_title] => Deceit on Capitol Hill
[post_date] => 2009-05-17 09:45:00
[year] => 2009
[month] => 5
)
[22] => stdClass Object
(
[slug] => blog
[ID] => 833
[post_name] => let%e2%80%99s-make-him-do-it
[post_title] => Let’s Make Him Do It
[post_date] => 2009-05-10 18:09:00
[year] => 2009
[month] => 5
)
[23] => stdClass Object
(
[slug] => blog
[ID] => 832
[post_name] => animal-farm
[post_title] => Animal Farm
[post_date] => 2009-05-04 11:43:00
[year] => 2009
[month] => 5
)
[24] => stdClass Object
(
[slug] => blog
[ID] => 831
[post_name] => santa-pluto
[post_title] => Santa Pluto
[post_date] => 2009-04-18 18:44:00
[year] => 2009
[month] => 4
)
[25] => stdClass Object
(
[slug] => blog
[ID] => 830
[post_name] => better-dead-than-red
[post_title] => Better Dead Than Red
[post_date] => 2009-04-13 09:38:00
[year] => 2009
[month] => 4
)
[26] => stdClass Object
(
[slug] => blog
[ID] => 829
[post_name] => tell-me-no-lies
[post_title] => Tell Me No Lies
[post_date] => 2009-04-09 08:01:00
[year] => 2009
[month] => 4
)
[27] => stdClass Object
(
[slug] => blog
[ID] => 828
[post_name] => drugged-senseless
[post_title] => Drugged Senseless
[post_date] => 2009-04-06 07:37:00
[year] => 2009
[month] => 4
)
[28] => stdClass Object
(
[slug] => blog
[ID] => 827
[post_name] => cream-pies
[post_title] => Cream Pies
[post_date] => 2009-03-31 17:01:00
[year] => 2009
[month] => 3
)
[29] => stdClass Object
(
[slug] => blog
[ID] => 826
[post_name] => the-great-and-powerful-oz
[post_title] => The Great and Powerful Oz
[post_date] => 2009-03-21 09:44:00
[year] => 2009
[month] => 3
)
[30] => stdClass Object
(
[slug] => blog
[ID] => 825
[post_name] => weed-wars
[post_title] => Weed Wars
[post_date] => 2009-03-13 19:25:00
[year] => 2009
[month] => 3
)
[31] => stdClass Object
(
[slug] => blog
[ID] => 824
[post_name] => barack-we-hardly-knew-ye
[post_title] => Barack, We Hardly Knew Ye
[post_date] => 2009-02-15 10:19:00
[year] => 2009
[month] => 2
)
[32] => stdClass Object
(
[slug] => blog
[ID] => 823
[post_name] => silk-road-blues
[post_title] => Silk Road Blues
[post_date] => 2009-01-24 10:22:00
[year] => 2009
[month] => 1
)
[33] => stdClass Object
(
[slug] => blog
[ID] => 822
[post_name] => ecstasy-and-apostasy
[post_title] => Ecstasy and Apostasy
[post_date] => 2009-01-21 09:21:00
[year] => 2009
[month] => 1
)
[34] => stdClass Object
(
[slug] => blog
[ID] => 821
[post_name] => its-about-palestine-mr-obama
[post_title] => It's about Palestine, Mr Obama
[post_date] => 2009-01-06 08:33:00
[year] => 2009
[month] => 1
)
[35] => stdClass Object
(
[slug] => blog
[ID] => 820
[post_name] => ground-invasion
[post_title] => Ground Invasion
[post_date] => 2009-01-03 20:12:00
[year] => 2009
[month] => 1
)
[36] => stdClass Object
(
[slug] => blog
[ID] => 819
[post_name] => new-moon-massacre
[post_title] => New Moon Massacre
[post_date] => 2008-12-28 10:15:00
[year] => 2008
[month] => 12
)
[37] => stdClass Object
(
[slug] => blog
[ID] => 818
[post_name] => joy-is-great-isn%e2%80%99t-it
[post_title] => Joy is great, isn’t it?
[post_date] => 2008-11-05 13:07:00
[year] => 2008
[month] => 11
)
[38] => stdClass Object
(
[slug] => blog
[ID] => 817
[post_name] => oliver-stones-w-which-i-havent-seen
[post_title] => Oliver Stone's "W", which I haven't seen
[post_date] => 2008-10-28 17:25:00
[year] => 2008
[month] => 10
)
)
SKYWATCH ARCHIVEMySQL server version: 5.0.89-community-log
collapsArch options:
Array
(
[title] => SKYWATCH ARCHIVE
[noTitle] =>
[inExcludeCat] =>
[inExcludeCats] =>
[inExcludeYear] =>
[inExcludeYears] =>
[showPages] =>
[sort] => DESC
[linkToArch] =>
[showYearCount] =>
[expandCurrentYear] => 1
[expandMonths] => 1
[expandYears] => 1
[expandCurrentMonth] => 1
[showMonthCount] =>
[showPostTitle] => 1
[expand] => 0
[showPostDate] =>
[debug] => 1
[postDateFormat] => m/d
[animate] => 0
[postTitleLength] =>
[showPostCount] =>
[archSortOrder] => DESC
[showPosts] =>
[showMonths] =>
[customExpand] =>
[customCollapse] =>
)
POST QUERY:
SELECT wp_terms.slug, wp_posts.ID, wp_posts.post_name, wp_posts.post_title,
wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
MONTH(wp_posts.post_date) AS 'month'
FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
wp_term_relationships.object_id
LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
wp_term_relationships.term_taxonomy_id
LEFT JOIN wp_terms ON wp_terms.term_id =
wp_term_taxonomy.term_id
WHERE post_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND post_type = 'post' AND wp_terms.slug IN ('skywatch')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
POST QUERY RESULTS
Array
(
[0] => stdClass Object
(
[slug] => skywatch
[ID] => 3403
[post_name] => skywatch-march
[post_title] => Skywatch March 2010 ARTICLES ARCHIVE
ASTROLOGY LINKS |
|||
|
|
||||