WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE post_status = 'publish' AND ID IN (39,38,37,27,26,24,21,5,4,3)
GROUP BY ID
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 39 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '39' AND comment_approved = '1'
Hilarious newsclips from Mobile, Alabama where many people report seeing leprechauns in a tree. One guy even has a genuine leprechaun flute passed down from his Irish great grandaddy. I’d like to email him for more info, so if you read this, let me know.
The Alabama Leprechaun Part I
The Alabama Leprechaun Part II
If you’re a leprechaun watcher yourself, here’s a webcam of interest: Tipperary Leprechaun Watch
You may remember Warwick Davis, the highly accomplished English actor who played the lead role in the leprechaun movie. Well, I just wish his Irish accent wasn’t so awful, because it’s really, really bad. Sorry Warwick. Still though, he has a fan base. More Later…
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 38 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '38' AND comment_approved = '1'
Here’s an interesting article about Scandanavian geological scientist Ulf Erlingsson’s belief that Plato based his Atlantis on a real place: Ireland.
Atlantis “Evidence” Found in Spain and Ireland
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 37 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '37' AND comment_approved = '1'
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 27 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '27' AND comment_approved = '1'
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 26 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '26' AND comment_approved = '1'
Ornate Celtic Skull which you can order online. (Image not to scale)
Celtic Skull
Celtic Skull Paperweight: This little Skull is cast in designer resin and intricately sculpted 3 inches tall. Heavy weight not hollow like some imitations.
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 24 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '24' AND comment_approved = '1'
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 21 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '21' AND comment_approved = '1'
Irish coffee was invented by the Irish airports for US visitors back in 1945 in Shannon airport apparently. - Although it may even date back to the flyingboats of Foynes in the 1930’s. Everyone knows what an Irish coffee is, including the majority of Irish bar staff ( who are not Irish anymore. They are Australian, French, Filipino, Polish, Latvian, Czech, etc etc. )
Everyone in Ireland knows about it. Everyone.
- How ever I’ve heard reports of US tourists arriving in off-licence premises (=takeout-only liquor store) in a shed, on an island (one of the Gaelic speaking Aran islands), where they selling nothing but cans of beer and bottles of whiskey and order Irish coffees and some Long Island Ice Teas, which causes untold mirth amongst the Irish to think about it, cos we all have aunty Eileens and cousin Nancy from New York, and to think about them braving the rural atlantic rough-and-ready seafaring coastal hospitality, trying to visit megalithic forts in hurricane weather, with their perfumed hair and finest sweaters… where they’re lucky to even arrive without seasickness (I always get nauseous on that boat), and expecting the trendy sophistication of Dublin’s capuccinos alleys.. is a bit comical to us, even if we understand and sympathise at the same time.
The one thing about Ireland, is that everyone has an expert opinion on it. Some opinions are so blatantly incorrect. Others are too correct, and some are just comical. Personally, I think you should be able to order anything, anywhere, anytime, and if I were there, I would have made their Long Island Ice teas, and their Irish coffees myself.
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 5 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '5' AND comment_approved = '1'
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 4 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '4' AND comment_approved = '1'
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 3 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '3' AND comment_approved = '1'