Home > Resources > Messages

240 Good Night Messages for Boyfriend to Express Your True Feelings

update: Jan 13, 2025

Summary

[#Good Night Messages for Boyfriend# #240 Good Night Messages for Boyfriend to Express Your True Feelings#]Sending a heartwarming good night message to your boyfriend can be a touching way to end the day, showing him just how much he means to you. Whether short and sweet or deeply romantic, your words have the power to strengthen your bond and make him feel cherished. Discover 240 good night messages for boyfriend—cute, flirty, funny, heartwarming, and more—to inspire you and help you craft the perfect message for every emotion and occasion. Let's make his nights brighter with your love and affection. Popai has prepared "240 Good Night Messages for Boyfriend to Express Your True Feelings" for you reference. ....
240 Good Night Messages for Boyfriend to Express Your True Feelings

Unlock the power of AI with PopAi: Make fun Al videos and images; Create stunning PPT in one-click; Chat with PDF/DOC.

Sending a good night message to your boyfriend can be a lovely way to end the day, showing him just how much you care. These short, sweet expressions of love and affection can help to strengthen your bond, remind him of your feelings, and bring you closer together despite the distance that may separate you. Whether you’re in a new relationship or have been together for years, crafting the perfect good night message can be a delightful way to keep the romance alive.

In this post, we’ve gathered 240 good night messages for boyfriends to inspire you and help you express your true feelings. From cute and romantic, to flirty and funny, there’s something here for every mood and moment. Let’s dive in and find the perfect good night message to make your boyfriend smile before he drifts off to sleep.

1. Cute Good Night Messages for Boyfriend

1. Cute Good Night Messages for Boyfriend
  1. “Good night, my love. May your dreams be as sweet as your kisses.”
  2. “I wish I could be there to tuck you in and kiss you goodnight.”
  3. “Good night, handsome. Dream of our future together.”
  4. “Sweet dreams, babe. I love you more than words can say.”
  5. “Rest well, my prince. Tomorrow is another day to love you more.”
  6. “Good night, sweetie. Always remember that I adore you.”
  7. “May your dreams be filled with all the happiness you bring into my life.”
  8. “Good night, my teddy bear. Know that I’m hugging my pillow thinking of you.”
  9. “Sleep tight, my hero. I’ll be dreaming of you.”
  10. “Good night, darling. I can’t wait to see you in the morning.”
  11. “Sweet dreams, love. You’re my favorite hello and hardest goodbye.”
  12. “Good night, my star. Thank you for making my days brighter.”
  13. “Sleep well, my heart. I’ll meet you in our dreams.”
  14. “Good night, babe. Your love is the light that brightens my nights.”
  15. “Rest well, my everything. I’m always here for you.”
  16. “Good night, my love. Thinking of you makes my nights so special.”
  17. “Sleep tight, babe. I wish you were here with me.”
  18. “Dream sweet dreams, my love. You mean the world to me.”
  19. “Good night, sweetheart. I’ll love you till the end of time.”
  20. “Good night, my angel. Counting down the moments until we’re together again.”

2. Romantic Good Night Messages for Boyfriend

2. Romantic Good Night Messages for Boyfriend
  1. “Good night, my darling. Falling asleep thinking of you is my favorite routine.”
  2. “Sweet dreams, my love. Every night without you feels incomplete.”
  3. “Good night, my heart. Your love is like a warm blanket that keeps me cozy.”
  4. “Sleep tight, handsome. Imagining your arms around me makes me feel safe.”
  5. “Good night, my prince. You make every day worth living and every night worth dreaming.”
  6. “Sweet dreams, my love. Our love story is my favorite fairytale.”
  7. “Good night, my soulmate. I can’t wait to spend forever wrapped in your love.”
  8. “Sleep well, my sweetheart. Your love is my most treasured possession.”
  9. “Good night, babe. Being with you has made my nights a thousand times sweeter.”
  10. “Sweet dreams, my treasure. Remember, you are always in my heart.”
  11. “Good night, my love. May your dreams be filled with the same magic you brought into my life.”
  12. “Sleep tight, my dear. My heart beats faster thinking of you, even in my dreams.”
  13. “Good night, my beloved. You are the reason my nights feel so serene and peaceful.”
  14. “Sweet dreams, my love. Your love is my lullaby, and I sleep peacefully thinking of you.”
  15. “Good night, my heart. Even the stars can’t compete with the light you bring into my life.”
  16. “Sleep well, my love. Knowing you are mine makes my heart flutter.”
  17. “Good night, my darling. Words could never express how deeply I love you.”
  18. “Sweet dreams, my love. In my dreams, we are always together.”
  19. “Good night, my sweetheart. Your love is my guiding light through the darkest nights.”
  20. “Sleep tight, my prince. I fall more in love with you every single day.”

3. Flirty Good Night Messages for Boyfriend

3. Flirty Good Night Messages for Boyfriend
  1. “Good night, handsome. Can’t wait to dream about those soft lips of yours.”
  2. “Sleep tight, babe. Just thinking about you makes me blush.”
  3. “Good night, hottie. You’re the last thing on my mind before I sleep—and not just because I miss you!”
  4. “Sweet dreams, handsome. Can’t wait to see what kind of trouble we can get into tomorrow.”
  5. “Good night, stud. Dream about me in that little dress you love.”
  6. “Sleep well, sexy. You’ve got my heart racing, even late at night.”
  7. “Good night, gorgeous. I wish I were there to whisper sweet nothings in your ear.”
  8. “Sweet dreams, babe. Can’t wait to feel your touch again.”
  9. “Good night, my hot stuff. Dream about our next adventure.”
  10. “Sleep tight, my love. Your charm never fails to make my nights exciting.”
  11. “Good night, sweetheart. You make my nights hotter than my dreams ever could.”
  12. “Sweet dreams, handsome. I’m already counting the seconds until I can kiss you again.”
  13. “Good night, babe. I’ll be dreaming of all the ways to make you smile.”
  14. “Sleep well, hottie. Just thinking about you keeps me warm and fuzzy.”
  15. “Good night, handsome. Your eyes are my favorite escape into dreamland.”
  16. “Sweet dreams, love. Dream of me, and I promise you won’t be disappointed.”
  17. “Good night, babe. Wishing I could be there to feel your embrace.”
  18. “Sleep tight, sexy. I’ll be waiting in your dreams with open arms.”
  19. “Good night, my love. Only you can make my heart flutter even from afar.”
  20. “Sweet dreams, my darling. You bring a whole new meaning to the word ‘temptation’.”

4. Thoughtful Good Night Messages for Boyfriend

4. Thoughtful Good Night Messages for Boyfriend
  1. “Good night, my love. Reflecting on our memories brings me so much peace.”
  2. “Sleep well, darling. Your kindness and love inspire me every day.”
  3. “Good night, sweetheart. You make my life so much richer with your presence.”
  4. “Sweet dreams, my love. I appreciate all that you do for us.”
  5. “Good night, my dear. I’m so grateful for the love we share.”
  6. “Rest well, my heart. You’re my constant source of strength and happiness.”
  7. “Good night, babe. Thank you for being my rock and my best friend.”
  8. “Sleep tight, my love. Your thoughtfulness and care mean the world to me.”
  9. “Good night, my angel. Each day with you is a precious gift.”
  10. “Sweet dreams, darling. You teach me the true meaning of love every single day.”
  11. “Good night, my beloved. Our connection grows stronger with each passing night.”
  12. “Sleep well, love. Your smile is my favorite end to each day.”
  13. “Good night, my dear. Knowing you’re in my life makes everything better.”
  14. “Sweet dreams, my love. Your support has helped me become who I am.”
  15. “Good night, sweetheart. Our love story is my greatest adventure.”
  16. “Rest well, my darling. I admire your strength, kindness, and unwavering love.”
  17. “Good night, my love. Let’s cherish our memories as we drift to sleep.”
  18. “Sleep tight, dear. You make every day brighter and every night more serene.”
  19. “Good night, babe. Your love fills my heart with endless joy and contentment.”
  20. “Sweet dreams, my heart. I’m so lucky to share this beautiful journey with you.”

5. Inspiring Good Night Messages for Boyfriend

5. Inspiring Good Night Messages for Boyfriend
  1. “Good night, my love. Tomorrow is another chance to chase our dreams together.”
  2. “Sleep well, sweetheart. Never forget how amazing and capable you are.”
  3. “Good night, my hero. Your strength and determination inspire me every day.”
  4. “Sweet dreams, my love. Let’s make the world a better place, one day at a time.”
  5. “Good night, babe. I’m so proud of everything you accomplish.”
  6. “Rest well, my heart. Believe in yourself as much as I believe in you.”
  7. “Good night, my dear. Remember, you’re a shining star in my universe.”
  8. “Sleep tight, love. Tomorrow holds endless possibilities for you.”
  9. “Good night, my angel. Together, we can achieve anything we set our minds to.”
  10. “Sweet dreams, darling. Your passion and ambition are truly inspiring.”
  11. “Good night, my beloved. Keep striving for your dreams; I’m always by your side.”
  12. “Rest well, my love. Your greatness is just beginning to unfold.”
  13. “Good night, babe. Your perseverance and dedication make me admire you more every day.”
  14. “Sleep tight, my hero. Your future is as bright as your spirit.”
  15. “Good night, sweetheart. Keep believing in your dreams; they’re within your reach.”
  16. “Sweet dreams, my love. Your strength and courage are a beacon of hope.”
  17. “Good night, my dear. Aim high and never stop dreaming—we’re in this together.”
  18. “Rest well, love. Your potential is limitless, and great things await you.”
  19. “Good night, my heart. Your unwavering determination inspires me to be better.”
  20. “Sleep tight, babe. Let’s conquer the world together, one dream at a time.”

6. Good Night Messages for Long Distance Relationships

  1. “Good night, my love. No distance can diminish the love we share.”
  2. “Sleep well, my dear. Though miles apart, you’re always in my heart.”
  3. “Good night, sweetheart. Your love makes the distance bearable.”
  4. “Sweet dreams, my love. Our hearts are always connected, no matter the miles.”
  5. “Good night, my darling. Distance means so little when someone means so much.”
  6. “Sleep tight, babe. Every day brings us closer to being together.”
  7. “Good night, my hero. Your love is my anchor, even from afar.”
  8. “Sweet dreams, my love. Our love knows no boundaries.”
  9. “Good night, my star. Counting down the days until I can hold you again.”
  10. “Sleep well, my angel. Your love bridges the gap between us.”
  11. “Good night, my prince. Thinking of you keeps me strong, even from a distance.”
  12. “Sweet dreams, my love. Distance cannot erase the beautiful memories we share.”
  13. “Good night, my dear. With every star in the sky, I send you my love.”
  14. “Sleep tight, my heart. Distance is temporary, but our love is forever.”
  15. “Good night, babe. Our love will always find a way to keep us connected.”
  16. “Sweet dreams, my love. Every night without you brings us one step closer.”
  17. “Good night, my sweetheart. You are worth every mile between us.”
  18. “Sleep well, my love. Patience and love will bring us together.”
  19. “Good night, my dear. The distance may be long, but our love is strong.”
  20. “Sweet dreams, my darling. Until we’re together again, I’m here loving you.”

7. Funny Good Night Messages for Boyfriend

  1. “Good night, handsome. Don’t let the bedbugs bite… unless they’re practicing for My Love Bites!”
  2. “Sweet dreams, babe. If you wake up with messy hair, just remember, I’m still guessing which monster took you by surprise!”
  3. “Good night, my love. Try not to think about how every blanket is out to defeat you tonight.”
  4. “Sleep tight, darling. If your dreams involve saving me from a dragon, be sure to win!”
  5. “Good night, my hotstuff. May your dreams be sweet, and your snores even sweeter!”
  6. “Rest well, handsome. Try not to steal all the covers tonight! Oh wait, I forgot you aren’t here. Lucky you!”
  7. “Good night, love. Your bed is waiting impatiently, so try to comply!”
  8. “Sleep tight, babe. Hope your dreams are more thrilling than your snoring!”
  9. “Good night, my darling. Just think of me if you happen to dream about food!”
  10. “Sweet dreams, my hero. Remember, even superheroes need sleep!”
  11. “Good night, my boo. Don’t be surprised if you dream of me bossing you around!”
  12. “Sleep well, love. Try not to fight any ghosts tonight, they’ll probably win!”
  13. “Good night, dear. Challenge yourself to snore in tune with the sweet lullabies.”
  14. “Sweet dreams, babe. Don’t let the worries of tomorrow wake you—only your alarm is allowed!”
  15. “Good night, my stud. If any sheep get too high while you’re counting them, furlough them from your dreams!”
  16. “Rest up, love. Pray you don’t roll off the bed and let the laundry pile catch you!”
  17. “Good night, dear. If you meet a talking cat in your dreams, question your dinner!”
  18. “Sweet dreams, my knight. May all your battles tonight be won with your trusty pillow.”
  19. “Good night, love. Try not to sleep through that important dream date with me!”
  20. “Sleep tight, handsome. Send me a signal if you see aliens in your dreams; I might be abducted next!”

8. Witty Good Night Messages for Boyfriend

  1. “Good night, handsome. Don’t let dreams be the only place to be witty—save some puns for tomorrow!”
  2. “Sweet dreams, love. Remember, sleep is the best time to plot our world domination!”
  3. “Good night, babe. If you find some wit in your dreams, bring it into the real world, please.”
  4. “Sleep tight, my clever man. Life without your humor would be un-BEAR-able.”
  5. “Good night, my love. Dream of awesome puns and don’t forget to share the best ones!”
  6. “Rest well, witty one. Your sense of humor is so bright, it could outshine the moon!”
  7. “Good night, genius. If ideas were stars, your brain would be a galaxy.”
  8. “Sleep tight, clever clogs. Don’t dream too much about solving world problems and forget about dreaming of us!”
  9. “Good night, my comedian. Remember not to laugh in your sleep—it might wake the neighbors!”
  10. “Sweet dreams, dear. Let’s hope your dreams are as clever as your jokes.”
  11. “Good night, my smartypants. May your dreams be seasoned with wittiness and garnished with laughter.”
  12. “Sleep well, my humor king. Keep being your incredible self, witty and charming.”
  13. “Good night, love. Don’t prank the dream fairies—they’re just doing their jobs.”
  14. “Sweet dreams, sharp mind. May your pillow be as comfy as your best one-liners.”
  15. “Good night, pun master. May your dreams be filled with endless puns and witty banter.”
  16. “Rest up, my jester. Your humor makes even the darkest nights sparkle.”
  17. “Good night, my clever boyfriend. Who needs a dreamcatcher when you have me, your wit-catcher?”
  18. “Sleep well, funny guy. Don’t hog all the good jokes for your dreams—save some for us!”
  19. “Good night, beloved. Let’s start a sleep show called ‘Dreams with Wit and Wisdom.'”
  20. “Sweet dreams, my humor hero. May you wake up with a new punchline every day.”

9. Heartwarming Good Night Messages for Boyfriend

  1. “Good night, my love. Your heart is my home, and your love feels like heaven.”
  2. “Sleep well, my angel. Your smile lights up my darkest nights.”
  3. “Good night, my dear. Thank you for being my constant source of joy and comfort.”
  4. “Sweet dreams, love. Your affection warms my heart each night.”
  5. “Good night, sweetheart. Holding you close in my thoughts until we meet again.”
  6. “Rest well, my beloved. You fill my heart with a love that will never fade.”
  7. “Good night, babe. Your kindness and love make every day better.”
  8. “Sleep tight, my darling. I cherish every moment spent with you.”
  9. “Good night, my prince. Your love makes my heart feel full and content.”
  10. “Sweet dreams, love. You are my forever and always.”
  11. “Good night, hero. Your love gives me the strength to face each new day.”
  12. “Rest well, my heart. Our love is the foundation of my happiness.”
  13. “Good night, my dear. I’m grateful for you and the love we share.”
  14. “Sleep tight, love. I treasure you more with each passing night.”
  15. “Good night, my sweetheart. Your love is a comforting lullaby for my soul.”
  16. “Sweet dreams, my everything. I’m so lucky to have you by my side.”
  17. “Rest well, babe. You bring an incredible warmth into my life.”
  18. “Good night, love. Your presence in my life is a blessing I’ll never take for granted.”
  19. “Sleep tight, my heart. I fall more in love with you each day.”
  20. “Good night, my forever love. You make my life complete and beautiful.”

10. Emotional Good Night Messages to Strengthen Your Bond

  1. “Good night, my love. Your presence in my life fills me with unspeakable joy.”
  2. “Sleep tight, darling. Missing you deeply, and my heart aches without you by my side.”
  3. “Good night, my everything. Distance may separate us, but our love holds us together.”
  4. “Sweet dreams, love. The thought of you brings tears of happiness to my eyes.”
  5. “Good night, my dear. I find solace and peace in your unwavering love.”
  6. “Rest well, my heart. Even in the quietest moments, your love speaks volumes.”
  7. “Good night, my beloved. You are my strength, my comfort, and my everything.”
  8. “Sleep tight, babe. Knowing you love me is the greatest gift I could ever receive.”
  9. “Good night, darling. Even on my darkest days, your love lights my way.”
  10. “Sweet dreams, my hero. The bond we share is unbreakable and eternal.”
  11. “Good night, love. My heart beats for you and only you.”
  12. “Rest well, my soul mate. Our connection is deeper than words can describe.”
  13. “Good night, my dearest. Your love has healed my broken heart.”
  14. “Sleep tight, my love. Every moment apart makes my love for you grow stronger.”
  15. “Good night, sweetheart. Our hearts are entwined by an unshakable bond.”
  16. “Sweet dreams, my darling. Your love uplifts me and carries me through tough times.”
  17. “Good night, my treasure. You are my safe place, my love, and my home.”
  18. “Rest well, babe. Our love story is written in the stars, eternal and unending.”
  19. “Good night, my rock. Thank you for being my pillar of strength and hope.”
  20. “Sleep tight, my angel. My love for you is boundless and will never wane.”

11. Personalized Good Night Messages for Boyfriend

  1. “Good night, [Boyfriend’s Name]. Your smile is my favorite part of the day.”
  2. “Sleep well, [Boyfriend’s Name]. I treasure every moment we spend together.”
  3. “Good night, [Boyfriend’s Name]. Dreaming of our special memories.”
  4. “Sweet dreams, [Boyfriend’s Name]. You make my life so wonderful.”
  5. “Rest well, [Boyfriend’s Name]. I’m so grateful for your love.”
  6. “Good night, [Boyfriend’s Name]. Can’t wait to make more memories with you.”
  7. “Sleep tight, [Boyfriend’s Name]. Your love completes me.”
  8. “Good night, [Boyfriend’s Name]. Thinking of you always gives me peace.”
  9. “Sweet dreams, [Boyfriend’s Name]. You are my everything.”
  10. “Rest well, [Boyfriend’s Name]. Our love is my greatest joy.”
  11. “Good night, [Boyfriend’s Name]. I love you more with each passing day.”
  12. “Sleep tight, [Boyfriend’s Name]. You are my forever and always.”
  13. “Good night, [Boyfriend’s Name]. You make my dreams come true.”
  14. “Sweet dreams, [Boyfriend’s Name]. Our love story is my favorite.”
  15. “Rest well, [Boyfriend’s Name]. I cherish you deeply.”
  16. “Good night, [Boyfriend’s Name]. Your love inspires me every day.”
  17. “Sleep tight, [Boyfriend’s Name]. I am lucky to call you mine.”
  18. “Good night, [Boyfriend’s Name]. You are my heart and soul.”
  19. “Sweet dreams, [Boyfriend’s Name]. Forever grateful for you.”
  20. “Rest well, [Boyfriend’s Name]. Loving you is my greatest honor.”

12. Cheerful Good Night Messages to Lift His Mood

  1. “Good night, my sunshine. Your smile is the best part of my day.”
  2. “Sleep well, love. Tomorrow is a new day full of endless possibilities.”
  3. “Good night, babe. Remember, even the darkest night will end and the sun will rise.”
  4. “Sweet dreams, my darling. You bring so much joy into my life.”
  5. “Good night, my love. Your happiness means the world to me.”
  6. “Rest well, babe. May your dreams be filled with cheerfulness and love.”
  7. “Good night, my hero. You have a heart of gold and a soul that shines.”
  8. “Sleep tight, my love. Tomorrow is a blank canvas; paint it with your brightest colors.”
  9. “Good night, dear. You are a source of joy and inspiration to everyone around you.”
  10. “Sweet dreams, love. Keep that beautiful smile on your face, always.”
  11. “Good night, my prince. Your optimism and positivity light up my world.”
  12. “Rest well, sweetheart. You have the power to make every day amazing.”
  13. “Good night, my star. Your laughter is the melody of my life.”
  14. “Sleep tight, love. Each day with you brings more reasons to smile.”
  15. “Good night, babe. You have an incredible ability to brighten my day.”
  16. “Sweet dreams, my joy. You are the sunshine in my life, even on cloudy days.”
  17. “Good night, darling. Your humor and positivity are infectious, keep spreading them.”
  18. “Rest well, my happiness. Knowing you’re in my life makes everything better.”
  19. “Good night, my angel. Always keep that cheerful spirit; the world needs it.”
  20. “Sleep tight, love. You are the rainbow after every storm.”

How to Craft Your Own Unique Good Night Messages

Creating your own good night messages for your boyfriend can be a heartfelt way to express your love and affection. Personalized messages not only show your creativity but also let your boyfriend know that you were thinking of him while crafting your message. Here are some steps and tips to help you craft unique good night messages that will make him smile and feel cherished:

1. Reflect on Your Relationship

Think about the unique aspects of your relationship. What shared experiences, inside jokes, or special memories come to mind? Use these as inspiration to create personalized messages that reflect your journey together.

For example:

  • “Good night, love. Remember that hilarious time at the beach? Dreaming of more fun adventures with you!”
  • “Sleep tight, babe. I’ll never forget our cozy nights watching our favorite movies.”

2. Use His Name or Nicknames

Incorporating his name or special nicknames in your message makes it more intimate and personal.

For example:

  • “Good night, [Boyfriend’s Name]. You light up my world.”
  • “Sweet dreams, my cuddle bug. I miss holding you close.”

3. Express Your Feelings

Let him know how you feel about him. Whether it’s love, gratitude, admiration, or even a little bit of playful teasing, expressing your emotions candidly will make your message special.

For example:

  • “Good night, darling. Every day with you is a new blessing.”
  • “Rest well, my hero. Thinking of you fills my heart with love.”

4. Be Creative and Playful

Don’t hesitate to infuse a bit of creativity and humor into your good night messages. This can make them more memorable and enjoyable.

For example:

  • “Good night, superstar. Can’t wait to rock the world with you tomorrow!”
  • “Sleep tight, handsome. If dreams were like kisses, I’d send you a million.”

5. Incorporate Inspiring or Uplifting Quotes

If you’re stuck, use quotes from books, movies, or even your favorite poems that you both enjoy. This can add a touch of elegance and thoughtfulness to your messages.

For example:

  • “Good night, babe. ‘You have bewitched me, body and soul.’ – Jane Austen”
  • “Sleep well, my love. ‘To me, you are perfect.’ – Love Actually”

6. Keep It Short and Sweet

While it’s important to be expressive, remember that good night messages should be concise enough for him to read and enjoy. Long messages can sometimes overshadow the simplicity and sweetness of a goodnight wish.

For example:

  • “Good night, babe. Your smile is my paradise.”
  • “Sweet dreams, my love. Always and forever.”

7. Add a Personal Touch

Use something unique to you both, like a pet name, a shared habit, or a future plan, to make the message deeply personal and meaningful.

For example:

  • “Good night, my snugglesaurus. Counting the days until our next adventure.”
  • “Rest well, my adventure buddy. Our future is bright and beautiful.”

By following these tips, you can create good night messages that are tailored to your relationship, making each one unique and heartfelt. Remember, the key is to be genuine and let your love shine through in your words.

In Conclusion: Tips for Writing Your Love Messages

Writing the perfect love messages can take your relationship to new emotional heights, and good night messages for your boyfriend are a wonderful way to convey your affection and care. As you craft these messages, keep in mind these helpful tips to ensure your words resonate with sincerity and warmth:

  1. Be authentic: Speak from your heart. Authenticity is key to making your messages truthful and impactful.
  2. Keep it simple: Sometimes, the most straightforward messages are the most powerful. Avoid overcomplicating your thoughts.
  3. Personalize it: Use details specific to your relationship. This shows that your message is meant just for him.
  4. Be consistent: Regular good night messages can maintain a sense of closeness and routine in your relationship.
  5. Reflect on his feelings: Think about what would make him feel loved and appreciated.
  6. Show appreciation: Acknowledge what he means to you and the positive impact he has on your life.
  7. Mix it up: Use a variety of tones – romantic, funny, thoughtful – to keep your messages interesting and avoid monotony.

Remember, the goal is to make your boyfriend feel valued, loved, and cherished every night. Happy writing!

Start Using PopAi Today

Suggested Content

More >

SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, SUM( COALESCE( pvc.count, 0 ) ) AS post_views FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_post_views pvc ON pvc.id = wp_posts.ID AND pvc.type = 4 WHERE 1=1 AND ( wp_posts.post_date > '2024-10-18 10:11:48' ) AND ( wp_term_relationships.term_taxonomy_id IN (13,52,53,99,100,101,102,103,104,105) ) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID, wp_term_relationships.term_taxonomy_id HAVING post_views > 0 ORDER BY post_views DESC LIMIT 0, 6