Search page display deleted post

Unless you provide a link to a page demonstrating the problem, no one will be able to offer much in the way of assistance.

In the page:
https://www.famvda.com/vetrina/
for example > the fifth record
https://www.famvda.com/villaggio-bovier-6/
or the last record
https://www.famvda.com/villaggio-bovier-3/

Thanks

Are you using any search plugins?

No, but a theme with custom search output.

this is the searchpage.php source:

https://pastebin.com/embed_js.php?i=33MNNNj5

this is the search_query.php

https://pastebin.com/embed_js.php?i=JaEtaemG

I think the problem lies in your search-query.php script – specifically the MySQL query.

Yes, I think here. But, do you know where wordpress store the deleted posts data? There are some plugin to view, edit or delete this data from the db?

I’ve try to add this, but don’t work!

SELECT p.*
			FROM wp_posts AS p
			...
			$rob
                        ...
                        WHERE wp_post.post_status='publish'
			ORDER BY convert(p3.meta_value, signed)
			";