Is there solution to this, I don’t mind deleting straight away from the database itself if necessary.
YES!!! it works, I placed it at the end of my shortcode and everything magically show up again. Mind telling me how wp_reset_query(); solve the issue?