How can I exclude the latest post from the front page?

I’m trying to exclude the latest post from the homepage/archive page. The closest I’ve gotten is by using this.

function exclude($  query) {       if ($  query->is_home() ) {           $  query->set('post__not_in', array(1111));       } } add_action('pre_get_posts', 'exclude'); 

Instead of using array(id) to select a post and exclude it from the query — how do I make it so it automatically picks the latest post?

Thanks.

MYSQL: Query the last conversion on chat messages and sort by latest message

I am having issue on query sorting of last convo messages of each users. Here is my current record on my 2 tables:

enter image description here

enter image description here

I want to achieve below result:

enter image description here

My current query is:

 SELECT `messages`.*, `users`.`username`, `u2`.`username` as `to_username`,  CASE WHEN to_user_id = 1     THEN `users`.`username`     ELSE u2.username  END as participant  FROM `messages`   LEFT JOIN `users` ON `messages`.`from_user_id`=`users`.`id`   LEFT JOIN `users` as `u2` ON `messages`.`to_user_id`=`u2`.`id`   INNER JOIN (SELECT max(id) as lastmsgId FROM messages where to_user_id = 1 or from_user_id =1 GROUP BY to_user_id) m2 ON `messages`.`id`=`m2`.`lastmsgId`   GROUP BY participant    ORDER BY `messages`.`created_at` DESC 

And the result of my query is: enter image description here

The 4th and 5th message is not sorted properly I am expecting to display the 4th message instead of 5th message. It displays the older message instead of latest one. I couldn’t find the solution on how will be display the right sorting.

Any help and suggestion is very much appreciated.

Chrome Vulnerabilities are detected in vulnerability scan even after upgraded with latest versions

Had few chrome vulnerabilities [CVE-2020-6420] detected by BI(Retina). Upgraded the affected machines to chrome version 84.0.4147.89. After re-scan still the same vulnerabilities are detected.

Anyone experienced it before ? please help to resolve

Chase your next PR in the latest running shoes from your favorite brands

Still hot on the tip our tongues, adidas Originals flexes some heritage funk to prove they are not fooling around with the soon to be launched SL Loop Runner. In celebration, adidas has created a limited, never-to-be-sold SL Loop Runner that nods directly to its roots, donning the adidas sl 72 colour scheme. Introduced in 1972 at the Munich Summer Olympic games – the same year the Trefoil logo was introduced – 42 years into the future and the SL family, with open arms, welcomes the newest contemporary addition to the family.
</br></br>
The Three Stripes brand will bring back the adidas powerphase cloud white once again without any attachment to Yeezy. Originally part of adidas Originals 1987 Fitness Collection, we have two new and simple color themes releasing during March.One pair comes dressed in Ecru Tint and Off-White which has a Cream look while the other features Cloud White and Off-White. The two feature a leather construction with perforations on the toe and panels. In addition they have an EVA midsole and split cupsole.
</br></br>
Through the relatively short but extremely impactful career of the adidas nmd white, the versatile silhouette has taken on many a unique colorway/alternate method of embellishment. The latest series of wittily decorated adidas NMDs to surface features a handful of artfully placed colorblock hits, and the latest colorway of that pack to be revealed is a clean combination of white and black. The shoe’s entire base — from the knit upper to the full-length Boost midsole — is dressed in an angelic white, while eye-catching black printed accents appear to provide detailing at the bottom of the throat, around the heel piece, and above the rear midsole brick.
</br></br>
Is a Superstar still a adidas superstar black without its stripes? Adidas asks us that question with this Superstar 80s Clean, emphasising the iconic shell-toe by stripping the sneaker of all other branding except for the gold foil stamp on the side of the buttery leather upper. Is the shell-toe just as recognisable for adidas as The Three Stripes? We think so!
</br></br>
The adidas yung-1 trail sneakers is starting to release in a new color option which comes in a simple and clean theme for the warmer months.Featuring a Core Black, Off-White and Alumina color combination. Constructed with mesh across the upper, textile liner and nubuck on the overlays. Black lands on most of the overlays while White and Cream is spread throughout. Finishing this simplistic look is an EVA midsole and a rubber outsole.
[Image: withft0042.jpg]

How to Find the Latest Window Apps

What types of Android Apps are there that will really impress the customers? There are many options that you can choose from. Here are some of the popular ones:

Navigation Apps: This is easy access to your profile, browsing history, email accounts, and more. These are the main reasons why people love using these. The navigation is made more convenient with the help of some new features such as instant search, and social integration.

Phone Control Apps: If you are a budding entrepreneur who wants to develop an app that is entirely about managing your phone, then a Phone Control App is what you need. Some features include the ability to control all the functions of your phone with the right app installed on your device. You can be sure that your business will benefit greatly from using these. You are curious to know more about antivirus, read this.

Mobile Messaging Apps: When the mobile industry was just starting out, people were initially too apprehensive of having their messages leaked on the market. With today’s technologies, you can now stay connected with your friends and business associates from any part of the world. It is very important to have an app that will allow you to get in touch with your loved ones as soon as possible.

enter image description here

Full-Featured Games: Are you tired of playing Angry Birds, Facebook, and other similar apps that are available for free? Why not try to develop a full-featured game and create a platform that will give you and your users something truly unique. With the right kind of graphics and sound effects, your game will definitely win over the competition.

One Top Paid Applications: When you want to create your own business, a high-end application is what you need. However, it is hard to develop such applications on your own. You need a developer, and this is where an expert can help you develop a useful and a high-tech application.

If you have an idea on how to make your Android application the best one, all you need to do is to hire a mobile developer to handle your task. However, you must make sure that you get in touch with the right developer. who will provide you with the best possible products and applications?