Note: This blog expresses only the opinions of the blog owner, and does not represent the opinion of any organization or blog that is associated with The Golden Rock.
If someone asks me what kind of music I like, I honestly have no idea how to answer. Just when I thought I have a handle on one genre, I find something else in another genre that I like, then the music I like just becomes a mishmash of whatever is out there, with any consistency ruined by my indecisiveness. Today’s Song of the Day is one of those songs. I first heard this song as an acoustic cover by Frente!, only to realize that I’ve come to like the original even more. At least enough taht I’ve done it on Karaoke Revolution. From New Order’s 1986 album Brotherhood, it’s “Bizarre Love Triangle.”
Here’s Frente!’s cover, the one that started it all
Took the three hours to watch Pirates of the Caribbean: At World’s End yesterday. Surprisingly, the 165-minute length went by fairly quickly, maybe because everyone was double-crossing each other the first hour and a half. Unlike Dead Man’s Chest, which sprinkled bits of action moments throughout to keep the audience pumped(including the Krakin beast thing that I have a personal affinity for, though it didn’t appear much in At World’s End), At World’s End is really one big setup for a somewhat underwhelming final battle that feels much like the second half of a huge 5-and-a-half hour film. This one really tests the audiences to see whether they actually care about the plot or not by stuffing as much into the journey between point A to point B as they can. It’s still very entertaining with the silly sense of humor and penchant for excess still around, but Verbinski and his writing team of Ted Elliot and Terry Rossio take the whole thing so seriously that Verbinski actually went as far as trying to channel Sergio Leone in a pre-showdown scene, Western music and extreme close-ups and all.
As expected, Johnny Depp steals the show as Jack Sparrow, even though he doesn’t appear until about 30 minutes in. While the Elizabeth Swann and William Turner plot line’s resolution was better than I expected, they are still the usual straight characters that were obviously misconceived when the writers wrote the original characters, not knowing that Depp’s performance would be so over-the-top. Chow Yun-Fat was great to see on the big screen, but that’s only because of the man’s reputation in my mind; he really doesn’t get much to do. The special effects are…..special, especially the Davy Jones character design. The credits showed at least 5 different special effects firms worked on the film, and it shows how much work they put in to make everything look real nice. Essentially, with all the money and audience love it’s gotten (which I honestly admit I’m a little baffled by, though I think a large percentage of the audience go purely for Johnny Depp and/or the special effects without even caring about the mythology and the plot), this movie is critic-proof. So go catch up with the second movie on DVD (trust me, you’ll need to), sit yourself in a movie theater with a good setup (I watched it in digital projection myself), and just enjoy the hell out of it. Word of warning, though: This movie is the most violent of the three, with people getting stabbed and shot in the head (though no blood). So don’t let the Disney label fool you into thinking it’s a kids film.
Note: Do stick around for past the credits. The post-credit scene this time actually matters, unlike the one in the second film (I had predicted the post-credit scene in the first movie mattered in the resurrection of Barbossa - it didn’t), because it wraps up a pretty important plot line. While I admire the team’s effort to make people watch the credits to recognize all the people’s hard work, it’s already been 160 minutes by the time the credits start. Just show what you need to show and let people go home.
- In Hong Kong, Pirates already seems to be slowing down a little bit. On Thursday opening day, Pirates made only HK$1 million on 88 screens for an 8-day total of only HK$25.85 million. One can argue that reduced running time means less shows, but I blame it on the ticket increase (theaterowners added HK$15 to the ticket price because of the length) and people just kind of balked at a 3-hour long movie. I don’t see this going past $HK40 million, which King Kong managed to do under the same condition.
In opening films, Hong Kong romantic comedy Single Blog (which actually claims in its trailer that 99% is not created, but rather situations taken from Hong Kong people’s blogs…someone should ask for royalties) made HK$220,000 on 25 screens, which is bad, but could have been a lot worse. Premonition starring Sandra Bullock makes HK$100,000 on 15 screens, Disney’s Bridge to Terabithia makes only HK$60,000 on 19 screens, and the weekend is just looking pretty yawn-y.
- Borat opened on 31 screens in Japan this past weekend, and it did pretty well in at least one of them. A theater in Shibuya is reporting that the film got off to an extremely good start, with hip people from their 20s to their 50s attending, and that people are taking advantage of the Monday discount….except the theater gives no official numbers, and no one knows how it did in the other 30 theaters. According to Box Office Mojo, it only made 7.3 million yen, for a not very good per-screen average of 237,000 yen (US$1=121 yen). But considering that it’s playing in small art house theaters that sit only about 150 people (at most 200), the houses are definitely getting filled….just not as filled as some might suggest.
- When my friend told me about the ridiculousness of this, I thought he was behind about 2 months, because I thought Norika Fujiwara’s wedding already happened. Turns out they held a Western wedding reception, and for some reason, Nippon TV thought it was important enough to broadcast it live. Then viewers thought it was important enough to tune in. In the Kansai area, where Fujiwara is from, the ratings for the wedding actually reached 40%. It didn’t do too shabby in Kanto, either; it reached 24%.
- In Europe, authorities report that they seized 23.2 million copies of entertainment goods such as DVDs, CDs, and software. And they’re blaming China, reporting that 93% of what they seized came from there.
- There’s a sales poster up for Johnnie To’s romance Linger. Is that what passes for a poster of a Johnnie To movie nowadays? And that title, “Butterfly Fly?” This might be the first time I’m actually avoiding a Johnnie To movie.
- Seems like the New York Asian Film Festival is running into some troubles after sponsor Midway Games decided to pull out of the festival. Now things are being rescheduled, but the festival is still on. I won’t be able to attend (due to the fact that i’m on the opposite end of the country), but I wish them mucho luck.
- Australian screenwriter/director Tony Ayres’ autobiographical film The Home Song Stories, starring Joan Chen and her daughter Irene, won a A$15,000 prize for its screenplay.
- Sai Yoichi, the Korean-Japanese director who made the brutally powerful Blood and Bones, made his Korean directorial debut with Soo, a violent revenge action thriller that sounds really promising. It’s coming to DVD on June 15th.
But then today Twitch’s Todd posted a fairly negative review that now has me wondering whether it’d be any good. I’ve read positive reviews of the film as well, so perhaps it’ll be one of those love-it-or-hate-it films that I might end up liking.
- The Galaxy Award, held by the Japan Council Better Radio and Television (there should be a council like that everywhere), was recently given out. I’ve never heard of this award, but since it’s in its 44th year, it must mean something. Notable winners include drama “Dr. Koto’s Clinic 2″ and actress Ryoko Shinohara for her several roles (including her lead role in drama Haken no Hinkaku).
Today’s song of the day may be Hong Kong legendary rock band Beyond’s most rebellious song, though you probably can’t tell that from their fashion and smile-filled introduction. You don’t even have to know Chinese to know they’re angry - the last lines of the chorus is “We don’t need you anymore/go to hell!” Most recently found on one of their many compilation discs, it’s “Can’t Be Forever.”
The idea for today’s song comes from Miss Japan’s victory at the Miss Universe contest. It’s the perfect time to use the boy group SMAP to tell all Japanese women that they’re beautiful (well, at least all the women that passed the audition). I agree with them too. From their latest album Pop Up! Smap, it’s “Dear Woman.”
Last year, the opening gross of Dead Man’s Chest is marked as US$16.6 million at the exchange rate of US$1=116.172 yen. However, Mojo wasn’t able to take in the fact that Dead Man’s Chest actually had weekend previews the previous week. Buena Vista probably calculated it all into the opening weekend gross to rig the numbers, or Mojo didn’t know about the screenings and just put whatever it made total as its total two-day gross. This week, At World’s End made about US$12 million in 2 days at the exchange rate of US$1=121.839 yen, with a total US$15.9 million. So not only did Mojo not know about the preview screenings for Dead Man’s Chest, it also failed to account the changing exchange rate, which shows At World’s End made more in yen in its first 3 days than Dead Man’s Chest in its first 2 days PLUS 3 days of weekend previews, which accounted for 0.94 billion yen, or at the exchange rate at the time, 8.09 million of Mojo’s reported 2-day gross.
OK, it all seems a little complicated, so here’s a summary: At World’s End made more money, despite Mojo’s one-sentence opinion that it disappointed because it forgot changing exchange rate and the lack of weekend previews.
Elsewhere on the rest of the Japanese box office top 10, seems like Kitaro drew more audiences, but For Those We Love made more money because of the adult audience it attracts. Same thing for Pacchigi - Love and Peace, which may be pulling in an older audience (senior tickets are cheaper as well) than Stranger Than Fiction. Spiderman 3 will probably pass Spiderman 2’s gross in Japan, but will not likely hit the 10 billion yen mark that Sony was hoping for. Everything else except for Bizan is seeing over-30% drops simply because there’s not enough screens to go around in Japan. This week’s strongest Japanese film opening is Shaberedomo Shaberedomo, a drama about Japanese comedians that opened with 39.7 million yen on just 98 screens. This looks like one of those movies with staying power anyway.
- In Korea, Jeon Do-Yeon’s best actress win at Cannes, the second ever for an Asian actress, for Secret Sunshine seems to be having a significant impact on its box office, with online ticket sales increasing to 31.6% of overall sales. Then again, this type of character-driven films probably depends more on word-of-mouth in the long run anyway.
- Everyone in Japan probably already know by now that Miss Japan is the new Miss Universe. In fact, two of the five finalists are from Asia (with two from South American, and Miss USA rounding out the rest). Asia represent!
Too bad that more people decided to tune into a rerun of a Charlie Sheen sitcom instead. And it’s even sadder that the ratings for amateur filmmaking reality show On the Lot continues to show that most people just don’t care about filmmaking. It’s like going to see a doctor and not care about how the doctor is going to fix you.
- I saw Batman Begins on IMAX, which was quite an experience, even though it was my second time watching the movie. What was that for, you ask? Christopher Nolan is now filming the sequel The Dark Knight, and he’s actually filming four sequences with IMAX cameras, instead of just letting them convert it from 35mm.
- EastSouthWestNorth is fuming at the further hypocrisy of the Hong Kong Television and Entertainment Licensing Authority. First the government prosecuted a man for just hyperlinking to some pornographic images on a Hong Kong forum. Except if you look at the board in question, you have people posting supposed pictures of their girlfriends and their wives with no constraint or morals involved. Meanwhile, you have the TELA going after inMediaHK for posting an artistic photograph with nudity that was already widely available on Flickr. The point is, with an entire forum of this crap, with even a warning on it, why did they even prosecute just one person?
By the way, link to forums in the EastSouthWestNorth is NOT work-safe, and not for anyone under 18 years old. There, just covering my own ass before I get arrested and extradited back to Hong Kong too.
- Stephen Fung’s Enter the Phoenix has been sold to be remade in Hollywood. I shuddered when the producer says “this movie should be remade for a bigger, broader audience.” Can you say bad gay jokes all around? Then again, the original has a kid smiling after a thermometer goes up his anus, it can’t really get any broader than that.
With the death of Zard lead/only singer Izumi Sakai, The Golden Rock feels it’s only appropriate to choose a Zard song for today’s Song of the Day. However, since I don’t know much Zard songs, picking this song from its title seems like a natural choice. From the album “Forever,” it’s the title song “Forever.”
As I wrote yesterday, I revisited the Iwo Jima saga by Clint Eastwood for Memorial Day in the United States. But except for my point that one should watch Letters From Iwo Jima before Flags of Our Fathers, I couldn’t write anything beyond that.
Anyway, my reasoning for the reverse order is simple chronological order: Letters takes place before and over the course of the battle of Iwo Jima, and at least half of Flags takes place after the battle. Since one is likely to suffer battle fatigue by the end of Letters, the fragmentary nature of Flags (which shows the battle using flashback moments) would work more effectively. In fact, if one looks closely, the scene transitions towards the end of Letters is similar to the first half an hour or so of Flags. Beyond those sections, Eastwood doesn’t use the fade-out approach as often, almost as if he wanted both films to work as one. Either way, even though Eastwood’s work doesn’t bring anything new to the genre, I think it’s still a monumental achievement, and it will hopefully be seen as that down the line.
- Feeling a little deja vu again, as I’m reporting another huge worldwide weekend for another huge blockbuster sequel. That’s right, Pirates of the Caribbean: At World’s End has broken a few records around the world at some of the places that this blog covers. Starting in North America, Pirates broke the Memorial Day weekend record set by X3: The Last Stand (another 3rd edition of a blockbuster franchise).
According to a link at Korea Pop Wars, it also broke the global 6-day opening record set by Spiderman 3 (just read that complicated explanation to see how it works), even though it didn’t win the 3-day weekend record. But it didn’t break the best opening weekend record in Korea set by The Host, taking in 2.71 million admissions since it opened on Wednesday on a crazy 900 screens. Oh, Secret Sunshine had a pretty good opening too, plus a Japanese film crossed the 100,000 admission mark. Go read all about it.
- Back in the beginning of the month, Spiderman 3 made HK$28.6 after 6 days on over 120 screens in Hong Kong. It might not have beaten its opening day record (and in fairness, both films opened on public holidays), but Pirates might its pace by making HK$20.33 million after 4 days, including HK$4.62 million from 121 screens on Sunday alone. We’ll know by Wednesday when the 6-day gross comes out, but with 8.3 million to go in 2 days, the best Pirates can do seems to be matching Spidey, not beating it. Of course, note that Pirates tickets in HK cost HK$5 more than Spiderman 3, so if the same amount of people go watch it, then its gross would naturally be higher than Spiderman.
(reference: US$1=HK$7.8)
- In Japan, Pirates ruled at number 1, as expected. But all I gots right now is the ranking (that’s an intentional mistake, by the way, unlike the many typos I make in this blog), so more number crunching tomorrow.
- In Japanese drama ratings, We see Operation Love climbing from a 16.9 to 17.4, solidifying its status as this season’s top drama. Sadly, Joudan Janai went further down from a 11.7 to a season low of 10.7. Sexy Voice and Robo saw its 2nd episode replayed because its 7th episode is too close for comfort after a police-involved shooting last week, and the rerun got only a 6.0 rating. Aya Ueto’s Hotelier (based on the Korean drama) is seeing an up trend with a 9.3 this week, same as Liar Game, which has seen its ratings go up for a 4th week with 12.0 rating.
- After its win at the Cannes Film Festival, Variety finally has a review of Naomi Kawase’s The Mourning Forest. Reviewer Russell Edwards says its ambitions are undercut by conveniently underarticulated affections, and won’t reach far beyond festivals and European arthouse audiences.
Meanwhile, Jason Gray updated his previous about with a few more words about the film and its upcoming limited release in Japan.
- r@sardonicsmile has a look at the Hong Kong band scene, which include a clip of the documentary on my favorite HK rap group LMF. However, if you’re in a Cantonese-speaking work environment, the language is not work-safe.
- Before moving on L, the spinoff for Death Note, Hideo Nakata finished his horror flick Kaidan. Twitch has the full theatrical trailer up. Am I the only one that thinks the Ayumi Hamasaki theme song is really out of place?
- Meanwhile, Yukihiko Tsutsumi, the director of Memories of Tomorrow and Trick, has signed up for yet another comic adaptation.
- Twitch is reporting some rumor from Hong Kong’s Oriental Daily (and we know how reliable Hong Kong entertainment news are) that Chow might take up a non-comedic role in a war film as part of his deal with Sony Pictures.
As kind of a related note, a Hong Kong entertainment reporter reported that Chow Yun-Fat is rumored to take a role in a kung-fu take on the Snow White story with Disney. I am not even joking, and I’m not being sarcastic. I heard this with my own ears.
- Twitch has a first look at Mathieu Kassovitz’s latest film Babylon AD, starring Vin “I should’ve starred in 300″ Diesel and Michelle Yeoh. It’s not even real footage, but rather behind-the-scenes stuff. Still, it’s actually looking pretty good.
- How can you get your movie into China without having to worry about blackout dates and import quota? Engage in an artistic battle royale with your fellow filmmakers at the Shanghai International Film Festival, and you shall get your wish.
- Following in the footsteps of Variety Asia, Hollywood Reporter has recently decided to expand their coverage into Asia with new offices in Hong Kong and Beijing. Good for them.
- EastSouthWestNorth has a link to an English TVB-produced special about The Society For Truth and Light, a conservative group in Hong Kong that is very much on the opposing side against the Chinese University of Hong Kong student newspaper controversy, and is a strong opponent against laws that outlaw discrimination of “sexual minorities” (that would mean the gays). The focus of the program is that they have recently been teaching a human rights course to schoolteachers. My favorite quote about the course: “If you think your time is valuable, don’t try to join this course.” Sounds like a quote ready for print.
- There have been clips of Sammi Cheng’s Hong Kong concert on Youtube, prompting the record company to ask Youtube to take it off the site. Problem is that these are just badly recorded clips from cell phones of digital cameras, so why start some petty copyrights fight to give up some promotion for the concert DVD?
- Apparently someone used a digital camera or something and bootlegged some footage from the reel for Feng Xiaogang’s The Assembly from the Cannes Film Festival. It looks technically accomplished, with huge explosions and whatnot, but Feng Xiaogang is first and foremost a commercial filmmaker. And honestly, the battle scenes look like they were taken straight out of Taeguki, which took its battle scenes out of Saving Private Ryan.
Out of those, I’ve only seen Cafe Lumiere, and if i have never been to Tokyo, I would’ve been bored to death by it. But for some reason(most likely in that I’m a bit of a transportation nerd), I really liked how Hou Hsiao-Hsien captured Tokyo in such a naturalistic fashion. It’s not really a crazy city. In fact, despite its sheer size, the city is rather serene when you leave its busiest districts, and that’s what Hou managed to capture. Also, I was in a Japanese cinema class at the time, and I was actually looking for recurring Ozu themes throughout the film, which made it even more interesting. Plus, it was fun playing “what’s that train” and “which train station is that” throughout the film. However, I expect everyone else to be pretty bored.
This leads me to a short rant. Recently, I signed up for a Japanese video service named Gyao, which is by the Usen Group and basically provides streaming video service for free. Unlike websites like Veoh and Crunchyroll (no link for you!) basically allow users to upload and watch films for free and illegally, this one is actually 100% legal and free, paying for itself through advertising. It has films, music videos, dramas, basically everything users wanted when they go to sites like Youtube. I was signed up and ready to watch (I knew something was fishy when they asked for my Japanese zip code, though. I used the zip code of someone I know), then the service won’t let me watch it, limiting it to Japanese computers only.
Obviously, I understand that it’s a matter of copyrights when foreign films or films sold to foreign distributors are involved, but this just shows how much the studio cares about exposure versus pure profit. Who cares who watches their movies when they got money from their foreign deals all lined up? This disdain for international audiences by Japanese distributors are why copyrights for their shows are infringed all the time. This is why sites like Crunchyroll and Veoh pop up, while the Japanese authorities moan and whine about how foreigners are stealing their copyright. Mind you, I’m not going to start downloading Japanese movies without paying my dues, but I think they brought it onto themselves.
- Here’s kind of an interesting idea for a new film. The Korean-Canadian co-production “Anti-Hero” introduces a world where everybody has some kind of unique power (where are they going to think of 6 billion different unique powers?) except for the protagonist. Doesn’t that make him unique in the first place?
- Looks like Harvey Weinstein and Luc Besson are going at each other over The Weinstein Company’s release of Besson’s last film Arthur and the Invisibles. Even though Weinstein does have a record of screwing with their foreign acquisitions, I actually haven’t really heard anything positive about Arthur and the Invisibles, so it was probably going to flop anyway. Maybe Besson is just look for a scapegoat for failing to gauge the audience for this film.
- Another conflict that might pop up is going on in Japan, where outspoken director Izutsu Kazuyuki (Pacchigi - Love and Peace) praised films in general…..except Kitano doesn’t exactly care whether directors like films or not. This is ironic, considering Kitano’s movie emulates just about all popular genres of film, which I figured only a director that likes film would do.
- Everybody is finishing up their trilogies in recent years, from Alejandro Gonzalez Inarritu’s “Death Trilogy” to Gus Van Sant’s…..other “Death Trilogy” (apparently death at the hands of strangers is what he calls it) to Park Chan-Wook’s “Revenge Trilogy.” Apparently, even Takeshi Kitano has been doing a trilogy from “Takeshis’” to “Kantoku Banzai!”. Now he’s planning to finish up this “self-exploratory trilogy” with a movie about the life of an artist from success to ruin that will feature his own paintings. Parallel to Kitano’s own directorial career is still unknown, depending on the reviews for “Kantoku Banzai!”.
- There’s a law in China that bans all materials that deal with the supernatural. Films and books that deal with the supernatural are often banned, though there are ways around it, as evident in the recent thriller The Matrimony. The latest victim of this ban is the popular Japanese comic/animated series/films Death Note. Authorities in China finally got off their asses and seized over 2400 copies of the comic and 360 copies of what is probably the animated series or the films on compact discs. Thanks to the popularity of the comic, kids are also buying up the mock version of the Death Notebook (In Japanese, the word for notebook is “no-to,” or just “note.” So Death Note actually means Death Notebook), freaking out other kids by writing their names in it. Now that’s just plain mean.
I don’t write about them much on this blog (probably because they broke up a few years ago), but I’m a fan of the British band Suede. After they broke up, lead Brett Anderson and former Suede member/mortal enemy Bernard Butler formed The Tears and has so far released only one album (Brett Anderson released his solo album earlier in the year, but I haven’t heard it yet). That’s where today’s song of the day is from. Even as a Suede fan, I have to admit that The Tears’ “Here Come the Tears” sounds like a pale imitation of Suede, but today’s track is still quite good (that’s why it got chosen today). It’s “The Ghost of You.”
Cannes finally comes to a close, meaning that those who don’t really care can now rest easy. Of course, if all goes well, we’ll doing it all over again for Venice and Toronto later this year.
On the Asian films front, Naomi Kawase’s “The Mourning Forest,” which screened on the last full day of screening in competition, won the Grand Prix (which is like a glorified 2nd place award). Variety and Hollywood Reporter critics usually don’t work on weekends (even during Cannes, apparently), so there are no reviews from them yet. However, we do have a review from Screen International’s Lee Marshall, who calls the film one of great emotional impact with a vision that is equal to Terrence Malick. Meanwhile, Mike D’Angelo has a short review on ScreenGrab, and he didn’t like it as much (it’s a short review, just scroll down. Thanks to Green Cine for the link).
Also, Jeon Do-Yeon won the best actress award for Lee Dong-Chang’s “Secret Sunshine,” which ups the awards count for Asian films in competition to two this year. Then again, the competition seems pretty heavy this year, so Asia should be glad that it represented itself quite well.
- Moving on, Danny Boyle’s Sunshine, which has unfortunately not been doing very well anywhere it’s playing so far (it has open in most major territories in the world and has only made US$27 million). Now, Fox has moved up the North American release to July 20th from its second release date in September. This might be a good move, since it’s only going against John Travolta in drag (courtesy of The Movie Blog) and the new Adam Sandler comedy, which just got the R kiss of death from the MPAA.
- Everybody is finishing up their trilogies in recent years, from Alejandro Gonzalez Inarritu’s “Death Trilogy” to Gus Van Sant’s…..other “Death Trilogy” (apparently death at the hands of stranger is what he calls it) to Park Chan-Wook’s “Revenge Trilogy. Apparently, even Takeshi Kitano has been doing a trilogy from “Takeshis’” to “Kantoku Banzai!”. Now he’s planning to finish up this “self-exploratory trilogy” with a movie about the life of an artist from success to ruin that will feature his own paintings. Parallel to Kitano’s own directorial career is still unknown, depending on the reviews for “Kantoku Banzai!”.
- There’s a law in China that bans all materials that deal with the supernatural. Films and books that deal with the supernatural are often banned, though there are ways around it, as evident in the recent thriller The Matrimony. The latest victim of this ban is the popular Japanese comic/animated series/films Death Note. Authorities in China finally got off their asses and seized over 2400 copies of the comic and 360 copies of what is probably the animated series or the films on compact discs. Thanks to the popularity of the comic, kids are also buying up the mock version of the Death Notebook (In Japanese, the word for notebook is “no-to,” or just “note.” So Death Note actually means Death Notebook), freaking out other kids by writing their names in it. Now that’s just plain mean.
WordPress database error: [Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'webkozo_wordpress.gr_posts.post_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM gr_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'webkozo_wordpress.gr_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM gr_posts
WHERE post_date < '2025-03-01'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'webkozo_wordpress.gr_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM gr_posts
WHERE post_date > '2025-03-01'
AND MONTH( post_date ) != MONTH( '2025-03-01' )
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date ASC
LIMIT 1